[mgwashburn]

OMG,

same issue here,

We started the upgrade process from 4.2 to the new 5.2 in April and we are supposed to go live this week.

I downloaded the updates from 5.2.x to 5.2.5 and a couple of days later the entire system took a dump.

The client had added in 600+ products with thousands of photos and pdf files...also static pages etc.

Now the mysql database is corrupt and trying a rebuild always brings the error :


Deploying store [step 5 of 13], please wait...
Run the "Doctrine_Plugin_UpdateSchema" plugin...

ERROR: "0" (code N/A)
An exception occurred while executing 'ALTER TABLE `xc_profiles` MODIFY `default_card_id` INT UNSIGNED NULL, MODIFY `pending_zero_auth` VARCHAR(255) NULL, MODIFY `pending_zero_auth_txn_id` VARCHAR(255) NULL, MODIFY `pending_zero_auth_status` CHAR(1) NULL, MODIFY `pending_zero_auth_interface` VARCHAR(255) NULL,': SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

After spending 40+ hours with no sleep attempting to restore the data from backups, we realize there is a serious problem with the new 5.2.5 version and we are screwed.

I have now attempted a brand new vanilla install with the barebones modules...only the Banner and Flyout Menu modules we purchased are added.

As soon as we add a few categories, add a couple of static pages and then...bang

same thing, shopping cart goes to "The site is temporarily closed for maintenance"

and we are screwed...

PLEASE make the 5.2.4 file available as we cannot even install this version.

we neeed help!!!