View Single Post
  #18  
Old 23rd December 2020, 20:25
Asterix Asterix is offline
Senior Member
 
Join Date: Mar 2011
P2P
Posts: 20
Default
Quote:
Originally Posted by fr31w1ld View Post
I changed that as you wrote me. I still get login failed
some php errors?
some sql errors? you can verify sql errors on folder sqlerr_logs.
but your error is on database.

on table `users` change length of column `passhash` from 32 to 64.

Code:
`passhash` varchar(32) CHARACTER SET utf8 DEFAULT NULL,
should be


Code:
`passhash` varchar(64) CHARACTER SET utf8 DEFAULT NULL;
first delete your account.
second from phpmyadmin enter on table users and change the length of column passhash from 32 to 64.
or use this on phpmyadmin:
Code:
ALTER TABLE `users` MODIFY `passhash` varchar(64) CHARACTER SET utf8 DEFAULT NULL;
now create a new account and try to login.

Bump: errors are from database on column passhash.
length of column passhash is 32.
function make_passhash creates a passhash of length 64. on sql insert passhash is truncated to 32.
Reply With Quote