[borbole]

Originally Posted by kawe

Strange error after install this product
i can't create new Forum in FORUM MANAGER

PHP Code:

Database error in vBulletin 4.0.3:

Invalid SQL:
INSERT INTO forum
    (title_clean, title, description_clean, description, link, displayorder, parentid, daysprune, defaultsortfield, defaultsortorder, showprivate, newpostemail, newthreademail, options, styleid, imageprefix, password, vbseo_moderatepingbacks, vbseo_moderatetrackbacks, vbseo_moderaterefbacks, MARCO1_forumnocontent, ucashoptions)
VALUES
    ('xx', 'xxx', 'Txxxx', 'xxxx', '', 0, -1, -1, 'lastpost', 'desc', 0, '', '', 97987, 0, '', '', 1, 1, 1, '0', '1::1::1');

MySQL Error   : Unknown column 'MARCO1_forumnocontent' in 'field list'
Error Number  : 1054
Request Date  : Saturday, May 22nd 2010 @ 07:52:04 PM
Error Date    : Saturday, May 22nd 2010 @ 07:52:04 PM
Script        : xxxxxx/admincp/forum.php?do=update
Referrer      : hxxxx/admincp/forum.php?do=add
IP Address    : xxxx
Username      : xxx
Classname     : vB_Database
MySQL Version : 5.0.77 


That is because the column is not added to the database. Maybe Marco forgot to add it at the install code.

Anyway, to fix the database error that appears with this mod when changing the forum option, run the following query at phpmyadmin by running the following query:

ALTER TABLE forum ADD `MARCO1_forumnocontent` INT( 10 ) UNSIGNED NOT NULL DEFAULT '0';

And when uninstalling the mod, you can drop the column by running this other query:

ALTER TABLE forum DROP `MARCO1_forumnocontent`;

If your db tables have a prefix, you should include that in the query as well.


Hopefully the author will include it in the install code at the plugin.xml file so it can perform both action automatically on install and uninstall.

P.s. I hope you didn''t mind me butting in here MARCO1