[support] Update

[Cog Rusty]

On Fri, Dec 19, 2008 at 4:02 AM, Bob Salsburg <bsisok at 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/ ]
>