[SOLVED] Error after creating an account

[nac78]

I can't understand what is it about, but, after a new user account creation I get
the same error as others too:

1 - an error ocurred while creating your account

This didn't happen in version 1.3 now I've been using 1.3.1

Any idea what could be wrong and how can be solved???
The user account it is actually created, I checked from phpMyAdmin, and I can even login with the user email and password, the problem is on the authentication.php file, which doesn't confirm the account creation.


When I open the theme file authentication.tpl in Dreamweaver the code shows an error in line 6

idSelectedCountry = {if isset($smarty.post.id_state)}{$smarty.post.id_state|intval}{else}false{/if};

but I'm not sure if it has something to be with the problem

[nac78]

Please guys, I need help with this!

I'm having the same trouble in BO even though the user is registered after account creation the form page shows this message

an error occurred while creating object customer (Duplicate entry '1-1' for key 'PRIMARY')

so there is some duplicate entry somewhere...but still it inserts the user data into the database... what could be the problem and where??

[nac78]

There are some threads related to this issue but there is no clear solution for it.

http://www.prestashop.com/forums/viewthread/58935/upgrading_prestashop/solved_an_error_occurred_while_creating_your_account/

http://www.prestashop.com/forums/viewthread/25740/

http://www.prestashop.com/forums/viewthread/63346/configuring___using_prestashop/customer_registration_has_stopped_working_after_upgrade_to_1_dot_3_dot_1_dot_1

[nac78]

I'm not sure, but could this have something to do with the database , here is my customer table

[nac78]

bug reported here

http://www.prestashop.com/bug_tracker/view/5102/

[nac78]

I'M GLAD TO ANNOUCE THAT THIS BUG WAS RESOLVED!

I didn’t run manually the updates, just took a watch at both tables ps_customer and ps_customer_group (which was added after version 1.3 as I understood)

So, as Alain asked, the PREFIX_customer table had the customer_group_id index, but the problem was that I truncated all the test customer tables according to this post http://www.prestashop.com/forums/viewthread/9045/#39166

and in that instruction this new table ps_customer_id, so it stayed with the previous customers ids, and that was causing the conflict when adding new ones with the same id. So what you must do if you are having the same problem is to run this code in your phpmyadmin

TRUNCATE TABLE `ps_customer_group`;

Sounds stupid, but it burned my head for at list 1 day, so I hope this solution helps others as well.

As far as I tested the customer registration works fine now in FO and BO.