2.2.0.0 Upgrade Script Improvements by Qphoria - TEST PLEASE

Post by labeshops » Fri Jun 17, 2016 9:51 pm

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/xxx/public_html/upgrade-test/system/library/db/mysqli.php on line 40

Running Opencart v3.0.3.2 with multi-stores and the default template from https://www.labeshops.com which has links to all my stores.

Post by pm-netti » Fri Jun 17, 2016 11:25 pm

if (!in_array($field['name'], $table_old_data[$table['name']]['field_list'])) {

$sql = "ALTER TABLE `" . $table['name'] . "` CHANGE `" . $field['name'] . "` `" . $field['name'] . "` " . strtoupper($field['type']);

Post by labeshops » Sat Jun 18, 2016 12:56 am

Afraid I don't know - the upgrade script code is beyond my limited php knowledge

Running Opencart v3.0.3.2 with multi-stores and the default template from https://www.labeshops.com which has links to all my stores.

Post by pm-netti » Sat Jun 18, 2016 3:28 pm

$this->db->query($sql);

//$this->db->query($sql);

Post by Jentoo » Sun Jun 19, 2016 12:26 am

Post by labeshops » Sun Jun 19, 2016 12:57 am

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_address` DROP PRIMARY KEY in /home/xxxx/public_html/upgrade-test/system/library/db/mysqli.php on line 40

Running Opencart v3.0.3.2 with multi-stores and the default template from https://www.labeshops.com which has links to all my stores.

Post by pm-netti » Sun Jun 19, 2016 3:01 am

labeshops wrote:well tried that and got another error - *sigh*

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_address` DROP PRIMARY KEY in /home/xxxx/public_html/upgrade-test/system/library/db/mysqli.php on line 40

You will have a fun server
1000.php line 282:

Code: Select all

$this->db->query("ALTER TABLE `" . $table['name'] . "` DROP PRIMARY KEY");

change to:

Code: Select all

//$this->db->query("ALTER TABLE `" . $table['name'] . "` DROP PRIMARY KEY");

Post by labeshops » Sun Jun 19, 2016 3:11 am

Running Opencart v3.0.3.2 with multi-stores and the default template from https://www.labeshops.com which has links to all my stores.

Post by pm-netti » Sun Jun 19, 2016 3:25 am

Post by beebl3brox » Sun Jun 19, 2016 3:26 am

Post by pm-netti » Sun Jun 19, 2016 2:31 pm

Post by labeshops » Sun Jun 19, 2016 7:24 pm

Running Opencart v3.0.3.2 with multi-stores and the default template from https://www.labeshops.com which has links to all my stores.

Post by pm-netti » Sun Jun 19, 2016 8:07 pm

labeshops wrote:Not sure but I think it is linux. Will have to check with evolve.

I would be interested in just upgrading the database too as I already have a clean 2.2 running - anyone know how to do that?

If your system is Linux, it is reason your upgrade problems.
You are do upgrade from version 1.5.x. Yes, it is known how the update is done Create new tables, create new columns, rename few colums name, add new setting data, change image paths ('data/' to 'catalog/'), move modules data from table setting, change data to Json format etc.

Post by labeshops » Sun Jun 19, 2016 8:27 pm

Running Opencart v3.0.3.2 with multi-stores and the default template from https://www.labeshops.com which has links to all my stores.

Post by pm-netti » Mon Jun 20, 2016 12:09 am

echo php_uname();

Post by pm-netti » Mon Jun 20, 2016 4:02 pm

$sql = "ALTER TABLE `" . $table['name'] . "` CHANGE `" . $field['name'] . "` `" . $field['name'] . "` " . strtoupper($field['type']);

$sql = "ALTER TABLE `" . $table['name'] . "` MODIFY `" . $field['name'] . "` " . strtoupper($field['type']);

Post by EvolveWebHosting » Tue Jun 21, 2016 3:31 am

Opencart Hosting Plans, Domain Registration, Microsoft and Google Email and More
Visit our website for great deals and most importantly, fast and friendly support - www.evolvewebhost.com

Post by labeshops » Tue Jun 21, 2016 10:08 am

Yup, thanks to Evolve, my awesome web hosts, I am upgrade! Have a bunch of work to do mainly in redesign, but everything is working if not pretty yet

Running Opencart v3.0.3.2 with multi-stores and the default template from https://www.labeshops.com which has links to all my stores.

Post by kirkhall » Thu Jun 23, 2016 8:19 am

Post by labeshops » Thu Jun 23, 2016 9:24 am

Running Opencart v3.0.3.2 with multi-stores and the default template from https://www.labeshops.com which has links to all my stores.