Support Forum
Support Forum
Offline
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
Offline
Here's the message I get:
Access denied - you do not have permission to view this page
Offline
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.
Offline
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
Offline
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?
 |
YELLOW
SWORDFISH
|
Offline
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.
Offline
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.
|
YELLOW
SWORDFISH
|
Offline
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
Offline
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?
|
YELLOW
SWORDFISH
|
Offline
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
All RSS1 Guest(s)