I empty the hitlog tables, then I retry the installation.


[...]
Creating DB schema version checkpoint at 9950... OK. (Elapsed upgrade time: 3 seconds)
Renaming tables...OK.
Making sure all tables use desired storage ENGINE as specified in the b2evo schema... T_groups:innodb
T_settings:innodb
T_global__cache:innodb
T_users:innodb
T_users__fielddefs:innodb
T_users__fields:innodb
T_locales:innodb
T_antispam:innodb
T_plugins:innodb
T_pluginsettings:innodb
T_pluginusersettings:innodb
T_pluginevents:innodb
T_cron__task:innodb
T_cron__log:innodb
T_skins__skin:innodb
T_skins__container:innodb
T_blogs:innodb
T_coll_settings:innodb
T_widget:innodb
T_categories:innodb
T_items__item:innodb
T_postcats:innodb
T_comments:innodb
T_items__prerendering:innodb
T_items__version:innodb
T_items__status:innodb
T_items__type:innodb
T_items__tag:innodb
T_items__itemtag:innodb
T_subscriptions:innodb
T_coll_user_perms:innodb
T_coll_group_perms:innodb
T_links:innodb
T_files:innodb
T_filetypes:innodb
T_sessions:myisam
T_basedomains:myisam
T_track__keyphrase:myisam
T_hitlog:myisam
T_track__goal:myisam
T_track__goalhit:myisam
OK.
Creating DB schema version checkpoint at 9960... OK. (Elapsed upgrade time: 9 seconds)
Creating table for default currencies... OK.
Creating default currencies... OK.
Creating table for default countries... OK.
Creating default countries...


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!
Table 'db.evo_regional__country' doesn't exist(Errno=1146)
Your query:
UPDATE evo_regional__country
SET ctry_preferred = 1
WHERE ctry_code = 'fr'

I know that I'm upgrading from an old version (I don't even remember the version number ;-)

back and try again:

Additional information about this error:

MySQL error!

Table 'evo_currency' already exists(Errno=1050)

Your query:

CREATE TABLE evo_currency (
curr_ID int(10) unsigned NOT NULL auto_increment,
curr_code char(3) NOT NULL,
curr_shortcut varchar(30) NOT NULL,
curr_name varchar(40) NOT NULL,
PRIMARY KEY curr_ID (curr_ID),
UNIQUE curr_code (curr_code)
) ENGINE = innodb

I dropped evo_currency, set the database schema to version 9950 but I got again:

MySQL error!
Table 'db.evo_regional__country' doesn't exist(Errno=1146)

This time I'm stuck :-/
Any idea ?

I found the problem.
The table country is renamed to regional_country in "10600 section"

# $DB->query( 'RENAME TABLE '.$tableprefix.'country TO T_regional__country' );
but there is some insert in regional__country before.
I had to manually do the rename in "9970 section" and comment some alter/insert/drop already done.

1 hour spent but the code is clean and easy to read/understand/modify.