Support Forum
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
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.
YELLOW
SWORDFISH
|
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
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.
YELLOW
SWORDFISH
|
1 Guest(s)