Database Error

[Vanhalen4041]

Database error in vBulletin :

Invalid SQL:
### GET USER INFO query(userid:1 option:0) ###
SELECT user.*, userfield.*, usertextfield.*, UNIX_TIMESTAMP(passworddate) AS passworddate,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid, language.phrasegroup_global AS phrasegroup_global,
language.options AS lang_options, language.languagecode AS lang_code,
language.imagesoverride AS lang_imagesoverride, language.dateoverride AS lang_dateoverride,
language.timeoverride AS lang_timeoverride, language.decimalsep AS lang_decimalsep,
language.thousandsep AS lang_thousandsep
FROM user AS user
INNER JOIN userfield AS userfield ON (user.userid = userfield.userid)
INNER JOIN usertextfield AS usertextfield ON (usertextfield.userid = user.userid) INNER JOIN language AS language ON (language.languageid = IF(user.languageid = 0, , user.languageid))
WHERE user.userid = 1

mysql error: You have an error in your SQL syntax near ' user.languageid))
WHERE user.userid = 1
' at line 11

mysql error number: 1064

Date: Tuesday 26th of August 2003 10:06:25 PM
Script: forum/conflicts.php

[Vanhalen4041]

Anyone?

[Steve Machol]

What are you trying to do when you get this error?

[Vanhalen4041]

Just going to the index of the forum... =/

[Scott MacVicar]

The conflicts script is meant to be used in a vB2 database not a vB3 database.

Have you performed the vB3 upgrade yet?

[Vanhalen4041]

Yes.

[Steve Machol]

What's the URL to this forum? As per the original error message it looks like you were doing something with the conflicts.php script:

Script: forum/conflicts.php

[Vanhalen4041]

What's the URL to this forum? As per the original error message it looks like you were doing something with the conflicts.php script:

https://www.hyper-zone.net/~evyl

[Steve Machol]

Do you mean this URL?

http://www.hyper-zone.net/~evyl/newforum/

This produces a different error than the one you posted above:

Database error in vBulletin :

Invalid SQL:
SELECT *
FROM session
WHERE userid = 0
AND host = '68.98.227.155'
AND idhash = 'a8c5bb0d3dafcc43a6e034e4ff138504'
LIMIT 1

mysql error: Unknown column 'idhash' in 'where clause'

mysql error number: 1054

Date: Monday 15th of September 2003 04:10:07 PM
Script: http://www.hyper-zone.net/~evyl/newforum/
Referer:
IP Address: 68.98.227.155

Was this an upgrade or a fresh install? Either way it looks like you did not complete all the steps.