By brucet1952 on

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.

⋅ Categories: Drupal 6.x

Comments

gtrusler’s picture

gtrusler commented

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.

nibble’s picture

nibble commented

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.

ndelattr’s picture

ndelattr commented

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

SupaFlyuk’s picture

SupaFlyuk commented

I'm getting the same problems anyone help PLEASE!

Thanks

lainel’s picture

lainel commented

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.

jimsoda’s picture

jimsoda commented

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

??????

goropad’s picture

goropad commented

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?

lainel’s picture

lainel commented

You should try deleting the module "menu_router", and send an issue report about it.

ytorf’s picture

ytorf commented

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.

lainel’s picture

lainel commented

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

bentpenny@drupal.org’s picture

bentpenny@drupal.org commented

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.

efelix’s picture

efelix commented

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.

businessdata’s picture

businessdata commented

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....

charlesuchu’s picture

charlesuchu commented

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.

sunday84’s picture

sunday84 commented

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 ;)

Commerco’s picture

Commerco commented

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

lainel’s picture

lainel commented

Do you still have the same users as you did before the upgrade?
I never upgraded, so I'm curious.

cmdanko’s picture

cmdanko commented

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!

intextdesign’s picture

intextdesign commented

I had error 'blah blah line 315' over and over trying to install in Firefox (my prefered browser on a mac) so tried installing in a different browser (Safari) and hey presto it worked.

Reading another post someone had had a prob on their 4th site and this was a 3rd installation so perhaps this is where the problem lies?

Thanks everyone for all the advice and possible solutions

mpp1031’s picture

mpp1031 commented

... 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

wik1234’s picture

wik1234 commented

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

peregrina’s picture

peregrina commented

go to mysqladmin and select the database, check all tables and drop them, that fixed my installation

sunday84’s picture

sunday84 commented

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 ;)

sarahdavies’s picture

sarahdavies commented

Thanks for this! This fixed a bug in a fresh install of 6.2 running on MySQL 5.

matherion’s picture

matherion commented

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!!!

mustang’s picture

mustang commented

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.

rpsu’s picture

rpsu
he/him
Primary language Finnish
commented

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).

--
Perttu Ehn

lainel’s picture

lainel commented

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?

pwolanin’s picture

pwolanin commented

The SQL error related to SELECT * FROM menu_router WHERE path IN () sounds like this bug: http://drupal.org/node/261148

---
Work: BioRAFT

slurpee’s picture

slurpee commented

Is everyone migrating these sites to a web hosting company?

I think the host creates some default tables every time you create a database with the control panel wizard.

If you go into phpmyadmin to clear all the tables. This should solve your issue. This can be done from the mysqladmin command line as well.

trackleft’s picture

trackleft commented

Hey guys, did you think to change the $cookie_domain in the settings.php file? Ha, this stumped me for awhile.

tilu’s picture

tilu commented

solved for me after changed of $cookie_domain in settings.php with the same domain

sjdavis’s picture

sjdavis commented

changing the cookie_domain in the settings.php file fixed it for me too. Thanks for the suggestion!

nymo’s picture

nymo commented

I was debugging a client's site and tried to make a fresh install on my local server and i kept getting that error (menu_router trying to select with an empty list for the IN parameter). The client set the $cookie_domain, and commenting it out worked and the install was finally able to continue with installing the profile.

drwierdo’s picture

drwierdo commented

well i think that this problem is caused because of intermittent internet connectivity or when the remote servers are not running smoothly......i encountered the same problem.......first there were php errors which were caused when the drupal installation files were not completely uploaded........say a file of 9kb was incomletely uploaded and it was only of 6kb.....when i solved these issues and went ahead with the installtion drupal started installing but then it stopped shortly because the mysql server went down......the result was the error message that all of us are having..........my suggestions:

1. ensure that the installation files are completely uploaded.....check the sizes (though it is cumbersome but it will save you from loads of hassles later)
2. run your installation when your server is ususally free.....for instance if you are in asia and using the host situated in the US then do the installation when the US sleeps......
3. and if even after doing all this your installation fails dont clan your drupal installation, just go and drop the mysql db and then open your site.....your installation will go fine...

enjoy!!!

lipinponmala007’s picture

lipinponmala007 commented

i had this error and i solved this by running the following in the terminal..

mysqlcheck -u root -p --auto-repair --check --optimize --all-databases

or check the following link
http://blog.taragana.com/index.php/archive/mysql-tip-how-to-check-repair...

hope the repairing and optimising all the tables in database will give you a relief

please place a feed back if this works.

odisey’s picture

odisey commented

I did a fresh install this morning and totally messed it up. Instead of putting contents of drupal instal folder into public_html I put the whole freakin' folder in. THis is an IP install, no URL is pointing to it. So, when I locatd the install.php file and set it up I thought I was good. It did install without a hitch.

Realized I flubbed up.

Deleated everything and DB.

Did fresh install.

Looked great.

Tried logging out and back in ... got ACCESS DENIED.

Accessed DB and reset Admin user name and passcode. Same problem.

Started OVER again.

Then I started getting the .........menu_router ......... at line 315 errors.

Tried everything thing here ..... enabling cookies, changing $cookie_url;, and nothing worked.

UNTIL!

I deletd everything ..... started over ..... ran set up in Firefox.

Set up .... I can log out and in with admin ....

Looks good.

Hope this helps someone!

More support for ALWAYS using FF.

Odisey

Shoffner’s picture

Shoffner commented

I was getting the same user warning:

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.

But I couldn't just drop my database because I was copying over production database to test environment. After trying everything on this thread and other stuff, I finally took a step back and asked myself, "What if the copy of my production database is broken?" Ran a couple tests, and determined it was.

So, I did another mysqldump, gzipped the sql file before moving from one environment to another (a step I skipped the first time), and then imported on the command line instead of using phpmyadmin (because phpmyadmin was misbehaving, and wanted to eliminate things I would need to troubleshoot).

Hope this saves somebody some time...

Daniel_KM’s picture

Daniel_KM commented

Hi,

You need to change db_query() with db_query_range(): db_query fails if there is a LIMIT statement in your SQL request.

Sincerely,

Daniel Berthereau
Infodoc & Knowledge management