Announcement

Collapse
No announcement yet.

MySQL Error 1064

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

  • MySQL Error 1064

    Trying to upgrade to Gamma and keep getting this error:

    Database error in vBulletin :

    Invalid SQL:
    INSERT INTO administrator (userid, adminpermissions)
    SELECT user.userid, 65532
    FROM user INNER JOIN usergroup USING(usergroupid)
    WHERE usergroup.cancontrolpanel = 1

    mysql error: You have an error in your SQL syntax near 'USING(usergroupid)
    WHERE usergroup.cancontrolpanel = 1
    ' at line 4

    mysql error number: 1064

    Date: Friday 12th of December 2003 04:14:08 PM
    Script: http://www.florida3si.com/forum/inst...de1.php?step=9
    Any ideas?

  • #2
    getting this error as well

    Database error in vBulletin 2.3.3:

    Invalid SQL: SELECT forumid,parentid,displayorder,title FROM forum WHERE displayorder<>0 AND active=1 ORDER BY parentid,displayorder,forumid
    mysql error: Unknown column 'active' in 'where clause'

    mysql error number: 1054

    Date: Friday 12th of December 2003 04:20:10 PM
    Script: http://www.flscc.com/vBulletin/unzip...load/index.php
    Referer: http://www.flscc.com/

    Comment


    • #3
      Nobody has an idea???

      Comment


      • #4
        Did you run the database conflicts script on the vB2 database prior to upgrading?

        http://www.vbulletin.com/forum/showt...threadid=73163
        Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
        Change CKEditor Colors to Match Style (for 4.1.4 and above)

        Steve Machol Photography


        Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


        Comment


        • #5
          Yes, still did not help.

          I do know my server is running an old verson of MySQL. COuld that be a problem? I didnt see anywhere that stated what version fo MySQL vB Gamma needed though

          Comment


          • #6
            What version of MySQL?
            Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
            Change CKEditor Colors to Match Style (for 4.1.4 and above)

            Steve Machol Photography


            Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


            Comment


            • #7
              Originally posted by Steve Machol
              What version of MySQL?
              3.22.32

              I'm helping with the upgrade. There was only one conflict and it was taken care of. After that, we get that error on step 8. We're upgrading from 2.3.3.
              Ed FvC
              Webmaster, FordvsChevy.com

              Comment


              • #8
                That version is ancient and well below the minimum required for vB. You will need to ask your host to upgrade MySQL - preferably to 4.0.16.
                Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
                Change CKEditor Colors to Match Style (for 4.1.4 and above)

                Steve Machol Photography


                Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


                Comment


                • #9
                  I knew it. The host was waiting 'til the end of the year to upgrade. WHY? I have no idea. I almost peed my pants laughing when I saw how old that version of MySQL was. I coudn't even run the repair.php script.

                  He needs to get his act together.
                  Ed FvC
                  Webmaster, FordvsChevy.com

                  Comment

                  Loading...
                  Working...
                  X