G. de Keijzer Posted January 24, 2009 Share Posted January 24, 2009 When customers sign up they get an error:There is 1 error:1. an error occurred while creating your account(translated from Dutch)But... what IS the error?Are there any logfiles inside PrestaShop i can check?Regards,Gerwin Link to comment Share on other sites More sharing options...
G. de Keijzer Posted January 24, 2009 Author Share Posted January 24, 2009 UPDATE:Same in adminpanel... can not add customer Link to comment Share on other sites More sharing options...
TropischBruin Posted January 24, 2009 Share Posted January 24, 2009 Upgrade, new install?Can you add products? Link to comment Share on other sites More sharing options...
G. de Keijzer Posted January 25, 2009 Author Share Posted January 25, 2009 New install.First fixed the 'pictures upload' issue (disable fopen or something, then create PHPTEMP folder instead of windows TEMP folder)I can:- Create items- Create categories- Upload pictures- Create suppliers- Create brandetc etcBut i can not create a single customer...Does PrestaShop create any logfiles of some kind?Regards Link to comment Share on other sites More sharing options...
Guest Posted January 25, 2009 Share Posted January 25, 2009 I suppose that you are doing this under V.1.1 !?... Link to comment Share on other sites More sharing options...
G. de Keijzer Posted January 25, 2009 Author Share Posted January 25, 2009 I suppose that you are doing this under V.1.1 !?... Yep. The latest i can download.Running on:W2003 Std. IIS6 with FastCGI PHP5Mysql 5.xNumerous other sites running on this config, so not really an webserver issueAs i said, any other 'action' for adding thing to PrestaShop i CAN do..No idea... Link to comment Share on other sites More sharing options...
Guest Posted January 25, 2009 Share Posted January 25, 2009 If I can recall, there have some path issue running PS on a windows box... Correct me if I'm wrong. Link to comment Share on other sites More sharing options...
G. de Keijzer Posted January 25, 2009 Author Share Posted January 25, 2009 If I can recall, there have some path issue running PS on a windows box... Correct me if I'm wrong. Ok, could be... but why only at creating customers??? Link to comment Share on other sites More sharing options...
G. de Keijzer Posted January 25, 2009 Author Share Posted January 25, 2009 What scripts are called / used when creating a new customer? Link to comment Share on other sites More sharing options...
zusu Posted February 19, 2009 Share Posted February 19, 2009 HiI have this same problem. Problem raising in authentication.php line 80: if (!$customer->add()) $errors[] = Tools::displayError('an error occurred while creating your account');$customer object exists, so any one knows where's the problem?zusu Link to comment Share on other sites More sharing options...
Milaus Posted March 16, 2009 Share Posted March 16, 2009 HI i have the same problem Link to comment Share on other sites More sharing options...
jmironet Posted March 19, 2009 Share Posted March 19, 2009 I have the same problem, I have install the version 1.1 in a server with win2003 + php5.2.8 + SQL 5.0.x + IIS 6.0 and I can not create customers, also when I installed I had a problem with db_settings_extends.sql INSERT INTO `PREFIX_cart_product` (`id_cart`, `id_product`, `id_product_attribute`, `quantity`) VALUES (1, 7, 23, 1);INSERT INTO `PREFIX_cart_product` (`id_cart`, `id_product`, `id_product_attribute`, `quantity`) VALUES (1, 9, 0, 1);I had change this line for INSERT INTO `PREFIX_cart_product` (`id_cart`, `id_product`, `id_product_attribute`, `quantity`, 'date') VALUES (1, 7, 23, 1, now());INSERT INTO `PREFIX_cart_product` (`id_cart`, `id_product`, `id_product_attribute`, `quantity`, , 'date') VALUES (1, 9, 0, 1, now());I tested with other server with win2003 + php5.2.8 + SQL 5.0.x + Apache 2.2 and the same download of prestashop and I had the some problems.Finally I installed prestashop in my local machine WinXP with easyphp with same download of prestashop and the problem is resolve but I need that Prestashop work in a server.I think that the problem is in SQL or configuration apache or IIS because I do not find sollution to problem.Any body could help us? Link to comment Share on other sites More sharing options...
matt85 Posted March 23, 2009 Share Posted March 23, 2009 Bump, anyone been able to work this problem out??? Link to comment Share on other sites More sharing options...
vsyucla Posted March 23, 2009 Share Posted March 23, 2009 It took me a couple a days of replicating the problem on my dev environment and setting up debugging, but I found what the problem was on my machine.The reason why customers were not able to create a new account on my website is because the insert statement was trying to insert a value into a column that did not exist in the table.This happens when you upgrade your prestashop and install a backup mysql data you saved from a previous install. Thus, your mysql prestashop tables are not updated and the current version prestahop has a db sql schema change that is causing problems with your old prestshop schema.Here is the fix:- Figure out what version prestashop you currently have installed and what version you had before when you saved the backup mysql data.- Unzip the prestashop zip file for your current install into a temp directory- Go to the temp directory\prestashop\install\sql\upgrade folder- Find the prestashop versions newer than the previously version when you backup your mysql data. I have version 1.1.0.4 when I save the mysql data.- Therefore I had to update my current database with the newer 1.1.0.5.sql file to use with my current 1.1.0.5 prestashop instance.- Copy the data in this file- Open mysql query browser or phpMyAdmin. Load the file for update.- Make sure you replace the everywhere you see "PREFIX" for the table name with the prefix you used for your tables. I think the default is "ps". So I replace all "PREFIX" with "ps". Otherwise you will get an error saying that the table does not exist.- Execute the script and make sure you are running it against your prestashop db instance.- Repeat for the other scripts to bring your db to your current prestashop version. 1 Link to comment Share on other sites More sharing options...
jmironet Posted March 23, 2009 Share Posted March 23, 2009 I have installed prestashop version 1.1.0.5 and I have the problem Link to comment Share on other sites More sharing options...
vsyucla Posted March 24, 2009 Share Posted March 24, 2009 Did you import the database data for your 1.1.0.5 from a previous version or from another server?The best way to figure out what is happenning is debug your server and step through the code. Find out what the exact call is to the database when it is trying to insert the new customer data. Cut and paste this data using mysql query anyalzer and see what errors it is giving you. For me it was giving me an error where the column "newsletter_date_add" did not exist in table "ps_customer". That was my clue that I did not update the database for the updated 1.1.0.5 prestashop properly.I used phpEd to debug the code. Link to comment Share on other sites More sharing options...
vsyucla Posted March 24, 2009 Share Posted March 24, 2009 Go to your prestashop database and see if this column "newsletter_data_add" exist in your "ps_customer" table (Note your prefix for your customer table might be different from mine).If it does not exist, then you did not run the new updates against your database.if it does exist, then you are going to have to debug the code. 1 Link to comment Share on other sites More sharing options...
jmironet Posted March 24, 2009 Share Posted March 24, 2009 Thanks for your help, but in my case I have the database version 1.1.0.5 and the column “newsletter_date_add” is in table “ps_customer”. Link to comment Share on other sites More sharing options...
jmironet Posted April 5, 2009 Share Posted April 5, 2009 I have resolve the problem, I don't Know if the best sollution but it works.In classes/customer.php in line 95 there is that coment it.// $fields['last_passwd_gen'] = pSQL($this->last_passwd_gen);bye Link to comment Share on other sites More sharing options...
Milaus Posted April 6, 2009 Share Posted April 6, 2009 I have resolve the problem, I don't Know if the best sollution but it works.In classes/customer.php in line 95 there is that coment it.// $fields['last_passwd_gen'] = pSQL($this->last_passwd_gen);bye thanks for your solution, now the customer register, and report this errorSystem error (Address -> id_country is empty) you know how the resolv? Link to comment Share on other sites More sharing options...
Milaus Posted May 23, 2009 Share Posted May 23, 2009 I'm solved!!http://www.prestashop.com/forums/viewthread/16043/installation_configuration___upgrade/state_requirement_is_not_working_on_create_account_works_in_update_address_dot_/ Link to comment Share on other sites More sharing options...
seog Posted February 8, 2014 Share Posted February 8, 2014 It took me a couple a days of replicating the problem on my dev environment and setting up debugging, but I found what the problem was on my machine. The reason why customers were not able to create a new account on my website is because the insert statement was trying to insert a value into a column that did not exist in the table. This happens when you upgrade your prestashop and install a backup mysql data you saved from a previous install. Thus, your mysql prestashop tables are not updated and the current version prestahop has a db sql schema change that is causing problems with your old prestshop schema. Here is the fix: - Figure out what version prestashop you currently have installed and what version you had before when you saved the backup mysql data. - Unzip the prestashop zip file for your current install into a temp directory - Go to the temp directory\prestashop\install\sql\upgrade folder - Find the prestashop versions newer than the previously version when you backup your mysql data. I have version 1.1.0.4 when I save the mysql data. - Therefore I had to update my current database with the newer 1.1.0.5.sql file to use with my current 1.1.0.5 prestashop instance. - Copy the data in this file - Open mysql query browser or phpMyAdmin. Load the file for update. - Make sure you replace the everywhere you see "PREFIX" for the table name with the prefix you used for your tables. I think the default is "ps". So I replace all "PREFIX" with "ps". Otherwise you will get an error saying that the table does not exist. - Execute the script and make sure you are running it against your prestashop db instance. - Repeat for the other scripts to bring your db to your current prestashop version. You are a genius. This was the only solution after of import ps_customers old tables in new prestashop installation best regards Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now