Have you tried Recount Categories Stats in the config?

Yes I did.

Hi to all!
The same problem into the same places.

I try in english, i hope than you can understand.

This one is working fine for me:

Backup structure and content of all "jos_fb_" tables (maybe we need to restore all)
Backup only content of all "jos_fb" tables (we work with this one later)
Erase all "jos_fb" tables from te DB

the attached file in this post, is the same than FB_databaseStructure file; but, with the "jos_fb_".

Run the content of FB_databaseStructure from the "sql" section in phpmyadmin.

If all is right, now, we have the rigth structure from "fireborad 1.0.3"

Take the previous backup of the "only content".

Run the "only content backup" from "sql" section in phpmyadmin.

Errors?
Is normal.. study thats errors, solve that, and try again (for every time than you "try again".. the best if you are not sure abaut what are you doing is "erase again" the "jos_fb_" tables and "begin again" "running FB_databaseStructure".. and then "try again" with the "Only content backup repared"

Into my "only content backup" i have fount two "SQL errors"

the firts is located into the table "jos_fb_categories" (my content backup has the "image field" than no exit into the "Fireboard 1.0.3 structure"..
Ok, erase "image" and him values from my conten backup.

--
-- Volcar la base de datos para la tabla `jos_fb_categories`
--

INSERT INTO `jos_fb_categories` (`id`, `parent`, `name`, `cat_emoticon`, `locked`, `alert_admin`, `moderated`, `moderators`, `pub_access`, `pub_recurse`, `admin_access`, `admin_recurse`, `ordering`, `future2`, `published`, `checked_out`, `checked_out_time`, `review`, `hits`, `description`, `headerdesc`, `class_sfx`, `id_last_msg`, `numTopics`, `numPosts`, `time_last_msg`, `image`) VALUES (1, 0, 'General', 0, 0, 0, 1, NULL, 0, 0, 0, 0, 1, 0, 1, 62, '2007-10-14 03:00:43', 0, 0, 'Espacio de ámbito general abierto para que, los usuarios registrados o no, puedan publicar sus mensajes dentro de la normativa vigente.\r\n\r\nLa web dispone también de Foros privados (solo los usuarios registrados pueden publicar).', '', '', 262, 16, 59, 1189985401, ''),

The thing in red color must be erased only from jos_fb_categoriesand for every value you must be sure than erase the last ", ''"(important!! only into the jos_fb_categories

The second "sql error" is in "jos_fb_smileys" because the "FB_databaseStructure" adds this one before... the solution for me:

Go to the "only content backup" and copy and past to ejecute the "SQL" from the next to jos_fb_smileys.

--
-- Volcar la base de datos para la tabla 'jos_fb_subscriptions'
--
..the rest of the querys..


Every thin all right for me

I understand.. to seems complex. But if dont work for you, alwais you cant to restore every thing with the "structure and content backup than we make in first place.

By!

Hello I have the same problem,

There are no forums in this category!

What can we do to fix this?

Please help this is a live site.

Thanks very much

I can't say for sure if this will work for any of you but it worked on my site http://www.alphafleet.org.

In the Fireboard_101_to_1.0.3.Stable I removed the following information from the top of the file:

-- __^__ __^__
--( ___ )------------------------------------------( ___ )
-- | / | SQL Upgrade | \ |
-- | / | Fireboard 1.0.1 to 1.0.3 Stable | \ |
-- |___| Rename jos_ to your db prefix |___|
--(_____)------------------------------------------(_____)
--


I then re-uploaded the file and it ran successfully my categories and forum posts, etc are now live again.

I have uploaded the file with only the previously mentioned modifications for anyone to use, but I can't take responsibility for any adverse actions that may happen from the use of this file.

Use it at your own risk.

I am pleased to report that I finally made the upgrade from 1.0.0(Beta) to 1.0.3 thanks to the efforts of grumblemarc who generously offered to look at my backend (not everyday I allow people to look at my backend but I was grateful he did). I believe that he ran the sql and had the same problem as me with the "No Forum In this Category". He then ran the sql upgrade script for 1.0.1 and that seemed to do the trick. I think this was more or less advised by bpowers84 too. Anyway I am up to date and very pleased with both the upgraded component and with all the help I received through this forum. Thank you.

Hello,

I too am having trouble upgrading from 1.0.0. to 1.0.3. Stable.

I have copied across all the files as advised and began making the SQL changes.

Insert the 1.0.0. to 1.0.3 code and get this error:

Code:

#1091 - Can't DROP 'catid'; check that column/key exists

Ok. so I remove that line and run again. But I get:

Code:

#1091 - Can't DROP 'catparent'; check that column/key exists

So, remove that line too and then get:

Code:

#1068 - Multiple primary key defined

Can't see a solution for this error on these boards so can anyone help?!?!

Keep going. There shouldn't be errors but there will be. This is "normal".

Hello, when you say "keep going" do you mean input the next SQL statement after:

Code:

alter table `jos_fb_categories` add column `headerdesc` text NOT NULL after `description`, add column `class_sfx` varchar(20) NOT NULL after `headerdesc`, add column `id_last_msg` int(10) NOT NULL DEFAULT '0' after `class_sfx`, add column `numTopics` mediumint(8) NOT NULL DEFAULT '0' after `id_last_msg`, add column `numPosts` mediumint(8) NOT NULL DEFAULT '0' after `numTopics`, add column `time_last_msg` int(11) NULL after `numPosts`, drop key `catid`, drop key `catparent`, add KEY `msg_id`(`id_last_msg`), add KEY `parent`(`parent`), add PRIMARY KEY(`id`), add KEY `published_pubaccess_id`(`published`,`pub_access`,`id`), COMMENT='';

and ignore the "#1068 - Multiple primary key defined" message?

You are in safe hands PaulyPaul if grumblemarc is keeping his eye on you. I know its a bit disconcerting to get so many error messages but persist - even I got there in the end (with more than a little help from my friends).