Upgrade from 3.1 to 3.3 Fails

[emcdermon]

I'm trying to upgrade a new installation of Squirrelcart from v3.1 to v3.3. My objective is to clear the multiple W3C validation errors caused by the css file types used in Squirrelcart, and apparently 3.3 "fixes" this problem.

The upgrade fails at Customers table on the e-mail address for some reason. Apparently, I've got some latin-1 characters in the database, I took a dump file of the database, converted those over to utf8 charset, restored wiht the updated database, and still get the same error. I've returned everything back to the way it was prior to the upgrade.

Here's what I'm seeing at the error screen:

Database Upgrade Failed
An error occurred during the database upgrade process:

Checking to see if conversion to UTF8 character set is needed...
MySQL version 5.0.89-community supports character sets - checking charset of database...
Database charset (latin1) is not utf8. Converting to utf8...
Temporarily converting column types to binary to preserve non latin1 encoding...
for table Address_Form_Settings...OK
for table Cart_Images...OK
for table Categories...OK
for table Choices...OK
for table Choices_Custom...OK
for table Condition...OK
for table Countries...OK
for table Coupon_Code...OK
for table Currency_Codes...OK
for table Customers...FAILED
Status: Failed

Error #1283: Column 'Email_Address' cannot be part of FULLTEXT index
If you would like to restore from a backup file in your sc_data/sc_backup folder, click the button below.

Anybody else seeing this error #1283? It occurs both with the Latin-1 charset and utf8 charset. I've had to stop the upgrade, and restore the database backup file.

Any assistance would be appreciated.

Ernest McDermon
Snellville, GA

[emcdermon]

I found the problem, there was corrupted database file on the local server that we restored and were able to complete the upgrade.

Thanks Squirrelcart! You can delete this thread.