Page 1 of 1
SQL error approving post
Posted: Fri Jun 07, 2024 7:44 pm
by Loewchen
Code: Select all
General Error
SQL ERROR [ mysqli ]
BIGINT UNSIGNED value is out of range in '`phpbb`.`phpbb_forums`.`forum_posts_unapproved` - 1' [1690]
An SQL error occurred while fetching this page. Please contact the Board Administrator if this problem persists.
The notification will persist for a month once more (happened a few times before).
Re: SQL error approving post
Posted: Tue Jan 06, 2026 12:11 pm
by Sanqui
I looked at this.
phpbb_forums.forum_posts_unapproved is a column of type
mediumint(8) unsigned. All of the rows have a value of either 0 or 1. I can only find
one other reference online to the same issue. No clue what's wrong here, I don't think changing the type of the column to bigint is the right fix.