OpenCart Community

Search found 102 matches

[SOLVED] Re: DB error upgrading from 3.0.3.1 to 3.0.40 - WHERE `key` = 'config_timezone' AND store_id = '0'' at line 1

JNeuhoff wrote: ↑
Sun Feb 02, 2025 5:33 pm
Invalid DB_PREFIX, it shouldn't contain '!' . See you config.php and admin/config.php.

Thanks JNeuhoff! That was the problem and all's good now.

Jump to post

Sun Feb 02, 2025 8:30 pm
Replies 2
Views 2646

p419

DB error upgrading from 3.0.3.1 to 3.0.40 - WHERE `key` = 'config_timezone' AND store_id = '0'' at line 1

Hello All, We're upgrading to OC 3.0.4.0 and php 8.1 and had it running successfully and error free on a dev server. We've now copied the database and files to the live server and we're getting the following error on the front end and back end: Warning: mysqli::query(): (42000/1064): You have an err...

Jump to post

Sun Feb 02, 2025 10:03 am
Replies 2
Views 2646

p419

Re: Upgrading 3.0.3.9 to 3.0.4.0

Thanks for the reply khnaz35.

I'm exporting products from our live site that's running OC 3.0.3.1 and importing into our dev site that's a clean install of OC3.0.4.0.

Jump to post

Fri Dec 20, 2024 3:22 am
Replies 6
Views 3109

p419

Re: Upgrading 3.0.3.9 to 3.0.4.0

Hello, I'm now starting to upgrade from scratch. We're exporting from 3.0.3.1 and importing into 3.0.4.0. I'm using Export/Import Tool v4.17 on the OC3.0.4.0 and v3.22 on the OC 3.0.3.1 site. I'm trying to import products in batches of 300. When I attempt to import it throws the following error: Err...

Jump to post

Fri Dec 20, 2024 12:43 am
Replies 6
Views 3109

p419

Re: Upgrading 3.0.3.9 to 3.0.4.0

Thank you for the input Johnp and JNeuhoff.
I'll try John's method first, I don't really want to start from scratch, again.

Jump to post

Thu Aug 01, 2024 1:53 am
Replies 6
Views 3109

p419

Upgrading 3.0.3.9 to 3.0.4.0

Hello All,

We're in the process of upgrading to 3.0.3.9 , have it running on a dev server and are close to being completed.
I assume that OpenCart 3.0.4.0 is very similar to 3.0.3.9.
Are we okay to just upload the OpenCart 3.0.4.0 files and overwrite the 3.0.3.9 files?

Any input is appreciated.

Jump to post

Tue Jul 30, 2024 3:27 am
Replies 6
Views 3109

p419

Help with Custom Product Tabs PRO / Unlimited Tabs

Hello All, Our live site currently runs Opencart Version 3.0.3.1 and we're upgrading to Opencart Version 3.0.3.9 running on PHP 8.1. We're looking for assistance with the extension Custom Product Tabs PRO / Unlimited Tabs (https://www.opencart.com/index.php?route=marketplace/extension/info&exten...

Jump to post

Thu Jul 04, 2024 3:20 am
Replies 4
Views 1819

p419

Re: OpenCart 3.0.3.9 - Unexpected character ";" in "default/template/checkout/cart.twig" at line 68

Restore your catalog/view/theme/default/template/checkout/cart.twig , line 68 should contain this: <button type="button" data-toggle="tooltip" title="{{ button_remove }}" class="btn btn-danger" onclick="cart.remove('{{ product.cart_id }}');"><i clas...

Jump to post

Sat Jun 08, 2024 12:46 am
Replies 2
Views 3640

p419

OpenCart 3.0.3.9 - Unexpected character ";" in "default/template/checkout/cart.twig" at line 68

Hello All, We're attempting to upgrade to OpenCart 3.0.3.9 from a clean install running on PHP 8.1. We're getting the following error whether we're on the default template or our template when we add something to cart and then click view cart. We're on the index.php?route=checkout/cart page when we ...

Jump to post

Wed Jun 05, 2024 2:29 am
Replies 2
Views 3640

p419

Re: What's the best upgrade/export data path?

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...

Jump to post

Wed May 22, 2024 3:16 am
Replies 11
Views 3045

p419

Re: What's the best upgrade/export data path?

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 "ZipArchive" not found in /home/u5vuuca9ho/public_html/admin/controller/marketplace/install.php:...

Jump to post

Wed May 22, 2024 1:39 am
Replies 11
Views 3045

p419

Re: What's the best upgrade/export data path?

Jump to post

Wed May 22, 2024 1:32 am
Replies 11
Views 3045

p419

Re: What's the best upgrade/export data path?

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?

Jump to post

Wed May 22, 2024 1:10 am
Replies 11
Views 3045

p419

Re: What's the best upgrade/export data path?

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 cau...

Jump to post

Tue May 21, 2024 11:11 pm
Replies 11
Views 3045

p419

Re: What's the best upgrade/export data path?

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 insta...

Jump to post

Fri Apr 12, 2024 3:39 am
Replies 11
Views 3045

p419

Re: What's the best upgrade/export data path?

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

Jump to post

Sat Apr 06, 2024 1:25 am
Replies 11
Views 3045

p419

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 too...

Jump to post

Fri Apr 05, 2024 11:13 pm
Replies 11
Views 3045

p419

[Solved] Re: Someone browsed to our renamed admin folder that is protected by htaccess

In our hosting under "Latest web server error log messages:" I'm seeing the following messages related to the ip address we saw attempting to access the folder: AH01797: client denied by server configuration: There are dozens and dozens of these as they seem to be trying to access many di...

Jump to post

Fri Jan 26, 2024 10:52 pm
Replies 6
Views 2070

p419

Re: Someone browsed to our renamed admin folder that is protected by htaccess

Hello Everyone, We've just noticed today that two people from different countries landed on our renamed admin folder. Our admin folder is protected with an .htaccess file that only allows browsers from our office ip address to access the folder. This is something we've never noticed before. I've go...

Jump to post

Fri Jan 26, 2024 10:46 pm
Replies 6
Views 2070

p419

Re: Someone browsed to our renamed admin folder that is protected by htaccess

Did they actually access the admin directory or did the htaccess rule deny access? It would still show in the web access logs just the status codes would be 200 for success and 403 for forbidden. The admin directory names can be leaked. For example in email headers or some sort of bug. There are al...

Jump to post

Fri Jan 26, 2024 2:31 am
Replies 6
Views 2070

Search found 102 matches

Jump to

Go to advanced search Go to advanced search

Community Forum

Sign up to our newsletter