Support Forum

PHP Table Names ?

JW john wilkins
john wilkins
Member

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.

 

7 Answers

New Answer

YS Yellow Swordfish
Yellow Swordfish
Member

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.

JW john wilkins
john wilkins
Member

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.

YS Yellow Swordfish
Yellow Swordfish
Member

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.

JW john wilkins
john wilkins
Member

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

JW john wilkins
john wilkins
Member

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