The full migration direction and upgrade.php file is here
NEVER take serious; anyone who gives negative impact statements with no ABSOLUTE proof!
OpenCart Helpful Information * Upgrade 1.5 to 2.1 * Upgrade 2.1 to 2.2
"Why do people NEVER have enough time to do it right but ALWAYS enough time to do it over?"
DO NOT EVER GIVE SOMEONE YOU DON"T KNOW ADMIN ACCESS TO ANYTHING!
I am NOT affiliated with OpenCart
line 8:
Code: Select all
$file = DIR_APPLICATION . 'opencart.sql';
Code: Select all
$file = DIR_INSTALL . 'opencart.sql';
line 555:
Code: Select all
INSERT INTO `" . DB_PREFIX . "user_group` VALUES(1, 'Top Administrator',
Code: Select all
INSERT INTO `" . DB_PREFIX . "user_group` VALUES(1, 'Administrator',
Simon
Yeah that was an old version of the upgrade script. I have removed it so that there is only one place to get the script. The TOP_ADMINISTRATOR is correct in the newer script that is found in the link. As for the $file = DIR_APPLICATION . 'opencart.sql'; line. I noticed that early on in testing and just copied the opencart.sql file to the catalog folder instead of changing the install.php file which originally created the config.php file. I forgot to note the change, I will either have to change the install.php file to reflect the install folder or put in the steps that the new DIR_INSTALL define statement needs to be added to the config.php files.
The latest script is in the link in the first post.
NEVER take serious; anyone who gives negative impact statements with no ABSOLUTE proof!
OpenCart Helpful Information * Upgrade 1.5 to 2.1 * Upgrade 2.1 to 2.2
"Why do people NEVER have enough time to do it right but ALWAYS enough time to do it over?"
DO NOT EVER GIVE SOMEONE YOU DON"T KNOW ADMIN ACCESS TO ANYTHING!
I am NOT affiliated with OpenCart
NEVER take serious; anyone who gives negative impact statements with no ABSOLUTE proof!
OpenCart Helpful Information * Upgrade 1.5 to 2.1 * Upgrade 2.1 to 2.2
"Why do people NEVER have enough time to do it right but ALWAYS enough time to do it over?"
DO NOT EVER GIVE SOMEONE YOU DON"T KNOW ADMIN ACCESS TO ANYTHING!
I am NOT affiliated with OpenCart
NEVER take serious; anyone who gives negative impact statements with no ABSOLUTE proof!
OpenCart Helpful Information * Upgrade 1.5 to 2.1 * Upgrade 2.1 to 2.2
"Why do people NEVER have enough time to do it right but ALWAYS enough time to do it over?"
DO NOT EVER GIVE SOMEONE YOU DON"T KNOW ADMIN ACCESS TO ANYTHING!
I am NOT affiliated with OpenCart
NEVER take serious; anyone who gives negative impact statements with no ABSOLUTE proof!
OpenCart Helpful Information * Upgrade 1.5 to 2.1 * Upgrade 2.1 to 2.2
"Why do people NEVER have enough time to do it right but ALWAYS enough time to do it over?"
DO NOT EVER GIVE SOMEONE YOU DON"T KNOW ADMIN ACCESS TO ANYTHING!
I am NOT affiliated with OpenCart
NEVER take serious; anyone who gives negative impact statements with no ABSOLUTE proof!
OpenCart Helpful Information * Upgrade 1.5 to 2.1 * Upgrade 2.1 to 2.2
"Why do people NEVER have enough time to do it right but ALWAYS enough time to do it over?"
DO NOT EVER GIVE SOMEONE YOU DON"T KNOW ADMIN ACCESS TO ANYTHING!
I am NOT affiliated with OpenCart
2 Week FREE Trial of our Shared Hosting plans (DIrectAdmin or cPanel) for new customers
2 Week FREE Trial of Astra Firewall and Malware Scanner
Visit our website for full details and to start your trial today - www.evolvewebhost.com
That's fine but we had to solve these issues NOW! They could just borrow from what has been done already instead of re-creating the wheel. That is what a forum and open source software is supposed to benefit from.
NEVER take serious; anyone who gives negative impact statements with no ABSOLUTE proof!
OpenCart Helpful Information * Upgrade 1.5 to 2.1 * Upgrade 2.1 to 2.2
"Why do people NEVER have enough time to do it right but ALWAYS enough time to do it over?"
DO NOT EVER GIVE SOMEONE YOU DON"T KNOW ADMIN ACCESS TO ANYTHING!
I am NOT affiliated with OpenCart
I hear you! I just wanted to point that out. It looks like another significant overhaul for the next version.Randem wrote:EvolveWebHosting,
That's fine but we had to solve these issues NOW! They could just borrow from what has been done already instead of re-creating the wheel. That is what a forum and open source software is supposed to benefit from.
2 Week FREE Trial of our Shared Hosting plans (DIrectAdmin or cPanel) for new customers
2 Week FREE Trial of Astra Firewall and Malware Scanner
Visit our website for full details and to start your trial today - www.evolvewebhost.com
NEVER take serious; anyone who gives negative impact statements with no ABSOLUTE proof!
OpenCart Helpful Information * Upgrade 1.5 to 2.1 * Upgrade 2.1 to 2.2
"Why do people NEVER have enough time to do it right but ALWAYS enough time to do it over?"
DO NOT EVER GIVE SOMEONE YOU DON"T KNOW ADMIN ACCESS TO ANYTHING!
I am NOT affiliated with OpenCart
NEVER take serious; anyone who gives negative impact statements with no ABSOLUTE proof!
OpenCart Helpful Information * Upgrade 1.5 to 2.1 * Upgrade 2.1 to 2.2
"Why do people NEVER have enough time to do it right but ALWAYS enough time to do it over?"
DO NOT EVER GIVE SOMEONE YOU DON"T KNOW ADMIN ACCESS TO ANYTHING!
I am NOT affiliated with OpenCart
Just came to say thank you for your efforts
I followed your guide and tested an upgrade from 1.5.5.1
My only suggestion:
In step 10 where is says "then run the OpenCart 2.1.0.1 installation again"
you might want to say run "yoursite/install"
I have one issue where the product prices look nothing like the database on the default template
Now the hard work on all the modules/vqmods begins!
Make sure you download and install the VQMOD I have for the real time fixes (I just changed them again).
In step 10 you run the installation the same way you started http://www.mysite.com/install, Yes?
I am not following...
NEVER take serious; anyone who gives negative impact statements with no ABSOLUTE proof!
OpenCart Helpful Information * Upgrade 1.5 to 2.1 * Upgrade 2.1 to 2.2
"Why do people NEVER have enough time to do it right but ALWAYS enough time to do it over?"
DO NOT EVER GIVE SOMEONE YOU DON"T KNOW ADMIN ACCESS TO ANYTHING!
I am NOT affiliated with OpenCart
I am not following..."
First time install http://www.mysite.com - worked
Upgrade http://www.mysite.com - gave white screen - so I ran
http://www.mysite.com/install - that worked
It Would never have occurred to me to try it without the install portion on the URL...
I made a note on the steps anyway t clarify.
Thanks
NEVER take serious; anyone who gives negative impact statements with no ABSOLUTE proof!
OpenCart Helpful Information * Upgrade 1.5 to 2.1 * Upgrade 2.1 to 2.2
"Why do people NEVER have enough time to do it right but ALWAYS enough time to do it over?"
DO NOT EVER GIVE SOMEONE YOU DON"T KNOW ADMIN ACCESS TO ANYTHING!
I am NOT affiliated with OpenCart
I just completed a test, but possible actual upgrade of our OC 1.5.6.4 store to OC 2.1.0.2 using the instructions at your link Randem.
It went pretty well with only a few minor issues that confused me.
I was lazy and have so many that I did not disable all mods in our current store before starting. I don't see any side effects from not doing so...YET.
In your step 9 you say to copy the opencart.sql from the upload/install/model folder to the catalog folder. In the 2.1.2.2 download that file is located in the upload/install directory after unzipping. Not in upload/install/model No big deal, once I found it I uploaded it to my new catalog folder.
After the upgrade was complete ( step 11) I attempted to import the import the oc_settings, oc_extension, oc_layout, oc_layout_route & oc_layout_module sql files from converted database to the new upgraded database and I could not do so until I first deleted the ones that were already there from importing the original database. I guess most would know to do that but I didn't so I guessed based on the error I received when I first tried.
I also had trouble getting into admin as I was not sure which user to use but that was just me being dumb and not thinking it through. Of course it would be the user and password from the original store but there was still an issue. I noticed that in the now upgraded database the usernames were all truncated / cut off at 20 characters. Since my 1.5.6.4 install allowed for more my username which was an email address was cutoff. Once I figured that out I was able to get in. I can't remember if my 1.5.6.4 install allowing more characters was something I changed at some point of if it was that way by default.
The only thing I will need to figure out how to do after a week or so (probably more like a month) of getting everything the way I want it is how to export from the old store and import into new store orders etc that come in between now and then. But I know a guy, he commented above, who can maybe help me out.
Anyway, just wanted to say thanks. Nice job. Even someone with limited abilities can do it following your instructions...and guessing when needed.
Yes, you were supposed to comment here. This is why the thread is locked on my site.
I made a few changes in the instructions to make it even more clear.
Step 9 - My bad, the opencart.sql file is originally in the install folder.
Step 11 - The reason this did not work for you was because you were supposed to use the tables from step 6 that you exported from the database of the new installation. The database that was just created (v2.1.0.1)... This is why you had trouble getting into the admin panel.
Step 6 - If you exported the SQL file with CREATE / DROP / INSERT checked you would not have had to delete the tables. They would have been automatically dropped, recreated and your data inserted.
Disabling MODS is a safety instruction... better safe than sorry. Trying to eliminate more problems than are caused.
All good though, you just made the instructions better.
NEVER take serious; anyone who gives negative impact statements with no ABSOLUTE proof!
OpenCart Helpful Information * Upgrade 1.5 to 2.1 * Upgrade 2.1 to 2.2
"Why do people NEVER have enough time to do it right but ALWAYS enough time to do it over?"
DO NOT EVER GIVE SOMEONE YOU DON"T KNOW ADMIN ACCESS TO ANYTHING!
I am NOT affiliated with OpenCart
Unfortunately I had already tried to upgrade OC in-situ (my bad) and therefore I could not save my full database instructions including the TABLE CREATE, etc.
I have a backup db. Would it work (at stage 8.) to run the opencart.sql for my old version OC 1.5.1.3 followed by the backup DB in phpmysql in order to re-create the TABLES and populate them?
Thank you
Users browsing this forum: No registered users and 51 guests