| User | Post |
|
9:23 am 1 Mar 2007
| Benzin
Guest
| | | |
|
| |
|
|
The installer refuses to create the db tables. Need the structure of the tables to create them manually.
|
|
|
|
|
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
| | | |
|
| |
|
|
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
| | | |
|
| |
|
|
removed " FULLTEXT KEY post_content (post_content) "
|
|
|
9:49 am 1 Mar 2007
| Benzin
Guest
| | | |
|
| |
|
|
" [The used table type doesn't support FULLTEXT indexes] " when i activate the plugin .. ill be back
|
|
|
|
|
FULLTEXT index… page 20 of the PDF guide…
|
|
|
10:08 am 1 Mar 2007
| Benzin
Guest
| | | |
|
| |
|
|
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
| | | |
|
| |
|
|
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
!?
|
|
|
|
|
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
| | | |
|
| |
|
|
Roger roger.. changed to 1.0 .. thanks it worked!
|
|
|
11:02 am 1 Mar 2007
| Benzin
New Member
| | | |
|
| posts 1 |
|
|
Great job with the forum, keep up the good work
now im registred.. :)
|
|
|
|
|
Good to know you got it sorted and I hope you find it useful
|
|