Announcement

Collapse
No announcement yet.

database error

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • database error

    keep getting this database error everytime i try and create a new usergroup

    Database error in vBulletin 3.6.5:

    Invalid SQL:

    ### INSERT QUERY GENERATED BY fetch_query_sql() ###
    INSERT INTO usergroup
    (`title`, `description`, `usertitle`, `opentag`, `closetag`, `passwordexpires`, `passwordhistory`, `ispublicgroup`, `canoverride`, `forumpermissions`, `genericpermissions`, `attachlimit`, `pmquota`, `pmpermissions`, `pmsendmax`, `calendarpermissions`, `wolpermissions`, `adminpermissions`, `genericoptions`, `profilepicmaxwidth`, `profilepicmaxheight`, `profilepicmaxsize`, `avatarmaxwidth`, `avatarmaxheight`, `avatarmaxsize`, `signaturepermissions`, `sigpicmaxwidth`, `sigpicmaxheight`, `sigpicmaxsize`, `sigmaxrawchars`, `sigmaxchars`, `sigmaxlines`, `sigmaxsizebbcode`, `sigmaximages`, `arcadepermissions`, `minpoststoplay`, `minreptoplay`, `minreglengthtoplay`, `vbarticles`, `awardpermissions`, `displayorder`)
    VALUES
    ('Registered Users', '', '', '<img src=\"http://www.trueconsoleghosts.com/crown.gif\" />', '', '0', '0', '0', '0', '782591', '505943751', '0', '50', '3', '5', '49', '1', '0', '62', '100', '100', '100000', '80', '80', '50000', '237567', '5000', '1000', '20000', '1000', '500', '0', '7', '4', '7', '0', '-1000', '0', '447', '1', '');

    MySQL Error : Unknown column 'displayorder' in 'field list'
    Error Number : 1054
    Date : Saturday, March 31st 2007 @ 08:10:37 PM
    Script : http://forum.trueconsoleghosts.com/a....php?do=update
    Referrer : http://forum.trueconsoleghosts.com/a...oup.php?do=add
    IP Address : 86.142.100.226
    Username : breamy
    Classname : vB_Database

  • #2
    Displaygroup is not a default vBulletin column in the usergroup table.

    This is probably caused by a modification you have removed, but forgot to remove the ./includes/xml/bitfield_XX.xml file belonging to the modification.
    Want to take your board beyond the standard vBulletin features?
    Visit the official Member to Member support site for vBulletin Modifications: www.vbulletin.org

    Comment

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