[drupal-support] Re: Upgrading database from 4.5.4 to 4.6.2 (was Psychophobia)

[sunblockster at gmail.com]

More info: things are more or less working, except that when I went  
to edit the blocks configuration I got this:

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.



On Jul 20, 2005, at 6:43 PM, sunblockster at gmail.com wrote:

> First, a *huge* thank you to everyone on the list who has helped us  
> resurrect our site after the hack, especially to Gerhard. It's  
> always amazing to experience the support of the OSS community.
>
> I think we are almost there. I upgraded from 4.3.x to 4.4 to 4.5.4  
> without a hitch--an exhilirating feeling.
>
> I just ran the 4.6.2 upgrade.php on the database, choosing the  
> first update after the 4.5 release.
>
> Everything went well until here:
>
>
>
>> 2005-03-21
>>
>> user error: Duplicate entry '0-11' for key 1
>> query: ALTER TABLE term_node ADD PRIMARY KEY (tid,nid) in /path/to/ 
>> file/www/drupal462/includes/database.mysql.inc on line 66.
>>
>> ALTER TABLE {term_node} ADD PRIMARY KEY (tid,nid)
>> FAILED
>>
>> 2005-04-14
>>
>> 2005-05-06
>>
>> 2005-05-07
>>
>> ALTER TABLE {locales_source} CHANGE location location varchar(255)  
>> NOT NULL default ''
>> OK
>>
>>
>
>
> Any ideas why this failed, and how to fix it?
>
> Many thanks.
>
>
>
>
> On Jul 20, 2005, at 5:04 PM, Gerhard Killesreiter wrote:
>
>
>
>>
>>
>> On Wed, 20 Jul 2005 sunblockster at gmail.com wrote:
>>
>>
>>
>>
>>> A 4.4 tarball would be great if you think that would do the trick.
>>> How do we work that?
>>>
>>>
>>>
>>
>> http://tfp1.physik.uni-freiburg.de/~killes/drupal-4.4.tar.gz
>>
>> You need to pay attention for the start of the update from 4.5 to  
>> 4.6. You
>> need to select the first after the 4.5 release.
>>
>> Cheers,
>>     Gerhard
>>
>>
>>
>
>
>