Upgrade from 2.1.0.2 to 2.2.0.0 has problems

I tried upgrading a working site with Opencart 2.1.0.2 to Opencart 2.2.0.0 in my test environment using WAMPserver with PHP 5.6.15 and it all seems to work with the exception that when I click on a category to see all the products I get the following errors;

Warning: imagecreatetruecolor(): Invalid image dimensions in C:\wamp64\www\km5h.softrockradio.org\system\library\image.php on line 105
Warning: imagecolorallocate() expects parameter 1 to be resource, boolean given in C:\wamp64\www\km5h.softrockradio.org\system\library\image.php on line 113
Warning: imagefilledrectangle() expects parameter 1 to be resource, boolean given in C:\wamp64\www\km5h.softrockradio.org\system\library\image.php on line 116
Warning: imagecopyresampled() expects parameter 1 to be resource, boolean given in C:\wamp64\www\km5h.softrockradio.org\system\library\image.php on line 118
Warning: imagecreatetruecolor(): Invalid image dimensions in C:\wamp64\www\km5h.softrockradio.org\system\library\image.php on line 105
Warning: imagecolorallocate() expects parameter 1 to be resource, boolean given in C:\wamp64\www\km5h.softrockradio.org\system\library\image.php on line 113
Warning: imagefilledrectangle() expects parameter 1 to be resource, boolean given in C:\wamp64\www\km5h.softrockradio.org\system\library\image.php on line 116
Warning: imagecopyresampled() expects parameter 1 to be resource, boolean given in C:\wamp64\www\km5h.softrockradio.org\system\library\image.php on line 118
Warning: imagecreatetruecolor(): Invalid image dimensions in C:\wamp64\www\km5h.softrockradio.org\system\library\image.php on line 105
Warning: imagecolorallocate() expects parameter 1 to be resource, boolean given in C:\wamp64\www\km5h.softrockradio.org\system\library\image.php on line 113
Warning: imagefilledrectangle() expects parameter 1 to be resource, boolean given in C:\wamp64\www\km5h.softrockradio.org\system\library\image.php on line 116
Warning: imagecopyresampled() expects parameter 1 to be resource, boolean given in C:\wamp64\www\km5h.softrockradio.org\system\library\image.php on line 118

Any assistance would be appreciated.

Thanks

Cecil

Hi Cecil,

I just finished an upgrade script to test for v2.2.0.0. Try it if you like.

Upgrade to 2.1.0.x - http://www.randemsystems.com/support/op ... n-2-1-0-1/
Upgrade from 2.1.0.x to 2.2.0.0 - http://www.randemsystems.com/support/op ... 0/#msg6260

Ref: http://forum.opencart.com/viewtopic.php ... 30#p608730

Thanks for the link.

I put my local website back to 2.1.0.2 and tested it, all seems OK
Copied the 2.2.0.0 files over the site.
copied your files also
ran website/install/ and got the following errors;

Error Code(0): Error: Duplicate entry '1' for key 'PRIMARY'
Error No: 1062
INSERT INTO `api` VALUES(1, 'Default', 'ABWtRPVCVDd2IRrGGnIEniG5b7V5fQIe8WUuf2h8QtQGeD3JCweYi7SdJ17TpgVtTGbTcKwfms0H8k4DtcsdRFc0MwDfD62m6Uno6HatYAkoUvzf7dSxJH6AfCGWE8LQIKYXk2FppY6dptqg9r6loUUpe32xC3ZG4EvLNYbdFr3Em7thggrAYXwFgkpznawcjpC5gISst2c6I6gBfWIspcNrZi6Om0D22mZ227eWQtUqpXqeisslua9J6xbAAPHF', 1, '2015-12-20 00:00:46', '2015-12-20 00:00:46'); in C:\wamp64\www\km5h.softrockradio.org\system\library\db\mysqli.php on line 40

Thanks

Cecil

You are running on a test site yes?


Which file did you download (2.1.0.x or 2.2.0.0) the install.zip or upgrade.zip. I can't duplicate that error no matter how many times I run the 2.2.0.0 script.

I clicked on the 2.1 to 2.2 upgrade link and downloaded the file there.

cbayona wrote:I clicked on the 2.1 to 2.2 upgrade link and downloaded the file there.

You try go to admin > extension > theme > theme default and press "Save"

cbayonam

Did you install the 2.2.0.0 software first before applying the 8 upgrade files?

I ran this procedure on a test environment on PHP 5.6.15 my actual host has PHP 5.6.15

I downloaded the files that the link said they were for 2.1.x.x to 2.2.x.x conversion

I had the test website with OpenCart 2.1.02 up and running OK.
I added the 2.2.0.0 upgrade files overriding the original files
I added the conversion upgrade files overriding the files in the install directory
I ran website/install/

The errors were while running the upgrade, the site was in no shape to run afterwards.

Should I upgrade to 2.2.0.0 first then run the conversion files? Or should I run the database upgrade while still on 2.1.0.2?

Thanks

Cecil

I have fix this issue and updated the archive only the 1000.php file was affected.

http://www.randemsystems.com/support/op ... 0/#msg6260

Didn't quite get an answer to my last post so I'm not sure of the order to do the upgrade but I did the following;

Got the site and database back to 2.1.0.2, tested OK.
Installed files from the 2.2.0.0 upgrade
Upgraded the site to 2.2.0.0
Installed the conversion software with the updated files from the last post
ran the install procedure, no errors during update this time but have the following errors that look the same as the initial post when I click on one of the categories to see the products in that category.

Client errors;

Warning: imagecreatetruecolor(): Invalid image dimensions in C:\wamp64\www\test.softrockradio.org\system\library\image.php on line 105Warning: imagecolorallocate() expects parameter 1 to be resource, boolean given in C:\wamp64\www\test.softrockradio.org\system\library\image.php on line 113Warning: imagefilledrectangle() expects parameter 1 to be resource, boolean given in C:\wamp64\www\test.softrockradio.org\system\library\image.php on line 116Warning: imagecopyresampled() expects parameter 1 to be resource, boolean given in C:\wamp64\www\test.softrockradio.org\system\library\image.php on line 118Warning: imagecreatetruecolor(): Invalid image dimensions in C:\wamp64\www\test.softrockradio.org\system\library\image.php on line 105Warning: imagecolorallocate() expects parameter 1 to be resource, boolean given in C:\wamp64\www\test.softrockradio.org\system\library\image.php on line 113Warning: imagefilledrectangle() expects parameter 1 to be resource, boolean given in C:\wamp64\www\test.softrockradio.org\system\library\image.php on line 116Warning: imagecopyresampled() expects parameter 1 to be resource, boolean given in C:\wamp64\www\test.softrockradio.org\system\library\image.php on line 118Warning: imagecreatetruecolor(): Invalid image dimensions in C:\wamp64\www\test.softrockradio.org\system\library\image.php on line 105Warning: imagecolorallocate() expects parameter 1 to be resource, boolean given in C:\wamp64\www\test.softrockradio.org\system\library\image.php on line 113Warning: imagefilledrectangle() expects parameter 1 to be resource, boolean given in C:\wamp64\www\test.softrockradio.org\system\library\image.php on line 116Warning: imagecopyresampled() expects parameter 1 to be resource, boolean given in C:\wamp64\www\test.softrockradio.org\system\library\image.php on line 118

At this point the client side get the above errors, and the administration side gets a bunch of errors and is non-functional.

Admin errors;

( ! ) Fatal error: Uncaught exception 'Exception' with message 'Error: Unknown column 'cgd.name' in 'order clause'<br />Error No: 1054<br />SELECT * FROM customer_group cg LEFT JOIN customer_group_description cgd ON (cg.customer_group_id = cgd.customer_group_id) WHERE cgd.language_id = '1' ORDER BY cgd.name ASC' in C:\wamp64\www\test.softrockradio.org\system\library\db\mysqli.php on line 40
( ! ) Exception: Error: Unknown column 'cgd.name' in 'order clause'<br />Error No: 1054<br />SELECT * FROM customer_group cg LEFT JOIN customer_group_description cgd ON (cg.customer_group_id = cgd.customer_group_id) WHERE cgd.language_id = '1' ORDER BY cgd.name ASC in C:\wamp64\www\test.softrockradio.org\system\library\db\mysqli.php on line 40
Call Stack
# Time Memory Function Location
1 0.0010 240504 {main}( ) ...\index.php:0
2 0.0106 570944 require_once( 'C:\wamp64\www\test.softrockradio.org\system\framework.php' ) ...\index.php:22
3 0.0301 825432 Front->dispatch( ) ...\framework.php:99
4 0.0699 1660520 Front->execute( ) ...\front.php:29
5 0.0699 1660520 Action->execute( ) ...\front.php:34
6 0.0706 1672920 call_user_func_array:{C:\wamp64\www\test.softrockradio.org\system\engine\action.php:44} ( ) ...\action.php:44
7 0.0706 1673376 ControllerStartupRouter->index( ) ...\action.php:44
8 0.0710 1674384 Action->execute( ) ...\router.php:26
9 0.0764 2182432 call_user_func_array:{C:\wamp64\www\test.softrockradio.org\system\engine\action.php:44} ( ) ...\action.php:44
10 0.0764 2202464 ControllerSettingSetting->index( ) ...\action.php:44
11 0.1130 3417664 getCustomerGroups ( ) ...\setting.php:669
12 0.1130 3417840 Proxy->__call( ) ...\setting.php:669
13 0.1130 3417888 call_user_func:{C:\wamp64\www\test.softrockradio.org\system\engine\proxy.php:13} ( ) ...\proxy.php:13
14 0.1130 3418136 Loader->{closure:C:\wamp64\www\test.softrockradio.org\system\engine\loader.php:129-163}( ) ...\proxy.php:13
15 0.1133 3419056 call_user_func_array:{C:\wamp64\www\test.softrockradio.org\system\engine\loader.php:150} ( ) ...\loader.php:150
16 0.1133 3419336 ModelCustomerCustomerGroup->getCustomerGroups( ) ...\loader.php:150
17 0.1133 3420632 DB->query( ) ...\customer_group.php:72
18 0.1133 3420760 DB\MySQLi->query( )

So the site is non-functional from the admin side, errors when categories are looked at on the client side.

Thanks

Cecil

Tried it a different way;

Restore site to 2.1.0.2, tested OK
Added files to update to 2.2.0.0
Added files including latest update to migrate database
ran the install procedure, it proceeded to complete without errors.

The categories now display OK but new errors showed up that were not showing up in 2.1.0.2;

When viewing a order you get the following error;

Notice: Undefined index: name in C:\wamp64\www\test.softrockradio.org\admin\controller\sale\order.php on line 874

if one tried to edit the order, the page crashes with multiple errors;

( ! ) Fatal error: Uncaught exception 'Exception' with message 'Error: Unknown column 'cgd.name' in 'order clause'<br />Error No: 1054<br />SELECT * FROM customer_group cg LEFT JOIN customer_group_description cgd ON (cg.customer_group_id = cgd.customer_group_id) WHERE cgd.language_id = '1' ORDER BY cgd.name ASC' in C:\wamp64\www\test.softrockradio.org\system\library\db\mysqli.php on line 40
( ! ) Exception: Error: Unknown column 'cgd.name' in 'order clause'<br />Error No: 1054<br />SELECT * FROM customer_group cg LEFT JOIN customer_group_description cgd ON (cg.customer_group_id = cgd.customer_group_id) WHERE cgd.language_id = '1' ORDER BY cgd.name ASC in C:\wamp64\www\test.softrockradio.org\system\library\db\mysqli.php on line 40
Call Stack
# Time Memory Function Location
1 0.0004 240648 {main}( ) ...\index.php:0
2 0.0097 571040 require_once( 'C:\wamp64\www\test.softrockradio.org\system\framework.php' ) ...\index.php:22
3 0.0263 832576 Front->dispatch( ) ...\framework.php:99
4 0.0604 1668472 Front->execute( ) ...\front.php:29
5 0.0605 1668472 Action->execute( ) ...\front.php:34
6 0.0613 1680904 call_user_func_array:{C:\wamp64\www\test.softrockradio.org\system\engine\action.php:44} ( ) ...\action.php:44
7 0.0613 1681336 ControllerStartupRouter->index( ) ...\action.php:44
8 0.0617 1682336 Action->execute( ) ...\router.php:26
9 0.0688 2368456 call_user_func_array:{C:\wamp64\www\test.softrockradio.org\system\engine\action.php:44} ( ) ...\action.php:44
10 0.0688 2368776 ControllerSaleOrder->edit( ) ...\action.php:44
11 0.0727 2561104 ControllerSaleOrder->getForm( ) ...\order.php:32
12 0.1021 3462248 getCustomerGroups ( ) ...\order.php:647
13 0.1021 3462424 Proxy->__call( ) ...\order.php:647
14 0.1021 3462472 call_user_func:{C:\wamp64\www\test.softrockradio.org\system\engine\proxy.php:13} ( ) ...\proxy.php:13
15 0.1021 3462720 Loader->{closure:C:\wamp64\www\test.softrockradio.org\system\engine\loader.php:129-163}( ) ...\proxy.php:13
16 0.1022 3463640 call_user_func_array:{C:\wamp64\www\test.softrockradio.org\system\engine\loader.php:150} ( ) ...\loader.php:150
17 0.1023 3463920 ModelCustomerCustomerGroup->getCustomerGroups( ) ...\loader.php:150
18 0.1023 3465216 DB->query( ) ...\customer_group.php:72
19 0.1023 3465344 DB\MySQLi->query( )

also one can't change the status of an order or delete an order, no errors just nothing happens.

Thanks

Cecil

Cecil,
Take a look here
http://forum.opencart.com/viewtopic.php ... 82#p609082

cbayona wrote:Tried it a different way;

Restore site to 2.1.0.2, tested OK
Added files to update to 2.2.0.0
Added files including latest update to migrate database
ran the install procedure, it proceeded to complete without errors.

The categories now display OK but new errors showed up that were not showing up in 2.1.0.2;

When viewing a order you get the following error;

Notice: Undefined index: name in C:\wamp64\www\test.softrockradio.org\admin\controller\sale\order.php on line 874

if one tried to edit the order, the page crashes with multiple errors;

( ! ) Fatal error: Uncaught exception 'Exception' with message 'Error: Unknown column 'cgd.name' in 'order clause'<br />Error No: 1054<br />SELECT * FROM customer_group cg LEFT JOIN customer_group_description cgd ON (cg.customer_group_id = cgd.customer_group_id) WHERE cgd.language_id = '1' ORDER BY cgd.name ASC' in C:\wamp64\www\test.softrockradio.org\system\library\db\mysqli.php on line 40
( ! ) Exception: Error: Unknown column 'cgd.name' in 'order clause'<br />Error No: 1054<br />SELECT * FROM customer_group cg LEFT JOIN customer_group_description cgd ON (cg.customer_group_id = cgd.customer_group_id) WHERE cgd.language_id = '1' ORDER BY cgd.name ASC in

It looks that your language id is not found in table customer_group_description.
If this ok, you change admin language to english.
Then go to admin > customer > customer group and save customer groups all your languages.

Cecil. There was an error in the upgrade script which has since been fixed. New script posted. Only the 1000.php script file was affected.

I recommend OpenCart migration extension to upgrade old version of Opencart to new version. Try http://litextension.com/opencart-migrat ... ation.html as same as a easy solution.