Error while activing a forum

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Barakat
    Member
    • Feb 2005
    • 87
    • 6.X

    Error while activing a forum

    thats happend while i was trying to active a fourm
    after upgrade to 3.6.1 beta 1
    Code:
     
    Database error in vBulletin 3.6.0 Beta 1:
    Invalid SQL:
    UPDATE forum SET
     title_clean = 'movies',
     title = 'movies',
     description_clean = '',
     description = '',
     link = '',
     displayorder = 1,
     parentid = -1,
     daysprune = -1,
     defaultsortfield = 'title',
     defaultsortorder = 'asc',
     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, options + 8192),
      options = IF(options & 4, options - 4, options),
      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),
     styleid = 0,
     password = ''
    WHERE forumid = 233;
    MySQL Error  : Unknown column 'defaultsortfield' in 'field list'
    Error Number : 1054
    Date         : Friday, June 9th 2006 @ 05:34:50 PM
    Script       : [URL]http://www.jerusalemgts.com/gti/admincp/forum.php?do=update[/URL]
    Referrer     : [URL]http://www.jerusalemgts.com/gti/admincp/forum.php?do=edit&f=233&s[/URL]=
    IP Address   : ********
    Username     : ********
    Classname    : vB_Database
    مسلمـ من أمة محمد ...
  • Barakat
    Member
    • Feb 2005
    • 87
    • 6.X

    #2
    and when iam trying to create a new forum also
    i have the same problem coz of defaultsortfield colum
    مسلمـ من أمة محمد ...

    Comment

    • Barakat
      Member
      • Feb 2005
      • 87
      • 6.X

      #3
      it works after i add those coloums


      ALTER TABLE `forum` ADD `defaultsortfield` VARCHAR( 50 ) NOT NULL DEFAULT 'LASTPOST';
      ALTER TABLE `forum` ADD `defaultsortorder` ENUM( 'asc', 'desc' ) NOT NULL DEFAULT 'DESC';
      ALTER TABLE `forum` ADD `showprivate` TINYINT( 3 ) UNSIGNED NOT NULL DEFAULT '0';


      just wonder why it happend and why it didn't alert them during the upgrade ?
      Last edited by Barakat; Fri 9 Jun '06, 6:22am.
      مسلمـ من أمة محمد ...

      Comment

      widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
      Working...