Drupal configuration fails on Install Site step with the following error:

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 nbc_menu_router WHERE path IN () ORDER BY fit DESC LIMIT 0, 1 in /usr/share/drupal/includes/menu.inc on line 315.

What are the steps required to reproduce the bug?: Just run the install
What behaviour were you expecting: Not this!
What happened instead?: The install failed after creating all the tables in the database.

This error appears to be the subject of nearly 400 posts over the last 30 months (at least) without any resolution (although lots of 'it suddenly worked when I did this' suggestions). I'm currently dead in the water because of it.

Drupal 6.16
Apache 2.2.15
PHP 5.2.13
Database (on a seperate server) MySQL 5.1.47

Comments

lostchord’s picture

lostchord commented

Update.

Installing Drupal and Apache on the database server allows the database to be configured. The other nodes can access this database but (for some as yet unknown reason) they think that Apache cannot make HTTP requests (other sites on the same servers that access the same database server do not have this issue).

So, still broken and a fix required but yet another possible work-around may be added to the list.

Edit:
HTTP requests fixed by adding host name to hosts file. Forgot about this amongst all the other crap.

grendzy’s picture

grendzy commented
Status: Active » Closed (duplicate)

#791004: Installer does not warn the user that cookies must be enabled with the correct cookie domain (and fails when they aren't)

lostchord’s picture

lostchord commented

Not sure about this one. Had created other sites without any problems and, from memory, tried using a browser that worked with other sites without any trouble - so I would assume cookies were enabled. In fact I tried from a number of systems and it only worked when I configured a dummy site from the system holding the database.

When I get time I will try again and flip cookies on/off in the browser in a controlled experiment.

cheers!