Page 1 of 1
1.5.0.5 Upgrade
Posted: Tue Jun 28, 2011 10:48 pm
by mmmsabeel
Hello Opencart team.
my site url is :
http://www.abayashopping.com
i have just upgraded to 1.5.0.5 from 1.4.9.3.. upgrade was success !! with no errors.
but when i go to the store front or store admin i get error.
Error: Unknown column 'store_id' in 'where clause'
Error No: 1054
SELECT * FROM setting WHERE store_id = '0' OR store_id = '0' ORDER BY store_id ASC
and when i go to admin,
Error: Unknown column 'store_id' in 'where clause'
Error No: 1054
SELECT * FROM setting WHERE store_id = '0'
Please help me out as soon as possible.
best regards
sabeel
Re: 1.5.0.5 Upgrade
Posted: Tue Jun 28, 2011 11:07 pm
by Xsecrets
did you run the upgrade script? sounds like you didn't, because it should have done those database changes. Also note that the script does not support options,so if you have options on your products you will lose all the options.
Re: 1.5.0.5 Upgrade
Posted: Tue Jun 28, 2011 11:11 pm
by mmmsabeel
thank you for your reply..
yes i had run the upgrade script and it said success.
and as you say yes i had options on my products
im ready to redo all the option. but now i need my site back running as before.
Re: 1.5.0.5 Upgrade
Posted: Sat Jul 02, 2011 2:59 pm
by scsunboy
go to mysql admin
run sql:
ALTER TABLE oc_setting DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
DELETE FROM oc_setting WHERE `group` = 'latest';
INSERT INTO `oc_setting` (`setting_id` ,`group` ,`key` ,`value`) VALUES (NULL, 'latest', 'latest_limit', '8') ON DUPLICATE KEY UPDATE setting_id=setting_id;
INSERT INTO `oc_setting` (`setting_id` ,`group` ,`key` ,`value`) VALUES (NULL, 'latest', 'latest_position', 'home') ON DUPLICATE KEY UPDATE setting_id=setting_id;
INSERT INTO `oc_setting` (`setting_id` ,`group` ,`key` ,`value`) VALUES (NULL, 'latest', 'latest_status', '1') ON DUPLICATE KEY UPDATE setting_id=setting_id;
INSERT INTO `oc_setting` (`setting_id` ,`group` ,`key` ,`value`) VALUES (NULL, 'latest', 'latest_sort_order', '0') ON DUPLICATE KEY UPDATE setting_id=setting_id;
Re: 1.5.0.5 Upgrade
Posted: Tue Jul 05, 2011 9:19 am
by pthurmond
And where did you find the upgrade script? I don't see it anywhere.
Thanks,
Patrick
Re: 1.5.0.5 Upgrade
Posted: Tue Jul 05, 2011 12:30 pm
by mmmsabeel
hello there,
after copying all files
domain.com/upload/install/upgrade.php
best regards
sabeel
Re: 1.5.0.5 Upgrade
Posted: Wed Jul 06, 2011 11:12 am
by magicsavings
Can you please tell me how to upgrade a version 1.4.9.2 to the newest
Re: 1.5.0.5 Upgrade
Posted: Thu Jul 07, 2011 7:05 am
by wishfulthinking
sweet, just lost my store
upgraded from 1.4.9.4 to the latest 1.5.0.5
Like the above guys posting, after running the upgrade script it says:
"OpenCart 1.x Upgrade Script (BETA) SUCCESS!!! Click here to goto your store OpenCart.com"
but when i goto my store it gives:
"Error: Unknown column 'store_id' in 'where clause'
Error No: 1054
SELECT * FROM TTR_setting WHERE store_id = '0' OR store_id = '0' ORDER BY store_id ASC"
Any clue how to solve this?
Re: 1.5.0.5 Upgrade
Posted: Thu Jul 07, 2011 1:51 pm
by i2Paq
wishfulthinking wrote:sweet, just lost my store
upgraded from 1.4.9.4 to the latest 1.5.0.5
Like the above guys posting, after running the upgrade script it says:
"OpenCart 1.x Upgrade Script (BETA) SUCCESS!!! Click here to goto your store OpenCart.com"
but when i goto my store it gives:
"Error: Unknown column 'store_id' in 'where clause'
Error No: 1054
SELECT * FROM TTR_setting WHERE store_id = '0' OR store_id = '0' ORDER BY store_id ASC"
Any clue how to solve this?
Lets keep all the issues related to the BETA upgrade script in one place:
[BETA] Upgrade Script for 1.4.x to 1.5.x (NO OPTIONS)
Please read that topic FIRST before posting your question.