Originally Posted by PimvanJ (Post 1446192)

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

Originally Posted by maidos (Post 1446235)

vbdev can you explain why ?

Originally Posted by Jenkins (Post 1446307)

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

Originally Posted by Kaycee123 (Post 1446313)

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

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

Originally Posted by lordtopcat (Post 1446400)

Hey vBDev,

Are you going to release a fix for the color selection? I am awaiting this fix before I launch my site.

Cheers
LTC

Originally Posted by maidos (Post 1446406)

well at least u can ask ppl from ur same timezone ?
beside you also know that when you release a new version new bugs always occurs not big but it can always be troublesome lke for my issue

Originally Posted by VBDev (Post 1431113)

You have not followed install instrcutions carefully.

Readme says : Remove all chatbox files first (previous version), remove old products, and then do the fresh install.

Now two solutions to correct your mistake : either rebuild bitfields manually after having removed the old chatbox files from your directories (especially the one in the xml directory) or remove files and install product again.

Originally Posted by VBDev (Post 1446385)

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 ?