Fatal error: Uncaught mysqli_sql_exception: Out of range value

[swo0p]

Hi there,

I need help with SMF, suddenly showed up:

Code Select Expand

Fatal error: Uncaught mysqli_sql_exception: Out of range value for column 'id_error' at row 1 in /home/mierzejewski/ftp/www/tkp_forum/Sources/Subs-Db-mysql.php:1169 Stack trace: #0 /home/mierzejewski/ftp/www/tkp_forum/Sources/Subs-Db-mysql.php(1169): mysqli_query(Object(mysqli), '\n\t\t\tINSERT INTO...') #1 /home/mierzejewski/ftp/www/tkp_forum/Sources/Subs-Db-mysql.php(1497): SMF_DB_MySQLi->query('', '\n\t\t\tINSERT INTO...', Array, Object(mysqli)) #2 /home/mierzejewski/ftp/www/tkp_forum/Sources/Errors.php(143): SMF_DB_MySQLi->insert('', 'smf_log_errors', Array, Array, Array) #3 /home/mierzejewski/ftp/www/tkp_forum/Sources/Errors.php(161): log_error('Out of range va...', 'general') #4 /home/mierzejewski/ftp/www/tkp_forum/index.php(132): fatal_error('Out of range va...', 'general') #5 [internal function]: {closure}(Object(mysqli_sql_exception)) #6 {main} thrown in /home/mierzejewski/ftp/www/tkp_forum/Sources/Subs-Db-mysql.php on line 1169
Someone can help me with that?

Thank You from the mountains

[Doug Heffernan]

Hi there,

I need help with SMF, suddenly showed up:

Code Select Expand

Fatal error: Uncaught mysqli_sql_exception: Out of range value for column 'id_error' at row 1 in /home/mierzejewski/ftp/www/tkp_forum/Sources/Subs-Db-mysql.php:1169 Stack trace: #0 /home/mierzejewski/ftp/www/tkp_forum/Sources/Subs-Db-mysql.php(1169): mysqli_query(Object(mysqli), '\n\t\t\tINSERT INTO...') #1 /home/mierzejewski/ftp/www/tkp_forum/Sources/Subs-Db-mysql.php(1497): SMF_DB_MySQLi->query('', '\n\t\t\tINSERT INTO...', Array, Object(mysqli)) #2 /home/mierzejewski/ftp/www/tkp_forum/Sources/Errors.php(143): SMF_DB_MySQLi->insert('', 'smf_log_errors', Array, Array, Array) #3 /home/mierzejewski/ftp/www/tkp_forum/Sources/Errors.php(161): log_error('Out of range va...', 'general') #4 /home/mierzejewski/ftp/www/tkp_forum/index.php(132): fatal_error('Out of range va...', 'general') #5 [internal function]: {closure}(Object(mysqli_sql_exception)) #6 {main} thrown in /home/mierzejewski/ftp/www/tkp_forum/Sources/Subs-Db-mysql.php on line 1169
Someone can help me with that?

Thank You from the mountains

This error usually means that the value that is trying to be inserted is greater than the maximum value for data type INT.

What was the latest change done to the forum prior to this happening?

[swo0p]

Basically, I didn't make any changes. I noticed that my database was growing significantly due to errors, but everything worked.

Today I received a message from users that the forum is not working and while checking various things, I deleted all errors from the database. that's all I know

[Arantor]

Go to phpMyAdmin, to the smf_log_errors table, to the Operations tab, and select to Truncate the table. (Do NOT, understand any circumstances drop the table. Truncate is a special kind of emptying it, drop is to delete it entirely.)

This should not only clear the error log but reset the counter for id_error because otherwise it just keeps counting upwards and never reusing numbers for the life of the forum.

[swo0p]

That was it ... thank You very much