phpMyFaq 2.0.12 tags remain when articles are deleted

[djbeefburger]

Thank you very much for this helpful tool! I have found what appears to be a bug:

When an article is deleted, the rows remain in faq_faqdata_tags, so if the tag was only used once it still shows up in the tag cloud but clicking on it takes you nowhere. (They tags also remain in faq_faqtags, but this does not seem to have an adverse impact.)

I have been able to work-around the issue by clearing all tags and saving before deleting articles.

To clean up the table (I had a lot of deleted articles+tags) I used:
DELETE FROM faq_faqdata_tags WHERE faq_faqdata_tags.record_id NOT IN (SELECT faq_faqdata.id FROM faq_faqdata)

Cheers!

[Thorsten]

Hi,

I know this issue... I think about your solution. The problem is that this is a sub-select statement that doesn't work on MySQL 4.0 for example. But we dropped MySQL 4.0 support in phpMyFAQ 2.5 so we can add this query in phpMyFAQ 2.5.0-beta.

Thanks!

bye
Thorsten