Site announcements, suggestions, Q&A
#22200
michi wrote:Just stumbled across another problem: media/dvd-famoudou-konate-famille-t3244.html#p22114

Note how the post sort of includes itself, and also the missing JPEG image of the DVD cover.
I reposted that article so it displays correctly. When I tried to delete the old one, I got:
General Error
SQL ERROR [ mysql4 ]

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

SQL

UPDATE phpbb_topics SET topic_replies_real = topic_replies_real - 1, topic_replies = topic_replies - 1 WHERE topic_id = 3244

BACKTRACE

FILE: includes/db/mysql.php
LINE: 174
CALL: dbal->sql_error()

FILE: includes/functions_posting.php
LINE: 1646
CALL: dbal_mysql->sql_query()

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

FILE: posting.php
LINE: 314
CALL: handle_post_delete()
It still looks like there might be some inconsistencies in the DB.

On the second attempt, I managed to delete the post.

James, it might be a good idea to run a consistency check on the entire DB. If there are inconsistencies, they could cause damage down the track, with bits progressively falling off the DB...

Cheers,

Michi.