Can someone please tell me when the big change was made with tables in the DB ? was it before version 3.0.0.0 or a lower version of 3
3.0.0.0, 3.0.1.1, 3.0.1.2, 3.0.2.0, 3.0.3.0, 3.0.3.1, 3.0.3.2, 3.0.3.3, 3.0.3.5, 3.0.3.6, 3.0.3.7, 3.0.3.8
The DB structure remains the same with all OC versions enounced above. However, OC 4 releases uses a different DB structure compared to previous releases.
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
Why do i get all these errors and a failure tostraightlight wrote: ↑Sun Oct 08, 2023 6:01 am
The DB structure remains the same with all OC versions enounced above.
Import? Example is oc_event table, 3.0.3.8 adds another column and data
There will be numerous changes to the database across different versions. For example the sort_order was added to the exents table in 3.0.0.0. https://github.com/opencart/opencart/co ... 059c140d09
You can see the database changer at the following link.
https://github.com/opencart/opencart/co ... encart.sql
You could take the upload/install/opencart.sql files from two different versions and use a file comparison application to compare the differences.
You can see the database changer at the following link.
https://github.com/opencart/opencart/co ... encart.sql
You could take the upload/install/opencart.sql files from two different versions and use a file comparison application to compare the differences.
Thanks for info that helps, would it be best to alter the version 2 opencart.sql to match structure of version 3 then run the sql? I could probably then get successful import of products, categories and customersADD Creative wrote: ↑Sun Oct 08, 2023 8:09 amThere will be numerous changes to the database across different versions. For example the sort_order was added to the exents table in 3.0.0.0. https://github.com/opencart/opencart/co ... 059c140d09
You can see the database changer at the following link.
https://github.com/opencart/opencart/co ... encart.sql
You could take the upload/install/opencart.sql files from two different versions and use a file comparison application to compare the differences.
Better to run a fresh install and integrate the data you need afterwards rather than running an upgrade between such releases since a lot of changes could of been involved since.gsc1ugs wrote: ↑Sun Oct 08, 2023 3:18 pmThanks for info that helps, would it be best to alter the version 2 opencart.sql to match structure of version 3 then run the sql? I could probably then get successful import of products, categories and customersADD Creative wrote: ↑Sun Oct 08, 2023 8:09 amThere will be numerous changes to the database across different versions. For example the sort_order was added to the exents table in 3.0.0.0. https://github.com/opencart/opencart/co ... 059c140d09
You can see the database changer at the following link.
https://github.com/opencart/opencart/co ... encart.sql
You could take the upload/install/opencart.sql files from two different versions and use a file comparison application to compare the differences.
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
This classic extension is often handy: https://www.opencart.com/index.php?rout ... sion_id=17
UK OpenCart Hosting | OpenCart Audits | OpenCart Support - please email info@antropy.co.uk
Its what i used - solved - modifications to columns requiredpaulfeakins wrote: ↑Mon Oct 09, 2023 6:11 pmThis classic extension is often handy: https://www.opencart.com/index.php?rout ... sion_id=17
Who is online
Users browsing this forum: Majestic-12 [Bot] and 39 guests
