Please help me !!!!!!!

[Guest]

I keep recieving this error when a new user tries to set up an account..1062 - Duplicate entry '1' for key 1

 

insert into address_book (customers_id, address_book_id, entry_firstname, entry_lastname, entry_street_address, entry_postcode, entry_city, entry_country_id, entry_company, entry_zone_id, entry_state) values ('19', '1', 'test2', 'test', '112 pay', '30056', 'dacula', '223', '', '12', '')...

 

Now if you try to log in with the account you have just created, which you really wouldnt know if you did because after you hit submit or create,, the error above pops up.but I tried to enter the information in the login area and it worked..strange///but then after I placed an order and hit confirm order I ger this error

 

Warning: mail(): "sendmail_from" not set in php.ini or custom "From:" header missing in D:\hshome\sweetdar\sweetdarlings.com\catalog\includes\classes\email.php on line 500

 

Warning: Cannot modify header information - headers already sent by (output started at D:\hshome\sweetdar\sweetdarlings.com\catalog\includes\classes\email.php:500) in D:\hshome\sweetdar\sweetdarlings.com\catalog\includes\functions\general.php on line 29

 

 

This is complete misery for me...does anyone have a clue as to how to fix this,, I reall dont want to have to rebuld this store@@

 

Thanks

 

prettygirl ;)

[Egrys]

Sounds like your customer_id field in the database is not defined as auto-increment....

[ibandyop]

I keep recieving this error when a new user tries to set up an account..1062 - Duplicate entry '1' for key 1

This is complete misery for me...does anyone have a clue as to how to fix this,, I reall dont want to have to rebuld this store@@

 

Thanks

 

prettygirl ;)

account..1062 - Duplicate entry '1' for key 1
This is complete misery for me...does anyone have a

 

Note the Duplicate entry please go into the database and

look into Table address_book. You may need to use phpMyAdmin from

the hosting panel.

 

Delete the records and start on a fresh browser.

 

Looks like you may have more problems e.g., email in your setup.

[CreativeArt]

Hi,

 

I just had the same issue with the duplicate 1062 error........

 

I solved it by going into phpAdmin......address_book

 

The issue is that you need two primary keys........I had just one. To do this click on the go button beside "create an index in 1 columns.........change the 1 to 2 and add address_book_id and customer_id as your primary keys.

 

It worked for me, hope it helps.

[devindelane]

OK... I like what you have said: I'm new to this and I'm in my control panel. How do I do this:

 

1. I click on the go button.

2. Then what?