7.0.9 to 7.1.0.B1 Upgrade failed

In trying to apply the first upgrade in the 7.1.0 upgrade list I got this error message:

UPDATE `sys_options`, `sys_options_tmp`SET `VALUE` = `v`WHERE `Name` = `n` AND `VALUE` != `v` AND `n` NOT IN ('featured_num', 'top_members_max_num', 'sys_ps_enabled_group_1', 'categ_show_columns', 'sys_uridnsbl_enable', 'main_div_width');: Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '='

What do I do now???  (All upgrade instructions to this point were followed explicitly.)

After trying to apply this upgrade. I received 20 Database error messages.  They all begin with:

"Query:

SELECT * FROM `sys_objects_member_info` WHERE `object` = ''

Mysql error: Table '..._dolph.sys_objects_member_info' doesn't exist

Found error in the file '/home/.../inc/classes/BxDolMemberInfoQuery.php' at line 27.
Called 'getRow' function with erroneous argument #0."

This is then followed by a debug backtrace a mile long.

It looks like upgrade was not completed due to the error.

I would suggest to try the following solution:

For some reason tables collates don't match, I would suggegst to try to change the following:

 
CREATE TEMPORARY TABLE `sys_options_tmp` (
  `n` varchar(64) NOT NULL default '',
  `v` mediumtext NOT NULL,
  PRIMARY KEY  (`n`)
) DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci; /* OR utf8_unicode_ci */

in upgrade/files/7.0.9-7.1.0.B1/sql.sql file.

Make sure that collate is the same as collate in your `sys_options` table.

Then run upgrade script again - http://www.boonex.com/forums/topic/Errors-fixing-procedures-during-upgrade.htm

@ AlexT.  To insure the stability of my site and check the original table structure, I have reverted back to 7.0.9.  It appears that the table "dolph.sys_objects_member_info" did not exist in 7.0.9.  My error messages all indicate this missing table as the source of the problem.  If this is a new table in 7.1.0, after the first failed upgrade attempt (from 7.0.9-7.1.0.B1), I checked the database and saw that this table had NOT been created during that process.

Was "dolph.sys_objects_member_info" supposed to be created during the upgrade to 7.1.0.B1 ?  I'm hoping for an answer to this before I proceed.  As your error-fixing procedures indicate, it is only for experienced users, and your above instructions to me are beyond my expertise.  My site is fairly basic, with all non-Boonex modules uninstalled before the upgrade, and I don't understand why I should have had this problem unless it is an issue in the upgrade script.

As an additional note, before I clicked to begin the upgrade process, the final upgrade, from 7.1.0.B2-7.1.0, was not included as a future option.

Thank you very much for your assistance.

Yes, you can see it in upgrade/files/7.0.9-7.1.0.B1/sql.sql file.

Please try this: http://www.boonex.com/forums/topic/7-0-9-to-7-1-0-B1-Upgrade-failed.htm#194709