[drupal-support] Upgrading database from 4.5.4 to 4.6.2 (was
Psychophobia)
sunblockster at gmail.com
sunblockster at gmail.com
Thu Jul 21 01:53:50 UTC 2005
I have successfully upgraded the database from 4.5.4 to 4.6.2, and
fixed the term_node duplicates problem following Gerhard's instructions!
However, I now get this series of errors when I click on "Blocks" in
Adminisration. So close!
> user error: Unknown column 'throttle' in 'field list'
> query: INSERT INTO blocks (module, delta, status, weight, region,
> visibility, pages, custom, throttle, types) VALUES ('block', '1',
> 1, 0, 0, 0, '', 0, 0, '') in /big/dom/xpublic_domain/www/drupal462/
> includes/database.mysql.inc on line 66.
>
> user error: Unknown column 'throttle' in 'field list'
> query: INSERT INTO blocks (module, delta, status, weight, region,
> visibility, pages, custom, throttle, types) VALUES ('comment', '0',
> 0, 0, 0, 0, '', 0, 0, '') in /big/dom/xpublic_domain/www/drupal462/
> includes/database.mysql.inc on line 66.
>
> user error: Unknown column 'throttle' in 'field list'
> query: INSERT INTO blocks (module, delta, status, weight, region,
> visibility, pages, custom, throttle, types) VALUES ('node', '0', 1,
> 0, 0, 0, '', 0, 0, '') in /big/dom/xpublic_domain/www/drupal462/
> includes/database.mysql.inc on line 66.
>
> user error: Unknown column 'throttle' in 'field list'
> query: INSERT INTO blocks (module, delta, status, weight, region,
> visibility, pages, custom, throttle, types) VALUES ('poll', '0', 0,
> 0, 0, 0, '', 0, 0, '') in /big/dom/xpublic_domain/www/drupal462/
> includes/database.mysql.inc on line 66.
>
> user error: Unknown column 'throttle' in 'field list'
> query: INSERT INTO blocks (module, delta, status, weight, region,
> visibility, pages, custom, throttle, types) VALUES ('search', '0',
> 0, 0, 0, 0, '', 0, 0, '') in /big/dom/xpublic_domain/www/drupal462/
> includes/database.mysql.inc on line 66.
>
> user error: Unknown column 'throttle' in 'field list'
> query: INSERT INTO blocks (module, delta, status, weight, region,
> visibility, pages, custom, throttle, types) VALUES ('user', '0', 1,
> 0, 0, 0, '', 0, 0, '') in /big/dom/xpublic_domain/www/drupal462/
> includes/database.mysql.inc on line 66.
>
> user error: Unknown column 'throttle' in 'field list'
> query: INSERT INTO blocks (module, delta, status, weight, region,
> visibility, pages, custom, throttle, types) VALUES ('user', '1', 1,
> 0, 0, 0, '', 0, 0, '') in /big/dom/xpublic_domain/www/drupal462/
> includes/database.mysql.inc on line 66.
>
> user error: Unknown column 'throttle' in 'field list'
> query: INSERT INTO blocks (module, delta, status, weight, region,
> visibility, pages, custom, throttle, types) VALUES ('user', '2', 0,
> 0, 0, 0, '', 0, 0, '') in /big/dom/xpublic_domain/www/drupal462/
> includes/database.mysql.inc on line 66.
>
> user error: Unknown column 'throttle' in 'field list'
> query: INSERT INTO blocks (module, delta, status, weight, region,
> visibility, pages, custom, throttle, types) VALUES ('user', '3', 0,
> 0, 0, 0, '', 0, 0, '') in /big/dom/xpublic_domain/www/drupal462/
> includes/database.mysql.inc on line 66.
>
If I ignore this, don't change anything and hit "Save Blocks," I get:
> user error: Unknown column 'throttle' in 'field list'
> query: UPDATE blocks SET region = 0, status = 1, weight = 0,
> throttle = 0 WHERE module = 'block' AND delta = '1' in /big/dom/
> xpublic_domain/www/drupal462/includes/database.mysql.inc on line 66.
>
> user error: Unknown column 'throttle' in 'field list'
> query: UPDATE blocks SET region = 0, status = 1, weight = 0,
> throttle = 0 WHERE module = 'user' AND delta = '1' in /big/dom/
> xpublic_domain/www/drupal462/includes/database.mysql.inc on line 66.
>
> user error: Unknown column 'throttle' in 'field list'
> query: UPDATE blocks SET region = 0, status = 1, weight = 0,
> throttle = 0 WHERE module = 'user' AND delta = '0' in /big/dom/
> xpublic_domain/www/drupal462/includes/database.mysql.inc on line 66.
>
> user error: Unknown column 'throttle' in 'field list'
> query: UPDATE blocks SET region = 0, status = 0, weight = 0,
> throttle = 0 WHERE module = 'user' AND delta = '3' in /big/dom/
> xpublic_domain/www/drupal462/includes/database.mysql.inc on line 66.
>
> user error: Unknown column 'throttle' in 'field list'
> query: UPDATE blocks SET region = 0, status = 0, weight = 0,
> throttle = 0 WHERE module = 'user' AND delta = '2' in /big/dom/
> xpublic_domain/www/drupal462/includes/database.mysql.inc on line 66.
>
> user error: Unknown column 'throttle' in 'field list'
> query: UPDATE blocks SET region = 0, status = 1, weight = 0,
> throttle = 0 WHERE module = 'node' AND delta = '0' in /big/dom/
> xpublic_domain/www/drupal462/includes/database.mysql.inc on line 66.
>
> user error: Unknown column 'throttle' in 'field list'
> query: UPDATE blocks SET region = 0, status = 0, weight = 0,
> throttle = 0 WHERE module = 'comment' AND delta = '0' in /big/dom/
> xpublic_domain/www/drupal462/includes/database.mysql.inc on line 66.
>
> user error: Unknown column 'throttle' in 'field list'
> query: UPDATE blocks SET region = 0, status = 0, weight = 0,
> throttle = 0 WHERE module = 'search' AND delta = '0' in /big/dom/
> xpublic_domain/www/drupal462/includes/database.mysql.inc on line 66.
>
> user error: Unknown column 'throttle' in 'field list'
> query: UPDATE blocks SET region = 0, status = 0, weight = 0,
> throttle = 0 WHERE module = 'poll' AND delta = '0' in /big/dom/
> xpublic_domain/www/drupal462/includes/database.mysql.inc on line 66.
>
> warning: Cannot modify header information - headers already sent by
> (output started at /big/dom/xpublic_domain/www/drupal462/includes/
> common.inc:384) in /big/dom/xpublic_domain/www/drupal462/includes/
> common.inc on line 192.
>
When I go back to the home page I get a little note "The block
settings have been updated," but the blocks are now gone.
Any ideas?
More information about the drupal-support
mailing list