Announcement

Collapse
No announcement yet.

SQL Syntax Error When Adding a Forum

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

  • SQL Syntax Error When Adding a Forum

    I'm using 2.3.3 and I'm getting this error when I try to add a forum:

    Database error in vBulletin Control Panel 2.3.3:

    Invalid SQL: INSERT INTO forum
    (forumid,styleid,title,description,active,displayorder,parentid,
    parentlist,allowposting,cancontainthreads,daysprune,newpostemail,newthreademail,
    moderatenew,allowhtml,allowbbcode,allowimages,allowsmilies,allowicons,
    styleoverride,allowratings,countposts,moderateattach,storereply,storethread))
    VALUES
    (NULL,'1','ActiveBucks Transactions','Buy or sell goods and services for ActiveBucks in this forum.','1','4','6',
    '','1','1','30','','',
    '0','0','1','1','1','1',
    '0','0','1','0', '','')
    mysql error: 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 ')
    VALUES
    (NULL,'1','

    mysql error number: 1064

    Date: Saturday 06th of December 2003 11:47:38 AM
    Script: http://www.activegaming.net/forums/f...dmin/forum.php
    Referer: http://www.activegaming.net/forums/a...hp?action=add&

    I know the problem is that there's an extra ) next to "storethread." I got the forum added my manually editing and running the query in phpmyadmin, but how can I get this fixed so I don't have to do this every time I add a forum?

  • #2
    storereply and storethread are not standard vB2 columns. Since you have hacked your installation we cannot provide assistance and you will need to ask at vBulletin.org.

    Comment

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