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
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'
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'
cool theme by the waydamien 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
ALL Templates :: 1.5.1+ Templates :: 50%-75% PRICE DROP ONLY at OpencartStuff.com
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.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
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!
I don't know why but I can't update my store settings :( this error appear:
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?Warning: Please check the form carefully for errors!
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)I am using default themeCode: 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 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
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...
See first postigpltd 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'
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
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
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!
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!
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?
This is a 1.5.x problem nowreynierpm wrote:Q, what about my problem? I can save any from Settings form under administration
PS: Good then your vacations all fine
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.
b2bblack wrote:
Error: Could not load model total/gift_voucher!
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?You didn't upload all the 1.5.x files
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
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.
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.
Who is online
Users browsing this forum: No registered users and 50 guests