Support Forum

Advanced Search
Forum Scope


Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
plugins-topic
Latest simple:press update deleted all data
Avatar
Geoffrey WIlson
Member
Free Members
sp_UserOfflineSmall Offline
Aug 7, 2013 - 10:42 am

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

Avatar
Geoffrey WIlson
Member
Free Members
sp_UserOfflineSmall Offline
Aug 7, 2013 - 10:53 am

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.

Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
Aug 7, 2013 - 11:00 am

table - sftopics name - topic_watches type - longtex

Avatar
Geoffrey WIlson
Member
Free Members
sp_UserOfflineSmall Offline
Aug 7, 2013 - 11:14 am

null or not null? 

Avatar
Geoffrey WIlson
Member
Free Members
sp_UserOfflineSmall Offline
Aug 7, 2013 - 11:27 am

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.
 
Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
Aug 7, 2013 - 11:52 am

syntax is fine... but good to know you have permission - just dont know why its failing...

null is fine...

Avatar
Geoffrey WIlson
Member
Free Members
sp_UserOfflineSmall Offline
Aug 7, 2013 - 12:00 pm

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

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Aug 7, 2013 - 12:15 pm

sfposts table.
attachments text

andy-signature.png
YELLOW
SWORDFISH
Avatar
Geoffrey WIlson
Member
Free Members
sp_UserOfflineSmall Offline
Aug 7, 2013 - 2:23 pm

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 ;)

Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
Aug 7, 2013 - 2:41 pm

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!

Forum Timezone: Europe/Stockholm
Most Users Ever Online: 1170
Currently Online:
Guest(s) 1
Currently Browsing this Page:
1 Guest(s)
Top Posters:
Mr Papa: 19448
Ike: 2086
Brandon: 864
kvr28: 804
jim: 650
FidoSysop: 577
Conrad_Farlow: 531
fiddlerman: 358
Stefano Prete: 325
Member Stats:
Guest Posters: 619
Members: 17363
Moderators: 0
Admins: 4
Forum Stats:
Groups: 7
Forums: 17
Topics: 10127
Posts: 79625