Hi,
I downloaded Drupal6.2 from download section of drupal website.
In installtion process on windows xp pack 2
1] First created Database Drupal in mysql.
2] I start http://localhost/drupal/install.php
3] Language setup
4] In database setup step I got an error as
"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 C:\xampp\htdocs\Drupal\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 C:\xampp\htdocs\Drupal\includes\menu.inc on line 316."
So what is wrong in my installtion process?
Is it any more setting required for installtion?
Please help me !!!!!!!!!
Varsha
Comments
A few more questions
It gave out a SQL syntax error.
Which is the SQL you are using? The best is to use the apache web server with PHP 4.3.5 or greater and MySQL server with MySQL 4.1.1 or greater.
______________________
Alexei Rayu, Web Designer and Developer
SpryDev, Austin TX, Search Engine Marketing
WE GUARANTEE WEB PROFITS
http://www.sprydev.com/design-gallery
Isn't it a warning?
Isn't it a warning?
Perhaps this is because php has not "error_reporting set to E_ALL & ~E_NOTICE" (see http://drupal.org/requirements)?
Ditto
I hate for my first post to be "me, too!", but I'm getting the same error other than mine indicates line 315 in menu.inc. And the path is different, of course.
Still researching, but would appreciate any guidance provided.
Ainvar
@varsha123; have you had any
@varsha123; have you had any luck getting past this?
Here is my set up:
* Drupal 6.6
* XAMPP version 1.6.8
(
+ Apache 2.2.9
+ MySQL 5.0.67 (Community Server)
+ PHP 5.2.6 + PHP 4.4.9 + PEAR
+ PHP-Switch win32 1.0 (use "php-switch.bat" in the xampp main directory)
+ XAMPP Control Version 2.5 from www.nat32.com
+ XAMPP Security 1.0
+ SQLite 2.8.15
+ OpenSSL 0.9.8i
+ phpMyAdmin 2.11.9.2
+ ADOdb 4.990
+ Mercury Mail Transport System v4.52
+ FileZilla FTP Server 0.9.27
+ Webalizer 2.01-10
+ Zend Optimizer 3.3.0
+ eAccelerator 0.9.5.3 für PHP 5.2.6 (but not activated in the php.ini)
)
* Windows XP Pro, SP 2
I followed the directions on http://drupal.org/node/307956, and double checked the requirements referred to in one of the reply posts.
The error message I get after following the final steps of the Simple Install instruction 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 ') 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 C:\xampp\htdocs\drupal\includes\menu.inc on line 315.
It sure looks like the "path IN ()" part is the problem. I've had to code around an "IN" clause that may need to be changed based upon the value of the path variable. That said, this is my first attempt at installing Drupal and I assume that I have an installation and configuration error rather than having stumbled across a legit bug.
Any guidance?
Thanks,
Peter
Resolved
I seemed to get around the issue by shutting everything down and rebooting. Then I reviewed all changes and verified the requirements.
I found one recommended setting that I backed out. In c:\xampp\apache\bin\php.ini, it was recommended that one set "session.save_handler = user"
When phpMyAdmin wouldn't log in, I restored this line to "session.save_handler = files". Then I was able to get into phpMyAdmin. I dropped the "drupal" database and created a new one. The installation script then worked.
Hope this helps someone.
- Peter