Recent Topics

1 Mar 27, 2009 05:41    

3.1.0 upgrade from 2.4.6

Any help appreciated.
The results are that I cannot access "admin.php"
I can access the Admin via any toolbar link other than Dashboard ( there's none) or Admin.

Ok, the installer said .....

The following database changes will be carried out. If you are not sure what this means, it will probably be alright.

*ALTER TABLE evo_widget CHANGE COLUMN wi_coll_ID wi_coll_ID INT(11) UNSIGNED NOT NULL

*ALTER TABLE evo_widget CHANGE COLUMN wi_type wi_type ENUM( 'core', 'plugin' ) NOT NULL DEFAULT 'core'

* ALTER TABLE evo_widget ADD UNIQUE wi_order( wi_coll_ID, wi_sco_name, wi_order )

And the following is the result....

b2evo installer: Upgrade from a previous version
"Upgrading data in existing b2evolution database...

Checking DB schema version... 9930 : OK.
Resetting b2evolution.net polling times... OK.
Altering table «evo_widget»...

* Changed type of evo_widget.wi_coll_ID from int(11) to wi_coll_ID INT(11) UNSIGNED NOT NULL
An unexpected error has occurred!

If this error persists, please report it to the administrator.

Go back to home page
Additional information about this error:

MySQL error!

Duplicate entry '0-Left column-1-2' for key 2(Errno=1062)

Your query:

2 Mar 27, 2009 07:35

It's the dashboard widget that's causing it, you should be able to uninstall it > upgrade > re-install it

¥

3 Mar 27, 2009 07:38

Thanks, I'll give that a spin once I clean the red wine off the keyboard :(
Appreciated

4 Mar 27, 2009 07:52

Such a waste of wine! Drain the keyboard into a clean glass :D

¥

5 Mar 27, 2009 07:56

Well after reinstalling all files twice, to be certain, I'm sure glad you came along and suggested un-installing for a change.
Fixed, as usual.

6 Mar 27, 2009 08:03

P.S: It doesn't want to be re-installed!!

7 Mar 27, 2009 08:58

I'll have a play with it in 3.0 and see if I can make it work again .... otherwise I'm never gonna upgrade :P

¥

8 Mar 27, 2009 09:14

:) I can understand that ...


Form is loading...