I've figured this out myself, posting here in case someone else finds it useful.
re: my previous post the id field jos_fb_messages is fine.
I installed a clean installation of fireboard 1.0.4 on a test system, and compared it to my upgraded tables. I was surprised to see several differences, I'm not sure if this is missing stuff from Fireboard 1.0 -> 1.0.4 upgrade, or if this is hangover stuff from the Joomlaboard to Fireboard migration.
For each table I've listed the differences I've found, and the SQL to bring the upgraded table in line with the clean install table schema.
Table: jos_fb_attachments
- clean install table has a default value of '0', upgraded table has no default.
[code:1]
ALTER TABLE `jos_fb_attachments` MODIFY `mesid` int(11) NOT NULL default '0';
[/code:1]
[u]Table: jos_fb_categories[/u]
[ul]
[li]Extra field "image" in upgraded table, doesn't exist in clean install[/li]
[li]Default value for moderated is "0", it is "1" on a clean install.[/li]
[/ul]
[code:1]
ALTER TABLE `jos_fb_categories` MODIFY `moderated` tinyint(4) NOT NULL default '1', DROP `image`;
[/code:1]
[u]Table: jos_fb_messages[/u]
[ul]
[li]Upgraded table is missing several keys. The clean install has the following extra fields defined as keys:
parent, thread, catid, userid, ip[/li]
[/ul]
[code:1]
ALTER TABLE `jos_fb_messages`
ADD KEY `thread` (`thread`),
ADD KEY `parent` (`parent`),
ADD KEY `catid` (`catid`),
ADD KEY `ip` (`ip`),
ADD KEY `userid` (`userid`);
[/code:1]
[u]Table: jos_fb_moderation[/u]
[ul]
[li]catid and userid are primary keys on the clean install, but not the upgraded table[/li]
[/ul]
[code:1]
ALTER TABLE `jos_fb_moderation` ADD PRIMARY KEY (`catid`,`userid`);
[/code:1]
[u]Table: jos_fb_sessions[/u]
[ul]
[li]userid is a primary key on the clean install, but not the upgraded table[/li]
[/ul]
[code:1]
ALTER TABLE `jos_fb_sessions` ADD PRIMARY KEY (`userid`);
[/code:1]
[u]Table: jos_fb_subscriptions[/u]
[ul]
[li]thread and userid are keys on the clean install, but not the upgraded table[/li]
[/ul]
[code:1]
ALTER TABLE `jos_fb_subscriptions`
ADD KEY `thread` (`thread`),
ADD KEY `userid` (`userid`);
[/code:1]
[u]Table: jos_fb_users[/u]
[ul]
[li]userid is a primary key on clean install, but not the upgraded table[/li]
[li]birthdate default value is 0001-01-01 on clean install, but 0000-00-00 on the upgraded table[/li]
[/ul]
[code:1]
ALTER TABLE `jos_fb_users`
MODIFY `birthdate` date NOT NULL default '0001-01-01',
ADD PRIMARY KEY (`userid`);
[/code:1]
This work has been somewhat complicated for me due to our site being moved to a new hosting company and domain name.
We had a problem with image and file attachments not showing up in the forums. This was caused by two issues:
[ol]
[li]The absolute path for our base Joomla! directory has changed.[/li]
[li]The domain name for our website has changed[/li]
[/ol]
NB: We moved site, then upgraded Fireboard, only then was the attachment problems noticed, so note the new and old style fireboard locations for files and images, as these fixes were applied after the 1.0.4 upgrade.
The first problem (Moving Joomla base directory) was fixed with the below:
[code:1]
UPDATE jos_fb_attachments SET filelocation=(REPLACE(filelocation, 'old_joomla_base_path/components/com_fireboard/uploaded',
'new_joomla_base_path/images/fbfiles'));
[/code:1]
The second problem (Moving site to a new URL) was fixed with the below:
[code:1]
UPDATE jos_fb_messages_text SET message=(REPLACE(message, 'http://oldurl.example.com/components/com_joomlaboard/uploaded',
'http://newurl.example.com/images/fbfiles'));
UPDATE jos_fb_messages_text SET message=(REPLACE(message, 'http://oldurl.example.com/components/com_fireboard/uploaded',
'http://newurl.example.com/images/fbfiles'));
[/code:1]
We had several instances of attached image urls referring to com_joomlaboard, hence why it is included above, if you only ever had fireboard installed, you can ignore the line mentioning joomlaboard.
Cheers,
Jag
Have you tried this?
