Post by jonathortense » Sat Oct 25, 2014 8:04 am

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

Newbie

Posts

Joined
Sat Oct 25, 2014 7:59 am

Post by rph » Sat Oct 25, 2014 12:53 pm

You can ignore it though I would strongly recommend against upgrading. The upgrade script is not up to snuff.

-Ryan


rph
Expert Member

Posts

Joined
Fri Jan 08, 2010 5:05 am
Location - Lincoln, Nebraska

Post by jonathortense » Tue Apr 21, 2015 1:03 pm

Ok Thanks.

I gave up update. Too much errors.

Newbie

Posts

Joined
Sat Oct 25, 2014 7:59 am

Post by sruzin » Thu Apr 30, 2015 4:21 am

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.

Newbie

Posts

Joined
Wed Aug 21, 2013 6:59 am

Post by Webnet » Sun Sep 06, 2015 8:34 pm

I too ran into this issue when upgrading from 1.5.6.4 to 2.0.3.1:

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
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?

New member

Posts

Joined
Fri Dec 31, 2010 3:17 am
Who is online

Users browsing this forum: No registered users and 6 guests