Problems installing Drupal 6.3

[szern]

Hi All,

I'm having problems installing Drupal (either manually or via Installatron).
Mid-way through the installation (via the browser), I'm confronted with the following 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 ijcv_menu_router WHERE path IN () ORDER BY fit DESC LIMIT 0, 1 in /home/drupal/domains/dot.my/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 ijcv_menu_router WHERE path IN () ORDER BY fit DESC LIMIT 0, 1 in /home/drupal/domains/dot.my/public_html/drupal/includes/menu.inc on line 315.


I've already updated the system to Apache 2.x, PHP 5 and MySQL 5.0
I'm at wits end...

Can anyone please help?

Thanks!

[System Information]
[root@triton ~]# cat /etc/redhat-release
CentOS release 4.1 (Final)

[root@triton ~]# uname -a
Linux triton.xxx.xxx 2.6.9-11.ELsmp #1 SMP Wed Jun 8 17:54:20 CDT 2005 i686 i686 i386 GNU/Linux

System Uptime 194 Days, 12 Hours and 41 Minutes
Apache 2.2.9 Running
DirectAdmin 1.32.2 Running
Exim 4.51 Running
MySQL 5.0.51a Running
Named 9.2.4 Running
ProFTPd 1.3.1 Running
sshd Running
dovecot 1.1.1 Running

 

[Randy]

Considered about updating (letting a sysadmin) your system, not only php/http? CentOS 4.1 is about two years old. The current version is 4.6.
The problem possibly is in the MySQL version and PHP MySQL driver... Seen this one before...

 

[szern]

Hi Randy,

Thanks for the advice.
The machine itself is an old machine, with about less than 5 users.
It's been chugging along quite well and has no problems (aside from this Drupal install problem).

I know CentOS 4.1 is pretty old (heck I should know, since I installed it )

I used CustomBuild to updated the Apache, PHP and MySQL.
Since PHP was compiled against that very version of MySQL, the PHP MySQL driver should be compatible, no?

I thought of going MySQL 5.1, but since its not a release/stable version yet, decided against it.

Was wondering if anyone else ran across such problems, and if yes, what they did to surmount it.

Cheers!