I get the following error when trying to install Drupal 6.4:

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, 1 in C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\drupal-6.4\includes\menu.inc on line 315.

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, 1 in C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\drupal-6.4\includes\menu.inc on line 315.

I am running WinXP with Apache2.2, PHP 5.2, and MySQL 5.0.

I have scoured the forums and internet for possible remedies to these errors and have yet to find a solution.
It seems like many others have the same problem, but there appears to be no reliable solution. Is version 6.4 corrupt or buggy ?

Comments

prodosh’s picture

Drupal 6.4 is neither corrupt nor buggy. I suspect the problem is somewhere with your PHP or Apache installation. Have you checked what is on line 315?
The best way to run Drupal or any other PHP based programs on Windows is to install the XAMPP distribution of Apache, MySQL and PHP which you can download here: http://www.apachefriends.org/en/xampp-windows.html
Make sure you use the installation with the installer.
_______
Anolim: developing and supporting multimedia, community and collaboration solutions

_______
Safe Swiss Cloud: Enterprise grade cloud infrastructure for Drupal B2B solutions and platforms.

ejrehmeyer’s picture

I am having the same problem. I've taken a look at line 315 and what appears to be happening is that the variable $placeholders does not have any data, thus creating a query with the IN options as nothing, which is why the error is being thrown (MySQL doesn't like it). The $placesholders is being generated from the $parts variable which in turn should be coming from the $path variable. Also, the table menu_router does not have any data in it at this point...should it?

Any help would be appreciated. Thanks!

leighli’s picture

I am experiencing the problem above when attempting to install Drupal on a remote host.

somebody ppllllllease help us?!!!?!?!?!

leighli’s picture

I'm not sure why, I can only assume it's to do with cookies..

I'm using internet explorer 7 to install drupal (against my wishes, my firefox 3 is broken! :( )

in internet explorer 7, tools>internet options>privacy
-I changed my cookie settings to "allow all"
-I then added the website in question as an "always allow cookies" site
-i then restarted my browser.

-I also deleted settings.ph and re-copied the default.settings.php file and permissioned it etc).

-then, i opened up phpMyAdmin, and dropped all tables in the drupal db i had set up.

-then i went back to the start of the install process by going to the web directory containing the drupal files, and presto- on to step 5 yay.. hope the rest works!

Brn’s picture

Enable coockies for the website and it's ok.
Thanks !