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 greencheetah on
Can anybody help me with this one? I am using MySQL 5 something. I get this error message when I try to install Drupal 6.6 -
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 /mysite/includes/menu.inc on line 315.
Comments
i have the exact same
i have the exact same problem
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 //public_html/drupal/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, /public_html/drupal/includes/menu.inc on line 315
so any help is very welcome
The menu was not built
The menu was not built during installation, probably because of a timeout or lack of PHP memory. It is possible that other things failed as well for the same reason.
Drop all database tables and start over, after checking http://drupal.org/requirements for Drupal 6. In particular, make sure that the PHP memory limit is at least 16M (see http://drupal.org/node/207036). This is a minimum requirement for Drupal 6.
If the same error appears later, after installing more modules, you can fix it by increasing PHP memory even more, then running update.php to rebuild the menus, and making sure that it completes successfully.
My memory limit is 40M. I deleted
My memory limit is 40M. I deleted everything, uploaded everything and created new databases at least 5 times and I continue to get the same error message every time.
memory limit of 32 , still
memory limit of 32 , still having the problem
I am not sure what it is
I am not sure what it is then.
Is that a hosted server? Have you verified whether your 40M (or 32M) memory limit really applies inside Drupal's directory? (by running phpinfo() in a file inside Drupal's directory?) Or are you just trusting a php.ini setting?
Also try running update.php on the bad installation.
The only sure thing is that the SQL query is currently trying to use empty menu paths.
tryed runningin an
tryed runningin an update.php .
Fatal error: Call to undefined function: filter_xss_bad_protocol() in /home/*******/public_html/drupal/includes/common.inc on line 898
what exactly do you mean by running phpinfo in a file inside drupal directory like droping the php.ini file into the directory ?
cause i tried that , and not it does not give me an error , it just moves to the "install site" section of the installing process , but then nothing happens , no installing bar , just a blank page with home on it ? , any ideas, ?
http://img237.imageshack.us/my.php?image=screenshot052pl4.jpg
after looking around the forums i see alot of people are saying ot dropping the databases , and it will not hang i will try that and update if it works.
This new error message means
This new error message means that the filter module (modules/filter/filter.module) is either missing or unreadable or moved or disabled. To check whether it is disabled, look at the database, in the "system" table, to see if the "filter" module has status=0.
Normally this shouldn't be happening, because the filter module is one of the five "required" core modules (system, node, user, block, filter) and normally it is always enabled. This indicates that for some reason the installation was interrupted prematurely, and not only didn't it create the menus but also it didn't enable the required modules (and perhaps other things).
What I meant was:
- Create a text file and name it phpinfo.php
- Inside this file, enter the line
<?php phpinfo(); ?>- Upload it into Drupal's directory.
- Browse to phpinfo.php to run it. See what is says about memory_limit.
The purpose of this is to check if the memory_limit setting which you did actually works or not. Make sure to upload it into Drupal's directory, because different directories can have different php memory_limit settings.
By the way, if your local php.ini file contains only that one line, that may be a problem because then all other php settings are reset to some default values which may not be OK.
----- Edited to add:
While checking the "status" of the required modules in the system table, also check whether their paths are correct.
well i ran the phpinfo , and
well i ran the phpinfo , and it did come up different memory_limit 16M 16M
post_max_size 8M 8M , but that should still be emoungh yes ? my local php.ini , is not just one line.
i wend to filter module , and its status was = 0 , so i set it to 1 , still having the error, i am guessing that means the other five required core modules , need to be . so i check and only system had a status of 1, i changed , block node and user to 1 .
all the paths seems to correct
still having the problem of it freezing when it gets to install site.
This is a bit
This is a bit puzzling...
16M should be enough for a core-only installation, but try 32M anyway. Do it in Drupal's settings.php file (in sites/default/settings.php), by adding an
ini_set('memory_limit', '32M');, because that run-time method overrides all the others.yea "
yea " ini_set('memory_limit', '32M'); " into the setting php, still getting the error ,
What happens if, after
What happens if, after getting that page without content (your image), you enable the five required modules and then run update.php?
Do you have access to MySQL's settings on your server? Can you increase MySQL's max_allowed_packet to 16M or so in my.conf (or my.ini in Windows)?
when i try running
when i try running update.php , and it updates normally , and the drupal page comes up then tells me to log in , .....only have not created an admin account yet , so i am not sure what to enter , unless its set to default ?
when i try running
when i try running update.php , and it updates normally , and the drupal page comes up then tells me to log in , .....only have not created an admin account yet , so i am not sure what to enter , unless its set to default ?
Check the database, the
Check the database, the users table, to see if an account has been created with uid=1. If not, go back to Drupal and register one.
Thanks, cog.rusty
I was having the same problem. Seems like this took care of it.
Problem resolved by changing my server on Ubuntu Server
I've got the same issue. Drupal 6.16 was installed on a Debian Server. I Think that this issue is there because Drupal needs recent version of certain softwares. I've tried to upgrade my debian server with some new depots but it still didn't work. Now, I've switched my server on Ubuntu Server. Everything is OK.