Did you disable all MODS and extensions in your upgrade?
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
If you are referring to OpenCart-Migration-Upgrade-Tool-2.0.5
That I executed many times, but Can not be to turn data into the database, So it will use text comparison tool to manually input.
How can I correct use OpenCart-Migration-Upgrade-Tool-2.0.5 it?
Which is referenced in this thread a few times.
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
Code: Select all
$line = str_replace("CREATE TABLE `" . DB_PREFIX . "", "CREATE TABLE `" . DB_PREFIX, $line);
Code: Select all
$line = str_replace("CREATE TABLE `oc_", "CREATE TABLE `" . DB_PREFIX, $line);
I'll let you know if this fixes my problem.
Using the updated "upgrade.php" script solves most immediate problems. It has already been done for you... No need to re-invent the wheel...
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'm not re-inventing the wheel. Your work is brilliant and has helped a lot. After I removed the extra keys that had been added in error by some other mod, your upgrade.php script ran fine (but please could you change this issue?
I now have a working 2.1.0.1 database with my old dataAllenConquest wrote:I found a small bug in the upgrade.php file. Line 25 currently reads:
It should be:Code: Select all
$line = str_replace("CREATE TABLE `" . DB_PREFIX . "", "CREATE TABLE `" . DB_PREFIX, $line);
I have never used a prefix on my tables, so this was causing a problem.Code: Select all
$line = str_replace("CREATE TABLE `oc_", "CREATE TABLE `" . DB_PREFIX, $line);
Change which issue? I don't understand... My line 25 looks like this:
Code: Select all
$line = str_replace("DROP TABLE IF EXISTS `oc_", "DROP TABLE IF EXISTS `" . DB_PREFIX, $line);
$line = str_replace("CREATE TABLE `" . DB_PREFIX . "", "CREATE TABLE `" . DB_PREFIX, $line);
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
Code: Select all
$line = str_replace("CREATE TABLE `oc_", "CREATE TABLE `" . DB_PREFIX, $line);
Code: Select all
$line = str_replace("CREATE TABLE `" . DB_PREFIX . "", "CREATE TABLE `" . DB_PREFIX, $line);
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
The errors I was getting in line 254 were caused by non-PRIMARY composite keys being added to the database (by some other script). This situation would also cause the OC upgrade.php script to fail. The reason is that the SHOW INDEXES command returns multiple rows for a composite index, so the loop in this area of the code tries to drop an index that has already be dropped.
I believe the show indexes query should be changed to something like
Code: Select all
SHOW INDEXES FROM `table` where Seq_in_index = 1
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
You are confusing your self; The words update and upload are not interchangeable...
The correct instructions have always been to copy the CONTENTS of the upload folder of the newer version to the folder where you have installed OpenCart. Meaning that what you are really doing is replacing all your files with the newer version and that WILL NOT upgrade your OpenCart. All you will do with those instructions is cause your version 1.5.5.1 to become almost useless.
Where are you getting these instructions from. Please post them. None of my instructions would NEVER tell you to do that. Either you are confused or have gotten a hold of bad instructions.
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
Users browsing this forum: No registered users and 55 guests