Support Forum

New update new bug

LO lordgault
lordgault
Member

Hello again, after the latest update (v 5.0 Release Candidate Build 7759 ) every time you load the forum shows the error message you see in the picture. Sorry I can not provide more information.
The forum is http://masalladelared.com/foro
Translate by goole
thanks

17 Answers

New Answer

YS Yellow Swordfish
Yellow Swordfish
Member

Really? That’s worrying. Can you do the following for me please:

  1. Go to forum admin > Toolbox > Error Log
  2. At the bottom of any displayed errors is a button to clear the log. Clear it.
  3. Run the forum again and generate the error.
  4. Go back to the log and redisplay it.
  5. Copy and paste here the content of the error reported.

And I will look to see what the issue is.

LO lordgault
lordgault
Member
Date Type Description
20 enero 2012

13:31

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

line: 315

function: sp_pm_do_user_class

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

SELECT adversary_id FROM patriblog_sfadversaries WHERE user_id=1

20 enero 2012

13:31

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

line: 315

function: sp_pm_do_user_class

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

SELECT adversary_id FROM patriblog_sfadversaries WHERE user_id=1

20 enero 2012

13:31

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

line: 315

function: sp_pm_do_user_class

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

SELECT adversary_id FROM patriblog_sfadversaries WHERE user_id=1

20 enero 2012

13:31

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

line: 315

function: sp_pm_do_user_class

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

SELECT adversary_id FROM patriblog_sfadversaries WHERE user_id=1

20 enero 2012

13:30

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

line: 315

function: sp_pm_do_user_class

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

SELECT adversary_id FROM patriblog_sfadversaries WHERE user_id=1

20 enero 2012

13:30

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

line: 315

function: sp_pm_do_user_class

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

SELECT adversary_id FROM patriblog_sfadversaries WHERE user_id=1

20 enero 2012

13:30

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

line: 315

function: sp_pm_do_user_class

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

SELECT adversary_id FROM patriblog_sfadversaries WHERE user_id=1

20 enero 2012

13:30

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

line: 315

function: sp_pm_do_user_class

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

SELECT adversary_id FROM patriblog_sfadversaries WHERE user_id=1

20 enero 2012

13:30

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

line: 315

function: sp_pm_do_user_class

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

SELECT adversary_id FROM patriblog_sfadversaries WHERE user_id=1

20 enero 2012

13:30

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

line: 315

function: sp_pm_do_user_class

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

SELECT adversary_id FROM patriblog_sfadversaries WHERE user_id=1

20 enero 2012

13:30

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

line: 315

function: sp_pm_do_user_class

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

SELECT adversary_id FROM patriblog_sfadversaries WHERE user_id=1

20 enero 2012

13:30

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.patriblog_sfmessages’ doesn’t exist

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

20 enero 2012

13:30

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

line: 315

function: sp_pm_do_user_class

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

SELECT adversary_id FROM patriblog_sfadversaries WHERE user_id=1

20 enero 2012

13:30

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.patriblog_sfmessages’ doesn’t exist

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

20 enero 2012

13:30

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

line: 315

function: sp_pm_do_user_class

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

SELECT adversary_id FROM patriblog_sfadversaries WHERE user_id=1

20 enero 2012

13:30

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

line: 315

function: sp_pm_do_user_class

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

SELECT adversary_id FROM patriblog_sfadversaries WHERE user_id=1

20 enero 2012

13:30

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

line: 315

function: sp_pm_do_user_class

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

SELECT adversary_id FROM patriblog_sfadversaries WHERE user_id=1

YS Yellow Swordfish
Yellow Swordfish
Member

er… 1 would have done it – these are all the same basic error after all.

So – for some reason the PM plugin seems to have not created your Pm tables. Not something we have any other reports about.

When did you install the PM plugin?

As it can not have been used can you try uninstalling it (NOT deactivating) and then re-activating?

LO lordgault
lordgault
Member

With the latest update I noticed that there were two folders same plugin and delete one of them, possibly delete the correct folder.
Translated by google

PD: Now let me not sending pm

LO lordgault
lordgault
Member

Yellow Swordfish said

 

…As it can not have been used can you try uninstalling it (NOT deactivating) and then re-activating?

 

not working
YS Yellow Swordfish
Yellow Swordfish
Member

Sorry – I realise there is a language problem but can you possibly give a more detailed explanation as I do not understand what you mean about ‘two folders’?

LO lordgault
lordgault
Member

forum admin > Plugin> Available Plugin> Private Message System had two, one deactivate, another activate and delete the deactivate.

translated by google
YS Yellow Swordfish
Yellow Swordfish
Member

wow. How odd. What about in the plugin folder? Were there two copies in there? Maybe with a different name or something?

LO lordgault
lordgault
Member

It is as I explained, two p.m. plugin. One active, the other off. With an FTP client delete the plugin folder and and went up the new version of plugin. Since then I get the error mentioned.

YS Yellow Swordfish
Yellow Swordfish
Member

So again. Have you ‘uninstalled’ (NOT deactivated) the one you have and then reactivated it?

LO lordgault
lordgault
Member

Yellow Swordfish said

So again. Have you ‘uninstalled’ (NOT deactivated) the one you have and then reactivated it?

Yes, and not work

YS Yellow Swordfish
Yellow Swordfish
Member

OK we are going to need to talk this one over here so can we just confirm one or two things?

I am still a little confused over this ‘two copies’ business.

Was and is there ONE copy in the SP plugins folder?

Was and is there ONE entry in the SP admin plugins list?

Then can you go to the forum admin > toolbox > error log. At the bottom of the lost there is abutton to clear the errors. Please clear them

Then go to plugins again and Uninstall PM.s

Back to error log – are there any entries?

Bacvk to plugins – activate PMs.

Back to error log – are there any entries?

LO lordgault
lordgault
Member

Was and is there ONE copy in the SP plugins folder?

In the plugins folder there was only one PM plugin message

 

Was and is there ONE entry in the SP admin plugins list?

In the list of SP admin plugins list had two PM message plugin, one active, one deactive, now only one
 

Then can you go to the forum admin > toolbox > error log. At the bottom of the lost there is abutton to clear the errors. Please clear them

ok

 

Then go to plugins again and Uninstall PM.s

ok

 

Back to error log – are there any entries?

yes

Date Type Description
21 enero 2012

10:00

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

line: 151

function: sp_pm_do_upgrade_check

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

ALTER TABLE patriblog_sfmessages ADD KEY message_status_idx (message_status)

21 enero 2012

10:00

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

line: 151

function: sp_pm_do_upgrade_check

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

ALTER TABLE patriblog_sfmessages ADD KEY sentbox_idx (sentbox)

21 enero 2012

10:00

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

line: 151

function: sp_pm_do_upgrade_check

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

ALTER TABLE patriblog_sfmessages ADD KEY inbox_idx (inbox)

21 enero 2012

10:00

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

line: 151

function: sp_pm_do_upgrade_check

error: Unknown column ‘buddies’ in ‘where clause’

UPDATE patriblog_sfmembers SET buddies=” WHERE buddies=’0′

21 enero 2012

10:00

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

line: 121

function: sp_pm_do_uninstall

error: Can’t DROP ‘buddies’; check that column/key exists

ALTER TABLE patriblog_sfmembers DROP buddies

21 enero 2012

09:59

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

line: 315

function: sp_pm_do_user_class

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

SELECT adversary_id FROM patriblog_sfadversaries WHERE user_id=1

21 enero 2012

09:59

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

line: 315

function: sp_pm_do_user_class

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

SELECT adversary_id FROM patriblog_sfadversaries WHERE user_id=1

21 enero 2012

09:59

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

line: 315

function: sp_pm_do_user_class

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

SELECT adversary_id FROM patriblog_sfadversaries WHERE user_id=1

 

Bacvk to plugins – activate PMs.

ok

 

Back to error log – are there any entries?

yes

Date Type Description
21 enero 2012

10:03

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

line: 315

function: sp_pm_do_user_class

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

SELECT adversary_id FROM patriblog_sfadversaries WHERE user_id=1

21 enero 2012

10:03

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

line: 315

function: sp_pm_do_user_class

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

SELECT adversary_id FROM patriblog_sfadversaries WHERE user_id=1

21 enero 2012

10:03

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

line: 315

function: sp_pm_do_user_class

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

SELECT adversary_id FROM patriblog_sfadversaries WHERE user_id=1

21 enero 2012

10:03

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

line: 315

function: sp_pm_do_user_class

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

SELECT adversary_id FROM patriblog_sfadversaries WHERE user_id=1

21 enero 2012

10:03

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

line: 315

function: sp_pm_do_user_class

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

SELECT adversary_id FROM patriblog_sfadversaries WHERE user_id=1

21 enero 2012

10:03

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

line: 315

function: sp_pm_do_user_class

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

SELECT adversary_id FROM patriblog_sfadversaries WHERE user_id=1

21 enero 2012

10:03

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

line: 315

function: sp_pm_do_user_class

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

SELECT adversary_id FROM patriblog_sfadversaries WHERE user_id=1

21 enero 2012

10:02

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

line: 315

function: sp_pm_do_user_class

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

SELECT adversary_id FROM patriblog_sfadversaries WHERE user_id=1

21 enero 2012

10:00

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

line: 151

function: sp_pm_do_upgrade_check

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

ALTER TABLE patriblog_sfmessages ADD KEY message_status_idx (message_status)

21 enero 2012

10:00

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

line: 151

function: sp_pm_do_upgrade_check

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

ALTER TABLE patriblog_sfmessages ADD KEY sentbox_idx (sentbox)

21 enero 2012

10:00

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

line: 151

function: sp_pm_do_upgrade_check

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

ALTER TABLE patriblog_sfmessages ADD KEY inbox_idx (inbox)

21 enero 2012

10:00

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

line: 151

function: sp_pm_do_upgrade_check

error: Unknown column ‘buddies’ in ‘where clause’

UPDATE patriblog_sfmembers SET buddies=” WHERE buddies=’0′

21 enero 2012

10:00

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

line: 121

function: sp_pm_do_uninstall

error: Can’t DROP ‘buddies’; check that column/key exists

ALTER TABLE patriblog_sfmembers DROP buddies

21 enero 2012

09:59

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

line: 315

function: sp_pm_do_user_class

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

SELECT adversary_id FROM patriblog_sfadversaries WHERE user_id=1

21 enero 2012

09:59

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

line: 315

function: sp_pm_do_user_class

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

SELECT adversary_id FROM patriblog_sfadversaries WHERE user_id=1

21 enero 2012

09:59

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

line: 315

function: sp_pm_do_user_class

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

SELECT adversary_id FROM patriblog_sfadversaries WHERE user_id=1

YS Yellow Swordfish
Yellow Swordfish
Member

Ok – we need to just take these away and have a good look and discussion thanks.

This has been a unique report and as such is going to be perhaps difficult to work out what happened. If you can shed any more light on what transpired that would be useful.

But we will look and get back to you.