Support Forum
Whenever I have the "Polls" plugin activated, every user gets an "Access denied - you do not have permission to view this page" error. I also get the little fading warning box about "Invalid Database Query" up top. Disabling the plugin makes the error go away.
I found the following entry in the error log:
file: /home/myusername/public_html/wp-content/plugins/simple-press/forum/content/classes/sp-topic-view-class.php
line: 236
function: select
error: Unknown column 'poll' in 'field list'SELECT SQL_CALC_FOUND_ROWS 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_name, 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, NULL AS new_post, polls, poll, expire_date 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 WHERE wp_sftopics.topic_id=7079 ORDER BY post_pinned DESC, wp_sfposts.post_id ASC LIMIT 0, 20
I have the latest version of both: SimplePress is 5.7.1 and Polls is 1.6.1.
I did, however, recently upgrade WordPress and SimpleForum through several generations to get them up to date; perhaps a database table wasn't updated correctly along the way.
Thank you for any help!
not sure what would be up with the permission message as the polls plugin does not have anything to do with page access... quite odd...
as to the db error, yes it seems that you are missing at least one column in your database... can you check your database, the wp_sfforums table and verify if you have a polls column or not?
have you done anything with polls yet? if not easiest way to try to fix is to uninstall the plugin (on forum - plugins - plugin list) and then activate again... this will remove any polls data so if you have existing data, you may not want to do this...
lets fix that, then come back to the permission message...
Visit Cruise Talk Central and Mr Papa's World
Thank you. The "poll" field was missing from the sf_posts database. Somehow when I restored data during my migration, it didn't include this field. I restored it manually in phpmyadmin and now it works again.
(I wonder why this field wasn't recreated when I deactivated, then deleted and reactivated the plugin. It might be smart to add a check to the plugin to make sure the field is there and add it if not.)
1 Guest(s)