phpbb upgrade error : Data too long for column ‘user_password’ at row 1

hi i have just upgrade my phpbb forum from 3.0 to 3.1 and am getting mysql error when trying to login to admin account


General Error

SQL ERROR [ mysql5 ]
Data too long for column 'user_password' at row 1 [1406]
An SQL error occurred while fetching this page. Please contact the Board Administrator if this problem persists.

Supporter Asked on November 13, 2016 in Software.
Add Comment
1 Answer(s)
Best answer

ya its looks like error is cause by user_password field  length , try changing it to 255 by run mysql query in phpmyadmin


ALTER TABLE myphpbb_users MODIFY user_password varchar(255)

replace my myphpbb  with your table prefix

Supporter Answered on November 13, 2016.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.