On fresh install of Drupal 6.1

"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 ') ORDER BY fit DESC LIMIT 0, 1' at line 1 query: SELECT * FROM menu_router WHERE path IN () ORDER BY fit DESC LIMIT 0, 1v"

Reference forum thread here:

http://drupal.org/node/223160#comment-786228

Issues seems like bug/incompatibility with MySQL 4.1.x. Issue was solved by using MySQL 5.x.

Comments

fabsor’s picture

fabsor commented
Priority: Critical » Normal

Could this be resolved by making an alternate query that does not have the IN statement if there is nothing in it, since mysql 4.1x clearly doesn't allow the current query?

dpearcefl’s picture

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

Does this issue exist in current D6?

dpearcefl’s picture

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

Status: Active » Closed (outdated)

Automatically closed because Drupal 6 is no longer supported. If the issue verifiably applies to later versions, please reopen with details and update the version.