Support Forum

Reasignar hilo, perdida de usuarios y MP

25 Answers

New Answer

MP Mr Papa
Mr Papa
Member

hang loose for bit… I am researching a potential issue in the pm plugin with regards to that table…

give me few minutes to figure out if there is an issue…

MP Mr Papa
Mr Papa
Member

yeah, found a potential problem… trying to resolve…

LO lordgault
lordgault
Member

right. I’ll be very attentive to the news.
thanks for this wonderful plugin-forum that is simple-press.

MP Mr Papa
Mr Papa
Member

lordgault, can I email you an updated version of the plugin to try for me?

LO lordgault
lordgault
Member

not working

error log

Date Type Description
19 febrero 2012

19:58

database file: /problem-with-post-edit-buttonome5/masalla1/public_html/wp-content/sp-resources/forum-plugins/private-messaging/library/sp-pm-components.php

line: 368

function: sp_pm_get_threads

error: Table ‘masalla1_wrd2.xxxxxxxxxx_sfmessages’ doesn’t exist

SELECT max(message_id) as message_id, title, message_slug, count(message_slug) as pm_count, sum(message_status) as status, sum(from_id = 1) as status2, display_name, sent_date FROM xxxxxxxx_sfmessages JOIN xxxxxxx_sfmembers ON xxxxxxx_sfmessages.from_id = xxxxxxx_sfmembers.user_id WHERE (to_id = 1 AND inbox = 1) OR (from_id = 1 AND sentbox = 1) AND message_id in (SELECT message_id FROM xxxxxx_sfmessages GROUP BY message_slug, sent_date) GROUP BY message_slug ORDER BY message_id DESC

19 febrero 2012

19:58

database file: /problem-with-post-edit-buttonome5/masalla1/public_html/wp-content/sp-resources/forum-plugins/private-messaging/template-tags/sp-pm-inbox-button-tag.php

line: 26

function: spdb_count

error: Table ‘masalla1_wrd2.xxxxxxxx_sfmessages’ doesn’t exist

SELECT COUNT(*) FROM xxxxxxx_sfmessages WHERE to_id=1 AND inbox=1 AND message_status=0

19 febrero 2012

19:58

database file: /problem-with-post-edit-buttonome5/masalla1/public_html/wp-content/sp-resources/forum-plugins/private-messaging/library/sp-pm-components.php

line: 368

function: sp_pm_get_threads

error: Table ‘masalla1_wrd2.xxxxxxx_sfmessages’ doesn’t exist

SELECT max(message_id) as message_id, title, message_slug, count(message_slug) as pm_count, sum(message_status) as status, sum(from_id = 1) as status2, display_name, sent_date FROM xxxxxx_sfmessages JOIN xxxxxx_sfmembers ON xxxxxx_sfmessages.from_id = xxxxxx_sfmembers.user_id WHERE (to_id = 1 AND inbox = 1) OR (from_id = 1 AND sentbox = 1) AND message_id in (SELECT message_id FROM xxxxxxx_sfmessages GROUP BY message_slug, sent_date) GROUP BY message_slug ORDER BY message_id DESC

19 febrero 2012

19:58

database file: /problem-with-post-edit-buttonome5/masalla1/public_html/wp-content/sp-resources/forum-plugins/private-messaging/template-tags/sp-pm-inbox-button-tag.php

line: 26

function: spdb_count

error: Table ‘masalla1_wrd2.xxxxxx_sfmessages’ doesn’t exist

SELECT COUNT(*) FROM xxxxxxx_sfmessages WHERE to_id=1 AND inbox=1 AND message_status=0

19 febrero 2012

19:58

database file: /problem-with-post-edit-buttonome5/masalla1/public_html/wp-content/sp-resources/forum-plugins/private-messaging/template-tags/sp-pm-inbox-button-tag.php

line: 26

function: spdb_count

error: Table ‘masalla1_wrd2.xxxxxxx_sfmessages’ doesn’t exist

SELECT COUNT(*) FROM xxxxxxxx_sfmessages WHERE to_id=1 AND inbox=1 AND message_status=0

19 febrero 2012

19:57

database file: /problem-with-post-edit-buttonome5/masalla1/public_html/wp-content/sp-resources/forum-plugins/private-messaging/template-tags/sp-pm-inbox-button-tag.php

line: 26

function: spdb_count

error: Table ‘masalla1_wrd2.xxxxxxxx_sfmessages’ doesn’t exist

SELECT COUNT(*) FROM xxxxxxxx_sfmessages WHERE to_id=1 AND inbox=1 AND message_status=0

MP Mr Papa
Mr Papa
Member

well actually those are quite different… you do have the pm plugin active, right?

at this point, I think you need to uninstall the pm plugin from the sp plugins panel (do not uninstall sp)… and then reactivate it…

LO lordgault
lordgault
Member

Mr Papa said

well actually those are quite different… you do have the pm plugin active, right?

 

at this point, I think you need to uninstall the pm plugin from the sp plugins panel (do not uninstall sp)… and then reactivate it…

Now it works.
Thank you very much for the helplaughlaughlaughlaugh