Post by Gobbo » Mon Mar 02, 2020 5:44 am

Hi,

I've just updated opencart from 2 to the latest version.

Linked it up to the old database I was using, but can't see the customer list, previous orders or stock.

Is the old database setup compatible with the current version?

Using opencart 3.0.3.2 - PHP 7.4 - Standard Template - Add to Cart Enable Disable Out of Stock Product 3.x - Export/Import Tool (V3.22) for OpenCart 3.x - Footer Social Media Link( 3.x ) v1.0


Active Member

Posts

Joined
Tue Jun 22, 2010 12:38 am

Post by xxvirusxx » Mon Mar 02, 2020 5:55 am

You can't use Opencart 3 files with a 2.x database...

Upgrade Service | OC 2.3.0.2 PHP 8 | My Custom OC 3.0.3.8 | Buy me a beer


User avatar
Expert Member

Posts

Joined
Tue Jul 17, 2012 10:35 pm
Location - România

Post by Gobbo » Mon Mar 02, 2020 6:08 am

Okay, shame I didn't know that before.

No worries ;)

Using opencart 3.0.3.2 - PHP 7.4 - Standard Template - Add to Cart Enable Disable Out of Stock Product 3.x - Export/Import Tool (V3.22) for OpenCart 3.x - Footer Social Media Link( 3.x ) v1.0


Active Member

Posts

Joined
Tue Jun 22, 2010 12:38 am

Post by Gobbo » Tue Mar 03, 2020 4:51 pm

Out of interest, how do you convert a v2 database to v3?

Using opencart 3.0.3.2 - PHP 7.4 - Standard Template - Add to Cart Enable Disable Out of Stock Product 3.x - Export/Import Tool (V3.22) for OpenCart 3.x - Footer Social Media Link( 3.x ) v1.0


Active Member

Posts

Joined
Tue Jun 22, 2010 12:38 am

Post by xxvirusxx » Tue Mar 03, 2020 4:57 pm

Gobbo wrote:
Tue Mar 03, 2020 4:51 pm
Out of interest, how do you convert a v2 database to v3?
By upgrading entire 2.x store to 3.x...

Upgrade Service | OC 2.3.0.2 PHP 8 | My Custom OC 3.0.3.8 | Buy me a beer


User avatar
Expert Member

Posts

Joined
Tue Jul 17, 2012 10:35 pm
Location - România

Post by Quino » Tue Mar 03, 2020 6:53 pm

You don't convert a database from V2 to V3, you migrate data from a V2 database to a V3 database.
You would need to know the exact differences between the schemas and adapt/amend the exported data before importing.
You could use MySQL workbench for that, it has a schema diff function I believe.

New member

Posts

Joined
Fri Feb 28, 2020 1:19 am
Who is online

Users browsing this forum: Axlagusti, niagato and 451 guests