cipetonk Posted November 5, 2012 Share Posted November 5, 2012 (edited) hello, I'm using prestashop 1.5.2.0 for my online store www.epicdistro.com, this version is upgraded from 1.5.0.17 I have a problem when updating, creating, deleting customer group, an error message "Object cannot be loaded (not found)" when creating the new one, this message will appear: An error occurred while creating object. group (Unknown column 'id_group' in 'field list'), and then group name will be "--", undetiable & undeletable I had tried fresh install 1.5.2.0 in my localhost, no problem occured, and then I tried to restore my web database to localhost, and the the problem occured. please help me Edited November 5, 2012 by cipetonk (see edit history) Link to comment Share on other sites More sharing options...
doekia Posted November 5, 2012 Share Posted November 5, 2012 Unknown column id_group?? What is your database prefix? Could you do: show table `ps_group`; show table `ps_group_lang`; Seems like you database backup is somehow corrupted. Link to comment Share on other sites More sharing options...
cipetonk Posted November 5, 2012 Author Share Posted November 5, 2012 (edited) prefix is: es_ es_group id_group reduction price_display_method show_prices date_add date_upd 1 0.00 0 1 2012-05-27 14:38:42 2012-05-27 14:38:42 2 0.00 0 1 2012-09-16 01:40:23 2012-09-16 01:40:23 3 0.00 0 1 2012-09-16 01:40:23 2012-09-16 01:40:23 4 0.00 0 1 2012-09-16 01:40:52 2012-09-16 01:40:52 5 0.00 0 1 2012-09-16 01:40:52 2012-09-16 01:40:52 6 0.00 0 1 2012-11-05 04:19:11 2012-11-05 04:19:11 es_group_lang id_group id_lang name 1 1 Default 1 2 Défaut 1 3 Predeterminado 1 4 Default 1 5 Default 2 1 Visitor 2 2 Visiteur 2 3 Visitor 2 4 Visitor 2 5 Visitor 3 1 Guest 3 2 Invité 3 3 Guest 3 4 Guest 3 5 Guest 4 1 Visitor 4 2 Visiteur 4 3 Visitor 4 4 Visitor 4 5 Visitor 5 1 Guest 5 2 Invité 5 3 Guest 5 4 Guest 5 5 Guest Edited November 5, 2012 by cipetonk (see edit history) Link to comment Share on other sites More sharing options...
cipetonk Posted November 5, 2012 Author Share Posted November 5, 2012 (edited) I had double checked my database with the freshly installed one, they have same structure in both tables Edited November 5, 2012 by cipetonk (see edit history) Link to comment Share on other sites More sharing options...
cipetonk Posted November 5, 2012 Author Share Posted November 5, 2012 (edited) it seems es_group & es_group_lang is not linked, id_group 6 does not exist in es_group_lang Edited November 5, 2012 by cipetonk (see edit history) Link to comment Share on other sites More sharing options...
doekia Posted November 5, 2012 Share Posted November 5, 2012 There is no link per say. The Prestashop framework does it.Apprently it fail on your setup. Which language are installed? Which are active? Which language your employee profile is using? Link to comment Share on other sites More sharing options...
cipetonk Posted November 5, 2012 Author Share Posted November 5, 2012 languages installed: english, french, spanish, german, italian (language and icon doesn't match) active: only english using: only english Link to comment Share on other sites More sharing options...
cipetonk Posted November 5, 2012 Author Share Posted November 5, 2012 more error found: when editing customer, groups list doesn't appear Link to comment Share on other sites More sharing options...
doekia Posted November 5, 2012 Share Posted November 5, 2012 I trully suspect some spagethi occured with your languages. PM me with some access to your BDD/BO. If icons does not match surely languages ids are wrong which explain the problem. Link to comment Share on other sites More sharing options...
cipetonk Posted November 5, 2012 Author Share Posted November 5, 2012 (edited) I have deleted languages, only english left but still no luck cart rules won't work too in default theme but configurable in BO I had tried backing up my products, categories, attributes, impacts. And then install fresh 1.5.2 on localhost and restor my backup, errors occured, such as unable to access categories from BO I suspect a slight change in database structure is the root cause. I don't think my database is corrupted, I always do full back up from cpanel, not mySQL nor prestashop Edited November 5, 2012 by cipetonk (see edit history) Link to comment Share on other sites More sharing options...
doekia Posted November 5, 2012 Share Posted November 5, 2012 We need to find the root cause not try blind whatever approach... Provide a BO access should you want to investigate. Deleting this and that should there be database inconsistencies will only lead to another new set of problems 1 Link to comment Share on other sites More sharing options...
cipetonk Posted November 5, 2012 Author Share Posted November 5, 2012 I've given you access to my BO, and uploaded screen in first post for other users to see check your PM Link to comment Share on other sites More sharing options...
doekia Posted November 6, 2012 Share Posted November 6, 2012 For the record, it's been solved, the probleme was related to schema / classes discrepancies. Some misupgrade apparently. 1 Link to comment Share on other sites More sharing options...
cipetonk Posted November 6, 2012 Author Share Posted November 6, 2012 Thank you for your help, it is solved Link to comment Share on other sites More sharing options...
Recommended Posts