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.

 

[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... :-\

 

[Tango]

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.

 

[Tango]

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