Recent Topics
  1. b2evolution CMS Support Forums
  2. b2evolution Support
  3. General Support
  4. [10.1.2] mySQL error on upgrading db from 1.9.3?

[10.1.2] mySQL error on upgrading db from 1.9.3?

1 Jul 05, 2007 06:19    

My b2evolution Version: 10.1.2

I'm trying to upgrade from 1.9.3 and in the process it wants to upgrade the db... there's just one query, but I get an error when running it.


Additional information about this error:

MySQL error!

Duplicate entry '' for key 2(Errno=1062)

Your query:

ALTER TABLE cyn_posts ADD UNIQUE post_urltitle( post_urltitle ))

What can I do to fix this? Is it a big issue?

Back to top

2 Jul 05, 2007 06:20

I should note... I ran the query in phpMyAdmin and got essentially the same response.

Back to top

3 Jul 05, 2007 20:33

I didn't have a look on the table/db and I don't know much about the b2evolution database structure but it seems like you've got a row in the TABLE cyn_posts where post_urltitle is both time an empty string ''. I would suggest to edit one to make them different -- so the update can add a unique key...

Back to top

4 Aug 11, 2007 00:09

I've been traveling for a while... just got back a few days ago.

Oh bummer... yah I see that now. I imported hundreds of entries from my old blog and didn't bother setting a post title for those entries. Didn't think it would mess anything up.

Arg. I guess I'll have to write another script to update those entries. Or maybe I can figure out a mysql query to do it for me.

Back to top


Form is loading...