Shaiya Register Error

[ShaiyaDeadlyBreath]

Warning: odbc_execute(): SQL error: [Microsoft][ODBC SQL Server Driver]String data, right truncation, SQL state 22001 in SQLExecute in C:\xampp\htdocs\register\register.php on line 60

Failed to create a new account, please try again later

Users_Master Design is correctly , Register have been working for a few days ,
Then somthing strange happend and this came up..


[ NOTICE ] I just discovered a password that Abrasive Registration doesn't work O.o
Password it : Andrzejewski1 , I've tested on all private servers Registration and it doesn't work.
Please check it.

[treica]

This error occurs most likely is too long that the Pw field allows it to be, try a maximum of 10 characters and see if works. If works then improve your error check in register.php with something like..

if($password > 10 || $password < 3)
    errors[] = 'password too long or too short, please try again';

It will allow the output to be your string rather than server error.

[ShaiyaOld]

Abrasive Registration System has Password between 3 and 16 , I am not sure its that.

}else if(strlen($password) < 3 || strlen($password) > 16){
$errors[] = 'Password must be between 3 and 16 characters in length.';

[beetols]

Originally Posted by ShaiyaOld

Abrasive Registration System has Password between 3 and 16 , I am not sure its that.

And the column Pw in PS_UserData.dbo.Users_Master how many letters allow? usual is 12 and the password you tried is 13.

[treica]

Originally Posted by treica

This error occurs most likely is too long that the Pw field allows it to be

As i stated above the Pw field in your database not the script and to overcome this you have to change in your script the error output or to update the max allowed chars in your Pw field (requires recreate).