Support Forum

Can't see posts/topics after full site restore

TE Teresa
Teresa
Member

Hello,

After doing a full site backup on Sunday morning, I upgraded to WP4.1 and upgraded Simple Press and all associated plugins and themes. After that, I was getting error messages in my forum. I restored from the full backup. So I’m back now to WP4.0 and to SP 5.2. This was a full site restore.

 

Now that that was done I can create a topic but I can’t see any topics. I can see that there are topics but when I click on the forum, it tells me there are no new topics. When a member makes a new topic, I can see it in the mailbag. But when I click “close and go to topic” so I can reply, then I get a message telling me there are no topics.

 

What should I be checking/doing to correct this?

 

Thanks,

Teresa

54 Answers

New Answer

TE Teresa
Teresa
Member

Here’s the message I get:

Access denied – you do not have permission to view this page

IK Ike
Ike
Member

Hey Teresa,

Are you seeing any error messages on the forum page?

Could you first try resetting the auths cache in Forum > Toolbox > Housekeeping?

Could you take a look in the error log? To do this, go to the admin page and navigate to Forum > Toolbox > Error Log. Empty the log with the button at the bottom, reload the forum page, then go back to the error log and refresh to see if any errors are showing. You can ignore warnings as just harmless notices, but if you can please paste any errors you see here.

TE Teresa
Teresa
Member

Are you seeing any error messages on the forum page?

When I click on the last post, I get:

Access denied – you do not have permission to view this page

 

When I click on a forum, I get:

There are no topics in this forum

 

Could you first try resetting the auths cache in Forum > Toolbox > Housekeeping?

Okay, I’ve done that.

Could you take a look in the error log?

Two errors:

January 20, 2015 9:24 am | spaErrError | 1 | database


file: /problem-with-post-edit-buttonome4/rogovsky/public_html/passionforlawofattraction.com/wp-content/plugins/simple-press/forum/content/classes/sp-topic-view-class.php

line: 238

function: select

error: Unknown column ‘topic_subs’ in ‘field list’

SELECT group_id, wp_sftopics.topic_id, wp_sftopics.forum_id, topic_name, topic_slug, topic_status, topic_pinned, topic_icon, topic_opened, wp_sftopics.post_count, forum_slug, forum_status, forum_disabled, forum_rss_private, wp_sfposts.post_id, post_date, wp_sfposts.user_id, wp_sftopics.user_id AS topic_starter, guest_name, guest_email, post_status, post_pinned, post_index, post_edit, poster_ip, source, post_content, wp_sfwaiting.post_count AS new_post, answered, polls, poll, topic_subs, topic_desc FROM wp_sftopics JOIN wp_sfposts ON wp_sftopics.topic_id=wp_sfposts.topic_id JOIN wp_sfforums ON wp_sftopics.forum_id=wp_sfforums.forum_id LEFT JOIN wp_sfwaiting ON wp_sfposts.post_id=wp_sfwaiting.post_id WHERE wp_sftopics.topic_id=1301 ORDER BY post_pinned DESC, wp_sfposts.post_id ASC LIMIT 0, 20

 

And

 

January 20, 2015 9:25 am | spaErrError | 1 | database


file: /problem-with-post-edit-buttonome4/rogovsky/public_html/passionforlawofattraction.com/wp-content/plugins/simple-press/forum/content/classes/sp-forum-view-class.php

line: 313

function: select

error: Unknown column ‘topic_subs’ in ‘field list’

SELECT wp_sftopics.forum_id, forum_slug, forum_name, forum_status, group_id, topic_count, forum_icon, topic_icon, topic_icon_new, topic_icon_locked, forum_desc, forum_rss, forum_rss_private, parent, children, forum_message, forum_disabled, keywords, wp_sftopics.topic_id, topic_slug, topic_name, topic_status, topic_pinned, topic_opened, wp_sftopics.post_id, wp_sftopics.post_count, polls, topic_subs, topic_desc FROM wp_sftopics JOIN wp_sfforums ON wp_sftopics.forum_id = wp_sfforums.forum_id WHERE wp_sfforums.forum_id=99 ORDER BY topic_pinned DESC, wp_sftopics.post_id DESC LIMIT 0, 12

YS Yellow Swordfish
Yellow Swordfish
Member

That looks like you have restored an older version of the forum and its plugins bit have not restored to an equivalent older database.

is this perhaps the case?

TE Teresa
Teresa
Member

Yellow Swordfish said
That looks like you have restored an older version of the forum and its plugins bit have not restored to an equivalent older database.

is this perhaps the case?

There is a long list of plugins waiting to be updated that say they require 5.5.3, so I think the answer is no.

Two plugins in that list said that they require 5.5 (not 5.5.3) so I went ahead and updated them but that made no difference in my ability to see things in the forum.

YS Yellow Swordfish
Yellow Swordfish
Member

Apologies – I was on a mobile phone enjoying a cafe panettone when I replied before so was perhaps a little brief.

The database errors you are seeing can only really be interpreted one way. The missing column ‘topic_subs’ (which causes the database query to fail which then causes the page to believe there is nothing to display) was removed in the version 1.4.7 update of the Subscriptions plugin. This was the version of the plugin that was released at the same time as the core Simple:Press version 5.5.3 – or the very last one to be released.

This mean that if the database is a pre-5.5.3 version then those columns would still be there – unless the Subscriptions plugin version you have is, in fact 1.4.7 and it has already updated the database. Either way there is an anomaly.

Full site backups may also not include the database depending, perhaps, on the tools being used. Normally, the database gets backed up differently as mySQL is a shared resource across all websites on a server.

Perhaps the key to this is what were the ‘error messages in my forum’ you were seeing after the updates were applied right at the top of the thread? Solving those is probably the best and safest way to go.

TE Teresa
Teresa
Member

Hello,

 

Thank you for following up. 

 

Here are the error messages I get when I’m on the forum.

 

When I click on the last post, I get:

“Access denied – you do not have permission to view this page”

 

When I click on a forum, I get:

“There are no topics in this forum”

 

As for the Subscriptions plugin, here is what it says:

Subscriptions
You have version 1.4.6 installed. Update to 1.4.7. Requires SP Version 5.5.3.

 

Thank you,

Teresa

YS Yellow Swordfish
Yellow Swordfish
Member

So are you saying that these were the messages you were getting AFTER you upgraded everything and BEFORE you restored the site backup? Which are the damer messages you are getting now after the restore? IS that right?

TE Teresa
Teresa
Member

No, those are the messages I’m getting now. 

 

The message I was getting after I upgraded but before I restored the backup was:

Fatal error: Call to undefined function sp_get_activity_exists() in /problem-with-post-edit-buttonome4/rogovsky/public_html/passionforlawofattraction.com/wp-content/sp-resources/forum-plugins/subscriptions/sp-subscriptions-plugin.php on line 306

 

There may be a typo in there. I took a screenshot of the message, and I typed this out from the screenshot.

 

(I don’t know what you mean by “damer messages”.)

 

Teresa

YS Yellow Swordfish
Yellow Swordfish
Member

“damer messages”…! Sorry typo for ‘same messages’!

Now the original message you received might have shown up if you upgraded SP plugins before the core and ran the forum admin. It would have perhaps tried to use a function which was not there yet as it was in the core SP 5.5.3. At least that is the only thing that comes to mind…

I really do think you need to perform all the upgrades again – starting with WP then SP core and then the SP plugins and see what happens. And if a problem after that we will be in a stronger position to help and sort it out.

YS Yellow Swordfish
Yellow Swordfish
Member

Let us know what happens either way please…

TE Teresa
Teresa
Member

I updated to WP4.1 then I updated Simple Press. 

 

I got the following:

The update process is starting. This process may take a while on some hosts, so please be patient.

Updating Plugin Simple:Press (1/1)
Simple:Press updated successfully. Show Details.

All updates have been completed.

Upgrade the Simple:Press Database | Return to WordPress Updates | Return to Plugins page

 

However, when I click “Upgrade the Simple Press Database” then I get:

You do not have sufficient permissions to access this page.

I have full admin rights and don’t see how I wouldn’t have permission to access a page.

 

On the plugins page of my dashboard, it still shows SP5.5.2 and that I need to update to 5.5.3.

 

All of that is what I encountered on Sunday (I’m now remembering).

Teresa

YS Yellow Swordfish
Yellow Swordfish
Member

Can you confirm that the message ‘You do not have sufficient permissions to access this page’  is EXACTLY what you see because this is not one of our messages so we would need to try and find out where it is coming from.