By _dala_ on

I am trying to install drupal 6.2 but get stuck in step 4.
Message:

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 drupal_menu_router WHERE path IN () ORDER BY fit DESC LIMIT 0, 1 in [...]/includes/menu.inc on line 315.

Line 315 in menu.inc:

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

The site is on a shared host (linux) with Apache 2 and php 5.1.6.

Any ideas?

⋅ Categories: Drupal 6.x

Comments

_dala_’s picture

_dala_ commented

...efter specifying session.cookie_path in .htaccess!

callidusictus’s picture

callidusictus commented

Would you mind sharing what changes you made to .htaccess to make this work? My time spent googling the problem did not work.

_dala_’s picture

_dala_ commented

All I did was pointing cookie path to my drupal folder:

[...]
<IfModule mod_php5.c>
  [...]
  php_value session.cookie_path 	    /drupal/
</IfModule>
[...]
jhomme’s picture

jhomme commented

I shop at http://tinyurl.com/32rsxz
Hi. How do you go about solving this on XP. I have similar errors and a warning about ini-set that says that a session is already started. Thanks.

KristVB’s picture

KristVB commented

I'm having the same problem.

However I did a test on another server, where installation worked.

The server where it worked is Solaris 10 machine, with apache 2.0.58, PHP 5.2.1, MySQL 5.0.51

The server where it didn't is a Ubuntu Linux 6.0.6 , with apache 2.0.55 (must remember to update), PHP 5.2.1, MySQL 5.0.22

Other differences: The server where it didn't work I accessed over https, and uses authentication for the whole webroot. (As this is a development machine accessible over the internet). This means the REMOTE_USER is set. Could that be the problem?

KristVB’s picture

KristVB commented

I tried installing Drupal 6.1, and this went without a problem. Afterwards I replaced my drupal 6.1 with drupal 6.2, ran the setup again (without dropping the database) , and now it worked.... Strange.

KristVB’s picture

KristVB commented

I tried installing Drupal 6.1, and this went without a problem. Afterwards I replaced my drupal 6.1 with drupal 6.2, ran the setup again (without dropping the database) , and now it worked.... Strange.