Post by p419 » Tue Jul 30, 2024 3:27 am

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.

Regards,

Paul


Active Member

Posts

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

Post by johnp » Tue Jul 30, 2024 4:12 am

p419 wrote:
Tue Jul 30, 2024 3:27 am
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.
Upload the files then run the installer. Follow the instructions on the screen. Make sure to back everything up first.

Opencart 1.5.6.5/OC Bootstrap Pro/VQMOD lover, user and geek.
Affordable Service £££ - Opencart Installs, Fixing, Development and Upgrades
Plus Ecommerce, Marketing, Mailing List Management and More
FREE Guidance and Advice at https://www.ecommerce-help.co.uk


User avatar
Active Member

Posts

Joined
Fri Mar 25, 2011 10:25 am
Location - Surrey, UK

Post by JNeuhoff » Tue Jul 30, 2024 9:05 pm

I would do a fresh install. Or at least make sure after the upgrade to completely delete and then reload the storage/vendor folder from the new 3.0.4.0 version.

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 » Thu Aug 01, 2024 1:53 am

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.

Regards,

Paul


Active Member

Posts

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

Post by p419 » Fri Dec 20, 2024 12:43 am

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:

Error: Cannot truncate a table referenced in a foreign key constraint (`uvuucaho_kcbXXXX`.`zp2025_product_combination_as_product`, CONSTRAINT `fk-pcap-product_id`)
Error No: 1701
TRUNCATE TABLE `zp2025_product`

Can anyone point me in the right direction to resolve this error?

Any help is appreciated.

Regards,

Paul


Active Member

Posts

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

Post by khnaz35 » Fri Dec 20, 2024 3:12 am

Where is this table coming from?

The error occurs because you are attempting to truncate a table (zp2025_product) that is still referenced by a foreign key constraint (fk-pcap-product_id) in another table (zp2025_product_combination_as_product).

Got a burning question at 3 AM that even Google shrugs at? There’s a not-so-secret inbox that might just have your answer: khnaz35@gmail.com
Breathe in some nature while you're at it. It’s cheaper than therapy. :-*

Feel free to sling a bear my way via PayPal @ khnaz35@gmail.com


User avatar
Active Member

Posts

Joined
Mon Aug 27, 2018 11:30 pm
Location - Malaysia

Post by p419 » Fri Dec 20, 2024 3:22 am

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.

Regards,

Paul


Active Member

Posts

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

Post by barnettgs » Fri Aug 22, 2025 9:38 pm

JNeuhoff wrote:
Tue Jul 30, 2024 9:05 pm
I would do a fresh install. Or at least make sure after the upgrade to completely delete and then reload the storage/vendor folder from the new 3.0.4.0 version.
Is that done by clearing the modification cache in the Dashboard?

New member

Posts

Joined
Thu Sep 16, 2010 3:01 am

Post by OSWorX » Fri Aug 22, 2025 10:13 pm

barnettgs wrote:
Fri Aug 22, 2025 9:38 pm
JNeuhoff wrote:
Tue Jul 30, 2024 9:05 pm
I would do a fresh install. Or at least make sure after the upgrade to completely delete and then reload the storage/vendor folder from the new 3.0.4.0 version.
Is that done by clearing the modification cache in the Dashboard?
Read this here and my last statement: viewtopic.php?t=235644#p879191

btw: better to update to 3.0.4.1 (or the newer coming release 3.0.5.0 >> now 3.o.x.x - get the latest files from GitHub directly: https://github.com/opencart/opencart/tree/3.0.x.x

Full Stack Web Developer :: Dedicated OpenCart Development & Support DACH Region
Contact for Custom Work / Fast Support.


User avatar
Administrator

Posts

Joined
Mon Jan 11, 2010 10:52 pm
Location - Austria
Who is online

Users browsing this forum: No registered users and 8 guests