[SOLVED] mail remind password not work

[jesushp]

Hi everyone.

After a fresh install PS 1.4.4.1, i restored some tables from other PS site (products and customers).

Now, all work ok, except the mail remind password.

If i want to remind my password, i set the mail address but PS tell me that there´s a problem sending the mail...

I´ve check all the mail configuration and it work ok. I send without problem from the contact form and the test of BO mail.

 

If i reset or change the password from the BO, the customer will log in without problem, but i have many customers...

I think that the original passwords not work ant the customers must remind ther password...

 

I was thinking if the problem will be for other table that i dont migrate...

 

I´m desesperated.

 

Thanks a lot.

[phrasespot]

I was thinking if the problem will be for other table that i dont migrate...

There is more to adding customers then customers table, (e.g. groups, addresses etc etc) so you cannot expect the new installation to work w/o problems by just restoring customers table. Restore all tables and it should work fine.

[phrasespot]

OK, I have been making some tests and I will take back what I said. It will not work, even when full DB is restored because the way passwords are stored in the DB.

 

During installation a new file, settings.inc, is created in /config directory with a value for _COOKIE_KEY_ which is unique for each install.

 

When a customer, (or an employee) registers, the password is appended to this value and then MD5 hash of the concatenated string is taken and stored in the DB. When you make a new install, you have a different value for the _COOKIE_KEY_ so the old passwords will not work.

 

If you have a copy/backup of the old installation and iff there are no new registrations since you reinstalled (otherwise you will have the same problem with those new registrations) you could replace the _COOKIE_KEY_ in settings.inc and the password should again work.

 

My previous comment about restoring more than customers table is still valid though.

 

I really cannot believe this to be the case, I am hoping someone will correct me because if I am correct, this is a major issue. This behaviour would mean that a full DB backup is useless if you reinstall, which would be the exact point when one needs the backup. Regardless on what domain or installation, a DB backup from one installation should be fully restorable to another installation as long as the versions are the same.

 

I am grateful to you for bringing this issue up; you may find solace in knowing that your misery is probably saving countless hours of work for other users

 

If someone with more experience in codebase can confirm or otherwise that would be great.

[jesushp]

Now, i have the original COOKIE_KEY, but the original users cant remind their passwords...

The tables that i restored about customers are:

ps_customer.sql

ps_customer_group.sql

ps_customer_message.sql

ps_customer_thread.sql

 

The error are the same: "Error occurred when sending the e-mail"

 

Thanks.

[solopedro]

Hi for me , it comes the same message, however sends an email with a link, once you click the link then takes you to the page forgot password, then entering email again and even same error message, I receive the login and password

 

HAs anyone an explanation or how to solve this confusing thing?

 

Thank you

[phrasespot]

Now, i have the original COOKIE_KEY,

OK, that should help.

but the original users cant remind their passwords...

Is this only a problem with the original users? If you did not already, create a new user account logout and try the password reminder. Does it work OK with the new user? If not maybe this is an email setup issue. Does new registration email work?

 

The tables that i restored about customers are:

ps_customer.sql

ps_customer_group.sql

ps_customer_message.sql

ps_customer_thread.sql

The error are the same: "Error occurred when sending the e-mail"

There are few more tables required (e.g. address, order history etc etc). Is there any reason you are restoring the DB completely?

[jesushp]

OK, that should help.

Is this only a problem with the original users? If you did not already, create a new user account logout and try the password reminder. Does it work OK with the new user? If not maybe this is an email setup issue. Does new registration email work?

 

 

There are few more tables required (e.g. address, order history etc etc). Is there any reason you are restoring the DB completely?

 

Well... I was thinking about that all day and all night and the problem of mail is produced with new and old customers.

If i register a new customer... He dont receive the mail.

Maybe will be a problem of mail...

I noticied that i dont receive the mail order either. I receive only the paypal notification, but not the PS notification about the new order.

I was looking for info on internet and i have found a interesting link: http://www.presto-changeo.com/en/content/9-fix-email-problems

Remember that when i try to remind the password, i get an error on sending the mail. After i aply the changes that the link says, i get no error but the mail dont send. I get a white page.

 

Other thing, at the first time, i restored all the tables that you said too.

 

P.s.: All this problem is becausa i cant restore all the database at the same time. After i upgrade to 1.4.4.1, there will be a problem on status table that after any order i get an error of status not define or similar... After that i made a fresh install and i restored only the tables that i need...

Sorry for my bad english. I hope that you undertand me. This problem makes me crazy. I dont sleep anything. Thanks, Phrasespot.

[phrasespot]

Let's find out if you are able to send an email using the native mail function of PHP. Add the attached file to the root of your installation after filling out the commented parts in it and load it in your browser. Is the email sent or are there any errors displayed?

email_test.php

[jesushp]

SOLVED!!

The solution was very easy than i expected.

The problem with the remid password was motivated for the mail template password_query (mail/EN), that i was not installed.

Once i extract the template from the installation and copied in the folder, the mail send perfectly.

And the problem for the mail order was because i had no installed the "mailalert' module...

 

Phrasespot, i want to give you all my gratitude and thanks for you support.

Whithout your help, i´ll never found the solution. You take me to the correct road.

THANKS A LOT.

[ferofo]

SOLVED!!

The solution was very easy than i expected.

The problem with the remid password was motivated for the mail template password_query (mail/EN), that i was not installed.

Once i extract the template from the installation and copied in the folder, the mail send perfectly.

And the problem for the mail order was because i had no installed the "mailalert' module...

 

Phrasespot, i want to give you all my gratitude and thanks for you support.

Whithout your help, i´ll never found the solution. You take me to the correct road.

THANKS A LOT.

puedes ser mas especifico por favor, como lo solucionaste?