Support Forum

Latest simple:press update deleted all data

101 Answers

New Answer

GW Geoffrey WIlson
Geoffrey WIlson
Member

Yes I am using a good number of your plugins. I looked in the system variable under phpmyadmin to find that there is a setting called old alter table which is set to off. I can turn that on if that is it. I also did a little research on alter table and I can run a script through phpmyadmin > Search > Run SQL query with the added script alter table to the front of the table settings. This sounds like it would not be that fun to do every time. So let me know if old alter table is the setting. ;)

Here is the next error.

file: /services2/webpages/d/o/doggroominginhouston.com/public/wp-content/plugins/simple-press/forum/content/classes/sp-forum-view-class.php
line: 305
function: select
error: Unknown column ‘topic_watches’ 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, use_tags, topic_desc, topic_watches FROM wp_sftopics JOIN wp_sfforums ON wp_sftopics.forum_id = wp_sfforums.forum_id WHERE wp_sfforums.forum_id=1 AND wp_sftopics.post_count_held > 0 ORDER BY topic_pinned DESC, wp_sftopics.post_id_held DESC LIMIT 0, 12

GW Geoffrey WIlson
Geoffrey WIlson
Member

BTW I sent an email to the hosting company about alter table setting since I have no way to change setting for mysql it seems. It might take a hot minute for them to reply with a portal account they gave to me a long time ago that I have lost the link to.

MP Mr Papa
Mr Papa
Member

table – sftopics name – topic_watches type – longtex

GW Geoffrey WIlson
Geoffrey WIlson
Member

Wow tech support responded in 20 minutes. When that happens you know you are going to have a good day. 

Thank you for your e-mail. Please be informed that alter command is granted for user doggroomin78xxxx. See log below for your reference. We kindly ask you to check your sql syntax if you are having issues executing ALTER TABLE command.
 
MP Mr Papa
Mr Papa
Member

syntax is fine… but good to know you have permission – just dont know why its failing…

null is fine…

GW Geoffrey WIlson
Geoffrey WIlson
Member

I figured it wasn’t your syntax because it seems it is just a handful of people that are having this problem. The last table fixed all the topics and now they are showing. Here is the next error.

file: /services2/webpages/d/o/doggroominginhouston.com/public/wp-content/sp-resources/forum-plugins/plupload/sp-plupload-plugin.php
line: 187
function: sp_plupload_do_forumview_query
error: Unknown column ‘attachments’ in ‘where clause’

SELECT topic_id FROM wp_sfposts WHERE wp_sfposts.topic_id IN (1,12,8,7) AND attachments IS NOT NULL

GW Geoffrey WIlson
Geoffrey WIlson
Member

FIXED!! No more errors and all the data is back. Thanks for the support guys. I am going to fix the rest of the updates on my site after I do a full site backup. I want to talk to you guys about an unlimited license for your plugin in a few days. I have 4 major sites that need this plugin. I am planning on creating an SEO domain empire for Houston but can’t afford $100 for each site since I am making them for my company pressingtrade.com. We will talk about it more later. 

Thanks for all your help! Have a great day ;)

MP Mr Papa
Mr Papa
Member

your current membership allows you to use Simple Press on as many sites as you like… go for it!

great all the errors are fixed!

GW Geoffrey WIlson
Geoffrey WIlson
Member

Cool beans! Just one last thing though. I have a problem with the share plugin not updating. I am going to look through your forums and do a few troubleshoots before we get into that. I will start a new thread for that one since it is unrelated if I can’t fix it. ;)