installing drupal with 1and1 hosting
* 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 /homepages/10/d258613186/htdocs/d/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 /homepages/10/d258613186/htdocs/d/includes/menu.inc on line 315.
thats the error I'm getting, I swear I've tried just about everything and searched everything possible on this. I thought it was settings.php at first but that doesn't seem to be it. any ideas?
ps i found this
ps i found this http://drupal.org/node/75041
but i cannot find database.4.0.mysql I'm assuming because its for 4.0 database
Your exact Drupal version?
Your exact Drupal version? Is it 6.4?
Is Drupal already installed? If so, try running update.php once to rebuild the menus.
If not, what are you doing when this error appears?
oh sorry installing it. I
oh sorry installing it. I set permissions and all the stuff to settings.php even tried to make a new one still didnt work.
Does your browser or your
Does your browser or your firewall block cookies? Try to allow them or try a different browser.
Don't make changes to settings.php, or explain what changes you made, otherwise it will be impossible to guess what the problem is.
I still don't know what Drupal version you are using. There are many posts about installing on 1on1, but I doubt that is the problem here.
I installed it on another
I installed it on another server and got it to run, with this exact setup just different server, it seems like a server setting possibly? though Im not sure. im running 6.4 there is no documents on this one, everything ive read is not for this problem or a different version of drupal
Are you using a real domain
Are you using a real domain name or some temporary IP on 1on1? What is your URL like? Does it contain any subdirectory path?
www.domainname.com/drupal is
www.domainname.com/drupal is the format not using subdomain or a temp one, only wierd thing is they link their database externally, but i compensated for that by adding that in where localhost should be
What is strange with the
What is strange with the error message is that probably Drupal's tables are already installed (it does not complain about missing tables) but something is wrong with them. There should have been other error messages before that one.
Take a look at the database, drop all tables if they exist, and start over with a clean settings.php copy, and this time run http://www.domainname.com/drupal/install.php. And of course specify your database server again in the advanced settings during installation.
From the 1on1 issues I have seen, there doesn't seem to be anything wrong, except a setting for enabling clean URLs, but that is for later.
woah wierd, it must have
woah wierd, it must have just been a faulty database, might have even had residual or default data that conflicted.
I cleared the database and it works perfect, thanks much for your help!