By isaacbowman.com on
I have been trying to upgrade 2 sites to mysql 5 so they can then switch to 6.8 and I am having issues. A friend upgraded the db to mysql5 and it works fine with Drupal 5.12 but when I switch the DNS to the new folder it get a bunch of errors. The new folder already has 4 sites running on it just fine.
I am using a backup DB on a dev.mysite.com running in the 5.12 directory. I disabled modules and switched to a default theme. But when the DNS flips to the 6.8 directory I get the errors below and I cannot update.php (goes to a blank page /update.php?op=info) so what do you suggest? Did I miss something?
What is the proper process when upgrading the DB and Drupal?
Here are my errors:
Warning: Unknown column 'serialized' in 'field list' query: SELECT data, created, headers, expire, serialized FROM cache WHERE cid = 'variables' in /homepages/xx/dxxx/xxx/drupal-6.8/includes/database.mysql.inc on line 128
Warning: Unknown column 'serialized' in 'field list' query: UPDATE cache SET data = 'a:529:{s:13:\"filter_html_1\";s:1:\"1\";s:18:\"node_options_forum\";a:1:{i:0;s:6:\"status\";}s:17:\"menu_primary_menu\";s:3:\"203\";s:19:\"menu_secondary_menu\";s:1:\"0\";s:12:\"clean_url_ok\";i:1;s:19:\"file_directory_temp\";s:4:\"/tmp\";s:12:\"site_mission\";s:86:\"Thinking outside the box! Isaac Bowman\'s professional site on business and technology.\";s:9:\"anonymous\";s:9:\"Anonymous\";s:14:\"site_frontpage\";s:4:\"node\";s:9:\"clean_url\";s:1:\"1\";s:8:\"site_403\";s:0:\"\";s:11:\"error_level\";s:1:\"0\";s:14:\"watchdog_clear\";s:7:\"2419200\";s:5:\"cache\";s:1:\"1\";s:14:\"cache_lifetime\";s:1:\"0\";s:14:\"fi in /homepages/xx/dxxx/xxx/drupal-6.8/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://dev.mysite.com/' in /homepages/xx/dxxx/xxx/drupal-6.8/includes/database.mysql.inc on line 128
Warning: Cannot modify header information - headers already sent by (output started at/homepages/xx/dxxx/xxx/drupal-6.8/includes/database.mysql.inc:128) in /homepages/xx/dxxx/xxx/drupal-6.8/includes/bootstrap.inc on line 610
Warning: Cannot modify header information - headers already sent by (output started at /homepages/xx/dxxx/xxx/drupal-6.8/includes/database.mysql.inc:128) in /homepages/xx/dxxx/xxx/drupal-6.8/includes/bootstrap.inc on line 611
Warning: Cannot modify header information - headers already sent by (output started at/homepages/xx/dxxx/xxx/drupal-6.8/includes/database.mysql.inc:128) in /homepages/xx/dxxx/xxx/drupal-6.8/includes/bootstrap.inc on line 612
Warning: Cannot modify header information - headers already sent by (output started at /homepages/xx/dxxx/xxx/drupal-6.8/includes/database.mysql.inc:128) in /homepages/xx/dxxx/xxx/drupal-6.8/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 /homepages/xx/dxxx/xxx/drupal-6.8/includes/database.mysql.inc on line 128
Comments
just copy the nodes?
This is a single user blog site. Would it be easier to just create a new Drupal 6.8 site and then copy in the older sites' blogs? What SQL command would capture the right tables for this?
Is there an easy way to import all of my blogs from my 5.12 site to the new 6.8? The Backup or Migrate module can't seem to handle this issue with converting from SQL 4 to 5. It seems like there should be an easy admin accessible RSS feed to send nodes from one site to the next.
Isaac Bowman
www.isaacbowman.com
I saw this error too and I
I saw this error too and I think it was because I wasn't doing the update properly. Did you update the settings.php before you visited your site ?
yes its a new settings.php
I have two directories, one with 5.12 and one with 6.8 - both have sites running under these dir files.
When I pointed the 5.12 site (with the SQL 5 DB) to the new dir it was pointing to a new 6.8 settings.php file.
Isaac Bowman
www.isaacbowman.com
any suggestions?
Sorry for the bump but figured I should try during normal hours.
Isaac Bowman
www.isaacbowman.com