Topic-icon Feeds Query

More
18 Jan 2019 06:12 #6675

Hi,
You just need to use #__tablename instead of jos_tablename. If the query runs in PhpMyAdmin, it should run in vData as well.


Thanks
Daniel

Please Log in or Create an account to join the conversation.

  • Andre Chernyshev
  • Andre Chernyshev's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
More
17 Jan 2019 20:24 #6673

Is there an example or guide to see feeds query? what kind of syntax it uses and stuff like that just using regular SQL query produces error.
SELECT jos_melsongs.id, jos_melsongs.name, jos_melsongs.audio_folder, jos_melsongs.dur_hrs,jos_melsongs.dur_mins, jos_melsongs.dur_secs, jos_melfilepath.folder FROM jos_melsongs JOIN jos_melfilepath ON jos_melsongs.audio_folder=jos_melfilepath.id ORDER BY jos_melsongs.id DESC LIMIT 50

{"result":"error", "error":"Table '{table omited}.#__melsongs join' doesn't exist"}

Please Log in or Create an account to join the conversation.

Cron Job Starts