Email
Share

We Rock Your Web Forum » Troubleshooting » Error Messages

user warning: Unknown column 'serialized' in 'field list' query: UPDATE cache_

(2 posts)

  1. DrupalJunkie

    senior member
    Joined: Oct '09
    Posts: 77

    Reputation:140
     

    I recently upgraded my site from Drupal 5 to 6, and now I keep getting the following error message when I run update: "user warning: Unknown column 'serialized' in 'field list' query: UPDATE cache_views"

    Any ideas what I need to do to resolve this? I tried upgrading views to no avail.

    Posted 1 year ago #


  2. Posted 1 year ago

  3. cwd

    senior admin
    Joined: Jul '09
    Posts: 225

    Reputation:244
     

    Try upgrading the table in question using the following code (substitute cache_views, cache_page, cache_location, cache_block, etc. depending on what shows up in your error message):

    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
    Posted 1 year ago #

RSS feed for this topic

Reply

(required)

Allowed markup: BBcode blockquote code em strong ul ol li font strike center u hr.
You can also put code in between backtick ( ` ) characters.