By le.waldman on

When running install.php I get this in install site step:

* 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 /srv/www/sites-drupal/drupal/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 /srv/www/sites-drupal/drupal/includes/menu.inc on line 315.

Looked on Google and on this forum but didn't find any way to fix this or a workaround for it...

Any Idea?

Thanks in Advance! :)

⋅ Categories: Drupal 6.x

Comments

le.waldman’s picture

le.waldman commented

I forget to set the $cookie_domain string to the domain of my site.

Thanks

kinalas’s picture

kinalas commented

i'm experiencing same error

can u pls give me the process on setting the cooke_domain string... where should is set this
thanks

gvolger’s picture

gvolger commented

How do you dio this? I have the same error!
Thanks!

jmbarlow’s picture

jmbarlow commented

Thanks for posting this. I copied over a settings.php file from another install to start a new site and got caught.

Anyone still having problems, check your settings.php file and either amend or comment-out (as it isn't required unless you're doing something fairly unusual) the following line:

$cookie_domain = 'foobar.com';
As If’s picture

As If commented

Also make sure you are accepting cookies from the domain.

-------------------------------------------
Interactive Worlds and Immersive Obsessions
http://www.asifproductions.com

elcapitan82’s picture

elcapitan82 commented

Shortening the database prefix in settings.php to only a few characters (+ underscore) solved this issue for me.

peddyfab’s picture

peddyfab commented

Please someone should make this properly clear to me...do i have to open my settings.php file? to include this string or what are my suppose to do to fix this problem..?
Thanks so much
* 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\Zend\Apache2\htdocs\outsource\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\Zend\Apache2\htdocs\outsource\includes\menu.inc on line 315.

sparker888’s picture

sparker888 commented

I had the same problem while installing Drupal Commons to an Acquia DAMP stack locally. I solved it by adding the database prefix as follows: $db_prefix = 'commons_'; to the settings.php file ('commons' is the prefix name of my local MySQL database - be sure to change this to your name). In the case of my particular database, the full name was 'commons_local'.

Hope this helps someone.

drupalfever’s picture

drupalfever commented

My problem was that the folder that I created to contain my Drupal files had an underscore "_" on the name. Once I renamed the folder and repeated the installation, everything went smoothly.

dinkydodouk’s picture

dinkydodouk commented

Hey sparky888,

Just wanted to say thanks for this post. I followed the other ones as well but this was where my error occured. For all others its on line 93 of the settings.php file.

Nice one!

shimba’s picture

shimba commented

Thanx sparky888, this worked for me. Just replaced $db_prefix = '' , with $db_prefix = 'mydatabaseprefix_'

shabbir111’s picture

shabbir111 commented

Thanks sparky888, it helped me too..my dbname was simply demo..bt i tried putting that in my $db_prefix='demo' and voila it worked..
thanks buddy
cheers..