[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