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 joaoa on
The installation of Drupal 6.1 fails at step 3 showing these errors:
# 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/joaocarlosalves/htdocs/drupal6/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/joaocarlosalves/htdocs/drupal6/includes/menu.inc on line 31
And these too:
Warning: Unknown column 'serialized' in 'field list' query: SELECT data, created, headers, expire, serialized FROM cache WHERE cid = 'variables' in /home/joaocarlosalves/htdocs/drupal6/includes/database.mysql.inc on line 128
Warning: Unknown column 'serialized' in 'field list' query: UPDATE cache SET data = 'a:40:{s:13:\"theme_default\";s:4:\"blix\";s:13:\"filter_html_1\";i:1;s:18:\"node_options_forum\";a:1:{i:0;s:6:\"status\";}s:17:\"menu_primary_menu\";i:2;s:19:\"menu_secondary_menu\";i:2;s:15:\"install_profile\";s:7:\"default\";s:17:\"node_options_page\";a:1:{i:0;s:6:\"status\";}s:12:\"comment_page\";i:0;s:14:\"theme_settings\";a:1:{s:21:\"toggle_node_info_page\";b:0;}s:18:\"drupal_private_key\";s:64:\"1d163b0d2dc691bf9d7815d1278f00b3d138224f18dad06615a3ec1503112ceb\";s:19:\"file_directory_temp\";s:25:\"/home/joaocarlosalves/tmp\";s:9:\"cron_last\";i:1202767459;s:11:\"admin_theme\";s:7:\"garland\";s:21:\"date_default_timezone\";s:1:\"0\";s:22:\"configurable_timezones\";s:1:\& in /home/joaocarlosalves/htdocs/drupal6/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://joaocarlosalves.eu/drupal6/install.php?profile=default&locale=en' in /home/joaocarlosalves/htdocs/drupal6/includes/database.mysql.inc on line 128
Warning: Cannot modify header information - headers already sent by (output started at /home/joaocarlosalves/htdocs/drupal6/includes/database.mysql.inc:128) in /home/joaocarlosalves/htdocs/drupal6/includes/bootstrap.inc on line 577
Warning: Cannot modify header information - headers already sent by (output started at /home/joaocarlosalves/htdocs/drupal6/includes/database.mysql.inc:128) in /home/joaocarlosalves/htdocs/drupal6/includes/bootstrap.inc on line 578
Warning: Cannot modify header information - headers already sent by (output started at /home/joaocarlosalves/htdocs/drupal6/includes/database.mysql.inc:128) in /home/joaocarlosalves/htdocs/drupal6/includes/bootstrap.inc on line 579
Warning: Cannot modify header information - headers already sent by (output started at /home/joaocarlosalves/htdocs/drupal6/includes/database.mysql.inc:128) in /home/joaocarlosalves/htdocs/drupal6/includes/bootstrap.inc on line 580
Any help would be appreciated.
Thanks,
Joao
Comments
Install failure
I had a similar install error on the 6.0 version.
During the troubleshooting, I realized that the people helping me figure the problem out couldn't get to the mySQL database with 'local' as the access. (My Hosting service provides a built-in myPHPadmin console but they couldn't get at that wihout granting strangers more access than was advisable.)
I set the database access to 'Remote/Local' via myPHPadmin, re-installed 6.1 from scratch and tried again. Things worked better that time.
Thanks for your reply. Could
Thanks for your reply. Could you tell me how you set the database access to 'Remote/Local'? It might be helpful for me too.
Local or Remote?
My hosting service actually provides a custom console for database management with this feature. So their instructions won't apply. However, if you didn't have to change the advanced options for the database from localhost, then this solution probably won't apply anyway.
(Watch the Lullabot install video for Drupal 6 at http://drupal.org/videocasts/installing-6 and see if that helps. The database setup portion begins at 5 minutes.)
After writing, I went back, deleted the database and drupal 6.1 files and reinstalled using the Local setting only. This time it worked too!
The Princes Bride
ubuntulistener
Inconceivable!