On Fri, Dec 19, 2008 at 4:02 AM, Bob Salsburg bsisok@gmail.com wrote:

This is a cross post in the forums.

After starting Drupal 6.8 upgraded from 5.14, the sequence at bottom occurs. According to the incomplete and cryptic comments in the several issues found in the forums, there is apparently a table or tables that do not get updated. The roof caves in when the password is entered.

My question is: How to identify the offending items from this goop?

In one of the posts, the following query was advised to be run after recreating the table or item (unclear):

CREATE TABLE IF NOT EXISTS `cache_location` ( `cid` varchar(255) NOT NULL default '', `data` longblob, `expire` int(11) NOT NULL default '0', `created` int(11) NOT NULL default '0', `headers` text, `serialized` smallint(6) NOT NULL default '0', PRIMARY KEY (`cid`), KEY `expire` (`expire`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8

This query seems unrelated to the error message that you mention below. The error message is about something missing from the main "cache" table, while this query creates a cache table for some contributed module, apparenty the location module.

Longblob? Too technical for me.

Warning: Unknown column 'serialized' in 'field list' query: UPDATE cache SET data = 'a:174:{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:18:{s:11:"toggle_logo";i:1;s:11:"toggle_name";i:1;s:13:"toggle_slogan";i:0;s:14:"toggle_mission";i:1;s:24:"toggle_node_user_picture";i:0;s:27:"toggle_comment_user_picture";i:0;s:13:"toggle_search";i:0;s:14:"toggle_favicon";i:1;s:21:"toggle_node_info_page";i:0;s:22:"toggle_node_info_story";i:0;s:12:"default_logo";i:1;s:9:"logo_path";s:0:"";s:11:"logo_upl in /home/christch/public_html/includes/database.mysqli.inc on line 128

===================================

This error message indicates that either you did not run update.php to update the database, or update.php was interrupted and didn't complete successfully. - Check the requirements for Drupal 6 in http://drupal.org/requirements, and especially the php memory_limit (see http://drupal.org/node/207036). What was good enough for Drupal 5 may not be OK for Drupal 6. - Run update.php again and make sure that it completes.

The error string. There is a bunch more, but this is the initial seqence

The other error messages are just a result of displaying the first error message.

Warning: Cannot modify header information - headers already sent by (output started at /home/christch/public_html/includes/database.mysqli.inc:128) in /home/christch/public_html/includes/bootstrap.inc on line 610

Warning: Cannot modify header information - headers already sent by (output started at /home/christch/public_html/includes/database.mysqli.inc:128) in /home/christch/public_html/includes/bootstrap.inc on line 611

Warning: Cannot modify header information - headers already sent by (output started at /home/christch/public_html/includes/database.mysqli.inc:128) in /home/christch/public_html/includes/bootstrap.inc on line 612

Warning: Cannot modify header information - headers already sent by (output started at /home/christch/public_html/includes/database.mysqli.inc:128) in /home/christch/public_html/includes/bootstrap.inc on line 613

Warning: Unknown column 'language' in 'where clause' query: SELECT src FROM url_alias WHERE dst = 'node' AND language IN('en', '') ORDER BY language DESC in /home/christch/public_html/includes/database.mysqli.inc on line 128

-- [ Drupal support list | http://lists.drupal.org/ ]