What would cause this error in the upgrade? I've disabled all but the core modules and the new install directory has only the current 6.10 files, plus some outside scripts. I'm not logged in as user 1 but fere_upgrade is set true in the settings file. Could anyone tell me which of these modules from the system table are not required? Is there another good place to look? Thanks for any advise.

Warning: Unknown column 'serialized' in 'field list' query: SELECT data, created, headers, expire, serialized FROM cache WHERE cid = 'variables' in /var/www/nick.beach.tableausoftware.com/includes/database.mysql.inc on line 128

Warning: Unknown column 'serialized' in 'field list' query: UPDATE cache SET data = 'a:511:{s:13:\"filter_html_1\";i:1;s:18:\"node_options_forum\";a:2:{i:0;s:6:\"status\";i:1;s:8:\"revision\";}s:15:\"install_profile\";s:7:\"default\";s:17:\"node_options_page\";a:2:{i:0;s:6:\"status\";i:1;s:8:\"revision\";}s:12:\"comment_page\";s:1:\"0\";s:18:\"drupal_private_key\";s:64:\"571adfaab278e0c7440597c77a49f7543822db0f46c2839053e7b4da943521a8\";s:9:\"cron_last\";i:1232582402;s:19:\"file_directory_temp\";s:4:\"/tmp\";s:13:\"theme_default\";s:12:\"tableauTheme\";s:9:\"site_name\";s:19:\"DEV | Tableau Soft \";s:9:\"site_mail\";s:35:\"customerservice@tableausoftware.com\";s:11:\"site_slogan\";s:2:\"NN\";s:12:\"site_mission\";s:0:\"\";s:11:\"site in /var/www/nick.beach.tableausoftware.com/includes/database.mysql.inc on line 128

Warning: Cannot modify header information - headers already sent by (output started at /var/www/nick.beach.tableausoftware.com/includes/database.mysql.inc:128) in /var/www/nick.beach.tableausoftware.com/includes/bootstrap.inc on line 630

Warning: Cannot modify header information - headers already sent by (output started at /var/www/nick.beach.tableausoftware.com/includes/database.mysql.inc:128) in /var/www/nick.beach.tableausoftware.com/includes/bootstrap.inc on line 631

Warning: Cannot modify header information - headers already sent by (output started at /var/www/nick.beach.tableausoftware.com/includes/database.mysql.inc:128) in /var/www/nick.beach.tableausoftware.com/includes/bootstrap.inc on line 632

Warning: Cannot modify header information - headers already sent by (output started at /var/www/nick.beach.tableausoftware.com/includes/database.mysql.inc:128) in /var/www/nick.beach.tableausoftware.com/includes/bootstrap.inc on line 633

Warning: Unknown column 'language' in 'where clause' query: SELECT src FROM url_alias WHERE dst = 'upgrade.php' AND language IN('en', '') ORDER BY language DESC in /var/www/nick.beach.tableausoftware.com/includes/database.mysql.inc on line 128
Home
Page not found
The requested page could not be found.

Home
Page not found
The requested page could not be found.

select * from system where status=1;
+-----------------------------------------------+-------------+--------------+--------------------------------------------------------------------+--------+----------+-----------+----------------+--------+
| filename                                      | name        | type         | description                                                        | status | throttle | bootstrap | schema_version | weight |
+-----------------------------------------------+-------------+--------------+--------------------------------------------------------------------+--------+----------+-----------+----------------+--------+
| modules/system/system.module                  | system      | module       | Handles general site configuration for administrators.             |      1 |        0 |         0 |           1022 |      0 |
| modules/block/block.module                    | block       | module       | Controls the boxes that are displayed around the main content.     |      1 |        0 |         0 |              0 |      0 |
| modules/filter/filter.module                  | filter      | module       | Handles the filtering of content in preparation for display.       |      1 |        0 |         0 |              0 |      0 |
| modules/node/node.module                      | node        | module       | Allows content to be submitted to the site and displayed on pages. |      1 |        0 |         0 |              0 |      0 |
| modules/user/user.module                      | user        | module       | Manages the user registration and login system.                    |      1 |        0 |         0 |              0 |      0 |
| modules/watchdog/watchdog.module              | watchdog    | module       | Logs and records system events.                                    |      1 |        0 |         0 |              0 |      0 |
| themes/engines/zengine/zengine.engine         | zengine     | theme_engine |                                                                    |      1 |        0 |         0 |             -1 |      0 |
| themes/engines/phptemplate/phptemplate.engine | phptemplate | theme_engine |                                                                    |      1 |        0 |         0 |             -1 |      0 |
| themes/garland/page.tpl.php                   | garland     | theme        | themes/engines/phptemplate/phptemplate.engine                      |      1 |        0 |         0 |             -1 |      0 |
| modules/menuTop/menuTop.module                | menuTop     | module       | Adds a menu to the navigation block.                               |      1 |        0 |         0 |              0 |      0 |
| sites/all/modules/notify/notify.module        | notify      | module       | Enables notifications of new content and comments by e-mail.       |      1 |        0 |         0 |              3 |     10 |
+-----------------------------------------------+-------------+--------------+--------------------------------------------------------------------+--------+----------+-----------+----------------+--------+
11 rows in set (0.00 sec)

Comments

sonicthoughts’s picture

upgrade from 5 ->6.10

blup’s picture

I just got the same problem right now. Subscribing.

nicknickoli’s picture

Looks like this was the permissions for sites/default/settings.php. $chmod g+w settings.php did the trick! For the bug afterwards, enabling the taxonomy module then hitting update again updated the forumn modules. Not bad. Thanks for the help on other posts.

prokopton’s picture

Sub.

happysnowmantech’s picture

The unknown column error is probably the same as this:
http://drupal.org/node/222533

It seems like this problem may show up in different cache tables. In my case, I saw it with the cache_block table. To fix it, I ran this SQL and then refreshed the Drupal cache.

DELETE FROM cache_block;
ALTER TABLE cache_block ADD serialized SMALLINT(6) NOT NULL;
BenStallings’s picture

Thank you for this fix, happysnowmantech!