Two Problems: Project Tools 2.0 and MGC Chatbox?

[ShadoWbg]

Hello i am using vbulletin 3.8.1. Yesterday i installed Project Tools 2.0 and i updated the MGC Chatbox of the forum.


The Project tools give some MYSQL Database Error which if i should be honnest a MYSQL noob like me understands only partially...

Database error in vBulletin 3.8.1:

Invalid SQL:

SELECT
issue.*,
issuenote.issuenoteid, issuenote.dateline,
IF(user.username IS NOT NULL, user.username, issuenote.username) AS username, issuenote.userid,
issuenote.type AS notetype, issuenote.isfirstnote, issuenote.pagetext, issuenote.visible As notevisible,
project.title_clean AS projecttitle_clean
, IF(issueassign.issueid IS NULL, 0, 1) AS isassigned

FROM pt_issuenote AS issuenote
INNER JOIN pt_issue AS issue ON (issuenote.issueid = issue.issueid)
INNER JOIN pt_project AS project ON (project.projectid = issue.projectid)
LEFT JOIN user AS user ON (user.userid = issuenote.userid)

LEFT JOIN pt_issueassign AS issueassign ON
(issueassign.issueid = issue.issueid AND issueassign.userid = 2)


WHERE issuenote.visible IN ('visible', 'private')
AND issue.visible IN ('visible', 'private')
AND ((issue.projectid = 2 AND ((issue.issuetypeid = 'task' AND (issue.visible IN ('visible') OR (issue.visible = 'private' AND issue.submituserid = 2))))) AND ((issue.projectid = 2 AND ((issue.issuetypeid = 'task' AND (issuenote.visible IN ('visible') OR (issuenote.visible = 'private' AND issuenote.userid = 2)))))))
ORDER BY issuenote.dateline DESC
LIMIT 0, 15;

MySQL Error : Illegal mix of collations (latin1_general_ci,IMPLICIT) and (cp1251_general_ci,IMPLICIT) for operation 'if'
Error Number : 1267
Request Date : Friday, March 27th 2009 @ 08:15:27 AM
Error Date : Friday, March 27th 2009 @ 08:15:27 AM
Script : vBTEAM Underground - Free vBulletin Hacks, Skins and Support
Referrer : vBTEAM Underground - Free vBulletin Hacks, Skins and Support
IP Address : XX.XXX.XXX.XXX
Username : MyAdminAcc
Classname : vB_Database
MySQL Version : 5.0.67-community-log

Well from what i guess i screwed up in the permissions somewhere? But everything seems to be asi need it. Only one usergroup, except the Admins ofc. to be able to see the Project Tools and the Forum i have reated for them.

To be honnest except that, if it is truth at all, i have screwed up that...

That is as for the first problem...

Now about number two...

I have installed updated the MGC chatbox, which is now the newest version, but after I did it started giving something which for me is an actual error. It takes loading too much. On the normal window it doesnt load at all...

When you click the Archives link it shows this error.

Database error in vBulletin 3.8.1:

Invalid SQL:

SELECT COUNT(chatid) AS nbchats
FROM mgc_cb_evo_chat AS c
LEFT JOIN user AS fromu ON (c.fromuid=fromu.userid)
LEFT JOIN user AS tou ON (c.touid=tou.userid)
WHERE chanid='0' AND coidentifier IN ('0','me','announcement','ban','del','ignore','pm','slap') AND (touid='0' OR fromuid='2'OR touid='2') AND iswarning='0' AND c.dateline>'1238049484'
ORDER BY c.dateline DESC;

MySQL Error : Unknown column 'iswarning' in 'where clause'
Error Number : 1054
Request Date : Friday, March 27th 2009 @ 08:38:04 AM
Error Date : Friday, March 27th 2009 @ 08:38:04 AM
Script : vBTEAM Underground - Free vBulletin Hacks, Skins and Support
Referrer : vBTEAM Underground - Free vBulletin Hacks, Skins and Support
IP Address : xAdminAccx.xxx.xxx.xxx
Username : My
Classname : vB_Database
MySQL Version : 5.0.67-community-log

So from the unknown 'iswarning' in 'where clause' i guess maybe it is about an error in the update or maybe there is a problem with the database tables?


Well can anyone help me about these problems?

Thanks to the ones who respond to it!