[BETA] Upgrade Script for 1.4.x to 1.5.x (NO OPTIONS)

Locked

144 posts

Re: [BETA] Upgrade Script for 1.4.x to 1.5.x (NO OPTIONS)

allenshea

Active Member

Posts

262

Joined

Mon Dec 14, 2009 10:01 pm

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.

allenshea

Active Member

Posts

262

Joined

Mon Dec 14, 2009 10:01 pm

Re: [BETA] Upgrade Script for 1.4.x to 1.5.x (NO OPTIONS)

mongkolbest

Newbie

Posts

Joined

Tue Jul 12, 2011 8:55 am

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

mongkolbest

Newbie

Posts

Joined

Tue Jul 12, 2011 8:55 am

Re: [BETA] Upgrade Script for 1.4.x to 1.5.x (NO OPTIONS)

asif

New member

Posts

Joined

Wed Jan 16, 2008 10:35 pm

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

asif

New member

Posts

Joined

Wed Jan 16, 2008 10:35 pm

Re: [BETA] Upgrade Script for 1.4.x to 1.5.x (NO OPTIONS)

Xsecrets

Guru Member

Posts

5017

Joined

Sun Oct 25, 2009 3:51 am

Location

FL US

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

Xsecrets

Guru Member

Posts

5017

Joined

Sun Oct 25, 2009 3:51 am

Location - FL US

Re: [BETA] Upgrade Script for 1.4.x to 1.5.x (NO OPTIONS)

mongkolbest

Newbie

Posts

Joined

Tue Jul 12, 2011 8:55 am

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

mongkolbest

Newbie

Posts

Joined

Tue Jul 12, 2011 8:55 am

Re: [BETA] Upgrade Script for 1.4.x to 1.5.x (NO OPTIONS)

ripper

New member

Posts

Joined

Wed Jul 06, 2011 4:37 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.

ripper

New member

Posts

Joined

Wed Jul 06, 2011 4:37 am

Re: [BETA] Upgrade Script for 1.4.x to 1.5.x (NO OPTIONS)

ripper

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'

ripper

New member

Posts

Joined

Wed Jul 06, 2011 4:37 am

Re: [BETA] Upgrade Script for 1.4.x to 1.5.x (NO OPTIONS)

Qphoria

Administrator

Posts

20056

Joined

Tue Jul 22, 2008 3:02 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.

Qphoria

Administrator

Posts

20056

Joined

Tue Jul 22, 2008 3:02 am

Re: [BETA] Upgrade Script for 1.4.x to 1.5.x (NO OPTIONS)

ripper

New member

Posts

Joined

Wed Jul 06, 2011 4:37 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

ripper

New member

Posts

Joined

Wed Jul 06, 2011 4:37 am

Re: [BETA] Upgrade Script for 1.4.x to 1.5.x (NO OPTIONS)

kestas

Active Member

Posts

1021

Joined

Tue Oct 12, 2010 2:23 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

kestas

Active Member

Posts

1021

Joined

Tue Oct 12, 2010 2:23 am

Re: [BETA] Upgrade Script for 1.4.x to 1.5.x (NO OPTIONS)

Xsecrets

Guru Member

Posts

5017

Joined

Sun Oct 25, 2009 3:51 am

Location

FL US

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.

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

Xsecrets

Guru Member

Posts

5017

Joined

Sun Oct 25, 2009 3:51 am

Location - FL US

Re: [BETA] Upgrade Script for 1.4.x to 1.5.x (NO OPTIONS)

kestas

Active Member

Posts

1021

Joined

Tue Oct 12, 2010 2:23 am

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.

how far?

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

kestas

Active Member

Posts

1021

Joined

Tue Oct 12, 2010 2:23 am

Re: [BETA] Upgrade Script for 1.4.x to 1.5.x (NO OPTIONS)

Qphoria

Administrator

Posts

20056

Joined

Tue Jul 22, 2008 3:02 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

Qphoria

Administrator

Posts

20056

Joined

Tue Jul 22, 2008 3:02 am

Re: [BETA] Upgrade Script for 1.4.x to 1.5.x (NO OPTIONS)

opencartisalright

Active Member

Posts

371

Joined

Mon Feb 21, 2011 4:09 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?

opencartisalright

Active Member

Posts

371

Joined

Mon Feb 21, 2011 4:09 am

Re: [BETA] Upgrade Script for 1.4.x to 1.5.x (NO OPTIONS)

Qphoria

Administrator

Posts

20056

Joined

Tue Jul 22, 2008 3:02 am

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

Already finished it smartass

... testing it now and looking to resolve the false errors people were seeing with the original

Qphoria

Administrator

Posts

20056

Joined

Tue Jul 22, 2008 3:02 am

Re: [BETA] Upgrade Script for 1.4.x to 1.5.x (NO OPTIONS)

opencartisalright

Active Member

Posts

371

Joined

Mon Feb 21, 2011 4:09 am

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

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

opencartisalright

Active Member

Posts

371

Joined

Mon Feb 21, 2011 4:09 am

Re: [BETA] Upgrade Script for 1.4.x to 1.5.x (NO OPTIONS)

Qphoria

Administrator

Posts

20056

Joined

Tue Jul 22, 2008 3:02 am

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

USA.. its 8am now

Qphoria

Administrator

Posts

20056

Joined

Tue Jul 22, 2008 3:02 am

Re: [BETA] Upgrade Script for 1.4.x to 1.5.x (NO OPTIONS)

ripper

New member

Posts

Joined

Wed Jul 06, 2011 4:37 am

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

Qphoria wrote:USA.. its 8am now

So let's start working

ripper

New member

Posts

Joined

Wed Jul 06, 2011 4:37 am

Re: [BETA] Upgrade Script for 1.4.x to 1.5.x (NO OPTIONS)

megahuman

Active Member

Posts

241

Joined

Tue Dec 14, 2010 4:57 pm

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

megahuman

Active Member

Posts

241

Joined

Tue Dec 14, 2010 4:57 pm

Re: [BETA] Upgrade Script for 1.4.x to 1.5.x (NO OPTIONS)

Qphoria

Administrator

Posts

20056

Joined

Tue Jul 22, 2008 3:02 am

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.

Qphoria

Administrator

Posts

20056

Joined

Tue Jul 22, 2008 3:02 am

Locked

Jump to

Return to “News & Announcements” Return to “News & Announcements”

Who is online

Users browsing this forum: No registered users and 13 guests

Sign up to our newsletter