2.2.0.0 Upgrade Script Improvements by Qphoria - TEST PLEASE

pm-netti wrote:

brik wrote: Question:
I have an upgraded system and a couple of systems installed from scratch. The new installations don't have the file system/library.user.php where did this file come from is it legacy? Is it even being used?

In version 2.2 this is in file system/library/cart/user.php

adilbhatofficial wrote:For those who are getting this error

SyntaxError: JSON.parse: unexpected character at line 1 column 1 of the JSON data OK
Fatal error: Maximum execution time of 30 seconds exceeded in C:\xampp\htdocs\testcart\system\library\db\mysqli.php on line 18

OSWorX wrote:Quite nice, but how many are working locale (XAMPP)???
And what for all those who cannot change the time (because of provider restrictions or not parsing additional *.ini files)?

SeniorSE wrote:Hi everyone. I used the new upgrade script to go from 1.5.5.1 to 2.2.0.0, and it worked great! Except, now I get an error when I try to load the Admin console or the store:

Admin Console

Code: Select all

Fatal error: Uncaught exception 'Exception' with message 'Error: Could not load database adaptor mysqli!' in /home4/onemuga1/public_html/store2/system/library/db.php:11 Stack trace: #0 /home4/onemuga1/public_html/store2/system/framework.php(25): DB->__construct('mysqli', 'localhost', '<deleted>', '<deleted>', 'onemuga1_oc2', '3306') #1 /home4/onemuga1/public_html/store2/admin/index.php(26): require_once('/home4/onemuga1...') #2 {main} thrown in /home4/onemuga1/public_html/store2/system/library/db.php on line 11

OSWorX wrote:While the proposal form Qphoria may acceptable for 'experienced developers', many of the users are 'not so experienced' (to stay nice ..).
Why not creating something like a 'self calling' script which loads the update commands in chunks by itself (as many other very big projects already doing)?
That should be possible with a few lines of ajax within the lowest possible value of 30 seconds most of the servers are configured actually.

Qphoria wrote:
Are you sure you uploaded all files from the oc2200 package? it looks like some files aren't there, namely the system/library/db/mysqli.php file

labeshops wrote:Trying to do the upgrade on a test copy of my 1.5.6.4 going to 2.2.0 using your upgrade script. I get:

Code: Select all

Progress
Error Code(0): Error: Duplicate entry '103-1' for key 'PRIMARY'
Error No: 1062
Error in: /home/xxxx/public_html/upgrade-test/install/model/upgrade/1000.php line 293
ALTER TABLE `oc_product_description` ADD PRIMARY KEY(`product_id`,`language_id`) in /home/xxxx/public_html/upgrade-test/system/library/db/mysql.php on line 54

and it fails.

labeshops wrote:Hmmm

I think the problem might be that years ago I ran this http://forum.opencart.com/viewtopic.php?f=121&t=107756 which added indexes? Not sure how I can undo that???

I have only ever used 1 language though.

				if ($primary_data) {
					       $this->db->query("ALTER TABLE `" . $table['name'] . "` ADD PRIMARY KEY(" . implode(',', $primary_data) . ")");
				}

				if ($query->num_rows && $primary_data) {
					foreach ($query->rows as $result) {
						if ($result['Key_name'] != 'PRIMARY' && $result['Key_name']) {
					       $this->db->query("ALTER TABLE `" . $table['name'] . "` ADD PRIMARY KEY(" . implode(',', $primary_data) . ")");
				        }
				    }
				}

labeshops wrote:Hmm well tried that and now have a different error...

Code: Select all

Error Code(0): Error: Incorrect table definition; there can be only one auto column and it must be defined as a key
Error No: 1075
ALTER TABLE `oc_affiliate` CHANGE `affiliate_id` `affiliate_id` INT(11) NOT NULL AUTO_INCREMENT in /home/ammaaset/public_html/upgrade-test/system/library/db/mysqli.php on line 40

if ($oldfield['Extra'] == 'auto_increment' && $field['autoincrement']) {

if ($oldfield['Extra'] == 'auto_increment' && $field['autoincrement'] && $oldfield['Field'] != $field['name']) {

labeshops wrote:That didn't work - same error

$oldfield['Field'] != $field['name']