Support Forum

After upgrade of recent plugin updates, canot read posts.

SS Suhaib Siddiqi
Suhaib Siddiqi
Member
Member since Aug 2012
65 posts
Oct 1, 2012 · 12:58 pm · Edited

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

13 Answers

New Answer
MP Mr Papa
Mr Papa
Member
Member since Dec 2006
19,448 posts
Oct 1, 2012 · 4:28 pm

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.

SS Suhaib Siddiqi
Suhaib Siddiqi
Member
Member since Aug 2012
65 posts
Oct 1, 2012 · 4:55 pm

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)
YS Yellow Swordfish
Yellow Swordfish
Member
Member since Nov 2008
16,437 posts
Oct 1, 2012 · 4:59 pm

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.

SS Suhaib Siddiqi
Suhaib Siddiqi
Member
Member since Aug 2012
65 posts
Oct 1, 2012 · 5:06 pm

yes, it is odd.  earlier, I could not read any posts, as amnistrator, neiither users could do.

SS Suhaib Siddiqi
Suhaib Siddiqi
Member
Member since Aug 2012
65 posts
Oct 3, 2012 · 8:39 am

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.

MP Mr Papa
Mr Papa
Member
Member since Dec 2006
19,448 posts
Oct 3, 2012 · 8:48 am

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…

SS Suhaib Siddiqi
Suhaib Siddiqi
Member
Member since Aug 2012
65 posts
Oct 3, 2012 · 8:52 am

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.

MP Mr Papa
Mr Papa
Member
Member since Dec 2006
19,448 posts
Oct 3, 2012 · 6:51 pm

okay cool….  rare to find conflicts when wp themes and plugins use the wp api… ;)

SS Suhaib Siddiqi
Suhaib Siddiqi
Member
Member since Aug 2012
65 posts
Oct 3, 2012 · 7:00 pm

Well, I am not really counting on IE 10.  I consider it a marketing gimick.  IE 10 is tightly integrated with Windows 8.  Users will not benefit much without upgrading to Windows 8. Microsoft is never going to stop the bullshit of integrting their browsers with Windows, even though they were sued and lost in Europe.  Also I am pretty sure Windows 8 will be same story as Vista.  Big bangs marketing to find later Vista was buggy crap.  Vista was intermediate release before a stable Windows 7 version.  Same happened with Windows Me before Windows 2000.  I expect same will be for Windows 8, then Windows 9 will be a stable product.  Many users will not upgrade to Windows 8 because of past history of Microsoft crap, thereffore IE 10 will not be of much use without Windows 8.

MP Mr Papa
Mr Papa
Member
Member since Dec 2006
19,448 posts
Oct 3, 2012 · 7:10 pm

could be… they certainly like to buck convention…

but I can say the preview versions I have used with Windows 7, have been noticeable and marked improvement in compliance with standards…  without a doubt better than IE 9 and puts IE 8 to shame which is well beyond its ‘sell by’ date…

SS Suhaib Siddiqi
Suhaib Siddiqi
Member
Member since Aug 2012
65 posts
Oct 3, 2012 · 7:33 pm

Mr Papa said
could be… they certainly like to buck convention…

but I can say the preview versions I have used with Windows 7, have been noticeable and marked improvement in compliance with standards…  without a doubt better than IE 9 and puts IE 8 to shame which is well beyond its ‘sell by’ date…

Well, now you can get IE10 only by downloading the pre-release version of Windows 8 :-)   I do not want to install Windows 8 and later I have to downgrade my system from Dell supplied recovery disk.  It had bitten me twice, once wiith WIN ME then Vista.  My take home message is, Microsoft always release a buggy crap after one stable version.  It is to get users feed back and make improvments in the next stable release.  I will keep my ears open for Windows 8/IE10 but I am certain 3 months after release, it will be decalred as a buggy system, and people will wait for Windows 9 in 2014.

MP Mr Papa
Mr Papa
Member
Member since Dec 2006
19,448 posts
Oct 4, 2012 · 12:09 am

lol, understand…  and certainly commiserate….

yes, the last platform release was only Windows 8… but the beta and RC are supposed to support Windows 7…  as will the final released version according to MS docs and plans…