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
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
Aug 6, 2013 - 1:25 pm

in case you dont have it, the schema for the keywords:

                    keywords varchar(256) default NULL,

Avatar
Geoffrey WIlson
Member
Free Members
sp_UserOfflineSmall Offline
Aug 6, 2013 - 2:36 pm

Well last time I did but I am not an SQL expert. If I give you the field that I need to fill in can you tell me what should go in those fields?

missingfield-1.jpgImage Enlarger

Avatar
Geoffrey WIlson
Member
Free Members
sp_UserOfflineSmall Offline
Aug 6, 2013 - 2:37 pm

Am I on the right table as-well? 

Avatar
Geoffrey WIlson
Member
Free Members
sp_UserOfflineSmall Offline
Aug 6, 2013 - 3:02 pm

Or is it sftopics?

Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
Aug 6, 2013 - 3:37 pm

sorry, Andy out for dinner and I am away from computer replying by email... so I can't see images or html... but the table would be sfforums... set:

name - keywords type - varchar(256) default - null

you should also set the collation to whatever the other tables/columns are in your db...

Avatar
Geoffrey WIlson
Member
Free Members
sp_UserOfflineSmall Offline
Aug 6, 2013 - 4:15 pm

:( Fixed that one but I am missing more field :/ My girl wants to watch a movie with me because this is taking too much time away from her. :P I will be back in a couple hours. 

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 'use_tags' 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
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
Aug 6, 2013 - 5:16 pm

what are you waiting for? get to the movie! ;)

we can just take these one at at time as they come up...

same table, sfforums...

name - use_tags type - smallint(1) null - NOT NULL default - 1

Avatar
Geoffrey WIlson
Member
Free Members
sp_UserOfflineSmall Offline
Aug 6, 2013 - 11:01 pm

Sounds like a plan Stan errr I mean Mr. Papa ;) Here is the next error posted below. BTW you have to watch a movie called "Coriolanus". It is made just as well if not better than all time #1 "Shawshank Redemption". 

 

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_desc' 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
Brandon
U.S.
SP Wrangler
Free Members
sp_UserOfflineSmall Offline
Aug 6, 2013 - 11:49 pm

Geoffrey WIlson said
 to watch a movie called "Coriolanus". It is made just as well if not better than all time #1 "Shawshank Redemption". 
 

Are you talking about this movie?

It looks pretty awesome.

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

sheesh... did we ever ask you to check with your host and see if your mysql user has 'alter table' permission?  it seems to not be able to run upgrade scripts where the tables get altered...  actually, you might be able to see your user permissions from phpmyadmin...

anyways...

table - sftopics

name - topic_desc

type - text

default - NULL

and these last two have all been from plugins... so I assume you are actually using the tags and topic description plugin....

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