[santimariani]

Help! I am getting the following error:

Database error in vBulletin 3.6.5:

Invalid SQL:

SELECT
c.calendarid,
max(CASE WHEN cp.calendarpermissions IS NULL THEN
ug.calendarpermissions
ELSE cp.calendarpermissions
END) maxPerm
FROM
usergroup ug
CROSS JOIN calendar c
LEFT JOIN calendarpermission cp ON
c.calendarid = cp.calendarid
AND cp.usergroupid = ug.usergroupid
WHERE
ug.usergroupid IN (6, 09)
GROUP BY
c.calendarid;;

MySQL Error : Unknown column 'ug.usergroupid' in 'on clause'
Error Number : 1054
Date : Monday, May 21st 2007 @ 08:36:59 PM
Script : XXXX
Referrer : XXXX
IP Address : XXX
Username : XXX
Classname : vB_Database

Thanks for what is promising to be a very useful mod.