i have tis error would anybody have any ideas ?
Database error in vBulletin 4.1.5:
Invalid SQL:
SELECT event. sg.name as socialgroupname, *,
user.username, IF(user.displaygroupid = 0, user.usergroupid, user.displaygroupid) AS displaygroupid,
user.adminoptions, user.usergroupid, user.usertitle, user.membergroupids, user.infractiongroupids, IF(options & 8192, 1, 0) AS hasaccessmask,
IF(dateline_to = 0, 1, 0) AS singleday
, subscribeevent.eventid AS subscribed
,avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,
customavatar.width AS avwidth,customavatar.height AS avheight, customavatar.width_thumb AS avwidth_thumb, user.avatarrevision,
customavatar.height_thumb AS avheight_thumb, customavatar.filedata_thumb, NOT ISNULL(customavatar.userid) AS hascustom
FROM vb_event AS event
LEFT JOIN vb_user AS user ON (user.userid = event.userid)
LEFT JOIN vb_socialgroupmember sgm ON sgm.userid = 01 AND sgm.groupid = event.socialgroupcalendar
LEFT JOIN (SELECT groupid, name FROM vb_socialgroup) sg ON sg.groupid = event.socialgroupcalendar
LEFT JOIN vb_subscribeevent AS subscribeevent ON (subscribeevent.eventid = event.eventid AND subscribeevent.userid = 1)
LEFT JOIN vb_avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN vb_customavatar AS customavatar ON(customavatar.userid = user.userid)
WHERE calendarid = 1 AND
((dateline_to >= 1312113600 AND dateline_from < 1320148800) OR (dateline_to = 0 AND dateline_from >= 1312113600 AND dateline_from <= 1320148800 )) AND
event.visible = 1
AND (event.socialgroupcalendar = 0 OR sgm.groupid IS NOT NULL OR 1=1 )
ORDER BY dateline_from;
MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '*,
user.username, IF(user.displaygroupid = 0, user.usergroupid, user.displaygr' at line 1
Error Number : 1064
|