Jump to content

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

Db Mismatch With Core File Version Rate Topic   - - - - -

  • Consultant
  • Member
  • Members
  • Join Date: 15-May 10
  • 170 posts

Posted 07 February 2020 - 10:53 PM #1

I had a bunch of files accidentally deleted and I was able to restore an old copy of the CS-Cart DB.  However even though the front end works fine, the back end is broken I believe due to a mismatch in the database structure.  I'm getting, 


Unknown column 'cscart_status_descriptions.status_id' in 'on clause' (1054)

SELECT cscart_statuses.*, cscart_status_descriptions.* FROM cscart_statuses LEFT JOIN cscart_status_descriptions ON cscart_status_descriptions.status_id = cscart_statuses.status_id AND cscart_status_descriptions.lang_code = 'en' WHERE 1 AND cscart_statuses.type = 'O'


I suspect if I added the status_id field to the table, it would then error out on some other missing table field.


What are my best options.  I don't mind losing old order data but I need to retain all the product information and other settings.


I see restore php files for all the upgraded I did but running the last one gives me an Access Denied (generated by the script not the O/S)


It's an old version, config.php says CS-Cart 4.4.2. 


After some more sleuthing, it appears the only DB backup I have is from when I was on version 4.3.10 


So either I need to know what updates to perform on the DB structure (if that's even an option) to get from the 4.3.10 version to 4.4.2, or, I need to figure out how to get the core files back to 4.3.10 without losing all my config info.  


I see an upg_core zip file for 4.3.10-4.4.1_1

Then 6 upg_core files with the same date for all the interim upgrades to get from 4.3 to 4.4.1

I guess the question is, is there a zip to take me back to 4.3.10 so I can then reapply the upgrades and update the database structure?