dbase error on step 8

[emecstudios]

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

[Andy]

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.

[emecstudios]

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

[Andy]

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?

[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.

[emecstudios]

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

[emecstudios]

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

[Mike Sullivan]

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.

[emecstudios]

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