Support Forum
Support Forum
Offline
I had new plugin update notice in WP Admin area. I updated the plugins. Now no one, even ADMIN, canot read any post. It gives acccess denied error and a red popup with "Invalid databasse querry" Below is cut and paste from the error log file.
| October 1, 2012 12:50 pm | php | file: iddiqi/public_html/wp-content/sp-resources/forum-plugins/watches/template-tags/sp-watches-watch-button-tag.php line: 42 function: sp_WatchesWatchButtonTag Notice | Trying to get property of non-object |
| October 1, 2012 12:50 pm | php | file: iddiqi/public_html/wp-content/sp-resources/forum-plugins/subscriptions/template-tags/sp-subscriptions-subscribe-button-tag.php line: 43 function: sp_SubscriptionsSubscribeButtonTag Notice | Trying to get property of non-object |
| October 1, 2012 12:50 pm | database | file: /problem-with-post-edit-buttonome/ssiddiqi/public_html/wp-content/plugins/simple-press/forum/content/classes/sp-topic-view-class.php line: 228 function: select error: Unknown column 'thanks' in 'field list'
SELECT wp_sftopics.topic_id, wp_sftopics.forum_id, topic_name, topic_slug, topic_status, topic_icon, wp_sftopics.post_count, forum_slug, forum_status, 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, blog_post_id, attachments, polls, poll, post_ratings, rating_id, vote_count, ratings_sum, ips, members, thanks, topic_subs, use_tags, topic_desc, topic_status_set, topic_status_flag, topic_watches 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=1912 ORDER BY post_pinned DESC, wp_sfposts.post_id ASC LIMIT 0, 20 |
| September 30, 2012 8:52 pm | database | file: /problem-with-post-edit-buttonome/ssiddiqi/public_html/wp-content/plugins/simple-press/sp-api/sp-api-primitives.php line: 312 function: sp_update_sfmeta error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's birthdays and upcoming birthdays.
Just download, install and ac' at line 4 UPDATE wp_sfmeta SET meta_type='news', meta_key='news', meta_value='a:3:{s:2:"id";s:1:"4";s:4:"show";i:1;s:4:"news";s:639:" New - Post Thanks and Birthdays Plugins Released Now available to download - the Birthdays plugin for your Simple:Press forum. Post Thanks: Allows your users to give thanks to post authors for good post and includes a points/reputation system. Birthdays: Allows your users to enter birtdate info in their profile and for you forum to show Today's birthdays and upcoming birthdays. Just download, install and activate. Available on our Plugins Download Page. ";}', autoload=0 WHERE meta_id=22 |
Offline
Away for couple days and trying to do via email.
Is the post thanks plugin active? It seems so but it's db columns are missing. Can you try un installing that plugin and then reactivating it? It should create the missing db table.
First couple are noticed and not related.
Visit Cruise Talk Central and Mr Papa's World
Offline
Mr. Papa,
I did that, now I have double "thanked" coulmn in the database. Posts can be read now, but error log has the following:
| October 1, 2012 2:16 pm | database | file: /problem-with-post-edit-buttonome/ssiddiqi/public_html/wp-content/sp-resources/forum-plugins/post-thanks/sp-thanks-plugin.php line: 62 function: sp_thanks_do_install error: Duplicate column name 'thanked'
ALTER TABLE wp_sfmembers ADD (thanked int(4) default NULL) |
Offline
That is just telling you that when you reinstalled the thanks plugjn it found the column DID exist already. Which is odd considering that earlier you were being told it didn't.
 |
YELLOW
SWORDFISH
|
Offline
yes, it is odd. earlier, I could not read any posts, as amnistrator, neiither users could do.
Offline
Mr Papa said
so its working now?
Yes, it is working great. There were a few other kick-ups, but Plugin Organizer took care of it, by disabeling a few more WP plugins for the Simple Press Forum page. In my opinion SimplePresss cannot live without Plugin Organizer plugin on my system.
Offline
thought it was IE only it saved you? fingers crossed IE 10 finally reaches legit status! 
thanks for the update... we had another user where the same plugin was able to fix another IE specific issue on their site...
Visit Cruise Talk Central and Mr Papa's World
Offline
Mr Papa said
thought it was IE only it saved you? fingers crossed IE 10 finally reaches legit status!thanks for the update... we had another user where the same plugin was able to fix another IE specific issue on their site...
Actually these issues were not IE9 specific this time. However, Plugin Organizer took care of it.
Offline
okay cool.... rare to find conflicts when wp themes and plugins use the wp api...
Visit Cruise Talk Central and Mr Papa's World
All RSS1 Guest(s)