Cannot delete empty topic

Get help with installation and running phpBB 3.0.x here. Please do not post bug reports, feature requests, or MOD-related questions here.
Anti-Spam Guide
Forum rules
END OF SUPPORT: 1 January 2017 (announcement)
Locked
w3neo
Registered User
Posts: 67
Joined: Wed Oct 23, 2002 3:35 pm
Contact:

Cannot delete empty topic

Post by w3neo »

On my forum a situation arose where a member deleted the first post in a thread where there were no responses and now the topic remains in the forum but clicking on the link yields
The requested topic does not exist.
I tested this by creating a topic then deleting it. I got an error then after going back (browser back button) found the same thing, topic listed in forum but nothing in the topic and no way to delete it. I did this once more with another topic as I did not copy the error message and once again got the same results. Here is the error message.
General Error
SQL ERROR [ mysql4 ]

Can't open file: 'neodaq3_search_wordmatch.MYI'. (errno: 144) [1016]

SQL

SELECT w.word_id, w.word_text, m.title_match FROM neodaq3_search_wordmatch m, neodaq3_search_wordlist w WHERE m.post_id = '391850' AND w.word_id = m.word_id

BACKTRACE

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

FILE: includes/search/fulltext_native.php
LINE: 1224
CALL: dbal_mysql->sql_query()

FILE: includes/functions_admin.php
LINE: 757
CALL: fulltext_native->index_remove()

FILE: includes/functions_posting.php
LINE: 1377
CALL: delete_posts()

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

FILE: posting.php
LINE: 279
CALL: handle_post_delete()
Is this a bug in phpBB3 or is this specific to me?

w3
User avatar
Brf
Support Team Member
Support Team Member
Posts: 52169
Joined: Tue May 10, 2005 7:47 pm
Location: {postrow.POSTER_FROM}
Contact:

Re: Cannot delete empty topic

Post by Brf »

That says your search_wordmatch database table is crashed. You should try to repair it in phpmyAdmin
w3neo
Registered User
Posts: 67
Joined: Wed Oct 23, 2002 3:35 pm
Contact:

Re: Cannot delete empty topic

Post by w3neo »

Thanks brf for the quick reply, sounds like it may be the cause of some search problems that have been coming up recently also.

w3
w3neo
Registered User
Posts: 67
Joined: Wed Oct 23, 2002 3:35 pm
Contact:

Re: Cannot delete empty topic

Post by w3neo »

Update, I ran
REPAIR TABLE neodaq3_search_wordmatch USE_FRM;
And got
Table Op Msg_type Msg_text
db116155532.neodaq3_search_wordmatch repair warning Number of rows changed from 0 to 6942821
db116155532.neodaq3_search_wordmatch repair status OK
Apparently there was a problem that is now corrected but the topics still remain with no apparent way to remove them.

w3
User avatar
Brf
Support Team Member
Support Team Member
Posts: 52169
Joined: Tue May 10, 2005 7:47 pm
Location: {postrow.POSTER_FROM}
Contact:

Re: Cannot delete empty topic

Post by Brf »

That is probably because an error was generated as they were being deleted. You might have to hack thm out of your database manually.
Locked

Return to “[3.0.x] Support Forum”