On these pages are my WordPress plugins, the odd article and my Support Forum.

For my random rantings on everything else please visit my blog at Yellow Swordfish

WP Plugins


Articles

If you find any of my plugins useful, please comsider a donation towards my running costs.

Thank you

In preparation for the release of the first beta of Simple:Press Version 4.0, the Support Forum has moved to a new site dedicated to the plugin. This will also be the future home for Simple:Press Forum.


Version 3.1.4 will still be available for download here in the short term.


For the support forum - and to visit our new site click on the logo to take you to simplepressforum.com

This forum is currently locked - access is read only
Current User: Guest
Please consider registering

 
Search Forums:


 




Create tables manually

UserPost

9:23 am
1 Mar 2007


Benzin

Guest

1

The installer refuses to create the db tables. Need the structure of the tables to create them manually.

9:28 am
1 Mar 2007


Yellow Swordfish

Admin

Peterborough, England

posts 5252

2

Curious. Do you know why?

The initial definitions of the tables can be found in sf-includes.php (4 tables). You should be able to lift the defs directly from there. 

But… there are also some additonal fields defined in sf-upgrade.php which you will also need to check. You will see the defs easily enough.

If you know what the probloem is I'd welcome the knowledge… 

9:45 am
1 Mar 2007


Benzin

Guest

3

hmm , i really dont know why, it just refused..

anyway, could create most of them but not sfposts

CREATE TABLE IF NOT EXISTS sfgroups (
            group_id bigint(20) NOT NULL auto_increment,
            group_name varchar(50) default NULL,
            group_seq int(4) default NULL,
            PRIMARY KEY group_id (group_id)
        );
       
CREATE TABLE IF NOT EXISTS sfforums (
            forum_id bigint(20) NOT NULL auto_increment,
            forum_name varchar(75) default NULL,
            group_id bigint(20) NOT NULL,
            forum_seq int(4) default NULL,
            PRIMARY KEY forum_id (forum_id)
        );
       
CREATE TABLE IF NOT EXISTS sftopics (
            topic_id bigint(20) NOT NULL auto_increment,
            topic_name varchar(100) NOT NULL,
            topic_date datetime NOT NULL,
            topic_status int(4) NOT NULL default '0',
            forum_id bigint(20) NOT NULL,
            user_id bigint(20) default NULL,
            topic_pinned smallint(1) NOT NULL default '0',
            PRIMARY KEY topic_id (topic_id)
        );
       
CREATE TABLE IF NOT EXISTS sfposts (
            post_id bigint(20) NOT NULL auto_increment,
            post_content text,
            post_date datetime NOT NULL,
            topic_id bigint(20) NOT NULL,
            user_id bigint(20) default NULL,
            forum_id bigint(20) NOT NULL,
            guest_name varchar(25) default NULL,
            guest_email varchar(50) default NULL,
            post_status int(4) NOT NULL default '0',
            PRIMARY KEY post_id (post_id),
            FULLTEXT KEY post_content (post_content)
        );
       
CREATE TABLE IF NOT EXISTS sfwaiting (
            topic_id bigint(20) NOT NULL,
            forum_id bigint(20) NOT NULL,
            post_count int(4) NOT NULL default '0',
            PRIMARY KEY topic_id (topic_id)
        );


9:47 am
1 Mar 2007


Benzin

Guest

4

removed " FULLTEXT KEY post_content (post_content) "

9:49 am
1 Mar 2007


Benzin

Guest

5

" [The used table type doesn't support FULLTEXT indexes] " when i activate the plugin .. ill be back :)

9:59 am
1 Mar 2007


Yellow Swordfish

Admin

Peterborough, England

posts 5252

6

FULLTEXT index… page 20 of the PDF guide…

10:08 am
1 Mar 2007


Benzin

Guest

7

yes i figured that out :) and changed frpm innoDB to MyISAM but no luck so far. Diving deeper ….

10:35 am
1 Mar 2007


Benzin

Guest

8

Really strange this.. i changed all tables to MyISAM but the DB was innoDB , changed in my.ini to default db MYISAM, restarted mysql and it worked. Removed the tables and recreated the tables. Now a new problem, cant create a group ?

WordPress database error: [Unknown column 'group_desc' in 'field list']
INSERT INTO wp_sfgroups (group_name, group_desc, group_view, group_seq) VALUES ('Standard', 'Test', 'public', 1);

New Group Creation Failed!

 The DB is:

group_id
group_name
group_seq

!? 

10:44 am
1 Mar 2007


Yellow Swordfish

Admin

Peterborough, England

posts 5252

9

As I said above there are also some additonal fields defined in sf-upgrade.php. These were defined as part of updates to the plugin. 'group_desc' was the first. If you look through sf-upgrade.php you will find the 7 ALTER statements that also need to be run.

The alternative method (to save doing them manually) is to open up your WP Options table and find the entry for 'sfversion'. if you change that to 1.0 then when you run the plugin (admin or the forum) it will perform the upgrade automatically. As long as you have ALTER rights of course!

[UPDATE] The sfversion in Options will have been set when you first ran the plugin. Removing the tables isn't enough to change that hence the 'uninstall' option which would have remoived the version tag as well. 

10:59 am
1 Mar 2007


Benzin

Guest

10

Roger roger.. changed to 1.0 .. thanks it worked!

11:02 am
1 Mar 2007


Benzin

New Member

posts 1

11

Great job with the forum, keep up the good work

now im registred.. :) 

11:07 am
1 Mar 2007


Yellow Swordfish

Admin

Peterborough, England

posts 5252

12

Good to know you got it sorted and I hope you find it useful



Reply to Topic: Create tables manually

NOTE: New Posts are subject to administrator approval before being displayed

Guest Name (Required):

Guest EMail (Required):

Guest URL (required)

Math Required!
What is the sum of: 3 + 10        (Required)

Topic Reply:


 
 

About the Stuff at Yellow Swordfish forum

Currently Online:

8 Guests

Maximum Online: 71

Forums:

Groups: 3

Forums: 16

Topics: 2068

Posts: 14091

Members:

There are 1003 members

There are 837 guests


Yellow Swordfish has made 5252 posts

Top Posters:

Mr Papa - 1602

-Radio- - 558

ovizii - 114

jfv - 82

angelic007 - 72

Administrator: Yellow Swordfish | Moderators: Yellow Swordfish, Mr Papa, -Radio-


© Simple:Press Forum - Version 3.1.4 (Build 357)