Come together with the global Drupal community in Rotterdam, 28 Sept – 1 Oct 2026. Sessions, contribution, connection, and Early Bird savings until 8 June.
By morrislex on
This install error I received when starting up server
* 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 /var/www/html/drupal-6.4/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 /var/www/html/drupal-6.4/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 /var/www/html/drupal-6.4/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 /var/www/html/drupal-6.4/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 /var/www/html/drupal-6.4/includes/menu.inc on line 315.
Comments
Install first run
Any help from any knowledable folks would be greatly appreciated
No need to cross-post:
No need to cross-post: http://drupal.org/node/320151
Solution - error in sql
This error occurs due to a bad install/configuration of PHP and apache.
Try uninstalling
- PHP
- Apache
- MySQL
Now use single package installer of WAMP Server. Then try! I found soution this way.
Amit Bhardwaj
www.quicksolution.in
Design, Web development, Flash Game development
Long Names
I got this message when I put the prefix on db tables in setting.php to be too long. Shortening them made the install go.
May be due session.cookie_secure
Hi,
I had the same problem, because I had set session.cookie_secure set to 1 in my PHP configuration. For that reason, installation had to go through https, not http. So, definitely it is a problem with cookies, no need to reinstall anything.
Had similar issue with first
Had similar issue with first time installation.
Tried two things at once (don't know which of these had caused the issue!) and was able to install drupal successfully!!!
1. I had selected 'system generated password' for SQL database (had many symbol characters), which I had to manually type in.
2. Copied settings.php instead of renaming it.