I've recently got this MySQL error:
Error SQL query:
SELECT t.entry_id FROM db_channel_titles AS t LEFT JOIN db_channels ON t.channel_id = db_channels.channel_id LEFT JOIN db_members AS m ON m.member_id = t.author_id WHERE t.entry_id !='' AND t.site_id IN ('1') AND t.entry_date < 1462934343 AND (t.expiration_date = 0 OR t.expiration_date > 1462934343) AND t.status = 'open' ORDER BY FIELD(t.entry_id, ) LIMIT 0, 100
MySQL said: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') LIMIT 0, 100' at line 1
which I assume is from a PHP or MySQL upgrade.
Two questions:
Nothing to do with a PHP or MySQL upgrade. You have curly quotes:
t.site_id IN (‘1’)
in several places.
Well this isn't right
ORDER BY FIELD(t.entry_id, )
MySql no likes the missing columns,