Thanks very much to the Fireboard team for 1.0.3
I have just upgraded from 1.0.0 (or 1.0.1) - i was between the 2 i think.
Anyhow i followed the provided instructions (pdf in the download pack).
Everything went pretty smoothly.
Got some SQL errors due to trying to re-add existing keys (or drop non-existent ones) but luckily I am comfy enough with SQL that i knew these were OK.
The main point of my post is this.......
after applying the change script everything worked fine.
But a couple days later I decided to double check that my fireboard SQL tables exactly matched the tables in the document provided (again in the download pack).
And .... I noticed that a bunch of keys were missing...
particularly on fb_messages and fb_users
So i added these keys (i.e. added the ones documented in the 1.0.3 DB structure that were not present on my converted 1.0.0 D
And...............
After adding these indexes FIREBOARD REALLLLYY FLIES!!!!!!
This is soo soo soo much better then any of the functional enhancements.
My site is getting busier ever day and now the forum is slick, responsive and that can only encourage more users and more posts.....THANKS SO MUCH FIREBOARD TEAM.
So to give a little back here (for others converting from 1.0.0) is my SQL to add the missing keys that the official upgrade process missed):
/* Alter table in Second database */
alter table `jo_fb_messages`
add KEY `thread`(`thread`),
add KEY `parent`(`parent`),
add KEY `ip`(`ip`),
add KEY `catid`(`catid`),
add KEY `userid`(`userid`), COMMENT='';
/* Alter table in Second database */
alter table `jo_fb_moderation`
add PRIMARY KEY (`catid`,`userid`), COMMENT='';
/* Alter table in Second database */
alter table `jo_fb_sessions`
add PRIMARY KEY (`userid`), COMMENT='';
/* Alter table in Second database */
alter table `jo_fb_subscriptions`
add KEY `thread`(`thread`),
add KEY `userid`(`userid`), COMMENT='';
/* Alter table in Second database */
alter table `jo_fb_users`
add PRIMARY KEY (`userid`), COMMENT='';
Hope that helps some of you
Favoured: 1
