Sql error when deleting post

Get help with installation and running phpBB 3.0.x here. Please do not post bug reports, feature requests, or MOD-related questions here.
Scam Warning
Forum rules
END OF SUPPORT: 1 January 2017 (announcement)
Locked
mclarens
Registered User
Posts: 1
Joined: Wed Nov 24, 2010 4:35 am

Sql error when deleting post

Post by mclarens »

Hello good folks

Out of sudden when deleting some post i get this mysq error:


General Error
SQL ERROR [ mysqli ]

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

SQL

UPDATE phpbb_forums SET forum_topics_real = forum_topics_real - 1, forum_posts = forum_posts - 1, forum_topics = forum_topics - 1, forum_last_post_id = 180, forum_last_post_subject = 'Amberina Blood Elf Paladin (HEALER)', forum_last_post_time = 1290575186, forum_last_poster_id = 62, forum_last_poster_colour = 'AA0000', forum_last_poster_name = 'Amberina' WHERE forum_id = 18

BACKTRACE

FILE: includes/db/mysqli.php
LINE: 163
CALL: dbal->sql_error()

FILE: includes/functions_posting.php
LINE: 1589
CALL: dbal_mysqli->sql_query()

FILE: posting.php
LINE: 1586
CALL: delete_post()

FILE: posting.php
LINE: 314
CALL: handle_post_delete()

but even the error comes, the post get deleted it seems,

Anyone got any clue how i can fix this?

User avatar
daroPL
Translator
Posts: 515
Joined: Tue Mar 27, 2007 11:58 am
Location: Poznan, Poland
Name: Darek
Contact:

Re: Sql error when deleting post

Post by daroPL »

It looks very strange. Did not you click twice on the delete icon?

Locked

Return to “[3.0.x] Support Forum”