By cjwworld on

Hello. I am a newbie here but I am stuck at one point of installing

Can anybody help decipher this error message? It seems to be stuck after setting up database but before installing site

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, 1 in /Applications/MAMP/htdocs/drupal-6.13/includes/menu.inc on line 315.

2)
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 /Applications/MAMP/htdocs/drupal-6.13/includes/menu.inc on line 315.

I know that I have to modify a file but what do I need to do with it?

thanks for any help

⋅ Categories: Drupal 6.x

Comments

doublewhopper’s picture

doublewhopper commented

I did severall Drupal installation in the past but i faced the same issue this morning.

I use Mamp 1.8.2 and Drupal 6.13.

I found this german blog post (http://www.pebosi.net/200807/drupal-6-sql-fehler-menurouter-tabelle) which says that Cookies should be enabled in the installation process. My browser (firefox) is accepting cookies so it must be something different.

JBacchi’s picture

JBacchi commented

Trying to set up locally with MAMP and cannot get past this error. No clue what to do now.

cjwworld’s picture

cjwworld commented

Finally getting somewhere.. See this video and it helps. http://ftp.drupal.org/files/videocasts/Install-D6.mp4

intextdesign’s picture

intextdesign commented

I have tried every which way but no further forward. It worked perfectly before I decided to upgrade MAMP but can't now get an earlier version.

Anyone got a staightforward and easy to implement solution?

CB

sankatha’s picture

sankatha commented

I think this is because of a cookie domain problem(had the same issue this morning). Anyway try commenting out the session.cookie_domain in your php.ini file and it may help (File->Edit Template->php5 ini)

sandybrit’s picture

sandybrit commented

I tried doing this when I had the same problem as the original post, but although the error message goes away, the php.install script still remains stuck. There is a page heading entitled "Home" but the installer doesn't advance any further. I have tried deleting the drupal installation folder and starting again from scratch but with no joy. Any ideas would be much appreciated.