Error in SQL Syntax
I am receiving the following message after I start the install for Drupal 6. I can get to chose language and then this.
Warning: Unknown column 'serialized' in 'field list' query: SELECT data, created, headers, expire, serialized FROM cache WHERE cid = 'variables' in /home/content/s/h/e/shelton2/html/includes/database.mysql.inc on line 128
Warning: Unknown column 'serialized' in 'field list' query: UPDATE cache SET data = 'a:186:{s:22:\"theme_evening_settings\";a:16:{s:11:\"toggle_logo\";i:1;s:11:\"toggle_name\";i:1;s:13:\"toggle_slogan\";i:1;s:14:\"toggle_mission\";i:1;s:24:\"toggle_node_user_picture\";i:0;s:27:\"toggle_comment_user_picture\";i:0;s:13:\"toggle_search\";i:0;s:14:\"toggle_favicon\";i:1;s:12:\"default_logo\";i:0;s:9:\"logo_path\";s:22:\"files/evening_logo.jpg\";s:11:\"logo_upload\";s:0:\"\";s:15:\"default_favicon\";i:0;s:12:\"favicon_path\";s:25:\"files/evening_favicon.ico\";s:14:\"favicon_upload\";s:0:\"\";s:2:\"op\";s:18:\"Save configuration\";s:10:\"form_token\";s:32:\"b03eec7d82603d4b241f2d30ee69db45\";}s:13:\"filter_html_1\";i:1;s:18:\"node_options_forum\";a:1:{i: in /home/content/s/h/e/shelton2/html/includes/database.mysql.inc on line 128
Warning: Unknown column 'serialized' in 'field list' query: SELECT data, created, headers, expire, serialized FROM cache_page WHERE cid = 'http://www.sheltonchristian.com/install.php?profile=default&locale=en' in /home/content/s/h/e/shelton2/html/includes/database.mysql.inc on line 128
Warning: Cannot modify header information - headers already sent by (output started at /home/content/s/h/e/shelton2/html/includes/database.mysql.inc:128) in /home/content/s/h/e/shelton2/html/includes/bootstrap.inc on line 577
Warning: Cannot modify header information - headers already sent by (output started at /home/content/s/h/e/shelton2/html/includes/database.mysql.inc:128) in /home/content/s/h/e/shelton2/html/includes/bootstrap.inc on line 578
Warning: Cannot modify header information - headers already sent by (output started at /home/content/s/h/e/shelton2/html/includes/database.mysql.inc:128) in /home/content/s/h/e/shelton2/html/includes/bootstrap.inc on line 579
Warning: Cannot modify header information - headers already sent by (output started at /home/content/s/h/e/shelton2/html/includes/database.mysql.inc:128) in /home/content/s/h/e/shelton2/html/includes/bootstrap.inc on line 580
This is in a red square following a copy of my logo
Home
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 /home/content/s/h/e/shelton2/html/includes/menu.inc on line 316.
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 /home/content/s/h/e/shelton2/html/includes/menu.inc on line 316.
I know nothing about mysql. Help please.
I'm seeing the same errors
I'm seeing the same errors and the upgrade just sits there without progressing.
* 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 /home/adivhelp/public_html/includes/menu.inc on line 316.
* 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 /home/adivhelp/public_html/includes/menu.inc on line 316.
* 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 /home/adivhelp/public_html/includes/menu.inc on line 316.
menu.inc on line 316
Since I've got this error (not while installing, the install process was succsesful), I cannot do anything, I cant save changes in admin, move menus, nothing...I received a validation error... I cant remember what I did to get the error in menu.inc :/
Help is welcom :)
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 xxxxxxxxxxx/includes/menu.inc on line 316.
Reproduce this error on my computer...
Using Apache 2.0.63, php 5.2.6 and mysql 5.0x and drupal 6.2
Into the section [mysqli] of the file "php.ini" I had an invalid configuration (mysqli.default_pw is wrong) :
mysqli.default_host = localhost
mysqli.default_user =root
mysqli.default_pw =
In sites\default\settings.php the $db_url was "OK" :
$db_url = 'mysqli://root:password@localhost/drup';
The consequence of that is that during the installation of Drupalthe mysqli section in php is used and not always the db_url in settings...
Changing php.ini section solves my problem!
Hope this helps
Nicolas DELATTRE
I'm getting the same
I'm getting the same problems anyone help PLEASE!
Thanks
My Problem is...
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 'DESC LIMIT 0, 5' at line 1 query: SELECT DISTINCT(node.nid), active, node.title AS node_title, node.changed AS node_changed, forward_statistics.clickthrough_count AS forward_statistics_clickthrough_count, forward_statistics.forward_count AS forward_statistics_forward_count FROM node node LEFT JOIN forward_statistics forward_statistics ON node.nid = forward_statistics.nid ORDER BY DESC LIMIT 0, 5 in /home/lainel/public_html/spikedout/includes/database.mysql.inc on line 172.
Same error as well on new install
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
??????
Same error, install on WAMP 5: php5, MySQL5, Apache2 on WInXP
this is what I got on "Install site" stage of installation of brand new Drupal 6.1 on WAMP5:
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
D:\www\6\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
D:\www\6\includes\menu.inc on line 315.
anibody can help?
You should...
You should try deleting the module "menu_router", and send an issue report about it.
Same error - install on php4.4 MySQL 4.1 Apache1.3 Linux 2.6.9
I'm getting the same thing:
* 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 /home/thegreen/public_html/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 /home/thegreen/public_html/includes/menu.inc on line 315.
Same thing...
Same thing with you, try to delete the module "menu_router".
If you guys should ever run across these messages, look at the message and it will tell you where it's coming from.
This message says From menu_router
Got the same - but it doesn't seem to matter
Got the same error when upgrading to 6.2, but I ignored it, went through with the installation and it seems to be working file.
Fantastico Upgrade - SQL syntax error
I was upgrading from 5.7 to 6.1 through my host server's Fantastico. But something went wrong because I would get the error 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 menu_router WHERE path IN () ORDER BY fit DESC LIMIT 0, 1 in /home/content/s/h/e/shelton2/html/includes/menu.inc on line 316.
So I manually finished the upgrade by entering into the browser - http://your_domain_name.com/update.php
This fixed it and I was up and running.
Exactly the same error
all very well saying delete the menu_router module, but there are no files in my modules directory by this name. THere are references to 'menu_router' in the menu.inc file, but it is all complex code.
I am really not impressed so far, this is obviously a serious installation bug, and no-one seems to have an answer....
Problem with compatibility of MySQL 4.1.x
I experienced this same error last night when running the drupal install, fixes listed above weren't relevant to me:
"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, 1v"
This error occurred on PHP 5.2.x and MySQL 4.1.x.
When I switched the database to a MySQL 5.x database server the error no longer happened.
Seems like a possible bug or incompatibility with MySQL 4.1.x branch.
Error: user warning in sql syntax
Hello everybody!
I also have the same error with the installation in the 4° step "Install site".
Msg error: 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/drupal/includes/menu.inc on line 319.
here:
WHERE path IN ('. implode (',', $placeholders) .')
My specifications are: - linux - ubuntu - phpmyadmin 2.11.5 - mysql 5.0.42 - apache 2.2.4 - php 5.2.3
My db have 43 table and 65 rows.
I looked further discussions on this forum to offer patches or enable "log_errors", but none has solved my problem. ^^'
I also printed out the contents of the variable $placeholders and the result was: Array()
This is an error of this new version? Should I install the previous version?
Can you help me? :'(
Thanks ;)
It may seem strange but...
I too have experienced this problem and seem to have found a more than odd resolution.
I was using IE 7.0 to access the server for the installation. I realize this sounds a bit odd, but I decided to use Firefox, clear out the database and the installation went fine. A reasonable person might ask if something else changed. I can assure you that all things were the same.
Because this seems so strange, I decided to do a simple step by step test to confirm my experience.
1) Moved the successful installation from the site web root to a save directory.
2) Copied the installation files into the site web root.
3) Created another DB (dbnameIE)
4) Ran installation with IE 7.0 - ran into failure.
5) Moved the failed installation to a save folder.
6) Copied the installation files into the site web root.
7) Created another DB (dbnameFOX)
6) Ran installation with FireFox 2.0.0.13 - installation completed.
8) Moved the successful installation to a save folder.
9) Moved the successful installation from step 1 back to the site web root
10) Site still works.
Why a browser choice should cause such an issue is a bit of a mystery, but there it is. Perhaps this will give the team at Drupal working on such things some insight into the matter.
Now that I've got Drupal up and running, I found that I'm also experiencing an inability to login to my site with IE 7.0, so perhaps the two things are related.
That said, I am posting this very message with the same IE 7.0 that I seem to be having difficulties with on one of my own sites.
Your mileage may vary...
-Commerco
Do you...
Do you still have the same users as you did before the upgrade?
I never upgraded, so I'm curious.
firefox fixed it for me too
I saw this post and tried something similar. I deleted the drupal install and database and started over using firefox, rather than IE, and everything went fine. Thanks!
Error in SQL Syntax, because...
... a couple of reasons.
I'm having the same problem, so I did some digging. At that point in the installation process, there appear to be no records in the database table named 'menu_router' (at least in my situation).
The SQL error is the part about IN(). The PHP code is supposed to be populating a comma-separated list of "things" (not sure what) in the IN() clause. Par example;
SELECT...blah...blah... IN('one','two','three','bazillion','cow','horse','BMW')Because there's *NOTHING* in there, MySQL is throwing a SQL syntax error. But the real problem seems to be WAY upstream in the PHP code... I don't know much about Drupal architecture, so I can't really nail it down. This is my first exposure to it at all.
Hope that helps someone smarter than me to figure out what's really wrong. I was looking forward to trying out Drupal; everything I've seen so far looks pretty freakin' slick.
MPP
Cookies blocked?
same error here when installing fresh copy of 6.2
solved by enabling cookies in browser (I block all cookies by default)
maybe that list of "things", which is supposed to go into the IN(...) clause, is stored in session data?
no cookies => no session data => empty list => sql syntax error
go to mysqladmin and select
go to mysqladmin and select the database, check all tables and drop them, that fixed my installation
-> go to mysqladmin and select
Thank you..with this action, the installation is running! But, after I create my first account, I have another errors. I posted my problems here: http://drupal.org/node/249402
Bye ;)
Thanks for this! This fixed
Thanks for this! This fixed a bug in a fresh install of 6.2 running on MySQL 5.
Thank you!
Dropping all tables worked for me too (client system (me): WinXP SP3, FF 3.0, server system (my provider) Windows Server 2003, IIS, PHP 5.2.5, MySQL 4). Thank you!!!
Clean install after encountering SQL error
Putting together much of what's here ...
I was working piecemeal on an installation. It blew up with the SQL error quoted here (line 315 ... menu.inc ... etc.).
Putting together much of what was here, I got a clean install of 6.1 by:
1. Deleting the 6.1 folder and extracting it again from the tar file
2. Dropping and re-creating the database.
3. Clearing my Firefox of Browsing History, Saved Forms and History, Cache, and Cookies.
4. Allowing scripts globally (I run the NoScript add-in for FIrefox).
5. Closing and re-opening my browser, then navigating to www.mysite.com/drupal-6.1
6. -Completing- the installation in one sitting :-)
Clean installation. Upgraded to 6.2 immediately by repeating these steps, except I extracted the 6.2 tar file instead of the 6.1 tar file.
One consideration: I hadn't yet created anything for the site, so I didn't lose much (if anything) by taking this rather draconian approach.
Hope this helps somebody in this situation.
One vote for that list
It seems like (but most probably just seems like) that new, fresh copy and using another browser (Firefox on Apple to Safari) solved my-very-much-the-same problem. I was installing Drupal 6.10 on NAS / linux server (with quite enough of memory).
I need help with ths one
warning: Cannot modify header information - headers already sent by (output started at /home/lainel/public_html/flowface/modules/audio/views_audio.inc:5) in /home/lainel/public_html/flowface/includes/common.inc on line 141
Any suggestions?
The SQL error related to
The SQL error related to
SELECT * FROM menu_router WHERE path IN ()sounds like this bug: http://drupal.org/node/261148