Post by allenshea » Sun Jul 17, 2011 11:06 am

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!

I know nothing about PHP and SQL, but I still try my best to understand it.


Active Member

Posts

Joined
Mon Dec 14, 2009 10:01 pm

Post by mongkolbest » Sun Jul 17, 2011 11:27 am

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

Newbie

Posts

Joined
Tue Jul 12, 2011 8:55 am

Post by asif » Sun Jul 17, 2011 10:36 pm

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

New member

Posts

Joined
Wed Jan 16, 2008 10:35 pm

Post by Xsecrets » Sun Jul 17, 2011 11:56 pm

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?

OpenCart commercial mods and development http://spotonsolutions.net
Layered Navigation
Shipment Tracking
Vehicle Year/Make/Model Filter


Guru Member

Posts

Joined
Sun Oct 25, 2009 3:51 am
Location - FL US

Post by mongkolbest » Mon Jul 18, 2011 2:39 am

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

Newbie

Posts

Joined
Tue Jul 12, 2011 8:55 am

Post by ripper » Mon Jul 18, 2011 8:09 pm

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.

New member

Posts

Joined
Wed Jul 06, 2011 4:37 am

Post by ripper » Mon Jul 18, 2011 10:06 pm

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'

New member

Posts

Joined
Wed Jul 06, 2011 4:37 am

Post by Qphoria » Mon Jul 18, 2011 10:10 pm

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.

Image
Donate!|OpenCart Basics|GeoZones
Image


User avatar
Administrator

Posts

Joined
Tue Jul 22, 2008 3:02 am

Post by ripper » Mon Jul 18, 2011 10:42 pm

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

New member

Posts

Joined
Wed Jul 06, 2011 4:37 am

Post by kestas » Tue Jul 19, 2011 12:51 pm

Qphoria Can we expect new upgrade script from 1.4.x to 1.5.1 ? ???

Custom OpenCart modules and solutions. You can write PM with additional questions... Extensions you can find here


Active Member

Posts

Joined
Tue Oct 12, 2010 2:23 am

Post by Xsecrets » Tue Jul 19, 2011 1:30 pm

kestas wrote:Qphoria Can we expect new upgrade script from 1.4.x to 1.5.1 ? ???
sure expect away. :crazy:

OpenCart commercial mods and development http://spotonsolutions.net
Layered Navigation
Shipment Tracking
Vehicle Year/Make/Model Filter


Guru Member

Posts

Joined
Sun Oct 25, 2009 3:51 am
Location - FL US

Post by kestas » Tue Jul 19, 2011 1:48 pm

Xsecrets wrote:
kestas wrote:Qphoria Can we expect new upgrade script from 1.4.x to 1.5.1 ? ???
sure expect away. :crazy:
how far? ::)

Custom OpenCart modules and solutions. You can write PM with additional questions... Extensions you can find here


Active Member

Posts

Joined
Tue Oct 12, 2010 2:23 am

Post by Qphoria » Tue Jul 19, 2011 7:01 pm

LOL

I'll compare the new database changes and update it today
I think its only the new setting column and some small stuff

Image
Donate!|OpenCart Basics|GeoZones
Image


User avatar
Administrator

Posts

Joined
Tue Jul 22, 2008 3:02 am

Post by opencartisalright » Tue Jul 19, 2011 7:06 pm

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

Active Member

Posts

Joined
Mon Feb 21, 2011 4:09 am

Post by Qphoria » Tue Jul 19, 2011 7:26 pm

Already finished it smartass :P ... testing it now and looking to resolve the false errors people were seeing with the original

Image
Donate!|OpenCart Basics|GeoZones
Image


User avatar
Administrator

Posts

Joined
Tue Jul 22, 2008 3:02 am

Post by opencartisalright » Tue Jul 19, 2011 7:49 pm

Qphoria wrote:Already finished it smartass :P ... 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... :D

Active Member

Posts

Joined
Mon Feb 21, 2011 4:09 am

Post by Qphoria » Tue Jul 19, 2011 9:00 pm

USA.. its 8am now

Image
Donate!|OpenCart Basics|GeoZones
Image


User avatar
Administrator

Posts

Joined
Tue Jul 22, 2008 3:02 am

Post by ripper » Tue Jul 19, 2011 9:45 pm

Qphoria wrote:USA.. its 8am now
So let's start working :D

New member

Posts

Joined
Wed Jul 06, 2011 4:37 am

Post by megahuman » Wed Jul 20, 2011 9:02 pm

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

Web Design and Development at 7 Design


Active Member

Posts

Joined
Tue Dec 14, 2010 4:57 pm

Post by Qphoria » Wed Jul 20, 2011 9:37 pm

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.

Image
Donate!|OpenCart Basics|GeoZones
Image


User avatar
Administrator

Posts

Joined
Tue Jul 22, 2008 3:02 am
Who is online

Users browsing this forum: No registered users and 9 guests