Announcement

Collapse
No announcement yet.

HELP - Error 1064 (With PHP 4.06)

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

  • HELP - Error 1064 (With PHP 4.06)

    I attempted to create a child forum and got the following:

    Database error in vBulletin Control Panel 2.2.6:

    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)
    VALUES
    (NULL,'1','Archived: Forum Guide Forum','','1','1','20',
    '','1','1','\','','',
    '0','1','1','1','1','1',
    '0','1','1','0')
    mysql error: You have an error in your SQL syntax near '0','1','1','1','1','1',
    '0','1','1','0')' at line 8

    mysql error number: 1064

    Date: Sunday 04th of August 2002 08:36:27 PM
    Script: http://www.ipiu.org/forums//forums/admin/forum.php
    Referer: http://www.ipiu.org/forums/admin/forum.php?action=add

    DAVID COPELAND
    Licensed VB Holder Since 2000
    Celebrating 20 Years with VB

  • #2
    upload the original forum.php to your admin folder, you have installed a hack that has caused this problem. I can count 23 field names and 24 values being inputted so obviously thats one too many.
    Scott MacVicar

    My Blog | Twitter

    Comment


    • #3
      The parent forum I was assigning the new child forum to was installed with an earlier version of VB, and probably with a hack at that time.

      We have alread gone through several upgrades since, and newer child forums that were installed last week in newer parent forums were successfully installed.

      This child (with the error) did not succeed in the install, as you see. But I just succeeded in installing it in a newer parent forum. I believe the forum.php is correct, but that the older forum contains the problem.

      Should I recreate a duplicated forum to replace the older one? And then mass move all the topics in preparation to deleting it?

      DAVID COPELAND
      Licensed VB Holder Since 2000
      Celebrating 20 Years with VB

      Comment


      • #4
        Upload the latest forum.php would be the first thing to do, the next would be to check that the structure of your forum table matches the version you should be running, ie all the columns exist.
        Scott MacVicar

        My Blog | Twitter

        Comment

        Loading...
        Working...
        X