Forum

Thread tagged as: Problem, Error, Configuration

Password reset link expires in seconds can't get new password to login

Perch Version 2.8.34

This email is send

Resetting your password

Hi Carol,

Below is a link to reset your password. You'll be asked to enter your username as a confirmation step.

Your username is: ckfs

Reset your password now »

This link will expire in about 4 hours. If you didn't request this email, you can simply ignore it.

All the best,

Carol Swinehart

I click the link to get to the password reset box in seconds after it is sent and I get this instead and get stuck in a loop where I click the link in the new request and get to the same reset password message below

Reset password Sorry, that recovery link has expired. For security reasons, you need to request a new link

The user table in the database is read only is this the problem? and has in that line password reset expired in the entry

~ Debug Message Activating via CURL {"result":"SUCCESS","latest_version":"2.8.15","on_sale_version":"2.8.34"} DELETE FROM perch2_settings WHERE settingID='latest_version' AND userID=0 LIMIT 1 Invalid query: SQLSTATE[HY000]: General error: 1290 The MySQL server is running with the --read-only option so it cannot execute this statement INSERT INTO perch2_settings(settingID,settingValue,userID) VALUES('latest_version','2.8.15',0) Invalid query: SQLSTATE[HY000]: General error: 1290 The MySQL server is running with the --read-only option so it cannot execute this statement DELETE FROM perch2_settings WHERE settingID='on_sale_version' AND userID=0 LIMIT 1 Invalid query: SQLSTATE[HY000]: General error: 1290 The MySQL server is running with the --read-only option so it cannot execute this statement INSERT INTO perch2_settings(settingID,settingValue,userID) VALUES('on_sale_version','2.8.34',0) Invalid query: SQLSTATE[HY000]: General error: 1290 The MySQL server is running with the --read-only option so it cannot execute this statement stdClass Object ( [result] => SUCCESS [latest_version] => 2.8.15 [on_sale_version] => 2.8.34 ) Activation: success [1] SELECT u.*, r.* FROM perch2_users u, perch2_user_roles r WHERE u.roleID=r.roleID AND u.userEnabled=1 AND userUsername='ckfs' LIMIT 1 User exists, checking password. Stronger password hash. Password failed to match. UPDATE perch2_users SET userFailedLoginAttempts=1, userLastFailedLogin='2017-02-01 01:01:29' WHERE userID='1' Invalid query: SQLSTATE[HY000]: General error: 1290 The MySQL server is running with the --read-only option so it cannot execute this statement Writing auth fail to log. [15] SELECT DISTINCT settingID, settingValue FROM perch2_settings WHERE userID=0 Queries: 2 Memory: 1.7144 Array ( [type] => 8192 [message] => Directive 'register_globals' is deprecated in PHP 5.3 and greater [file] => Unknown [line] => 0 ) ~

Carol Swinehart

Carol Swinehart 0 points

  • 4 years ago
Rachel Andrew

Rachel Andrew 394 points
Perch Support

Your server is misconfigured. You need to speak to your hosting.

General error: 1290 The MySQL server is running with the --read-only option so it cannot execute this statement

How do you sent it up so that you send a reset link rather than a random set of letters as a new password?

Tim, please start another thread as you have hopped on an old thread. In your thread please specify if your talking about members app or perch admin password reset. Thanks