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 an urgent question that’s keeping you up at night? There might just be a magical inbox ready to help: khnaz35@gmail.com
Enjoy nature ;) :) :-*


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
Who is online

Users browsing this forum: No registered users and 13 guests