Hello @
mgwashburn,
I am sorry to hear about those problems. Let us try to find what we can do:
1) When your new store shows the "The site is temporarily closed for maintenance" message, did you try to recover it as described here:
http://kb.x-cart.com/display/XDD/What+to+do+if+you+cannot+access+your+store+and+it+ says+we+are+deploying+new+changes#Whattodoifyoucan notaccessyourstoreanditsayswearedeployingnewchange s-Dropandre-createyoursite'scache
It should help without installation of 5.2.4
2) Just in case you still need 5.2.4, you can download it from here:
https://dl.dropboxusercontent.com/u/23858825/x-cart-5.2.4-en.tgz
3) If you still have files and database of the store that produced the aforementioned error:
Code:
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
could you please pack and send them to me? It would allow the team to check the problem and apply some fix, so you would be sure it is not going to happen again.
Thank you.
Tony