Problems with deleting Topics

[ChiSamurai]

Hi there,

I have a big problem with my SMF 1.1.3:

If a user deletes his own topic, all topics in the thread are "invisible" (it is set to "0 topics 0 posts". But if you access the "invisible" topics with

http://www.myurl.com/index.php?board=x.0

you can access them.

When you start a new topic in this "empty" thread they are visible again.

Any ideas?

[ChiSamurai]

Ok, I just tried to delete a topic by myself and got this error:

Datenbankfehler: Lost connection to MySQL server during query
Datei: /home/www.myurl.com/Sources/RemoveTopic.php
Zeile: 361

I can translate it if needed...

There is no problem with the MySQL-database

[ChiSamurai]

Used the search function and found this Topic: http://www.simplemachines.org/community/index.php?topic=63232.0

It removes the error message but the Topics are still "invisible" after doing it. Another problem: the deleted topics are still there, so I can't delete any topic

Edit:
Topics were deleted. But there is still the problem that the other topics in the Childboard are not visible but accessible and the statistic for this Childboard is set to "0 topics 0 posts". Adding a new post fixes it and all topics are there again.

After all the Problem seems to be with MYSQL Version 5.0.18 and .19 at least. Upgrading to 5.0.20 should solve the problem completely.

My host unfortunately doesnt want to upgrade due to compatibility and security-reasons so I have to get a workaround. Has anybody an idea how this could be fixed?

Maybe the solution shoud be pinned.

[ChiSamurai]

Fixed it at my board:

Find this in ManageAttachments.php and RemoveTopic.php

removeAttachments('a.attachmentType = 0

and replace it with

removeAttachments('a.attachmentType = \'0\'

After done this, you should be able to delete topics again.

Now execute this: Administration-Panel -> Forum Maintenance -> Recount all forum totals and statistics

This should fix the statistics and after deleting a topic the rest should be visible.

Maybe sbdy can change the subject of this post to "Problems with deleting Topics" or something.

Greets,
Samurai

[greyknight17]

Glad you resolved the issue.

You can edit the subject yourself. In your first post, click on the Modify link and change the subject.

You may mark your topic as resolved. Click on the icon to the left of the subject line in your first post and select the check mark.

[ChiSamurai]

done