[VBDev]

Originally Posted by PimvanJ

I'm simply upgrading and had a error during the proces.
After that I wasnt able to get access.

The error that I have

Database error in vBulletin 3.6.8:

Invalid SQL:

SELECT administrator.*,
userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid,
language.phrasegroup_cphome AS phrasegroup_cphome,
language.phrasegroup_cpglobal AS phrasegroup_cpglobal,
language.phrasegroup_global AS phrasegroup_global,
language.options AS lang_options,
language.languagecode AS lang_code,
language.charset AS lang_charset,
language.locale AS lang_locale,
language.imagesoverride AS lang_imagesoverride,
language.dateoverride AS lang_dateoverride,
language.timeoverride AS lang_timeoverride,
language.registereddateoverride AS lang_registereddateoverride,
language.calformat1override AS lang_calformat1override,
language.calformat2override AS lang_calformat2override,
language.logdateoverride AS lang_logdateoverride,
language.decimalsep AS lang_decimalsep,
language.thousandsep AS lang_thousandsep
,mgcugp.mgc_cb_evo_default_color,mgcugp.mgc_cb_evo _default_color
FROM user AS user
LEFT JOIN userfield AS userfield ON (user.userid = userfield.userid)
LEFT JOIN usertextfield AS usertextfield ON (usertextfield.userid = user.userid) LEFT JOIN administrator AS administrator ON (administrator.userid = user.userid) LEFT JOIN language AS language ON (language.languageid = IF(user.languageid = 0, 2, user.languageid))
LEFT JOIN usergroup AS mgcugp ON (user.usergroupid=mgcugp.usergroupid) LEFT JOIN usergroup AS mgcugp ON (user.usergroupid=mgcugp.usergroupid)
WHERE user.userid = 1;

MySQL Error : Not unique table/alias: 'mgcugp'
Error Number : 1066
Date : Monday, February 18th 2008 @ 10:53:58 PM

This error is strange the query doesn't seem wrong.

I don't understand why such an error would appear especially if you were doing an upgrade.

Did you do anything wrong ?

Originally Posted by maidos

vbdev can you explain why ?

Because mainly users are not from my timezone

Btw you know the remaining bugs are not that enormous compared to other software

Originally Posted by Jenkins

it appears that the maxosx directory is causing the problems with the zip file for windows users. or at least that's what it seems to be. I can unzip 1.2 with no issues, but 2.0 is still giving me problems

Hum looks like I have to find a zip utility for mac then !

Originally Posted by Kaycee123

Well, I already sent one collapsed, here is the one expanded:

http://img.photobucket.com/albums/v4...r/chatbox2.gif

Oh sorry yes this is what I mean. But as far as I can see there is no problem with the header on the screenshots you posted ??