6.16 Update Weirdness

I've seen those errors as well when I've done upgrades before, but when I do like Rightsprocket said, run update.php and clear ALL caches as well as run cron, they eventually went away.

There are a few cache tables in the DB. Am I supposed to clear out all of them or specific ones?

I run a few Drupal sites and felt that it was time to start upgrading to v6.16 from v5.1.
I started a test run on one of my sites...
I backed up the database and content.
Set the theme to garland and even turned off most of the extra modules other than the core modules.
I then deleted the v5.1 files and copied over the new v6.1 files. I also replaced all of the modules with their newer updates. I did keep the settings.php.

I brought the site up and received the following error in summary:
Warning: Unknown column 'serialized' in 'field list' query: SELECT data, created, headers, expire, serialized FROM cache WHERE cid = 'variables' ...

I followed some tips and did the following:
ALTER TABLE cache
ADD serialized smallint(6) NOT NULL default '0';

I've clear the cache "DELETE FROM TABLE 'cache'
and have even rebuilt the cache

CREATE TABLE IF NOT EXISTS cache (
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

and have also restored the existing database to start the steps over again.

No matter what I end up at the same place with the following message and cannot access anything else.
warning: Invalid argument supplied for foreach() in /home/public_html/site/includes/theme.inc on line 485.
warning: Invalid argument supplied for foreach() in /home/public_html/site/includes/theme.inc on line 490.

The code in theme.inc [484-494] is:

foreach ($themes as $theme) {
foreach ($theme->info['stylesheets'] as $media => $stylesheets) {
foreach ($stylesheets as $stylesheet => $path) {
$theme->stylesheets[$media][$stylesheet] = $path;
}
}
foreach ($theme->info['scripts'] as $script => $path) {
if (file_exists($path)) {
$theme->scripts[$script] = $path;
}
}

I'd appreciate any tips or suggestions...

Thanks

FWIW, I posted my solution to the problem here: http://drupal.org/node/860428#comment-3314346

HTH.

Hi,

My situation is a little odd, so my solution may not apply. I was moving from Drupal 5 to 6 in a closed multi-site environment, so I was doing the migration via a database dump and import.

I had to go to the system table and edit the info field. Somehow the type had been changed from text to varchar (255), which truncated the info being passed so that references to stylesheets and such were left out.

-Chase