When upgrading from 1.5.6.4 to 2.0
Notice: Error: Can't DROP 'value'; check that column/key exists
Error No: 1091
ALTER TABLE `oc_product_option` DROP `value` in /home/jonathortense/www/xxxxxxxxxx.com.br/system/library/db/mysqli.php on line 40
Notice: Error: Can't DROP 'option_value'; check that column/key exists
Error No: 1091
ALTER TABLE `oc_product_option` DROP `option_value` in /home/jonathortense/www/xxxxxxxxxx.com.br/system/library/db/mysqli.php on line 40
Warning: Cannot modify header information - headers already sent by (output started at /home/jonathortense/www/xxxxxxxxxx.com.br/system/library/db/mysqli.php:40) in /home/jonathortense/www/xxxxxxxxxx.com.br/system/library/response.php on line 12
I had the same problem trying to upgrade from 1.5.6.1 to 2.0.2.0. The upgrade script produced the "Can't DROP 'option_value" error, which killed the OpenCart site. I've restored from backup back to 1.5.6.1 and will postpone upgrading to 2 until a much later date.
I too ran into this issue when upgrading from 1.5.6.4 to 2.0.3.1:
I suppose I'll hold off on the upgrade to 2.0 for the time being. Any news on when this issue might be addressed?
Code: Select all
Notice: Error: Can't DROP 'option_value'; check that column/key exists
Error No: 1091
Error in: /home/path/to/site/install/model/upgrade.php line 349
ALTER TABLE `oc_product_option` DROP `option_value` in /home/path/to/site/system/library/db/mysql.php on line 55
Warning: Cannot modify header information - headers already sent by (output started at /home/path/to/site/system/library/db/mysql.php:55) in /home/path/to/site/system/library/response.php on line 12
Who is online
Users browsing this forum: No registered users and 2 guests
