It obviously fixed some things...

If you go through the exercise:

Fresh install.

Import Joomlaboard DB

Run suggested SQL scripts

Things more or less start running normally --
But try replying to an existing topic or thread
as imported from an old joomlaboard install.

SQL error.

I think before the developers offer Fireboard as
a component that seamlessly integrates an
existing Joomlaboard DB -- they need to test the
heck out of it.

Thankfully at no time have I deleted my OLD jb set-up.

I have a question. How do you "execute the code"? Do you cut and paste it somewhere in phpMyAdmin? Do you go line by line and edit the tables manually following the instructions on the list? Do you pack it up in a file and upload it into the database? I followed numerous threads during the last few weeks, including this one, where the catch phrase is to execute or run the code without an explanation as to how you actually do it.

I manually made the changes. I am not sure about something. On the lines that ADD PRIMARY KEY, do you just add the key to the list or do you add them to the Index as Primary Key as well? Some of the tables do not have anything in the Index.

For instance,

ALTER TABLE `jos_fb_attachments` ADD PRIMARY KEY ( `mesid` );
ALTER TABLE `jos_fb_categories` ADD PRIMARY KEY ( `id` );

Do I add the Primary Keys to the top list or do I also add them to the Index as a Primary Key?

The edit to the database did eliminate the 371 error, however when I go to the user list I get headers but an empty listing. I have 33 members in my forums and they are not listed.

Can u paste full and complete SQL query to fix this tables ?

Apaloosa: www.bestofjoomla.com/component/option,co...6/limitstart,0/#9469

rsavoia:
In PhpMyadmin select your table on the left and after the table is selected go to SQL tab on the top of the right side. Copy and paste the code. If execution stops on an error, remove error and run query again from that line on as phpMyadmin stops executing on error. If error is something like "Key already exists.." just move to next line (you will have a lot of this errors as you ran queries by hand)

Thanks, I appreciate the guidance.

I will try it when I get a chance. Everything seems to work except the userlist is blank. Apparently something is not right. At least I am not receiving the error.

Is anything happening to fix the userlist problem?

I got stuck on this issue to. At first I was very happy to see this great new board. Even with the database fixes of kauselot, very strange things still happen in the board.

I'll wait for the final version, this should be fixed by then I suppose.

Finetuning jb to fb upgrade - fix links (to e.g. images) in forum messages:

UPDATE 'jos_fb_messages_text' set message = replace(message,'joomlaboard','fireboard';

If you have links elsewhere(e.g. in ordinary content) you should update those tables too -e.g.: UPDATE 'jos_messages ' set message = replace(message,'joomlaboard','fireboard';

I ran the script. I have 44 users and now only the last registered user is in the userlist.
Before I ran the script I could insert emoticons into my posts. Now the emoticons do not work. They show next to the message box but when I click on one nothing happens. So now what?