Post by p419 » Fri Apr 05, 2024 11:13 pm

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.

Regards,

Paul


New member

Posts

Joined
Tue Nov 27, 2018 2:01 am
Location - Toronto

Post by JNeuhoff » Sat Apr 06, 2024 12:13 am

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

Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig


User avatar
Guru Member

Posts

Joined
Wed Dec 05, 2007 3:38 am


Post by p419 » Sat Apr 06, 2024 1:25 am

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

Regards,

Paul


New member

Posts

Joined
Tue Nov 27, 2018 2:01 am
Location - Toronto

Post by p419 » Fri Apr 12, 2024 3:39 am

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.

Regards,

Paul


New member

Posts

Joined
Tue Nov 27, 2018 2:01 am
Location - Toronto

Post by ADD Creative » Fri Apr 12, 2024 7:08 am

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

www.add-creative.co.uk


Expert Member

Posts

Joined
Sat Jan 14, 2012 1:02 am
Location - United Kingdom

Post by p419 » Tue May 21, 2024 11:11 pm

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.

Regards,

Paul


New member

Posts

Joined
Tue Nov 27, 2018 2:01 am
Location - Toronto

Post by ADD Creative » 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.

www.add-creative.co.uk


Expert Member

Posts

Joined
Sat Jan 14, 2012 1:02 am
Location - United Kingdom

Post by p419 » Wed May 22, 2024 1:10 am

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?

Regards,

Paul


New member

Posts

Joined
Tue Nov 27, 2018 2:01 am
Location - Toronto

Post by p419 » 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 />

Regards,

Paul


New member

Posts

Joined
Tue Nov 27, 2018 2:01 am
Location - Toronto

Post by p419 » Wed May 22, 2024 1:39 am

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.

Regards,

Paul


New member

Posts

Joined
Tue Nov 27, 2018 2:01 am
Location - Toronto

Post by p419 » Wed May 22, 2024 3:16 am

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.

Regards,

Paul


New member

Posts

Joined
Tue Nov 27, 2018 2:01 am
Location - Toronto

Post by ADD Creative » Wed May 22, 2024 6:42 pm

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.

www.add-creative.co.uk


Expert Member

Posts

Joined
Sat Jan 14, 2012 1:02 am
Location - United Kingdom
Who is online

Users browsing this forum: No registered users and 6 guests