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:
It's the dashboard widget that's causing it, you should be able to uninstall it > upgrade > re-install it
¥