Icy Phoenix

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

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 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 ?

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

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

database you can edit with phpmyadmin [cpanel]



and for ctracker