When I upgrade from openCart 1.5.6.1 to 2.0.1.1, error as following:
Notice: Error: Can't DROP 'option_value'; check that column/key exists
Error No: 1091
Error in: /home/tonerink/public_html/install/model/upgrade.php line 349
ALTER TABLE `oc3_product_option` DROP `option_value` in /home/tonerink/public_html/system/library/db/mysql.php on line 53
Warning: Cannot modify header information - headers already sent by (output started at /home/tonerink/public_html/system/library/db/mysql.php:53) in /home/tonerink/public_html/system/library/response.php on line 12
website is: tonerink.nz
Please help.
when I upgraded I got this error...
Notice: Use of undefined constant DIR_MODIFICATION - assumed 'DIR_MODIFICATION' in /home/content/10/7275410/html/store/system/startup.php on line 53
Notice: Use of undefined constant DIR_MODIFICATION - assumed 'DIR_MODIFICATION' in /home/content/10/7275410/html/store/system/startup.php on line 57
Notice: Use of undefined constant DIR_MODIFICATION - assumed 'DIR_MODIFICATION' in /home/content/10/7275410/html/store/system/startup.php on line 53
Notice: Use of undefined constant DIR_MODIFICATION - assumed 'DIR_MODIFICATION' in /home/content/10/7275410/html/store/system/startup.php on line 57
Hi,TonerInknz wrote:When I upgrade from openCart 1.5.6.1 to 2.0.1.1, error as following:
Notice: Error: Can't DROP 'option_value'; check that column/key exists
Error No: 1091
Error in: /home/tonerink/public_html/install/model/upgrade.php line 349
ALTER TABLE `oc3_product_option` DROP `option_value` in /home/tonerink/public_html/system/library/db/mysql.php on line 53
Warning: Cannot modify header information - headers already sent by (output started at /home/tonerink/public_html/system/library/db/mysql.php:53) in /home/tonerink/public_html/system/library/response.php on line 12
website is: tonerink.nz
Please help.
You can try my module to export your OpenCart 1 database to OpenCart 2: http://www.opencart.com/index.php?route ... n_id=20423
I found ignoring this error seems to work fine. Just re-run the installer and it should skip it the second timeTonerInknz wrote:When I upgrade from openCart 1.5.6.1 to 2.0.1.1, error as following:
Notice: Error: Can't DROP 'option_value'; check that column/key exists
Error No: 1091
Error in: /home/tonerink/public_html/install/model/upgrade.php line 349
ALTER TABLE `oc3_product_option` DROP `option_value` in /home/tonerink/public_html/system/library/db/mysql.php on line 53
Warning: Cannot modify header information - headers already sent by (output started at /home/tonerink/public_html/system/library/db/mysql.php:53) in /home/tonerink/public_html/system/library/response.php on line 12
website is: tonerink.nz
Please help.
This is because there are new defines in the config.php and admin/config.php that you need to add to point to the new system/upload and system/modification foldersodme wrote:when I upgraded I got this error...
Notice: Use of undefined constant DIR_MODIFICATION - assumed 'DIR_MODIFICATION' in /home/content/10/7275410/html/store/system/startup.php on line 53
Notice: Use of undefined constant DIR_MODIFICATION - assumed 'DIR_MODIFICATION' in /home/content/10/7275410/html/store/system/startup.php on line 57
Follow the other values like "DIR_SYSTEM" in those files as your guide and make the appropriate change of the target folder
I am having the same error, but target folder looks to be correct. Could you be more specific?Qphoria wrote:rote:
when I upgraded I got this error...
Notice: Use of undefined constant DIR_MODIFICATION - assumed 'DIR_MODIFICATION' in /home/content/10/7275410/html/store/system/startup.php on line 53
Notice: Use of undefined constant DIR_MODIFICATION - assumed 'DIR_MODIFICATION' in /home/content/10/7275410/html/store/system/startup.php on line 57
This is because there are new defines in the config.php and admin/config.php that you need to add to point to the new system/upload and system/modification folders
Follow the other values like "DIR_SYSTEM" in those files as your guide and make the appropriate change of the target folder
Thanks.
URL is taylorcreeknursery.com
ADD TO CONFIG FILES IN PUBLIC AND ADMIN..
should look something like this:
define('DIR_MODIFICATION', '/home/"CHANGE TO YOURS"/public_html/system/modification/');
define('DIR_UPLOAD', '/home/"CHANGE TO YOURS"/public_html/system/upload/');
should look something like this:
define('DIR_MODIFICATION', '/home/"CHANGE TO YOURS"/public_html/system/modification/');
define('DIR_UPLOAD', '/home/"CHANGE TO YOURS"/public_html/system/upload/');
Who is online
Users browsing this forum: Majestic-12 [Bot] and 5 guests
