By sara_ireth on

hello :-)

i had a problem when i tried to install drupal 6.1

this is the error message i get

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

the mysql version is 4.1.13 and the line that it refferes it is

if ($router_item = db_fetch_array(db_query_range('SELECT * FROM {menu_router} WHERE path IN ('. implode (',', $placeholders) .') ORDER BY fit DESC',

does anyone have any idea?
thank you :-)

⋅ Categories: Drupal 6.x

Comments

pobster’s picture

pobster commented

It seems your variable $placeholders isn't being built (or is being built, but perhaps incorrectly?) just before that line type;

print "here: ";
print_r($placeholders);

The "here" is just so you can tell that *anything* is being output. If the variable is empty it'll mean that something is un-setting it somewhere - perhaps a hook_menu_alter from a module? You'll need to check out a few things to be sure...

Pobster

jrgns’s picture

jrgns commented

I get this error, but only when I try the second site in a multisite install.

jrgns’s picture

jrgns commented

It seems that you get this error when either cookies or javascript is disabled for the second domain.

mauror’s picture

mauror commented

It might indeed be a cookie and/or JavaScript problem...
The fix seems to be to delete the cookies before running each install and to let Drupal set session cookies...