Support Forum

Advanced Search
Forum Scope


Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
plugins-topic
Subscriptions: When Activated "Access denied - you do not have permission to view this page"
Avatar
Jakob Silker
Member
Free Members
sp_UserOfflineSmall Offline
Sep 10, 2012 - 9:46 pm

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!

Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
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...

Avatar
Jakob Silker
Member
Free Members
sp_UserOfflineSmall Offline
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.

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
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.

andy-signature.png
YELLOW
SWORDFISH
Forum Timezone: Europe/Stockholm
Most Users Ever Online: 1170
Currently Online:
Guest(s) 1
Currently Browsing this Page:
1 Guest(s)
Top Posters:
Mr Papa: 19448
Ike: 2086
Brandon: 864
kvr28: 804
jim: 650
FidoSysop: 577
Conrad_Farlow: 531
fiddlerman: 358
Stefano Prete: 325
Member Stats:
Guest Posters: 619
Members: 17363
Moderators: 0
Admins: 4
Forum Stats:
Groups: 7
Forums: 17
Topics: 10127
Posts: 79625