Front End > Customer Registration Error "an error occurred while creating your account"

[watman10]

Details:

- Upgrading to Prestashop V1.3 from older version using an existing database

Problem Statement:

- When a customer attempts to register while at Cart > Checkout in the front end, they are presented with an error "an error occurred while creating your account"

Resolution Statement:

- There have been changes to the database infrastructure in V1.3 (AFAIK). This causes the php sql query to fail as it has an expectancy for several columns in 3 tables which does not exist in the old database.

- The new framework is unable to assign the customer to a specific group as the group column is not present in the old database

Resolution Fix:

- Launch preferred DB editor (Recommended: Heidi SQL 6.0 EXPERIENCED USERS ONLY http://www.heidisql.com/) – Navigate to table “PS_CUSTOMER” – At position 3 add column “id_default_group” of types “INT 11” and default value 1 and save changes to database

In the same table "PS_CUSTOMER" - At position 15 add column "dni" of types "VARCHAR 50" and default value NULL and save changes to database

Navigate to table "PS_CUSTOMER_GROUP" - At position 2 ensure that column "id_group" is added. This is most likely already present in the older DB, however if it is missing, at position 2 add column "id_group" of types "INT 10" and default value 1 and save changes to database

Navigate to "PS_ORDERS" - At position 20 add column "total_products_wt" of types "DECIMAL 17,2" and default value 0.00 and save changes to the database


Refresh your browser and attempt to register again at Cart > Checkout - This issue should now resolve.


SCREENSHOT ATTACHED

[Abh]

Thanks, i had a similar problem after doing some modification in core files, seems i missed the ones needed to be done in the database