Page 7 of 8
Re: [BETA] Upgrade Script for 1.4.x to 1.5.x (NO OPTIONS)
Posted: Sun Jul 17, 2011 11:06 am
by allenshea
The purpose of this script is to allow you to convert your 1.4.x store to 1.5.x without losing database data (orders, products, customers, stores, categories, etc.
The customer doesn't lost, but the CART info doesn't upgraded with this script, I've lost the cart for all customers. Don't know if you have plan to upgrade the cart too.
Thanks!
Re: [BETA] Upgrade Script for 1.4.x to 1.5.x (NO OPTIONS)
Posted: Sun Jul 17, 2011 11:27 am
by mongkolbest
i got this error message
OpenCart 1.x Upgrade Script (BETA)
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/j4an6exr/public_html/install/upgrade-14x-to-15x.no-opt.php on line 77
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/j4an6exr/public_html/install/upgrade-14x-to-15x.no-opt.php on line 77
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/j4an6exr/public_html/install/upgrade-14x-to-15x.no-opt.php on line 77
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/j4an6exr/public_html/install/upgrade-14x-to-15x.no-opt.php on line 77
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/j4an6exr/public_html/install/upgrade-14x-to-15x.no-opt.php on line 74
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/j4an6exr/public_html/install/upgrade-14x-to-15x.no-opt.php on line 77
The following errors occured:
Could not execute this query: DELETE FROM extension WHERE `type` = 'module' AND `key` = 'currency'; Unknown column 'key' in 'where clause'
Could not execute this query: ALTER TABLE coupon_description DEFAULT CHARSET=utf8 COLLATE=utf8_bin; Table 'j4an6exr_opct1.coupon_description' doesn't exist
Could not execute this query: ALTER TABLE product_option_description DEFAULT CHARSET=utf8 COLLATE=utf8_bin; Table 'j4an6exr_opct1.product_option_description' doesn't exist
Could not execute this query: ALTER TABLE product_option_value_description DEFAULT CHARSET=utf8 COLLATE=utf8_bin; Table 'j4an6exr_opct1.product_option_value_description' doesn't exist
Could not execute this query: DELETE FROM `extension` WHERE `type` = 'module' AND `key` = 'latest'; Unknown column 'key' in 'where clause'
Could not execute this query: INSERT INTO `extension` (`extension_id`, `type`, `key`) VALUES (NULL, 'module', 'latest') ON DUPLICATE KEY UPDATE extension_id=extension_id; Unknown column 'key' in 'field list'
Could not execute this query: ALTER TABLE `category_description` CHANGE `meta_keywords` `meta_keyword` varchar(255) NOT NULL COLLATE utf8_bin; Duplicate column name 'meta_keyword'
Could not execute this query: ALTER TABLE `extension` CHANGE `key` `code` varchar(32) NOT NULL COLLATE utf8_bin; Unknown column 'key' in 'extension'
Could not execute this query: ALTER TABLE `order` CHANGE `invoice_id` `invoice_no` int(11) NOT NULL DEFAULT '0'; Duplicate column name 'invoice_no'
Could not execute this query: ALTER TABLE `order` CHANGE `currency` `currency_code` varchar(3) NOT NULL; Unknown column 'currency' in 'order'
Could not execute this query: ALTER TABLE `order` CHANGE `value` `currency_value` decimal(15,8) NOT NULL; Unknown column 'value' in 'order'
Could not execute this query: INSERT INTO `coupon_history` (coupon_id, order_id, customer_id, date_added) SELECT coupon_id, order_id, customer_id, date_added FROM `order`; Unknown column 'coupon_id' in 'field list'
Could not execute this query: ALTER TABLE `order` ADD `reward` int(8) NOT NULL DEFAULT 0 COMMENT '' AFTER total, ADD `affiliate_id` int(11) NOT NULL DEFAULT 0 COMMENT '' AFTER order_status_id, ADD `commission` decimal(15,4) NOT NULL COMMENT '' AFTER affiliate_id, MODIFY `invoice_prefix` varchar(10) NOT NULL COMMENT '' COLLATE utf8_bin, DROP `invoice_date`, DROP `coupon_id`, ALTER `date_modified` DROP DEFAULT, ALTER `date_added` DROP DEFAULT; Can't DROP 'coupon_id'; check that column/key exists
Could not execute this query: ALTER TABLE `product` ADD `upc` varchar(12) NOT NULL COLLATE utf8_bin AFTER sku, ADD `points` int(8) NOT NULL DEFAULT '0' AFTER price, DROP `maximum`, DROP `cost`; Duplicate column name 'upc'
Could not execute this query: ALTER TABLE `product_description` CHANGE `meta_keywords` `meta_keyword` varchar(255) NOT NULL COLLATE utf8_bin; Duplicate column name 'meta_keyword'
how can ifix it
Re: [BETA] Upgrade Script for 1.4.x to 1.5.x (NO OPTIONS)
Posted: Sun Jul 17, 2011 10:36 pm
by asif
will this update script work for 1.5.1, the latest update by Daniel. As the Danial has updated few data types in the database which were not efficient earlier. Please reply soon as i need to update my store to 1.5.1 which is the latest version.
thanks
Re: [BETA] Upgrade Script for 1.4.x to 1.5.x (NO OPTIONS)
Posted: Sun Jul 17, 2011 11:56 pm
by Xsecrets
asif wrote:will this update script work for 1.5.1, the latest update by Daniel. As the Danial has updated few data types in the database which were not efficient earlier. Please reply soon as i need to update my store to 1.5.1 which is the latest version.
thanks
no it won't is that reply soon enough for you?
Re: [BETA] Upgrade Script for 1.4.x to 1.5.x (NO OPTIONS)
Posted: Mon Jul 18, 2011 2:39 am
by mongkolbest
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Notice: Undefined index: serialized in /home/j4an6exr/public_html/index.php on line 58
Warning: session_start() [function.session-start]: Cannot send session cookie - headers already sent by (output started at /home/j4an6exr/public_html/index.php:58) in /home/j4an6exr/public_html/system/library/session.php on line 11Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /home/j4an6exr/public_html/index.php:58) in /home/j4an6exr/public_html/system/library/session.php on line 11
moe-shopping
how to fix this code i got the success message
Thanks !!!
Re: [BETA] Upgrade Script for 1.4.x to 1.5.x (NO OPTIONS)
Posted: Mon Jul 18, 2011 8:09 pm
by ripper
Hi,
I'm trying to upgrade from 1.4.9.5 to 1.5.0.5. I have one error and therefore the store is completely messed up.
Code: Select all
Could not execute this query: INSERT INTO `coupon_history` (coupon_id, order_id, customer_id, date_added) SELECT coupon_id, order_id, customer_id, date_added FROM `order`; Field 'amount' doesn't have a default value
Thank you
L.
Re: [BETA] Upgrade Script for 1.4.x to 1.5.x (NO OPTIONS)
Posted: Mon Jul 18, 2011 10:06 pm
by ripper
ripper wrote:Hi,
I'm trying to upgrade from 1.4.9.5 to 1.5.0.5. I have one error and therefore the store is completely messed up.
Code: Select all
Could not execute this query: INSERT INTO `coupon_history` (coupon_id, order_id, customer_id, date_added) SELECT coupon_id, order_id, customer_id, date_added FROM `order`; Field 'amount' doesn't have a default value
Thank you
L.
somehow I make another step. Now when trying edit Modules and Saving:
Code: Select all
Error: Unknown column 'serialized' in 'field list'
Error No: 1054
INSERT INTO setting SET store_id = '0', `group` = 'bestseller', `key` = 'bestseller_module', `value` = 'a:1:{i:0;a:7:{s:5:\"limit\";s:1:\"5\";s:11:\"image_width\";s:2:\"80\";s:12:\"image_height\";s:2:\"80\";s:9:\"layout_id\";s:1:\"6\";s:8:\"position\";s:11:\"content_top\";s:6:\"status\";s:1:\"1\";s:10:\"sort_order\";s:0:\"\";}}', serialized = '1'
Re: [BETA] Upgrade Script for 1.4.x to 1.5.x (NO OPTIONS)
Posted: Mon Jul 18, 2011 10:10 pm
by Qphoria
ripper wrote:ripper wrote:Hi,
I'm trying to upgrade from 1.4.9.5 to 1.5.0.5. I have one error and therefore the store is completely messed up.
Code: Select all
Could not execute this query: INSERT INTO `coupon_history` (coupon_id, order_id, customer_id, date_added) SELECT coupon_id, order_id, customer_id, date_added FROM `order`; Field 'amount' doesn't have a default value
Thank you
L.
somehow I make another step. Now when trying edit Modules and Saving:
Code: Select all
Error: Unknown column 'serialized' in 'field list'
Error No: 1054
INSERT INTO setting SET store_id = '0', `group` = 'bestseller', `key` = 'bestseller_module', `value` = 'a:1:{i:0;a:7:{s:5:\"limit\";s:1:\"5\";s:11:\"image_width\";s:2:\"80\";s:12:\"image_height\";s:2:\"80\";s:9:\"layout_id\";s:1:\"6\";s:8:\"position\";s:11:\"content_top\";s:6:\"status\";s:1:\"1\";s:10:\"sort_order\";s:0:\"\";}}', serialized = '1'
Clearly you are using 1.5.1 not 1.5.0.5
1.5.1 added a new "serilized" field to setting that will need to be updated for.
Re: [BETA] Upgrade Script for 1.4.x to 1.5.x (NO OPTIONS)
Posted: Mon Jul 18, 2011 10:42 pm
by ripper
Qphoria wrote:ripper wrote:ripper wrote:Hi,
I'm trying to upgrade from 1.4.9.5 to 1.5.0.5. I have one error and therefore the store is completely messed up.
Code: Select all
Could not execute this query: INSERT INTO `coupon_history` (coupon_id, order_id, customer_id, date_added) SELECT coupon_id, order_id, customer_id, date_added FROM `order`; Field 'amount' doesn't have a default value
Thank you
L.
somehow I make another step. Now when trying edit Modules and Saving:
Code: Select all
Error: Unknown column 'serialized' in 'field list'
Error No: 1054
INSERT INTO setting SET store_id = '0', `group` = 'bestseller', `key` = 'bestseller_module', `value` = 'a:1:{i:0;a:7:{s:5:\"limit\";s:1:\"5\";s:11:\"image_width\";s:2:\"80\";s:12:\"image_height\";s:2:\"80\";s:9:\"layout_id\";s:1:\"6\";s:8:\"position\";s:11:\"content_top\";s:6:\"status\";s:1:\"1\";s:10:\"sort_order\";s:0:\"\";}}', serialized = '1'
Clearly you are using 1.5.1 not 1.5.0.5
1.5.1 added a new "serilized" field to setting that will need to be updated for.
Yes, this "serilized" was another try with 1.5.1, but the previous one was surely from 1.5.0.5
Code: Select all
Could not execute this query: INSERT INTO `coupon_history` (coupon_id, order_id, customer_id, date_added) SELECT coupon_id, order_id, customer_id, date_added FROM `order`; Field 'amount' doesn't have a default value
Re: [BETA] Upgrade Script for 1.4.x to 1.5.x (NO OPTIONS)
Posted: Tue Jul 19, 2011 12:51 pm
by kestas
Qphoria Can we expect new upgrade script from 1.4.x to 1.5.1 ?
Re: [BETA] Upgrade Script for 1.4.x to 1.5.x (NO OPTIONS)
Posted: Tue Jul 19, 2011 1:30 pm
by Xsecrets
kestas wrote:Qphoria Can we expect new upgrade script from 1.4.x to 1.5.1 ?
sure expect away.
Re: [BETA] Upgrade Script for 1.4.x to 1.5.x (NO OPTIONS)
Posted: Tue Jul 19, 2011 1:48 pm
by kestas
Xsecrets wrote:kestas wrote:Qphoria Can we expect new upgrade script from 1.4.x to 1.5.1 ?
sure expect away.
how far?
Re: [BETA] Upgrade Script for 1.4.x to 1.5.x (NO OPTIONS)
Posted: Tue Jul 19, 2011 7:01 pm
by Qphoria
LOL
I'll compare the new database changes and update it today
I think its only the new setting column and some small stuff
Re: [BETA] Upgrade Script for 1.4.x to 1.5.x (NO OPTIONS)
Posted: Tue Jul 19, 2011 7:06 pm
by opencartisalright
Qphoria wrote:LOL
I'll compare the new database changes and update it today
I think its only the new setting column and some small stuff
So in "today" are we talking next week?
Re: [BETA] Upgrade Script for 1.4.x to 1.5.x (NO OPTIONS)
Posted: Tue Jul 19, 2011 7:26 pm
by Qphoria
Already finished it smartass
... testing it now and looking to resolve the false errors people were seeing with the original
Re: [BETA] Upgrade Script for 1.4.x to 1.5.x (NO OPTIONS)
Posted: Tue Jul 19, 2011 7:49 pm
by opencartisalright
Qphoria wrote:Already finished it smartass
... testing it now and looking to resolve the false errors people were seeing with the original
LOL, isn't it past your bedtime, or are you pulling an all night coding session...
Re: [BETA] Upgrade Script for 1.4.x to 1.5.x (NO OPTIONS)
Posted: Tue Jul 19, 2011 9:00 pm
by Qphoria
USA.. its 8am now
Re: [BETA] Upgrade Script for 1.4.x to 1.5.x (NO OPTIONS)
Posted: Tue Jul 19, 2011 9:45 pm
by ripper
Qphoria wrote:USA.. its 8am now
So let's start working
Re: [BETA] Upgrade Script for 1.4.x to 1.5.x (NO OPTIONS)
Posted: Wed Jul 20, 2011 9:02 pm
by megahuman
When will we have a full upgrade script? That includes options? I feel very uneasy to use this current upgrade script. Also when will we be able to upgrade to the very latest versions? It feels very much like its not ready to use and potentially destroy my shop lol
Re: [BETA] Upgrade Script for 1.4.x to 1.5.x (NO OPTIONS)
Posted: Wed Jul 20, 2011 9:37 pm
by Qphoria
megahuman wrote:When will we have a full upgrade script? That includes options? I feel very uneasy to use this current upgrade script. Also when will we be able to upgrade to the very latest versions? It feels very much like its not ready to use and potentially destroy my shop lol
Don't care about your feelings.. it works fine
I am upgrading the script to clean up all the false positives now and it should look a lot cleaner anyway
It will not support product options yet, but will support 1.5.1 upgrades.