[drupal-support] Upgrading database from 4.5.4 to 4.6.2 (was Psychophobia)
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@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
On Wed, 20 Jul 2005 sunblockster@gmail.com wrote:
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
This has happened today to me as well. What I did is: mysqldump -uuser -ppass db term_node -w 'tid = 0'| sort | uniq > term_node.sql then I deleted the entries where tid = 0 and re-imported term_node.sql after deleting the table structure on top of the file. Afterwards add the index: ALTER TABLE term_node ADD PRIMARY KEY (tid,nid);
Any ideas why this failed, and how to fix it?
For some reason, there are duplicates of (tid, nid) = (0, 11) in the database. Probably many more. No idea why. Cheers, Gerhard
This has happened today to me as well. What I did is:
mysqldump -uuser -ppass db term_node -w 'tid = 0'| sort | uniq > term_node.sql
Got this.
then I deleted the entries where tid = 0
How did you do this? Do you mean entries in a certain table? Is this something I could do through phpmyadmin?
and re-imported term_node.sql
I am an ignoramus -- how did you do this?
after deleting the table structure on top of the file.
And this?
Afterwards add the index:
ALTER TABLE term_node ADD PRIMARY KEY (tid,nid);
This is just a mysql command? Thanks.
On Wed, 20 Jul 2005 sunblockster@gmail.com wrote:
This has happened today to me as well. What I did is:
mysqldump -uuser -ppass db term_node -w 'tid = 0'| sort | uniq > term_node.sql
Got this.
then I deleted the entries where tid = 0
How did you do this? Do you mean entries in a certain table? Is this something I could do through phpmyadmin?
Sure: delete from term_node where tid = 0;
and re-imported term_node.sql
I am an ignoramus -- how did you do this?
You can upload the file through phpmyadmin or import through the mysql commandline.
after deleting the table structure on top of the file.
And this?
Open in editor, edit. You can also use the -t flag with mysqldump, then you can skip this.
Afterwards add the index:
ALTER TABLE term_node ADD PRIMARY KEY (tid,nid);
This is just a mysql command?
Yes. Cheers, Gerhard
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?
Hi sunblockster! Unfortunately I can't give you detailed instructions, but I can say I had the same problem upgrading a site from 4.5.2 to 4.6.0. I believe a lot of people didn't have this problem yet because they didn't try to access the block admin section... Anyway, I dropped blocks table and created it again from the 4.6.2 database script. *But be carefull, do it only if you know sql very well*. :-) Yeah, recreating the blocks is a lot of work depending on the block you have. I hope someone here has a better solution than mine (so I can learn too). ;-) Cheers, Emiliano. On Wednesday 20 July 2005 22:53, sunblockster@gmail.com wrote:
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!
(...)
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?
On Wed, 20 Jul 2005 sunblockster@gmail.com wrote:
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.
ALTER TABLE blocks ADD throttle tinyint(1) NOT NULL DEFAULT '0'; Cheers, Gerhard
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@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@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
participants (3)
-
Emiliano -
Gerhard Killesreiter -
sunblockster＠gmail.com