Hi,

I got this error while trying to add new category... How can I fix this?

[code:1]fbforum::«»store failed />Unknown column 'class_sfx'
in 'field list' SQL=INSERT INTO jos_fb_categories[/code:1]

Joomla 1.0.13
Fireboard 1.0.3 Stable (data from -> SMF to Fireboard conversion)

- Juraus

Sorry... here's error (screencapture)



- Juraus

I also get the same error when tring to create a new category. Please can anyone help?

probably you have made an upgrade and this field in your fb_category table is missin, look at the upgrade.sql inside the package and put back the missing fields.

class_sfx

Hi thanks for the quick response. I am a newbie to Joomla, so forgive me if my questions are a bit dumb. Where do i go to view this sql file and what are the files i need to replace?

Hi,

thanks, that helped! There was two columns missing on my 'jos_fb_categories'
table, `headerdesc` and `class_sfx`

- Juraus

where is the upgrade.sql have looked in both stable and upgrade package and there is no upgrade sql file help please

Here's fields on my jos_fb_categories ...

[code:1]
jos_fb_categories
Field Type Null Default
id int(11) No
parent int(11) Yes 0
name tinytext Yes NULL
cat_emoticon tinyint(4) No 0
locked tinyint(4) No 0
alert_admin tinyint(4) No 0
moderated tinyint(4) No 0
moderators varchar(15) Yes NULL
pub_access tinyint(4) Yes 1
pub_recurse tinyint(4) Yes 1
admin_access tinyint(4) Yes 0
admin_recurse tinyint(4) Yes 1
ordering tinyint(4) No 0
future2 int(11) Yes 0
published tinyint(4) No 0
checked_out tinyint(4) No 0
checked_out_time datetime No 0000-00-00 00:00:00
review tinyint(4) No 0
hits int(11) No 0
description text No
id_last_msg int(10) No 0
time_last_msg int(11) No 0
numTopics mediumint(8) No 0
numPosts mediumint(8) No 0
class_sfx varchar(20) No
headerdesc text No
[/code:1]