Out of Range Value for Column Error

[orbofdarkness]

Hi Everyone,

Since yesterday I have beeen facing the following error in my website. can Anyone help me out?


General Error
SQL ERROR [ mysqli ]

Out of range value for column 'user_login_attempts' at row 1 [1264]

An SQL error occurred while fetching this page. Please contact the Board Administrator if this problem persists.

Orb.

orbofdarkness Reviewed by orbofdarkness on 18th Oct 2011. Out of Range Value for Column Error Hi Everyone, Since yesterday I have beeen facing the following error in my website. can Anyone help me out? General Error SQL ERROR Out of range value for column 'user_login_attempts' at row 1 Rating: 5

[Putin]

Guessing from the top of my head the column 'user_login_attempts' doesn't exists.
-Make sure you've connected the username to the database.
-Make sure you're using correct database info
-Make sure you have imported all the correct database tables/columns.
Edit -Make sure your username/database have the correct permissions (SELECT enabled)

Sorry I can't be much help... :-\

[Gavo]

It looks like you didnt let the DB update script complete.
Download phpbb3 and upload the /install folder and run /install/database_update.php

then clear the cache.

[orbofdarkness]

I Haven't changed anything in the site nor I have installed any mod.

[Gavo]

Still try what i said, it will check your DB and add the column


You have an outdated database for the phpbb files your running.


This is the default setting

ALTER TABLE `phpbb_users` CHANGE `user_login_attempts` `user_login_attempts` TINYINT( 4 ) NOT NULL DEFAULT '0' 

</DIV>

[orbofdarkness]

Thanks a lot "Gavo"...Problem Solved .....