Post by marc@63400 » Fri Feb 17, 2023 1:18 am

Good morning,
I am in production on a Version 3.0.3.6
not to be stupid, I wanted to redo a site on another machine to do tests so I installed the same version Version 3.0.3.6 and see how to update my site
Once installed, I did an export of the data to import them... and nothing works... the import is impossible.
I wanted to go through phpmyadmin with an export then an import...and I got errors like "Incorrect format parameter"
Can you give me a hand? I don't know where I'm making a mistake or what I have to correct on my file to do this import... Many thanks in advance

New member

Posts

Joined
Wed Jun 30, 2021 12:24 am

Post by by mona » Fri Feb 17, 2023 1:25 am

Good Mornign to you also :)
First - +1 for a mirror test site

If you used the built in import - that will be the mistake
use phpadmin - or https://www.opencart.com/index.php?rout ... sion_id=17

DISCLAIMER:
You should not modify core files .. if you would like to donate a cup of coffee I will write it in a modification for you.


https://www.youtube.com/watch?v=zXIxDoCRc84


User avatar
Expert Member

Posts

Joined
Mon Jun 10, 2019 9:31 am

Post by marc@63400 » Fri Feb 17, 2023 1:43 am

I just installed the module and I have the same error...
File could not be found! and my import does not work
and I just tried again with phpmyadmin "phpMyAdmin - Incorrect format parameter error" because I installed the module correctly

New member

Posts

Joined
Wed Jun 30, 2021 12:24 am

Post by by mona » Fri Feb 17, 2023 2:49 am

Lost - what file could nt be found?

1. You have a site already on 3.0.3.6 (not the best choice but assuming it is a site that already exists)
Presumably you have the modification fix for that version ?

2. You now want to create a test site / mirror site - so that you can install on a test site before a live site to make sure it has no issue ?

3. You installed a brand new 3.0.3.6 onto a mirror site

4. You added all the extensions / themes / modification you already have on the old site to the new mirror site ?

5. You used the import / export module to transfer the products etc.

DISCLAIMER:
You should not modify core files .. if you would like to donate a cup of coffee I will write it in a modification for you.


https://www.youtube.com/watch?v=zXIxDoCRc84


User avatar
Expert Member

Posts

Joined
Mon Jun 10, 2019 9:31 am

Post by marc@63400 » Fri Feb 17, 2023 1:49 pm

Thank you for your answer...
I still have 2 questions:
we bought modules and the sellers made some adaptations online by installing modules and we don't have them.. can we get them from our production site?
In one of these modules, we can make news but I can't find a way to retrieve them with your system. The news is well presented in the categories but not in the products. I suppose that it is necessary to do a specific manipulation but I can't find it. If you have an idea?
Thank you

New member

Posts

Joined
Wed Jun 30, 2021 12:24 am

Post by xxvirusxx » Fri Feb 17, 2023 6:09 pm

You want to test upgrade from 3.0.3.6 to 3.0.3.6 ???
Just clone the website......and remove all data....categories, products...etc...

Yes, extensions can be extracted.....

Upgrade Service | OC 2.3.0.2 PHP 8 | My Custom OC 3.0.3.8 | Buy me a beer


User avatar
Expert Member

Posts

Joined
Tue Jul 17, 2012 10:35 pm
Location - România

Post by by mona » Fri Feb 17, 2023 7:48 pm

All ocmod modification data is stored in the database.
This will probably help.
https://www.opencart.com/index.php?rout ... n_id=22318

DISCLAIMER:
You should not modify core files .. if you would like to donate a cup of coffee I will write it in a modification for you.


https://www.youtube.com/watch?v=zXIxDoCRc84


User avatar
Expert Member

Posts

Joined
Mon Jun 10, 2019 9:31 am

Post by marc@63400 » Fri Feb 17, 2023 9:22 pm

yes I succeeded... but in command line .. because my php.ini had to be modified so nickel.
On the other hand, I block because my site was related to a domain name, to do my tests I will only go through a local address and therefore this poses access path problems and therefore my tests will be false.. . do you have an idea of the method?

New member

Posts

Joined
Wed Jun 30, 2021 12:24 am

Post by SohBH » Sat Feb 18, 2023 5:05 pm

marc@63400 wrote:
Fri Feb 17, 2023 1:18 am
Good morning,
I am in production on a Version 3.0.3.6
not to be stupid, I wanted to redo a site on another machine to do tests so I installed the same version Version 3.0.3.6 and see how to update my site
Once installed, I did an export of the data to import them... and nothing works... the import is impossible.
I wanted to go through phpmyadmin with an export then an import...and I got errors like "Incorrect format parameter"
Can you give me a hand? I don't know where I'm making a mistake or what I have to correct on my file to do this import... Many thanks in advance
Hi, to update version
1. You make a fresh install (not upgrade) on another machine / localhost
2. Start to install all extensions, debug
3. Open phpmyadmin to locate database table that you want to import, should have same columns

View all extensions | Request custom work | Pricing | Contact Me


User avatar
Active Member

Posts

Joined
Mon Nov 02, 2020 12:01 am
Location - Malaysia
Who is online

Users browsing this forum: No registered users and 5 guests