Help to create forum category.

[shamroc]

Your phpBB Version: 2.0.22
phpBB Type: Integramod 141
MODs: No
Your knowledge: Beginner
Board URL: http://www.shamrocs.com

PHP Version:
MySQL Version:


What was done before the problem appeared?
new install


What was done to try to solve the problem?
nothing



De.scription and Message

I cant createcategories , I get the following error. How do I solve this?

General 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, 'f', 3, 15, 'jkop', 'po', '')

Line : 1202
File : admin_forums_extend.php

[Frost]

Seems like your sql instructions didn't get installed properly

I'll have to look at the sql file and post back

[shamroc]

THank you Frost, I hope you can help.

[CaNNon]

I have the same error frost If admin access to a site with it will help pm me.

[CaNNon]

Anyone have a link to the mod that does the icons?
maybe a reinstall of just that, could fix the injection into the db?

[Frost]

I'm pretty sure the Categories Hierarchy mod adds the icons to the forums, but like Found It said, integramod uses a version that was modified by an old staff member.

Can someone give me a link to the error they get?

[CaNNon]

well you can see whats happening here, [url=http]click here[/url]
I'm not sure how to link the error? but if i try to change the name from restored forums I get:

Couldn't update forums/categories table

DEBUG MODE

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

UPDATE phpbb_categories SET cat_id=3, cat_main_type='c', cat_main=0, cat_order=9000015, cat_title='Test forums', cat_desc='', icon='' WHERE cat_id=3

Line : 1202
File : admin_forums_extend.php

[shamroc]

Just had A look at your site Cannon, did you sort out the categories problem? It looks like it.

[CaNNon]

No I have not, I did keep messing with it and now after I did something in admin (I have no idea what tho, I'm sure it has something to do with the restored in the title. <img> ) I can create some forums... but i can't change the restored title or create a new section with out it.

[Helter]

the cause of this is an incompatibility between acp/general admin/db maintenance and CH

here is a fix, provided by Found it

Code: Select all

 ##-----[ OPEN ]-----#admin/admin_db_maintenance.php  ##-----[ FIND ]-----#                     WHERE c.cat_id IS NULL";    ##-----[ IN-LINE REPLACE WITH ]-----#                     WHERE c.cat_id IS NULL                     AND main_type = 'c'";  

you may not be able to edit the restored forums catagory, but you should be able to move the forums out of the catagory, then delete it.
It is created by using "db maintenance/Synchronize forums and topics" without this fix

[CaNNon]

Think I already have that?

Code: Select all

            // Check for forums with invalid categories
            echo("<p><b>" . $lang['Checking_invalid_forums'] . "</b></p>n");
            $sql = "SELECT f.forum_id, f.forum_name
               FROM " . FORUMS_TABLE . " f
                  LEFT JOIN " . CATEGORIES_TABLE . " c ON f.cat_id = c.cat_id
               WHERE c.cat_id IS NULL
               AND main_type = 'c'";
            $result_array = array();
            $result = $db->sql_query($sql);
            if ( !$result )