cmat Posted January 14, 2013 Share Posted January 14, 2013 so i backed up my clients db and upgraded from 1.4.3.1 to the latest rev. then i imported the back up of his db and no i cant see the BO or FO. it looks like the same error on both. FO 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 `ps_configuration` c LEFT JOIN `ps_configuration_lang` cl ON (c.id_configuration = cl.id_configuration)</pre> thrown in /home/vmotors/public_html/classes/db/Db.php on line 605 BO 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 `ps_configuration` c LEFT JOIN `ps_configuration_lang` cl ON (c.id_configuration = cl.id_configuration)</pre> thrown in /home/vmotors/public_html/classes/db/Db.php on line 605 please help. any information would be greatly appriciated. Link to comment Share on other sites More sharing options...
monstercreativestudio Posted January 14, 2013 Share Posted January 14, 2013 did you use the one click update module or install fresh? fresh install wont work from what I read as tables in the DB has changed so the module is the only way. I hope you backed up the site files before updating. Link to comment Share on other sites More sharing options...
cmat Posted January 14, 2013 Author Share Posted January 14, 2013 hey monster thank you for the reply. i did use the one click. and by back up i did a db back up and copied all the files from filezilla from remote to local. now if i wipe out the remote with filezilla and just load the backup files should i be back in buisness?? Link to comment Share on other sites More sharing options...
El Patron Posted January 14, 2013 Share Posted January 14, 2013 as monstercreateve said, hopefully you backed that site up...because what you described would never work... Link to comment Share on other sites More sharing options...
monstercreativestudio Posted January 14, 2013 Share Posted January 14, 2013 yea I would try wiping out everything, re-upload the backup files, and import database via phpmyadmin. Should be back as long as the settings.inc.php points to the same database file name and username/pass. I just noticed you said you were on 1.4.3. from being on the forum constantly the last 3 days I see people having issues updating from 1.4. It was suggested to update to 1.4.9 first then update again to 1.5. Haven't tried it. Also if I were you, I would use a test server to update first then test a buying product, especially in Internet Explorer (had a glitch where images wouldn't appear in IE, was easy fix but you don't want it live like I had it) Link to comment Share on other sites More sharing options...
ftom Posted January 28, 2013 Share Posted January 28, 2013 I just had the same problem. look at this : http://blog.thomasfossoul.be/prestashop-2/prestashop-error-classesdbdb-php-on-line-605-842 If u don't understand french : this is because your customer is not associated to a group.. Link to comment Share on other sites More sharing options...
Bonjour Posted August 18, 2013 Share Posted August 18, 2013 (edited) Also same problem after trying to update an shop for a customer. from 1.4.11 to 1.5.4.1 I tryed this many time but still getting the same error manual upgrade: Fatal error: Uncaught Unknown column 'c.id_shop_group' in 'field list' SELECT SQL_NO_CACHE 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 `ps_configuration` c LEFT JOIN `ps_configuration_lang` cl ON (c.id_configuration = cl.id_configuration) classes/db/Db.php on line 607 1click upgrade upgrade: all files has been upgraded. Now upgrading database. this can take a while ... [Ajax / Server Error for action upgradeDb] textStatus: "error " errorThrown:"Internal Server Error " jqXHR: " Internal Server Error Is there some one ho can help with this? Edited August 18, 2013 by Bonjour (see edit history) Link to comment Share on other sites More sharing options...
El Patron Posted August 18, 2013 Share Posted August 18, 2013 see if this search result gives you some clues... https://www.google.c...restashop+forge[Ajax+%2F+Server+Error+for+action+upgradeDb]+textStatus%3A+%22error+%22+errorThrown%3A%22Internal+Server+Error+%22+jqXHR%3A+%22&ie=utf-8&oe=utf-8&aq=t&rls=org.mozilla:en-US:official&client=firefox-a so much for posting that as a link: in google I entered: prestashop forge[Ajax / Server Error for action upgradeDb] textStatus: "error " errorThrown:"Internal Server Error " jqXHR: " I only was looking on forge, but it also found other non-forge threads with reference to this error. Hope that helps. Link to comment Share on other sites More sharing options...
.png.022b5452a8f28f552bc9430097a16da2.png)
Recommended Posts