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

Hi,

I have just used the upgrade script and all went well, great job thank you. Am I being thick ? on the demo site there is a global nav menu that looks like it is formed from category's that stays constant throughout the site. However, it doesn't appear on my site http://www.onlybuttons.com Is this a seperate mod or am I missing something?

Any help appreciated

Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in /home/udimore/public_html/install/upgrade-14x-to-15x.no-opt.php on line 77

Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in /home/udimore/public_html/install/upgrade-14x-to-15x.no-opt.php on line 77

Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in /home/udimore/public_html/install/upgrade-14x-to-15x.no-opt.php on line 77

Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in /home/udimore/public_html/install/upgrade-14x-to-15x.no-opt.php on line 77

Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in /home/udimore/public_html/install/upgrade-14x-to-15x.no-opt.php on line 74

Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in /home/udimore/public_html/install/upgrade-14x-to-15x.no-opt.php on line 77

The following errors occured:

Could not execute this query: DELETE FROM ocextension WHERE `type` = 'module' AND `key` = 'currency'; Unknown column 'key' in 'where clause'


Could not execute this query: ALTER TABLE occoupon_description DEFAULT CHARSET=utf8 COLLATE=utf8_bin; Table 'udimore_uts.occoupon_description' doesn't exist


Could not execute this query: ALTER TABLE ocproduct_option_description DEFAULT CHARSET=utf8 COLLATE=utf8_bin; Table 'udimore_uts.ocproduct_option_description' doesn't exist


Could not execute this query: ALTER TABLE ocproduct_option_value_description DEFAULT CHARSET=utf8 COLLATE=utf8_bin; Table 'udimore_uts.ocproduct_option_value_description' doesn't exist


Could not execute this query: DELETE FROM `ocextension` WHERE `type` = 'module' AND `key` = 'latest'; Unknown column 'key' in 'where clause'


Could not execute this query: INSERT INTO `ocextension` (`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 `occategory_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 `ocextension` CHANGE `key` `code` varchar(32) NOT NULL COLLATE utf8_bin; Unknown column 'key' in 'ocextension'


Could not execute this query: ALTER TABLE `ocorder` CHANGE `invoice_id` `invoice_no` int(11) NOT NULL DEFAULT '0'; Duplicate column name 'invoice_no'


Could not execute this query: ALTER TABLE `ocorder` CHANGE `currency` `currency_code` varchar(3) NOT NULL; Unknown column 'currency' in 'ocorder'


Could not execute this query: ALTER TABLE `ocorder` CHANGE `value` `currency_value` decimal(15,8) NOT NULL; Unknown column 'value' in 'ocorder'


Could not execute this query: INSERT INTO `occoupon_history` (coupon_id, order_id, customer_id, date_added) SELECT coupon_id, order_id, customer_id, date_added FROM `ocorder`; Unknown column 'coupon_id' in 'field list'


Could not execute this query: ALTER TABLE `ocorder` 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 `ocproduct` 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 `ocproduct_description` CHANGE `meta_keywords` `meta_keyword` varchar(255) NOT NULL COLLATE utf8_bin; Duplicate column name 'meta_keyword'

damien wrote:Hi,

I have just used the upgrade script and all went well, great job thank you. Am I being thick ? on the demo site there is a global nav menu that looks like it is formed from category's that stays constant throughout the site. However, it doesn't appear on my site http://www.onlybuttons.com Is this a seperate mod or am I missing something?

Any help appreciated

cool theme by the way

damien wrote:Hi,

I have just used the upgrade script and all went well, great job thank you. Am I being thick ? on the demo site there is a global nav menu that looks like it is formed from category's that stays constant throughout the site. However, it doesn't appear on my site http://www.onlybuttons.com Is this a seperate mod or am I missing something?

Any help appreciated

This is related to the new design. Log in to your admin, then select "Catalog->Category" from the menu. Edit your top-level categories. Under the "Data" tab in each of these, click the checkbox labelled "Top", specify a number of columns and save.

I don't know why but I can't update my store settings :( this error appear:

Warning: Please check the form carefully for errors!

And I check every field. Because of this I can't change the default theme and layout and then see the Frontend. I upgrade from 1.4.9.5 to 1.5.0.5. Any help or tip?

palmud wrote:my cart is now not working

I read this thread
viewtopic.php?f=2&t=33797

and downloaded upgrade file.

edited my config.php (not admin)

Code: Select all

<?php
// HTTP
define('HTTP_SERVER', 'http://store.mysite.com/');
define('HTTP_IMAGE', 'http://store.mysite.com/image/');
define('HTTP_ADMIN', 'http://store.mysite.com/dirtyadmin/');

// HTTPS
define('HTTPS_SERVER', 'http://store.mysite.com/');
define('HTTPS_IMAGE', 'http://store.mysite.com/image/'');


// DIR
define('DIR_APPLICATION', '/home/mysite/public_html/store/catalog/');

I am using default theme
i was upgrading from version 1.4.9.3
I downloaded 1.505 package and copied it to the server
I downloaded upgrade package and upgraded

it shows blank page....

upgrade was successful .

do i remove old files and upload? new files?

Okay my config.php was a problem now my site is working

1) i am getting following error when I login to admin area...
2 )I can't add images to the product description and manufacturer
images do not get displayed. Wen I upload images they do get upload but images are not displayed for selection

3) some time while editing admin setting I need to reenter my admin password...


4) some modules
Like visitor counter
customer testimonials

can we edit them for new version?

thanks a lot in advance...

igpltd wrote:Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in /home/udimore/public_html/install/upgrade-14x-to-15x.no-opt.php on line 77

Could not execute this query: DELETE FROM ocextension WHERE `type` = 'module' AND `key` = 'currency'; Unknown column 'key' in 'where clause'

See first post

This is not how you're supposed to be spending your vacation, Q.

Well i'm back now...


Also to others, remember, once you've upgraded, any issues you are having with modules or functionality are 1.5.x issues now, not upgrade issues. Only if you see php errors or sql errors are they potentially related to the upgrade process.. but now that the process has been run about 20-30 times, it can be said with 99% certainty that there are no residual errors from the upgrade process so you should not have any errors to post in here after following all the steps, regardless of the messy errors shown during the upgrade script part that all seem to be just false positives

So if I'm having problems while trying to setup stores or other functionallities are 1.5.x issues and not migration problems? Any update on options migration? ???

PS: How goes your vacations? Did you enjoy or rest at least? ;)

Hi Q,

Welcome back! I hope you had a good time...

I upgraded from 1.4.9.1 to 1.5.0.5 and all went just as you described. When I go in to my admin area, everything looks just as I would expect - products, orders, customers, etc. all there. But when I try to go to my storefront I get:

Error: Could not load model total/gift_voucher!

Any ideas?

Thanks!

reynierpm wrote:Any update on options migration?

PS: How goes your vacations? Did you enjoy or rest at least?

Seems you answered your own question. Vacation was excellent

b2bblack wrote: Error: Could not load model total/gift_voucher!

You didn't upload all the 1.5.x files

Well, I uploaded the entire upload folder from 1.5.0.5. Then I just followed your instructions... Seemed to work okay. Would it have caused a conflict if I had Gift Vouchers 1.0.1 installed on my 1.4.9.1 site? Where would I need to look for it on the new site?

Q, what about my problem? I can save any from Settings form under administration :(

PS: Good then your vacations all fine :laugh:

reynierpm wrote:Q, what about my problem? I can save any from Settings form under administration

PS: Good then your vacations all fine

This is a 1.5.x problem now
as you said the error shows "Warning: Please check the form carefully for errors!"
which tells me that there is a field on one of the tabs that you didn't fill in.

Well I check all of them and as far as I can see all are filled, anyway Q or D, any way to check by me where it fails just help yours and help me?

b2bblack wrote:
Error: Could not load model total/gift_voucher!

You didn't upload all the 1.5.x files

I replaced everything on my test site with the contents from the 1.5.0.5 upload folder except for the config.php and admin/config.php files. I still get the same error. Could it have to do with the fact that I had a Gift Vouchers module installed on my old 1.4.9.1 site?

Thanks!

Hi,

Any word on when a version of this with options will be available? We have a couple of sites with lots of options that need to be updated.

Apologies if that has already been answered, just trying to get an idea of timeline (if there is one).

Cheers and thanks!

Matt

Honestly I've been working solely on porting my existing mods to be 1.5.x compatible as that affects business. So I haven't looked at it since I released the first version of this.

The fact is, I've been trying to use almost sql to handle upgrades up to this point, but now the changes are so drastic that I need to actually use php code to handle them, so the script needs an overhaul to do that. A rather large job that will have to wait until after I finish porting my mods, which is going slower than planned. I hoped to be done at the end of this week with them all, but now it looks like I'll need another week.