Announcement

Collapse
No announcement yet.

dbase error on step 8

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

  • dbase error on step 8

    hi,

    im upgrading to beta 7 from 2.3.0 and at step 8 i got this error:

    Database error in vBulletin :

    Invalid SQL:
    SELECT DISTINCT access.userid, user.username
    FROM access
    INNER JOIN user USING(userid)

    mysql error: You have an error in your SQL syntax near 'USING(userid)
    ' at line 4

    mysql error number: 1064

    what should i do?
    i did run the scripting check, i followed the upgrade help file exactly...but still this error,

    davy
    www.emecstudios.com (studio) | MAXIMUS, passion for models. | MDO, when nature calls.

  • #2
    Did you try running the upgrade again. Be careful not to go too fast by clicking next too soon. I made that mistake once and the upgrade aborted in a similar way.

    Comment


    • #3
      yes i did ran it again with no luck, he goes directly to step 8 and get stuck with that error...
      what should i do if i did hit next too soon...i can do nothing, if i go back to step 1 he goes directly to step 8 with that error...

      davy
      emecstudios
      Member
      Last edited by emecstudios; Thu 13 Nov '03, 1:25pm.
      www.emecstudios.com (studio) | MAXIMUS, passion for models. | MDO, when nature calls.

      Comment


      • #4
        Before you started the upgrade process, what did you do to prepare a database?

        Did you do a mysqldump from 2.30 and then restore into a new database?

        Comment


        • #5
          Probably a very old version of MySQL; I believe before 3.23.15 (latest is 4.0.16 I believe).

          Can you check your version? Use this query:
          SELECT VERSION() AS version;

          If it's old (as I suspect it is), you'll need to upgrade it.

          Comment


          • #6
            Originally posted by Mike Sullivan
            Probably a very old version of MySQL; I believe before 3.23.15 (latest is 4.0.16 I believe).

            Can you check your version? Use this query:
            SELECT VERSION() AS version;

            If it's old (as I suspect it is), you'll need to upgrade it.
            thnx for the help its an old mysql, before 3.23.15

            i hate these kind of problems, we pay for this service and our host doesnt do its job...

            time to change from host

            thnx again...
            davy
            www.emecstudios.com (studio) | MAXIMUS, passion for models. | MDO, when nature calls.

            Comment


            • #7
              we run our forum on an another account that has an old mysql...

              our main server from our host has mysql 3.23.56,
              is that new enough that version?

              can i install my forum on our main server and import our dbase backup from our old one?

              please, i hope this is possible,

              our old host told us that they are going to wait for several mounths before they are gonna upgrade mysql, and we pay for what??

              is it possible to move our forum to another location?

              davy
              www.emecstudios.com (studio) | MAXIMUS, passion for models. | MDO, when nature calls.

              Comment


              • #8
                our main server from our host has mysql 3.23.56,
                is that new enough that version?
                Yup, that'll work fine.

                can i install my forum on our main server and import our dbase backup from our old one?
                Yeah, we have instructions on doing the move here: http://www.vbulletin.com/manual/movingservers.html . You can then continue (or preferably, restart) the upgrade from there.

                our old host told us that they are going to wait for several mounths before they are gonna upgrade mysql, and we pay for what??
                You might want to point them to the fact that they're using a version released more than 3 years ago.

                Comment


                • #9
                  Originally posted by Mike Sullivan
                  You might want to point them to the fact that they're using a version released more than 3 years ago.
                  thnx for the help mike,
                  ill keep you informed about our upgrade

                  and yes, they told me that they had to go back to an old version because their servers couldnt handle the new one...

                  huh?

                  my contract with the old host ends on January 2004,

                  yipi ya yeah

                  davy
                  www.emecstudios.com (studio) | MAXIMUS, passion for models. | MDO, when nature calls.

                  Comment

                  Loading...
                  Working...
                  X