Icy Phoenix

     
 


Post new topic  This topic is locked: you cannot edit posts or make replies. 
Page 1 of 1
 
 
Reply with quote Download Post 
Post Error I Forgot My Password 
 
I have this error, does someone knows what to do about it ?

***********************************************************

General Error  
Could not update new password information

DEBUG MODE

SQL Error : 1366 Incorrect integer value: '' for column 'ct_last_pw_reset' at row 1

UPDATE phpbb_users SET user_newpasswd = '8ee30ae645096e83ca0029663fc8a827', user_actkey = '783e5203d', ct_last_pw_reset = '' WHERE user_id = 5

Line : 81
File : usercp_sendpasswd.php
 




____________
Gr. Ron

Team "Dutch"

?If you have accomplished all that you have planned for yourself, you have not planned enough."
 
HarimauSend private message  
Back to topPage bottom
Icy Phoenix is an open source project, you can show your appreciation and support future development by donating to the project.

Support us
 
Reply with quote Download Post 
Post Re: Error I Forgot My Password 
 
It's something related to mysql i think.

BTW, i think that it'll be better to change your password manually via phpmyadmin (remember it's encrypted in MD5)
 




____________
? Zuker - EDDB - LPM - Sharefields
 
ZukerSend private messageVisit poster's website  
Back to topPage bottom
Reply with quote Download Post 
Post Re: Error I Forgot My Password 
 
Zuker wrote: [View Post]
It's something related to mysql i think.

BTW, i think that it'll be better to change your password manually via phpmyadmin (remember it's encrypted in MD5)


This is the option on the main page, if someone (user/member) forgot there password this error shows up.

Maybe it is something whith the language pack of IP 1.0.5.5 ?
 




____________
Gr. Ron

Team "Dutch"

?If you have accomplished all that you have planned for yourself, you have not planned enough."
 
HarimauSend private message  
Back to topPage bottom
Reply with quote Download Post 
Post Re: Error I Forgot My Password 
 
on my test site i've got no problems when asking for a new password :S

i don't know if this sql it's ok but try to do it

Code: [Download] [Hide] [Select]
ALTER TABLE `phpbb_users` ALTER `ct_last_pw_reset` INT( 11 ) NULL DEFAULT 1 AFTER `ct_post_counter`;

 




____________
? Zuker - EDDB - LPM - Sharefields
 
ZukerSend private messageVisit poster's website  
Back to topPage bottom
Reply with quote Download Post 
Post Re: Error I Forgot My Password 
 
Zuker wrote: [View Post]
on my test site i've got no problems when asking for a new password :S

i don't know if this sql it's ok but try to do it

Code: [Download] [Hide] [Select]
ALTER TABLE `phpbb_users` ALTER `ct_last_pw_reset` INT( 11 ) NULL DEFAULT 1 AFTER `ct_post_counter`;


I still have this error, when i run this SQL i get this error;

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INT( 11 ) NULL DEFAULT 1 AFTER `ct_post_counter`' at line 1

This is what i get on my site;

Could not update new password information

DEBUG MODE

SQL Error : 1366 Incorrect integer value: '' for column 'ct_last_pw_reset' at row 1

UPDATE phpbb_users SET user_newpasswd = '90171993a159947b236ca9189c7609e0', user_actkey = 'e89314889', ct_last_pw_reset = '' WHERE user_id = 5

Line : 81
File : usercp_sendpasswd.php
 




____________
Gr. Ron

Team "Dutch"

?If you have accomplished all that you have planned for yourself, you have not planned enough."
 
HarimauSend private message  
Back to topPage bottom
Reply with quote Download Post 
Post Re: Error I Forgot My Password 
 
go to my site
change language to english
go to downloads and download md5 converter

convert your new password to md5
go to your database -> users
find yourself ,edit and put md5 converted password

that's all


if it happens to other users
try to configure ctracker in ACP
 




____________
*VOLVO CLUB*
 
difusSend private messageVisit poster's website  
Back to topPage bottom
Reply with quote Download Post 
Post Re: Error I Forgot My Password 
 
difus wrote: [View Post]
go to my site
change language to english
go to downloads and download md5 converter

convert your new password to md5
go to your database -> users
find yourself ,edit and put md5 converted password

that's all


if it happens to other users
try to configure ctracker in ACP


Difus,

Can you tell me where i can find it in ACP ??

Thx
 




____________
Gr. Ron

Team "Dutch"

?If you have accomplished all that you have planned for yourself, you have not planned enough."
 
HarimauSend private message  
Back to topPage bottom
Reply with quote Download Post 
Post Re: Error I Forgot My Password 
 
database you can edit  with phpmyadmin [cpanel]

 users

and for ctracker

 ctracker
 




____________
*VOLVO CLUB*
 
difusSend private messageVisit poster's website  
Back to topPage bottom
Post new topic  This topic is locked: you cannot edit posts or make replies.  Page 1 of 1
 


Display posts from previous:    

HideWas this topic useful?

Link this topic
URL
BBCode
HTML




 
Permissions List
You cannot post new topics
You cannot reply to topics
You cannot edit your posts
You cannot delete your posts
You cannot vote in polls
You cannot attach files
You can download files
You cannot post calendar events


  

 

  cron