moy2010 Posted November 22, 2013 Share Posted November 22, 2013 (edited) I've recently moved my store to a new hosting, but after uploading all the files to the server, imported the database etc., I'm getting the following error: Fatal error: Uncaught Unknown column 'c.id_shop_group' in 'field list'<br /><br /><pre>SELECT c.`name`, cl.`id_lang`, IF(cl.`id_lang` IS NULL, c.`value`, cl.`value`) AS value, c.id_shop_group, c.id_shop FROM `hw_configuration` c LEFT JOIN `hw_configuration_lang` cl ON (c.id_configuration = cl.id_configuration)</pre> thrown in /home/xxx/public_html/classes/db/Db.php on line 613 For me, it looks like a problem with the dabase missing a column or something :S. Any ideas about how to solve this? Thanks in advance. Edited November 25, 2013 by moy2010 (see edit history) Link to comment Share on other sites More sharing options...
NemoPS Posted November 22, 2013 Share Posted November 22, 2013 Yes, the configuration tab is missing the id_shop_group column. I think it's okay to add it manually as a 12 INT Link to comment Share on other sites More sharing options...
moy2010 Posted November 22, 2013 Author Share Posted November 22, 2013 Hi, Nemo1. Thanks for your help . I went to PHPMyAdmin, clicked on hw_configuration and then in structure. After that I created a column named id_shop_group with the 12 (INT) type and saved it. I can see it now listed in the structure but the error persists :S. Link to comment Share on other sites More sharing options...
NemoPS Posted November 22, 2013 Share Posted November 22, 2013 really weird, are you sure it's referring to the correct database? Link to comment Share on other sites More sharing options...
moy2010 Posted November 22, 2013 Author Share Posted November 22, 2013 Hum, I think so . In the settings.inc file it's configured properly. Link to comment Share on other sites More sharing options...
moy2010 Posted November 24, 2013 Author Share Posted November 24, 2013 Hum, is anyone available to check this problem? We need to get this fixed in order to get the shop working. We are willing to pay for this. Thanks in advance. Link to comment Share on other sites More sharing options...
moy2010 Posted November 25, 2013 Author Share Posted November 25, 2013 A brief update. The previous error has been fixed, but now I'm getting this: Column 'id_shop_group' cannot be null INSERT INTO `hw_configuration` (`name`, `id_shop_group`, `id_shop`, `value`, `date_add`, `date_upd`) VALUES ('update_dboptimization', NULL, NULL, '1385373785', '2013-11-25 04:03:05', '2013-11-25 04:03:05') Does this mean that I have to give it a value manually? If this, then which value? Link to comment Share on other sites More sharing options...
NemoPS Posted November 25, 2013 Share Posted November 25, 2013 Try seting the value to 0 instead of null Link to comment Share on other sites More sharing options...
moy2010 Posted November 25, 2013 Author Share Posted November 25, 2013 Hi, Nemo1. This error was caused by a module named dboptimization, and I've deleted it. Now I'm getting the following error: No access reference in table module_access for id_module 296.at line 1814 in file classes/module/Module.php Even if I delete the module with that ID, the same error appears but only changes the id_module :S. Link to comment Share on other sites More sharing options...
NemoPS Posted November 25, 2013 Share Posted November 25, 2013 look for that id_module in all module_ related tabled, and erase every reference to it Link to comment Share on other sites More sharing options...
moy2010 Posted November 25, 2013 Author Share Posted November 25, 2013 Hi, Nemo. It's done now. I've finally been able to see the login screen for the B.O., but once I login I get this error: Warning: array_key_exists() [function.array-key-exists]: The first argument should be either a string or an integer in /home/pcxcommx/public_html/classes/shop/Shop.php on line 768 [PrestaShopDatabaseException]Unknown column 'id_shop' in 'where clause' SELECT IFNULL(SUM(`total_paid_real` / conversion_rate), "0") as total_sales, COUNT(*) as total_orders FROM `hw_orders` WHERE valid = 1 AND `invoice_date` BETWEEN '2013-11-01 00:00:00' AND '2013-11-31 23:59:59' AND id_shop IN (0) LIMIT 1 Link to comment Share on other sites More sharing options...
NemoPS Posted November 25, 2013 Share Posted November 25, 2013 Try adding that column in the database (INT (12)) Link to comment Share on other sites More sharing options...
moy2010 Posted November 25, 2013 Author Share Posted November 25, 2013 Done. After adding some other columns to different tabs, I'm now at the backoffice. I had to go to the SEO & URL menu to change some few things, but I'm getting this error again: Column 'id_shop_group' cannot be nullINSERT INTO `hw_configuration` (`name`, `id_shop_group`, `id_shop`, `value`, `date_add`, `date_upd`) VALUES ('PS_ALLOW_ACCENTED_CHARS_URL', NULL, NULL, '0', '2013-11-25 04:57:26', '2013-11-25 04:57:26') Seems that this will take longer than what I expected >.< Link to comment Share on other sites More sharing options...
moy2010 Posted November 25, 2013 Author Share Posted November 25, 2013 Well, I had to check the "null" field in the database structure options. Now I've been able to access the back office. Link to comment Share on other sites More sharing options...
NemoPS Posted July 26, 2014 Share Posted July 26, 2014 Login to phpmyadmin and add a table with that name and the following columns id_webservice_account INT 11 id_shop INT 11 Link to comment Share on other sites More sharing options...
NemoPS Posted July 28, 2014 Share Posted July 28, 2014 Well no, not normally, but that is an override, so if you install a third party module, it might happen Link to comment Share on other sites More sharing options...
Recommended Posts