The following error appears when opening the newsroom sorted by date:

user warning: 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 '' at line 1 query: SELECT * FROM users u WHERE in /home/vol5/byethost13.com/b13_1574882/htdocs/includes/database.mysql.inc on line 172.

Comments

toddw81’s picture

toddw81 commented

I am having this same problem, anyone have a solution?

user warning: 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 '' at line 1 query: SELECT * FROM users u WHERE in /home/content/t/e/c/techv/html/includes/database.mysql.inc on line 172.

Line 172 in the specified file is as follows:

trigger_error(check_plain(mysql_error($active_db) ."\nquery: ". $query), E_USER_WARNING);

dtarc’s picture

dtarc commented

I'm not able to duplicate this as i'm not getting the SQL error. Can you provide more info? Is this happening every time the newsroom is displayed sorted by date? Is it happening before or after the newsroom settings are configured?

dtarc’s picture

dtarc commented
Status: Active » Postponed (maintainer needs more info)