Solved – Warning: Unknown column ‘serialized’ in ‘field list’ – error while upgrading Drupal

Posted on October 20, 2009 by zzz_zwp

ALTER TABLE cache_similarterms ADD serialized SMALLINT(6) NOT NULL;

Leave a Reply Cancel reply

Toggle Console (0)

No entries found.

Profiler (0 ms)

No entries found.

SQL (32 queries | 19.94 ms)

0.6189	`SELECT option_value FROM wp_options WHERE option_name = 'GOTMLS_nonce_array' LIMIT 1`
0.5059	`SELECT option_value FROM wp_options WHERE option_name = 'GOTMLS_definitions_array' LIMIT 1`
0.7322	`SELECT option_value FROM wp_options WHERE option_name = 'GOTMLS_scan_log/3.147.63.162/1740245621.1816' LIMIT 1`
0.6549	`SELECT option_value FROM wp_options WHERE option_name = 'gzipcompression' LIMIT 1`
0.7019	`SELECT option_value FROM wp_options WHERE option_name = 'rsssl_encryption_keys_set' LIMIT 1`
0.6309	`SELECT option_value FROM wp_options WHERE option_name = 'rsssl_le_certificate_generated_by_rsssl' LIMIT 1`
0.6719	`SELECT option_value FROM wp_options WHERE option_name = 'rsssl_ssl_activation_active' LIMIT 1`
0.7081	`SELECT option_name, option_value FROM wp_options WHERE option_name IN ('_site_transient_wp_theme_files_patterns-521ceac6f7ea50d1f2c96a08a1af8fc4','_site_transient_timeout_wp_theme_files_patterns-521ceac6f7ea50d1f2c96a08a1af8fc4')`
0.5090	`SELECT option_value FROM wp_options WHERE option_name = 'preload_cache_counter' LIMIT 1`
0.7761	`SELECT ID, post_name, post_parent, post_type FROM wp_posts WHERE post_name IN ('solved-warning-unknown-column-serialized-in-field') AND post_type IN ('page','attachment')`
0.7420	`SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.post_name = 'solved-warning-unknown-column-serialized-in-field' AND wp_posts.post_type = 'post' ORDER BY wp_posts.post_date DESC`
1.0970	`SELECT DISTINCT t.term_id, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag', 'post_format') AND tr.object_id IN (1046) ORDER BY t.name ASC`
0.8421	`SELECT t., tt. FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE t.term_id IN (95,109,6,1,108)`
0.5980	`SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (1046) ORDER BY meta_id ASC`
0.6769	`SELECT * FROM wp_posts WHERE ID = 1716 LIMIT 1`
0.2890	`SELECT option_value FROM wp_options WHERE option_name = 'https_migration_required' LIMIT 1`
0.3810	`SELECT option_value FROM wp_options WHERE option_name = 'site_logo' LIMIT 1`
0.5338	`SELECT t., tt. FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE t.term_id = 468`
1.0440	`SELECT wp_posts.* FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) WHERE 1=1 AND ( wp_term_relationships.term_taxonomy_id IN (468) ) AND wp_posts.post_type = 'nav_menu_item' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.menu_order ASC`
0.6502	`SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (1670,1671,1672,1681,1682) ORDER BY meta_id ASC`
0.2551	`SELECT wp_posts.* FROM wp_posts WHERE ID IN (1542,1534,1579,1544)`
0.4570	`SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (1542,1534,1579,1544) ORDER BY meta_id ASC`
0.7920	`SELECT DISTINCT t.term_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category') AND tr.object_id IN (1046) ORDER BY t.name ASC`
0.9971	`SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (1) ORDER BY umeta_id ASC`
0.3660	`SELECT * FROM wp_users WHERE ID IN (1)`
0.5360	`SELECT p.ID FROM wp_posts AS p WHERE p.post_date < '2009-10-20 17:16:05' AND p.post_type = 'post' AND p.post_status = 'publish' ORDER BY p.post_date DESC LIMIT 1`
0.4511	`SELECT * FROM wp_posts WHERE ID = 1047 LIMIT 1`
0.5660	`SELECT p.ID FROM wp_posts AS p WHERE p.post_date > '2009-10-20 17:16:05' AND p.post_type = 'post' AND p.post_status = 'publish' ORDER BY p.post_date ASC LIMIT 1`
0.5782	`SELECT * FROM wp_posts WHERE ID = 1045 LIMIT 1`
0.6361	`SELECT SQL_CALC_FOUND_ROWS wp_comments.comment_ID FROM wp_comments WHERE ( comment_approved = '1' ) AND comment_post_ID = 1046 AND comment_parent = 0 ORDER BY wp_comments.comment_date_gmt ASC, wp_comments.comment_ID ASC`
0.4480	`SELECT option_value FROM wp_options WHERE option_name = 'akismet_comment_nonce' LIMIT 1`
0.4921	`SELECT option_value FROM wp_options WHERE option_name = 'akismet_comment_form_privacy_notice' LIMIT 1`

Templates

[0] => themes/twentyeleven/inc/theme-options.php
[1] => themes/twentyeleven/inc/widgets.php
[2] => themes/twentyeleven/single.php
[3] => themes/twentyeleven/header.php
[4] => themes/twentyeleven/searchform.php
[5] => themes/twentyeleven/content-single.php
[6] => themes/twentyeleven/comments.php
[7] => themes/twentyeleven/footer.php
[8] => themes/twentyeleven/sidebar-footer.php

Globals

$_GET = array (
);

$_POST = array (
);

$_COOKIE = array (
);

$_SESSION = array (
);

$_SERVER = array (
  'SERVER_SOFTWARE' => 'Apache',
  'REQUEST_URI' => '/solved-warning-unknown-column-serialized-in-field/',
  'LSPHP_ENABLE_USER_INI' => 'on',
  'PATH' => '/usr/local/bin:/usr/bin:/bin',
  'TEMP' => '/tmp',
  'TMP' => '/tmp',
  'TMPDIR' => '/tmp',
  'PWD' => '/',
  'HTTP_ACCEPT' => '*/*',
  'HTTP_ACCEPT_ENCODING' => 'gzip, br, zstd, deflate',
  'CONTENT_LENGTH' => '0',
  'HTTP_HOST' => 'www.zzzzzzzzz.net',
  'HTTP_REFERER' => 'https://zzzzzzzzz.net/solved-warning-unknown-column-serialized-in-field',
  'HTTP_USER_AGENT' => 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)',
  'HTTP_X_HTTPS' => '1',
  'REDIRECT_UNIQUE_ID' => 'Z7oKdX5NQMlFE8b4-x2P1AABG2E',
  'REDIRECT_QS_ConnectionId' => '174024562114400745833620',
  'REDIRECT_SCRIPT_URL' => '/solved-warning-unknown-column-serialized-in-field/',
  'REDIRECT_SCRIPT_URI' => 'https://www.zzzzzzzzz.net/solved-warning-unknown-column-serialized-in-field/',
  'REDIRECT_HTTPS' => 'on',
  'REDIRECT_SSL_TLS_SNI' => 'www.zzzzzzzzz.net',
  'REDIRECT_HTTP2' => 'on',
  'REDIRECT_H2PUSH' => 'off',
  'REDIRECT_H2_PUSH' => 'off',
  'REDIRECT_H2_PUSHED' => '',
  'REDIRECT_H2_PUSHED_ON' => '',
  'REDIRECT_H2_STREAM_ID' => '1',
  'REDIRECT_H2_STREAM_TAG' => '833620-1125-1',
  'REDIRECT_STATUS' => '200',
  'UNIQUE_ID' => 'Z7oKdX5NQMlFE8b4-x2P1AABG2E',
  'QS_ConnectionId' => '174024562114400745833620',
  'SCRIPT_URL' => '/solved-warning-unknown-column-serialized-in-field/',
  'SCRIPT_URI' => 'https://www.zzzzzzzzz.net/solved-warning-unknown-column-serialized-in-field/',
  'HTTPS' => 'on',
  'SSL_TLS_SNI' => 'www.zzzzzzzzz.net',
  'HTTP2' => 'on',
  'H2PUSH' => 'off',
  'H2_PUSH' => 'off',
  'H2_PUSHED' => '',
  'H2_PUSHED_ON' => '',
  'H2_STREAM_ID' => '1',
  'H2_STREAM_TAG' => '833620-1125-1',
  'SERVER_SIGNATURE' => '',
  'SERVER_NAME' => 'www.zzzzzzzzz.net',
  'SERVER_ADDR' => '192.185.137.117',
  'SERVER_PORT' => '443',
  'REMOTE_ADDR' => '3.147.63.162',
  'DOCUMENT_ROOT' => '/home1/zzz/public_html',
  'REQUEST_SCHEME' => 'https',
  'CONTEXT_PREFIX' => '',
  'CONTEXT_DOCUMENT_ROOT' => '/home1/zzz/public_html',
  'SERVER_ADMIN' => 'webmaster@zzzzzzzzz.net',
  'SCRIPT_FILENAME' => '/home1/zzz/public_html/index.php',
  'REMOTE_PORT' => '57631',
  'REDIRECT_URL' => '/solved-warning-unknown-column-serialized-in-field/',
  'SERVER_PROTOCOL' => 'HTTP/2.0',
  'REQUEST_METHOD' => 'GET',
  'QUERY_STRING' => '',
  'SCRIPT_NAME' => '/index.php',
  'PHP_SELF' => '/index.php',
  'REQUEST_TIME_FLOAT' => 1740245621.15569400787353515625,
  'REQUEST_TIME' => 1740245621,
  'argv' => 
  array (
  ),
  'argc' => 0,
);

z z z z z z z z z

z z z z z z z z z

Solved – Warning: Unknown column ‘serialized’ in ‘field list’ – error while upgrading Drupal

Leave a Reply Cancel reply