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
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.
OpenCart commercial mods and development http://spotonsolutions.net
Layered Navigation
Shipment Tracking
Vehicle Year/Make/Model Filter
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;
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;
如果您想要做跨境电商独立站，需要建站系统，欢迎来咨询我们哦！
OpenCart中文官网|OpenCart独立站－免费开源建站系统电商系统
www.opencart.cn
售前咨询：199 5031 8817（同微信）
QQ：1345048761
OpenCart技术交流QQ群：12111041
OpenCart开发QQ群：206915581
最后的最后，觉得内容不错的话欢迎点赞、评论、转发哦！^_^
“Ctrl + D” 收藏，定期分享干货！
Can you please tell me how to upgrade a version 1.4.9.2 to the newest
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?
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)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?
Please read that topic FIRST before posting your question.
Norman in 't Veldt
Moderator OpenCart Forums
_________________ READ and Search BEFORE POSTING _________________
Our FREE search: Find your answer FAST!.
[How to] BTW + Verzend + betaal setup.
Who is online
Users browsing this forum: No registered users and 21 guests
