What's the best upgrade/export data path?

Hello All,

We're about to update our OpenCart site to 3.0.3.9 , it's currently running OpenCart 3.0.3.1. I understand from this forum that we're best to start from a clean install of 3.0.3.9. We've installed 3.0.3.9 on a local machine using Wampserver, and used JNeuhoff's excellent Export/Import tool to bring in options, attributes, products and customers. There's a lot of data that the Export/Import tool doesn't export/import such as the data shown in the sales, marketing and system categories of the Open Cart admin. I have a couple of questions related to exporting that data.

What's the specific set of tables to be exported from phpMyAdmin to ensure we don't miss any of that data?
What's the safest method used to do this?

Any help would be appreciated. Thanks.

You could use PHPMyAdmin to export and import the other DB tables relevant for orders etc.

JNeuhoff wrote: ↑

Sat Apr 06, 2024 12:13 am

You could use PHPMyAdmin to export and import the other DB tables relevant for orders etc.

Thanks JNeuhoff.

As far as I can see we'll need to export the following native OpenCart tables:
_coupon x4
_currency
_order x10
_information x4
_review
_tax x4
_zones x2

Hello All,

We're in the process of trying to update to 3.0.3.9 from 3.0.3.1. It's my understanding that it's best to start from a clean install and clean database and essentially rebuild the site from scratch. Maybe I'm wrong on that.

The initial install of 3.0.3.9 was a breeze..... Know we're installing the extensions we used on the live site and quickly discovering that various tables and or just columns within a table on the old site database hold data that we need brought over for a specific extension. It seems like such a messy process.

Is it possible to use the 3.0.3.1 database as a starting point and upgrade using that database?

I'm finding this process somewhat broken, but I'm probably missing something.

Any input would really be appreciated. Thanks.

Compare the opencart.sql file from the two version. This will tell you what changes have been made to the database.

Hello,

We're getting an internal server error whenever we try to install extensions on Open Cart 3.0.3.9 while running php 8.1, if we switch to php 7.4 the extensions will install. There's no errors in cpanel and no errors open cart admin.

Can anyone point me in the right direction regarding the cause of this?
Any help is appreciated.

You need to look in your PHP error log (or server) not the OpenCart error log. Use phpinfo() to find it or ask your host.

ADD Creative wrote: ↑

Tue May 21, 2024 11:31 pm

You need to look in your PHP error log (or server) not the OpenCart error log. Use phpinfo() to find it or ask your host.

Thanks for the reply ADD creative.

I've got the phpinfo output, it's a huge list.
Is there something specific I should be looking for?

Ok. Here's the error from the installer via popup:

SyntaxError: JSON.parse: unexpected character at line 1 column 1 of the JSON data
OK
<br />
<b>Fatal error</b>: Uncaught Error: Class &quot;ZipArchive&quot; not found in /home/u5vuuca9ho/public_html/admin/controller/marketplace/install.php:61
Stack trace:
#0 /home/u5vuuca9ho/storage/modification/system/engine/action.php(79): ControllerMarketplaceInstall-&gt;unzip()
#1 /home/u5vuuca9ho/public_html/admin/controller/startup/router.php(26): Action-&gt;execute()
#2 /home/u5vuuca9ho/storage/modification/system/engine/action.php(79): ControllerStartupRouter-&gt;index()
#3 /home/u5vuuca9ho/storage/modification/system/engine/router.php(77): Action-&gt;execute()
#4 /home/u5vuuca9ho/storage/modification/system/engine/router.php(66): Router-&gt;execute()
#5 /home/u5vuuca9ho/public_html/system/framework.php(169): Router-&gt;dispatch()
#6 /home/u5vuuca9ho/public_html/system/startup.php(104): require_once('/home/uvuucaho/...')
#7 /home/u5vuuca9ho/public_html/admin/index.php(19): start()
#8 {main}
thrown in <b>/home/uvuucaho/public_html/admin/controller/marketplace/install.php</b> on line <b>61</b><br />

p419 wrote: ↑

Wed May 22, 2024 1:32 am

Ok. Here's the error from the installer via popup:

SyntaxError: JSON.parse: unexpected character at line 1 column 1 of the JSON data
OK
<br />
<b>Fatal error</b>: Uncaught Error: Class &quot;ZipArchive&quot; not found in /home/u5vuuca9ho/public_html/admin/controller/marketplace/install.php:61
Stack trace:
#0 /home/u5vuuca9ho/storage/modification/system/engine/action.php(79): ControllerMarketplaceInstall-&gt;unzip()
#1 /home/u5vuuca9ho/public_html/admin/controller/startup/router.php(26): Action-&gt;execute()
#2 /home/u5vuuca9ho/storage/modification/system/engine/action.php(79): ControllerStartupRouter-&gt;index()
#3 /home/u5vuuca9ho/storage/modification/system/engine/router.php(77): Action-&gt;execute()
#4 /home/u5vuuca9ho/storage/modification/system/engine/router.php(66): Router-&gt;execute()
#5 /home/u5vuuca9ho/public_html/system/framework.php(169): Router-&gt;dispatch()
#6 /home/u5vuuca9ho/public_html/system/startup.php(104): require_once('/home/uvuucaho/...')
#7 /home/u5vuuca9ho/public_html/admin/index.php(19): start()
#8 {main}
thrown in <b>/home/uvuucaho/public_html/admin/controller/marketplace/install.php</b> on line <b>61</b><br />

The ZIP extension wasn't installed for PHP 8.1 so I've enabled it, it seems to be working now.
Thanks ADD Creative for pointing me in the right direction.

Hello All,

Getting past the installer error I've now attempted to install an extension, refresh modifications and now I'm getting the following error when I try to access the admin.

Fatal error: Uncaught Error: Class "Twig_Loader_Filesystem" not found in /home/uvuucaho/storage/modification/system/library/template/twig.php:32 Stack trace: #0 /home/uvuucaho/public_html/system/library/template.php(51): Template\Twig->render() #1 /home/uvuucaho/storage/modification/system/engine/loader.php(125): Template->render() #2 /home/uvuucaho/public_html/admin/controller/common/header.php(89): Loader->view() #3 /home/uvuucaho/storage/modification/system/engine/action.php(79): ControllerCommonHeader->index() #4 /home/uvuucaho/storage/modification/system/engine/loader.php(48): Action->execute() #5 /home/uvuucaho/public_html/admin/controller/common/login.php(81): Loader->controller() #6 /home/uvuucaho/storage/modification/system/engine/action.php(79): ControllerCommonLogin->index() #7 /home/uvuucaho/storage/modification/system/engine/router.php(77): Action->execute() #8 /home/uvuucaho/storage/modification/system/engine/router.php(66): Router->execute() #9 /home/uvuucaho/public_html/system/framework.php(169): Router->dispatch() #10 /home/uvuucaho/public_html/system/startup.php(104): require_once('/home/uvuucaho/...') #11 /home/uvuucaho/public_html/admin/index.php(19): start() #12 {main} thrown in /home/uvuucaho/storage/modification/system/library/template/twig.php on line 32

Can someone point me in the right direction to resolve this issue?
Any help is appreciated.

Could be that that extension is using an old Twig loader that was deprecated in Twig 2.7 back in 2019. The extension may need to be updated to work with OpenCart 3.0.3.9.

Looking at the differences between system/library/template/twig.php and modification/system/library/template/twig.php may help.