Post by mikeconomy » Mon Sep 04, 2017 6:28 pm

Hi Everyone,
Hope you are well so it seems i think i have put myself in a really difficult situation and a little out of my depth.

I built a site from my father to run his business on open cart in 2010 and he is starting to have trouble with it and i want to try and move him along the upgrade path to 3.0.

Im a little out of my dept what is the best way to do this.

. Version of OpenCart? 1.5.1 >
. Clean install or upgrade? upgrade (or is it better to just upgrade the database and start clean ?)
. From what version are you upgrading? 1.5.1



Sat May 08, 2010 11:30 am

Post by MrPhil » Mon Sep 04, 2017 9:34 pm

That's too big a jump. Besides, v3 is still on its shakedown cruise and will have a lot of bugs for a while. It would be better to move to v2.3 for now, and think about v3 in a year or two, after it's settled down.

Active Member


Wed May 10, 2017 11:52 pm

Post by Sevak » Wed Sep 06, 2017 1:23 pm

Me too have similar situation.

I'm still running v 1.4 and want to upgrade to 3.0.2.

Tried couple of options, first installed 3.0.2 on my localhost and imported 1.4 DB, but it still show the demo content though the db is pointing to right one.

Please suggest the steps to upgrade from 1.4 to 3.x.

Your support would be greatly appreciated.
Thanks in advance.



Tue Sep 05, 2017 12:51 pm

Post by puyopuy » Sat Sep 16, 2017 12:02 pm

This is what I did.

1. Fulll backup existing database by export by SQL.
2. Create a new database(e.g. Upgrade) and import by SQL.
3. Make a copy of your existing Opencart folder and copy to new location(e.g. Upgrade).
4. Open config.php and admin/config.php from your new location and change the location path, DB name and db_driver(mysqli).
5. Create a subdomain(e.g. and point to your new location.
6. Test and make sure new created site are working.
(MAKE SURE YOU CHANGED THE NEW DB's NAME, you can test it by adding new record in upgrade Opencart)

7. Overwrite your upgraded folder by Opencart 3.0 files(all files and folders from upload folder).
8. Run the installation again and Opencart should detected an upgarde.

You may see this error, I just ignored and continue.
Error Code(0): Error: Unknown table 'nwtco859_upgrade.affiliate_activity'
Error No: 1051
DROP TABLE `affiliate_activity` in /home/nwtco859/upgrade/system/library/db/mysqli.php on line 40

After upgrade, clear any cookies in your browser to avoid getting token errors.

Load the admin page & press Ctrl+F5 twice to force the browser to update the css changes.
Opencart may ask you to move your storage directory.
So you move the storage directory by following the instructions, automatic Move doesn't work for me, I have to manually move the folder.
After you moved, you have to change to change the config files.

Goto Admin -> Users -> User Groups and Edit the Top Adminstrator group. Check All boxes.
Goto Admin and Edit the main System Settings. Update all fields and click save, even if nothing changed.
Goto Admin Extensions -> Themes -> Default Store Theme and Click Install and select your theme.
Goto Admin -> Settings -> Server and change the Error Log Filename to error.log
Load the store front & press Ctrl+F5 twice to force the browser to update the css changes.
All done :)



Fri Feb 10, 2012 11:47 pm
Who is online

Users browsing this forum: No registered users and 22 guests