Recent Topics
  1. b2evolution CMS Support Forums
  2. b2evolution Support
  3. General Support
  4. Upgrade .9.0.12 to .9.2 -- 'catpost'(Errno=1061) Error

Upgrade .9.0.12 to .9.2 -- 'catpost'(Errno=1061) Error

1 May 22, 2006 18:57    

Trying to upgrade my installation from Amsterdam to Sparkle, and I got this half-way through:

Upgrading data in existing b2evolution database

Checking DB schema version... 8064 : OK.
Adding catpost index...

MySQL error!

Duplicate key name 'catpost'(Errno=1061)

Your query:

ALTER TABLE evo_postcats ADD UNIQUE catpost ( postcat_cat_ID, postcat_post_ID )

I saw a couple other posts about this, but haven't yet found what the solution is. Help would be appreciated. In the meantime, I'll keep reading.

Back to top

2 May 22, 2006 19:38

I knew I should have looked around a little more before posting. :oops:

The solution for me was to:

Use PhpMyAdmin to make a backup of evo_settings

Edit the backup to change the DB schema version from 8064 to 8066 (as suggested in http://forums.b2evolution.net/viewtopic.php?t=5555)

Query the database to add evo_settings back to the table.

Voila!

Back to top

3 May 22, 2006 19:55

the first step to recovery is admitting it ;)

Back to top

4 May 23, 2006 00:03

It's a strange error..!

I've just taken a look at the source for 0.9.0.12 (Amsterdam), but there's no mentioning of "catpost" in any file.

So, can you remember your upgrade path? With what version have you started? Do you eventually have even upgraded from the original b2 in the beginning?

At some point the index must have been created on your tables already.

Back to top


Form is loading...