Customer Group error

[cipetonk]

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)

[doekia]

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.

[cipetonk]

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)

[cipetonk]

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)

[cipetonk]

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)

[doekia]

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?

[cipetonk]

languages installed: english, french, spanish, german, italian (language and icon doesn't match)

active: only english

using: only english

[cipetonk]

more error found:

when editing customer, groups list doesn't appear

[doekia]

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.

[cipetonk]

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)

[doekia]

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

[cipetonk]

I've given you access to my BO, and uploaded screen in first post for other users to see

check your PM

[doekia]

For the record, it's been solved, the probleme was related to schema / classes discrepancies. Some misupgrade apparently.

[cipetonk]

Thank you for your help, it is solved