Thread

We are getting the following error when members login to the website - not the control panel, but the main members area of the website.

SELECT t.entry_id FROM exp_weblog_titles AS t LEFT JOIN exp_weblogs ON t.weblog_id = exp_weblogs.weblog_id LEFT JOIN exp_members AS m ON m.member_id = t.author_id WHERE t.entry_id !='' AND t.site_id IN ('1') AND t.entry_date < 1314863074 AND (t.expiration_date = 0 OR t.expiration_date > 1314863074) AND exp_weblogs.is_user_blog = 'n' AND t.weblog_id = '11' AND t.status = 'open' ORDER BY FIELD(t.entry_id, ) LIMIT 0, 3

We haven’t changed anything to core files.
Site works fine when logged out.

I have run the query through phpmyadmin and it appears to be a problem with the comma in ORDER BY FIELD(t.entry_id, ).

Can anyone help? Please?!

Homepage works fine by the way, and this has lots of calls to different weblogs.

OK, I’ve worked out that it’s only happening for super admins and it’s because debug preference is set to show only to super admins.

However, I am confused as this message has only just started showing up, and for pages that haven’t been touched in ages.

We need to get this error fixed so any ideas would be welcome!

Weirdly, this now seems to be working…with no input from me!

Please close the thread.

Hi, David -

No problem, glad to see it’s working again.  If it does start repeating, please let us know and we’ll help troubleshoot.