MyBB Community Forums

I have problem with this plugin.

When I click on activate I see this message:

Quote:MySQL error: 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AFTER TABLE mybb_forums ADD (icon text NOT NULL)' at line 1
Query: AFTER TABLE mybb_forums ADD (icon text NOT NULL)

Does someone know what is problem?

I did this:

• CHMOD inc/functions_forumlist.php to 777 .
• CHMOD admin/forums.php to 777 .

It should be "ALTER TABLE" not "AFTER TABLE"

Edit ::

After viewing the plugin file =>

	$query = $db->query("ALTER TABLE ".TABLE_PREFIX."forums ADD (icon text NOT NULL)");

So where does that "after" comes from ? =P

MySQL error: 1060
Duplicate column name 'icon'
Query: ALTER TABLE mybb_forums ADD (icon text NOT NULL)

again..


and:

Linie 23:

$query = $db->query("ALTER TABLE ".TABLE_PREFIX."forums ADD (icon text NOT NULL)");

it does not work

Cause the column already exists ... delete the column througt cPanel of phpMyAdmin and try again.