Support Forum

Advanced Search
Forum Scope


Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
general-topic
PHP Table Names ?
Avatar
john wilkins
Member
Free Members
sp_UserOfflineSmall Offline
Jan 24, 2014 - 3:55 pm

OK have had to rebuild My website -three things in Simple Press not working.

I have imported all My members into Wordpress no problem but can't get them to show in Simple Press.

The php prefix for wordpress is wp_users - can anybody tell me the prefix for Simple Pres ?

For instance is it wp_sfuser ?

Two -  I have a back up of the forums - bp2_sfforums but they don't want to move across to wp_sfforums. Anyhelp please

The same problem with groups.

 

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Jan 24, 2014 - 4:40 pm

Simple:Press is just a WordPress plugin. The tables it creates use the same prefix as the base WordPress tables. There is no 'sfuser' table but there is an 'sfmembers' table which hold user level forum data which is over and above that held by core WordPress.

There are quire a few Simple:Press tables - all of those starting 'sf' in fact. They are all needed.

andy-signature.png
YELLOW
SWORDFISH
Avatar
john wilkins
Member
Free Members
sp_UserOfflineSmall Offline
Jan 24, 2014 - 5:18 pm

Yellow Swordfish said
Simple:Press is just a WordPress plugin. The tables it creates use the same prefix as the base WordPress tables. There is no 'sfuser' table but there is an 'sfmembers' table which hold user level forum data which is over and above that held by core WordPress.

There are quire a few Simple:Press tables - all of those starting 'sf' in fact. They are all needed.

Hi Yellow Swordfish - any idea where I can find a list of tables, I suspect the backup is incomplete.

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Jan 24, 2014 - 5:31 pm

The code file in the SP plugin at /simple-press/sp-startup/sp-load-core.php

around line 45 in this file you will find the comment '# Define table constants' and beneath that is a liost of the core SP plugins. Remember though that some SP plugins - like 'private messaging' for example - may add other tables.

andy-signature.png
YELLOW
SWORDFISH
Avatar
john wilkins
Member
Free Members
sp_UserOfflineSmall Offline
Jan 24, 2014 - 5:45 pm

Thanks , solved the forum one by simply dropping the wordpress one and re installing.

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Jan 24, 2014 - 6:01 pm

excellent.

andy-signature.png
YELLOW
SWORDFISH
Avatar
john wilkins
Member
Free Members
sp_UserOfflineSmall Offline
Jan 25, 2014 - 1:37 pm

Yellow Swordfish said
excellent.

With the remainder I had nearly given up hope. Out of interest I loaded the other .sql files into a html editor and it became obvious what was wrong, all the prefixes had to be changed that done every thing working OK laugh

Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
Jan 25, 2014 - 1:52 pm

good news. thanks for update.

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: 620
Members: 17365
Moderators: 0
Admins: 4
Forum Stats:
Groups: 7
Forums: 17
Topics: 10128
Posts: 79626