[ranafarooq]

having a bug in it actually I had installed it and it was working well but for some reason when i tried to create new forum or edit the old one it started to give and sql error quoted as under

PHP Code:

Database error in vBulletin 4.0.3:
 
 Invalid SQL:
 UPDATE forum SET
         title_clean = 'Welcome to :help|Forum:',
         title = 'Welcome to :help|Forum:',
         description_clean = '1 thread for each new member in  introduction Please',
         description = '1 thread for each new member in introduction  Please',
         link = '',
         displayorder = 1,
         parentid = 1,
         daysprune = -1,
         defaultsortfield = 'lastpost',
         defaultsortorder = 'desc',
         showprivate = 0,
         newpostemail = '',
         newthreademail = '',
         ### Bitfield: forum.options ###
                 options = IF(options & 8, options - 8, options),
                 options = IF(options & 16, options - 16, options),
                 options = IF(options & 32, options - 32, options),
                 options = IF(options & 32768, options - 32768,  options),
                 options = IF(options & 8192, options - 8192,  options),
                 options = IF(options & 4, options, options + 4),
                 options = IF(options & 1, options, options + 1),
                 options = IF(options & 2, options, options + 2),
                 options = IF(options & 16384, options, options +  16384),
                 options = IF(options & 256, options - 256, options),
                 options = IF(options & 64, options, options + 64),
                 options = IF(options & 128, options, options + 128),
                 options = IF(options & 512, options, options + 512),
                 options = IF(options & 1024, options, options +  1024),
                 options = IF(options & 2048, options, options +  2048),
                 options = IF(options & 4096, options, options +  4096),
                 options = IF(options & 65536, options, options +  65536),
                 options = IF(options & 131072, options - 131072,  options),
         styleid = 0,
         imageprefix = '',
         password = '',
         MARCO1_forumnocontent = '0'
 WHERE forumid = 2;
 
 MySQL Error   : Unknown column 'MARCO1_forumnocontent' in 'field list'
 Error Number  : 1054
 Request Date  : Sunday, July 18th 2010 @ 06:46:01 AM
 Error Date    : Sunday, July 18th 2010 @ 06:46:01 AM
 Script        : http://mysite name/forums/admincp/forum.php?do=update
 Referrer      : http://mysite name//forums/admincp/forum.php?do=edit&f=2
 IP Address    : xxx.xx.xxx.xx
 Username      : xyz
 Classname     : vB_Database
 MySQL Version : 5.0.91-community 


it was suggested by the vbulletin team that I must uninstall the mod in order to prevent the problem. After uninstalling my fourm is working fine.

But I loved your hack I need it can you please look into the matter and can provide us a bug free mod. I shall be really thankful to you.

Regards