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."

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

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."

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

____________
? Zuker - EDDB - LPM - Sharefields

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]

Code: [Download] [Show]

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."

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*

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."

database you can edit  with phpmyadmin [cpanel]

 

and for ctracker

 

____________
*VOLVO CLUB*