Support Forum

Subscriptions: When Activated "Access denied – you do not have permission to view this page"

JS Jakob Silker
Jakob Silker
Member
Member since Sep 2012
11 posts
Sep 10, 2012 · 9:46 pm · Edited

I receive “Access denied – you do not have permission to view this page” error.

I can view my forums list.  The post or topic count is correct.  But, when I try to view the forum, I receive the “Access Denied” note.  I am admin and all users see same error.

When the page loads, it says “Invalid Database Query” at the top.

 

When I “Deactivate” subscriptions, everything works as expected.

 

Today, I found out my digests were not working due to the “cron” files not being present.  I reinstalled the plugin. I know this created a “subscriptions1” folder.  I have uninstalled and reinstalled.   I correct the folder name to “subscriptions”…I simply cannot activate it and view the topics.

 

How can I have the subscriptions plugin activated AND allow forum access?  I do not know what “database query” is giving me the error.

wp-content/plugins/simple-press/forum/content/classes/sp-topic-view-class.php
line: 228
function: select
error: Unknown column ‘topic_subs’ in ‘field list’

 

Thanks for any help!

3 Answers

New Answer
MP Mr Papa
Mr Papa
Member
Member since Dec 2006
19,448 posts
Sep 10, 2012 · 10:38 pm

not sure I understand your comment about enabling subscriptions and viewing forums – that is independent…

when you activate subscriptions, you might be running into a wp bug where it gets the 1 added to directory name… It cannot have that 1 and must be subscriptions… cron files? do you mean wp cron files? or do you just mean the cron tasks within wp?

but first, lets work the invalid query you are getting… you are getting that when subscriptions is activated?

please check forum – toolbox – error log and get some more information on the query that failed and post it back here please…

JS Jakob Silker
Jakob Silker
Member
Member since Sep 2012
11 posts
Sep 10, 2012 · 11:12 pm

Fixed:

I used PHP Admin to add the missing column.

ALTER TABLE `wp_sftopics` ADD `topic_subs` INT( 1 ) NOT NULL

I don’t know why it disappeared or what happened to cause the error. But, that fixed it.

 

Should anyone else have the problem, here is what I had to do:

I had to update my subscriptions plugin, because the hook: sph_subs_digest_cron was not present.

The cron schedule was there…but not the hook.

After re-installing the plugin, I needed to change the plugin folder to “subscriptions” as it was automatically being called “subscriptions1”.  Then, I needed to add that missing column.  (using php admin as described above)

Also, the Forum Subscription option wasn’t appearing on Member Profiles any more.  To fix that, I also had to go to the Component “subscriptions” to deactivate “allow members to subscribe to forums”, save, and then re-activate and save again.

YS Yellow Swordfish
Yellow Swordfish
Member
Member since Nov 2008
16,437 posts
Sep 11, 2012 · 2:07 am

I think your problems started with the mis-naming of the folder and just escalated from that point. The correct activation code would not have been run.
We have spent a lot of time investigating why sometimes the ‘1’ gets appended to to a plugin folder name and have discovered it is actually a WP problem when the update button is double clicked. We hope we have buttoned this down in the next SP core update.