By ostrini on

Installing version 6.2, in a gentoo, mysql Ver 14.12 Distrib 5.0.54,
In the five Step (Install profile)
Error:"query: SELECT * FROM menu_router WHERE path IN () ORDER BY fit DESC LIMIT 0, 1 in menu.inc on line 367"

# 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 menu.inc on line 367.
# 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 menu.inc on line 367.

⋅ Categories: Drupal 6.x

Comments

xmaster’s picture

xmaster commented

I have also an error by my webhoster HOSTEUROPE after "set up database"

Fatal error: Trying to clone an uncloneable object of class mysqli in /PATH TO MY HOMEPAGE/includes/install.mysqli.inc on line 36

ostrini’s picture

ostrini commented

xmaster, open another thread with your error.

I would like to close this thread with a note resolving my problem, is more useful to center one thread in one problem.

I think i used a too much generic topic.

ostrini’s picture

ostrini commented

please, help, not resolved yet (it could be nice to change the topic of a thread about a problem to mark it like resolved or not).

ostrini’s picture

ostrini commented

Can any one help me?

Thx.

ostrini’s picture

ostrini commented

Help please.

lionheart8’s picture

lionheart8 commented

Sorry, I cannot help but I would just want to encourage you to be patient ... Most likely, someone who could know a solution has not read your request yet. :)

ostrini’s picture

ostrini commented

Thx lionheart, i have finally installed another solution that did not failed in the installation.

All the way i like drupal and it may be that i am too much stupid to install it correctly.

:) thx.

robertdouglass’s picture

robertdouglass commented

Here's a search that brings up a lot of similar issues.

I think what people are reporting is that you need to drop and recreate the database, then try the install in Firefox. If you were already using firefox, try clearing your cookies first. I haven't confirmed this and don't know why this would be the case, but I read a success report that said as much.

- Robert Douglass

-----
my Drupal book

ostrini’s picture

ostrini commented

Thx Robert,

I have try your solution and all the ideas in all posts in that search, but it dosent works.

How could i test if the SESSION during the installation is working correctly? perhaps is not a problem of the cookies but server sessions while installing.

I have checked the permissions in my phpinfo (php.ini) session paths and are ok.

robertdouglass’s picture

robertdouglass commented

Drupal uses db managed sessions. If you have your session key (look in your browser cookie) you can do a select on the sid of the sessions table to see if it is there.

- Robert Douglass

-----
my Drupal book

ostrini’s picture

ostrini commented

I have found the solution by myself (now i am hacker?).

In my php.ini

nano /etc/php/apache2-php5/php.ini

in my gentoo i have

session.cookie_secure = 1

This was causing the fails, i have commented it with a ';' and the installation was perfectly.

;session.cookie_secure = 1

Thx Robert, LionHeart, and the readers of this thread.

Arriba España y Olé.

THREAD CLOSED.

robertdouglass’s picture

robertdouglass commented

And happy Drupalling =)

- Robert Douglass

-----
my Drupal book