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:
- What is the error in the SQL?
- The PHP framework we're using is an old version of ExpressionEngine (version 2.0) so I'm not sure we can simply hack the SQL. Given that, I'm wondering what the quickest way of fixing the problem is. Any suggestions?