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
"Post Ratings" Plugin when activated caused access permisson issues
Avatar
Hong Tang
Member
Free Members
sp_UserOfflineSmall Offline
Aug 31, 2013 - 6:17 pm

Hello - I am new to Simple Press, especially the Post Rating Plugin. I followed the Plugin installation guide, got it activated and found the following problems:

1) was able to set display option as "stars" - however when going to a forum to enable the feature, it would not stick. Newly created forum shows it's enabled by default. Once saved, going back to edit the forum and the post rating is now shown unchecked  

2) forum postings content now can not be displayed even when logged in as super-admin. When viewing a topic, below the title, it just displays: Access denied - you do not have permission to view this page. Also momentarily I saw a message "Invalid database query"

3) After deactivating the post ratings plugin, the content of the topic can be displayed.

Please help as this feature is very important to us and one of the reasons to migrate to Simple:Press!

Wordpress version 3.6 MU Installation

Simple:Press version 5.3.1

Post Ratings Plugin version 1.3.2

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Sep 1, 2013 - 4:45 am

I think I need to start by asking some questions. So...

Are you running any WordPress caching plugins (like wp-super-cache for example)?

The 'Access Denied' message you are getting... Is this formatted and displayed as if it is intended to be shown to users - or is it just appearing as unformatted text?

Can you go to the forum admin > toolbox > error log and locate the entry for the database invalid query and paste the error text in a reply? If you see the same thing many times just one copy will suffice...

Let's start with that.

andy-signature.png
YELLOW
SWORDFISH
Avatar
Hong Tang
Member
Free Members
sp_UserOfflineSmall Offline
Sep 1, 2013 - 8:18 am

Thank you for the quick response!

We are not running any caching plugins.

"Access denied - you do not have permission to view this page" is displayed for users right where the content of the topic would be displayed.

I see several types of error text:

1) when loading the topic detail page:

file: /var/www/problem-with-post-edit-buttontml/wp-content/plugins/simple-press/forum/content/classes/sp-topic-view-class.php

line: 233

function: select

error: Unknown column 'post_ratings' in 'field list'

SELECT 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, guest_name, guest_email, post_status, post_pinned, post_index, post_edit, poster_ip, source, post_content, wp_sfwaiting.post_count AS new_post, post_ratings, rating_id, vote_count, ratings_sum, ips, members 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 LEFT JOIN wp_sfpostratings ON wp_sfpostratings.post_id = wp_sfposts.post_id WHERE wp_sftopics.topic_id=1 ORDER BY post_pinned DESC, wp_sfposts.post_id ASC LIMIT 0, 20

2) when loading the forum topics listing page:

file: /var/www/problem-with-post-edit-buttontml/wp-content/plugins/simple-press/forum/content/classes/sp-forum-view-class.php

line: 311

function: select

error: Unknown column 'post_ratings' 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, 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, post_ratings FROM wp_sftopics JOIN wp_sfforums ON wp_sftopics.forum_id = wp_sfforums.forum_id WHERE wp_sfforums.forum_id=1 ORDER BY topic_pinned DESC, wp_sftopics.post_id DESC LIMIT 0, 12

3) when saving the forum after "Edit Forum":

file: 

line: 

function: sp_rating_edit_forum_save

error: Unknown column 'post_ratings' in 'field list'

UPDATE wp_sfforums SET post_ratings=1 WHERE forum_id=1

4) when setting rating format to stars:

file: 

line: 

function: sp_rating_edit_forum_save

error: Unknown column 'post_ratings' in 'field list'

UPDATE wp_sfforums SET post_ratings=1 WHERE forum_id=1

5) when plugin was first activated:

file: /var/www/problem-with-post-edit-buttontml/wp-content/sp-resources/forum-plugins/post-rating/sp-rating-plugin.php

line: 113

function: sp_rating_do_install

error: ALTER command denied to user 'www'@'localhost' for table 'wp_sfforums'

ALTER TABLE wp_sfforums ADD (post_ratings smallint(1) NOT NULL default 0)

6) when plugin was first activated:

file: /var/www/problem-with-post-edit-buttontml/wp-content/sp-resources/forum-plugins/post-rating/sp-rating-plugin.php

line: 113

function: sp_rating_do_install

error: ALTER command denied to user 'www'@'localhost' for table 'wp_sfmembers'

ALTER TABLE wp_sfmembers ADD (posts_rated longtext)

----- The last two seem to indicate ALTER was not permitted for the database user. It must be the local database setup for some reason ALTER was not granted. Will try to change it and see how it goes. Most likely that's the issue.

------ the above are all "database" errors. Some additional php warnings:

1)

file: /simple-press/sp-api/sp-api-plugins.php

line: 82

function: closedir

Warning | closedir() expects parameter 1 to be resource, null given

2)

file: /simple-press/forum/content/forms/sp-form-components.php

line: 469

function: sp_post_editor_smileys_options

Notice | Trying to get property of non-object

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Sep 1, 2013 - 8:31 am

Indeed the ALTER privilege would be the killer there. You should uninstall the post ratings plugin - note uninstall not deactivate - until you have the proper set of permissions to alter the db table and then reactivate the plugin and, hopefully, all will be well.

andy-signature.png
YELLOW
SWORDFISH
Avatar
Hong Tang
Member
Free Members
sp_UserOfflineSmall Offline
Sep 1, 2013 - 10:19 am

That was it. Thank you very much!

Got another error in user mapping. Will open a new topic to report it.

Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
Sep 1, 2013 - 1:21 pm

thanks for the update...

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