Adding catergory error

[jae]

Your phpBB Version: 2.0.
phpBB Type: Standard phpBB
MODs: No
Your knowledge: Beginner
Board URL: http://scifi-talk.net/forum/index.php

PHP Version:
MySQL Version:


What was done before the problem appeared?



What was done to try to solve the problem?




De.scription and Message

Hi

I can add forums to my board but when ever I try to add a gatagory I get the following error

Couldn't update forums/categories table

DEBUG MODE

SQL Error : 1054 Unknown column 'icon' in 'field list'

INSERT INTO phpbb_categories (cat_id, cat_main_type, cat_main, cat_order, cat_title, cat_desc, icon) VALUES(1, 'c', 0, 15, 'Test category 2', '', '')

Line : 1202
File : admin_forums_extend.php

[CaNNon]

I had this problem when setting them up, it was usually from not using a icon or having the path set wrong.

[jae]

Hmm well I have an icon in there (show a preview of it) what do you mean by "path set wrong" also I assumed this part

SQL Error : 1054 Unknown column 'icon' in 'field list'

Meant the Icon field should not be there as there is no collumn for it??

[CaNNon]

What I had was a path error and the icon did still preview I'm not 100% sure, but I think it had to do with using the / in front I had to remove it.

[Zappa]

I have the same error and for my part is that I'm missing field icon in the DB.

Don't know when this went wrong since I've never used an icon.

Anyone know how the icon field should look like?

/Zappa

[Helter]

was your forum originally setup for mysql4 and changed to mysql5?
this seems to be the most common cause of "Unknown column" errors

Im assuming in your config.php you have this line

$dbms = 'mysqli';

try changing it to

$dbms = 'mysql4';