Post by damien » Fri Jul 01, 2011 4:21 am

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

Newbie

Posts

Joined
Fri Jul 01, 2011 4:12 am

Post by igpltd » Fri Jul 01, 2011 6:25 pm

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'

Newbie

Posts

Joined
Thu Jun 10, 2010 2:31 am

Post by Maansy » Fri Jul 01, 2011 8:20 pm

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 ;)

ALL Templates :: 1.5.1+ Templates :: 50%-75% PRICE DROP ONLY at OpencartStuff.com


User avatar
Active Member

Posts

Joined
Thu Jun 24, 2010 6:04 am


Post by fido-x » Fri Jul 01, 2011 10:35 pm

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.

Image
Modules for OpenCart 2.3.0.2
Homepage Module [Free - since OpenCart 0.7.7]
Multistore Extensions
Store Manager Multi-Vendor/Multi-Store management tool

If you're not living on the edge ... you're taking up too much space!


User avatar
Expert Member

Posts

Joined
Sat Jun 28, 2008 1:09 am
Location - Tasmania, Australia

Post by reynierpm » Sat Jul 02, 2011 10:21 am

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?

User avatar
Active Member

Posts

Joined
Tue Jan 12, 2010 9:51 pm

Post by palmud » Sat Jul 02, 2011 11:45 am

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

Code: Select all

Warning: fopen(/home/XXXXXXX/public_html/mystore/download/test) [function.fopen]: failed to open stream: Permission denied in /home/XXXXXXX/public_html/mystore/dirtyadmin/controller/common/home.php on line 99Warning: fclose(): supplied argument is not a valid stream resource in /home/XXXXXXX/public_html/mystore/dirtyadmin/controller/common/home.php on line 103Warning: sprintf() [function.sprintf]: Too few arguments in /home/XXXXXXX/public_html/mystore/dirtyadmin/controller/common/home.php on line 106Warning: fopen(/home/XXXXXXX/public_html/mystore/system/logs/test) [function.fopen]: failed to open stream: Permission denied in /home/XXXXXXX/public_html/mystore/dirtyadmin/controller/common/home.php on line 116Warning: fclose(): supplied argument is not a valid stream resource in /home/XXXXXXX/public_html/mystore/dirtyadmin/controller/common/home.php on line 120Warning: sprintf() [function.sprintf]: Too few arguments in /home/XXXXXXX/public_html/mystore/dirtyadmin/controller/common/home.php on line 123
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...

New member

Posts

Joined
Mon Dec 27, 2010 8:38 pm

Post by Qphoria » Sun Jul 03, 2011 3:00 am

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

Image
Donate!|OpenCart Basics|GeoZones
Image


User avatar
Administrator

Posts

Joined
Tue Jul 22, 2008 3:02 am

Post by rph » Sun Jul 03, 2011 6:56 am

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

-Ryan


rph
Expert Member

Posts

Joined
Fri Jan 08, 2010 5:05 am
Location - Lincoln, Nebraska

Post by Qphoria » Tue Jul 05, 2011 8:32 am

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

Image
Donate!|OpenCart Basics|GeoZones
Image


User avatar
Administrator

Posts

Joined
Tue Jul 22, 2008 3:02 am

Post by reynierpm » Tue Jul 05, 2011 10:12 am

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? ;)

User avatar
Active Member

Posts

Joined
Tue Jan 12, 2010 9:51 pm

Post by b2bblack » Tue Jul 05, 2011 7:52 pm

Hi Q,

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

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!

Newbie

Posts

Joined
Thu Jan 20, 2011 10:07 am

Post by Qphoria » Tue Jul 05, 2011 8:31 pm

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

Image
Donate!|OpenCart Basics|GeoZones
Image


User avatar
Administrator

Posts

Joined
Tue Jul 22, 2008 3:02 am

Post by Qphoria » Tue Jul 05, 2011 8:32 pm

b2bblack wrote: Error: Could not load model total/gift_voucher!
You didn't upload all the 1.5.x files

Image
Donate!|OpenCart Basics|GeoZones
Image


User avatar
Administrator

Posts

Joined
Tue Jul 22, 2008 3:02 am

Post by b2bblack » Tue Jul 05, 2011 8:44 pm

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?

Newbie

Posts

Joined
Thu Jan 20, 2011 10:07 am

Post by reynierpm » Tue Jul 05, 2011 8:48 pm

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

PS: Good then your vacations all fine :laugh:

User avatar
Active Member

Posts

Joined
Tue Jan 12, 2010 9:51 pm

Post by Qphoria » Tue Jul 05, 2011 9:37 pm

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

PS: Good then your vacations all fine :laugh:
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.

Image
Donate!|OpenCart Basics|GeoZones
Image


User avatar
Administrator

Posts

Joined
Tue Jul 22, 2008 3:02 am

Post by reynierpm » Tue Jul 05, 2011 9:41 pm

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?

User avatar
Active Member

Posts

Joined
Tue Jan 12, 2010 9:51 pm

Post by b2bblack » Wed Jul 06, 2011 3:48 am

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!

Newbie

Posts

Joined
Thu Jan 20, 2011 10:07 am

Post by mattbeck » Fri Jul 15, 2011 10:13 am

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

Newbie

Posts

Joined
Sun Jun 19, 2011 3:09 am

Post by Qphoria » Sat Jul 16, 2011 3:26 am

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.

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 5 guests