XF 1.2 Reporting Conversations doesn't work

[Nudaii]

I have a very odd glitch on one of my clients forums.

Reporting Posts/Threads works fine and creates a thread in the reports forum.

Reporting Conversation go nowhere, literally they go off into cyberspace.

I cloned the site to a dev server and uninstalled every addon/style and still the issue persists.

Yet its not server related, as if i copy another forum to the dev server, its reports work as intended etc.

has this issue been encountered before? and is there a fix known?

 

[Paul B]

Have you confirmed whether the thread exists in the database?

 

[Nudaii]

Good idea, i will check.

 

[shadrxninga]

Try running a file health check to see if any files have been manually changed. (Preventing Conversation reports from being saved to the database, although it seems unlikely)

It's in the AdminCP under Tools->Diagnostics->File Health Check

 

[Nudaii]

no it doesn't appear in database (convo reports) yet if i report a normal post it appears right away

 

[Nudaii]

Try running a file health check to see if any files have been manually changed.

It's in the AdminCP under Tools->Diagnostics->File Health Check

"All 1,097 checked files are present and correct." is result of that.

 

[shadrxninga]

"All 1,097 checked files are present and correct." is result of that.

Worth a shot... this seems pretty odd...

What is the output of this query on the database? I was able to reproduce this problem by removing the 'conversation_message' type, maybe it's been changed in that install of XenForo?

SELECT * FROM `xf_content_type`

 

[Paul B]

no it doesn't appear in database (convo reports) yet if i report a normal post it appears right away

Does it appear in the thread table?

 

[Nudaii]

Does it appear in the thread table?

no

 

[Nudaii]

Worth a shot... this seems pretty odd...

What is the output of this query on the database? I was able to reproduce this problem by removing the 'conversation_message' type, maybe it's been changed in that install of XenForo?

SELECT * FROM `xf_content_type`

 

[shadrxninga]

Unless phpMyAdmin cutoff some results there, it looks like you're missing two types which would prevent the reports from showing. I'm not too sure how to add them back in so give me a few minutes while I work it out .

These entries should be there.


Also did you disable or uninstall every add-on?

 

[Nudaii]

Unless phpMyAdmin cutoff some results there, it looks like your missing two types which would prevent the reports from showing. I'm not too sure how to add them back in so give me a few minutes while I work it out .

These entries should be there.
View attachment 64360

Also did you disable or uninstall every add-on?

uninstalled, however the above screenshot from a fresh "snapshot" of live cloned to dev (all addons back)

 

[shadrxninga]

Ok! Here's what you'll need to do.

Run these queries on the database:

INSERT IGNORE INTO xf_content_type
    (content_type, addon_id, fields)
VALUES
    ('conversation', 'XenForo', '');

INSERT IGNORE INTO xf_content_type_field
    (content_type, field_name, field_value)
VALUES
    ('conversation', 'alert_handler_class', 'XenForo_AlertHandler_Conversation'),
    ('conversation', 'spam_handler_class', 'XenForo_SpamHandler_Conversation'),
    ('conversation', 'stats_handler_class', 'XenForo_StatsHandler_Conversation');

INSERT IGNORE INTO xf_content_type
    (content_type, addon_id, fields)
VALUES
    ('conversation_message', 'XenForo', '');

INSERT IGNORE INTO xf_content_type_field
    (content_type, field_name, field_value)
VALUES
    ('conversation_message', 'attachment_handler_class', 'XenForo_AttachmentHandler_ConversationMessage'),
    ('conversation_message', 'report_handler_class', 'XenForo_ReportHandler_ConversationMessage');

You'll then need to disable then re-enable any add-on (doesn't matter which one) to rebuild the content type caches. Hopefully this should fix your problem!

It doesn't however fix why it happened in the first place... so it may occur again.

 

[Nudaii]

thanks i will try in a few moments

 

[Nudaii]

that fixed it thanks, jnow i must look why they vanished!

 

[Paul B]

I suspect uninstalling an add-on may be a likely candidate.

 

[Nudaii]

thats my guess too, i have backups from 60 days, seems convo reports stopped working on dec 15th day we upgraded to 1.2x

i will have a look which addon caused it.

 

[Nudaii]

http://xenforo.com/community/resources/conversation-search-by-waindigo.1721/ it was related to this addon.