Jump to content

  • You cannot start a new topic
  • You cannot reply to this topic

Database Backup Emergency Rate Topic   - - - - -

 
  • makstudios
  • Junior Member
  • Members
  • Join Date: 17-Feb 06
  • 8 posts

Posted 13 August 2006 - 07:08 PM #1

I am thankful for CS-Cart's ability to backup databases. We recently had a server crash and everything wiped out. We have everything backed up.

Here's the problem:

When the server crashed, we were using cs-cart 1.3.2

I downloaded a clean copy of cs-cart 1.3.3 since the upgrade features are awesome. Now I need to restore the backup files, however, when I do it doesnt comply with the new tables and new database for 1.3.3 all the new stuff isnt inserted and is also deleted. What do i do? I no longer have the cs-cart 1.3.2 and I dont want it either since there is an update. someone please help!

-MAK
Regards,
Michael A. Karr
MAKstudios Custom Web Design
www.makstudios.com

 
  • makstudios
  • Junior Member
  • Members
  • Join Date: 17-Feb 06
  • 8 posts

Posted 13 August 2006 - 07:49 PM #2

I thought that I could install my backup file which works fine, then grab the database file in the "upgrade" package and import that as It should just be upgrading the database. That isnt working as i get SQL errors that tables already exist. I tried addin IF NOT EXIST, but then I just get additional errors on other statements such as DUPLICATE FIELD. I need a database file or something that will just add the new stuff and alter existing without screwing everything up... why wont the upgrade database file do this?

Here is just one of the errors I get when viewing products on the website...

Database error: 1054 : Unknown column 'a.inventory' in 'field list'
Invalid query: SELECT a.option_id, a.option_type, a.position, a.inventory, b.option_name, b.option_text FROM cscart_product_options as a LEFT JOIN cscart_product_options_descriptions as b ON a.option_id=b.option_id AND b.lang_code='EN' WHERE a.product_id='2023' AND avail='Y' ORDER BY a.position
Regards,
Michael A. Karr
MAKstudios Custom Web Design
www.makstudios.com

 
  • YouRockDaddy
  • Senior Member
  • Members
  • Join Date: 11-Apr 06
  • 319 posts

Posted 13 August 2006 - 11:06 PM #3

Why don't you just install 1.3.2, restore from backup, then use the Upgrade kit from 1.3.2 to 1.3.3.