Page 1 of 1

Forgotten password not working?

Posted: Fri May 30, 2014 10:07 pm
by lpotts
Hi all,

Just looking for a little assistance with our site. For some unknown reason our forgotten password link is not working. The initial link works, and takes to a page for the user to input their email address. But when sending that it takes them to a blank page.

Can anyone help with this issue?

Our site is www . designer - man . co . uk (without the spaces obviously)

Thank you all for your time,

Regards,

Re: Forgotten password not working?

Posted: Tue Jun 03, 2014 5:01 pm
by MarketInSG
which version of OpenCart? The older version has an issue with it

Re: Forgotten password not working?

Posted: Fri Jun 06, 2014 9:01 pm
by lpotts
Thanks for the reply MarketInSG, were using version 1.5.5.1?

Re: Forgotten password not working?

Posted: Fri Jun 06, 2014 9:29 pm
by MarketInSG
just realised you were talking about a blank page, not failing to reset the password. The blank page should be related to your site specifically. Have a look into your error logs. You might be able to find hints on the php errors, then post it here and we can assist you

Re: Forgotten password not working?

Posted: Fri Jun 06, 2014 11:55 pm
by lpotts
Hi MarketInSG, I am going to PM you my error code, just I am unsure if there is any data in the error log that should not be shown publicly. If there isn't i'm more than happy to pop it all up on here afterwards to help others.
Thank you for your time,
Regards,

Re: Forgotten password not working?

Posted: Sat Jun 07, 2014 12:02 am
by lpotts
For some reason I cannot seem to PM you.

Thank you for your time with this. My error log shows this when I get the blank page on forgotten password link:

2014-06-06 15:53:36 - PHP Notice: Error: Unknown column 'cg.name' in 'field list'<br />Error No: 1054<br />SELECT *, CONCAT(c.firstname, ' ', c.lastname) AS name, cg.name AS customer_group FROM oc_customer c LEFT JOIN oc_customer_group cg ON (c.customer_group_id = cg.customer_group_id) WHERE LCASE(c.email) = 'my-email-address-removed' ORDER BY name ASC in /home/designer/public_html/system/database/mysql.php on line 50

Have you any idea on how I can resolve this?

Regards,

Luke

Re: Forgotten password not working?

Posted: Sat Jun 07, 2014 9:51 am
by MarketInSG
head over to your database and create the column 'name' varchar 255 into your customer_group table. That should solve the issue