I had to dump whole database, delete tables of the forum and reinstall forum again because i had one more error - i couldn't add more categories. Now everything is ok

man i am so confused

what would be the easiest way so i can make categorys again? do i need to uninstall everything? is there a way i can still keep my messages?

bump

I upgraded from 1.0.1 to 1.0.3 and can see messages but can't create categories, plus looks like categories are still there but messages are not in categories. I know this sounds weired but here are some images of the errors I get. Can anyone help me?
Creating a new category

saving a categroy that still shows up in database

Error when runing upgrade .sql

Maybe this can help someone help me....
Also the link to the forum itself is www.tmrchome.com/index.php?option=com_fireboard&Itemid=27



Thanks

Check your Table structure for table `#__fb_categories`

You find that in install packages Docs/FB_databaseStructure -file.
Please backup before.

That say this for me:

CREATE TABLE IF NOT EXISTS `#__fb_categories` (
`id` int(11) NOT NULL auto_increment,
`parent` int(11) default '0',
`name` tinytext,
`cat_emoticon` tinyint(4) NOT NULL default '0',
`locked` tinyint(4) NOT NULL default '0',
`alert_admin` tinyint(4) NOT NULL default '0',
`moderated` tinyint(4) NOT NULL default '0',
`moderators` varchar(15) default NULL,
`pub_access` tinyint(4) default '1',
`pub_recurse` tinyint(4) default '1',
`admin_access` tinyint(4) default '0',
`admin_recurse` tinyint(4) default '1',
`ordering` tinyint(4) NOT NULL default '0',
`future2` int(11) default '0',
`published` tinyint(4) NOT NULL default '0',
`checked_out` tinyint(4) NOT NULL default '0',
`checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
`review` tinyint(4) NOT NULL default '0',
`hits` int(11) NOT NULL default '0',
`description` text NOT NULL,
`headerdesc` text NOT NULL,
`class_sfx` varchar(20) NOT NULL,
`id_last_msg` int(10) NOT NULL default '0',
`numTopics` mediumint(8) NOT NULL default '0',
`numPosts` mediumint(8) NOT NULL default '0',
`time_last_msg` int(11) default NULL,
PRIMARY KEY (`id`),
KEY `parent` (`parent`),
KEY `published_pubaccess_id` (`published`,`pub_access`,`id`),
KEY `msg_id` (`id_last_msg`)
);

Thanks for the quick response, but I am not sure what you ask me to do. Can you be specific. I am not to good at this

thanks,

Sorry you're having trouble but you haven't finished upgrading because you haven't run the SQL queries successfully yet. Firstly get rid of all the nonsense in the text that comes before "*/ Alter table in second database". Then paste the remainder into the SQL window and run it. Most likely you will come across another error saying that something does not exist. No problem. Go back to the text file and copy everything AFTER the line you got the error at and and run it in the SQL window again. Every time you get one of those errors saying something does not exist or that something already exists repeat that step. Do that until you run the whole query without errors. Until you do that successfully you will not have a true upgrade.

Check out this link to simplify the whole script process.

www.bestofjoomla.com/component/option,co...d,79/id,26714/#26714

Thank you also for the quick response! Great news....I removed the text you mentioned then ran the SQL like you said. Fortunatly I recieved no errors, then all I had to do was run the Recount category stats and all is looking perfect. Thank you so much! Even tho the forum only had 2 messages it is prof that this works.

Thanks Again!

Just to bring this back for anyone still trying to get the upgrade to work and get categories not showing. I updated a forum members Fireboard forum from 1.0.0 to 1.0.3. Installed easySQL because I did not have access to the hosting control pnael. I ran the appropriate script using that component. The COOL thing about this component is that it SKIPS THE ERRORS AND RUNS THE WHOLE SCRIPT!!! Let me say that again. "It skips the errors and runs the whole script!!!. But wait! No categories showing!!! Argh! Ran the 1.0.1 script right behind it and BINGO categories!!! But what now?!!! Now no posts!!! Recount Categories Stats and BINGO all back to normal!! Fully upgraded FB!!!