I was installing a modification that did not go well. So I restored my site with my backup and now I am getting this Database Error. How can I fix his?
Database error in vBulletin 3.8.2:
Invalid SQL:
SELECT event.*, sg.name as socialgroupname,
user.username, IF(user.displaygroupid = 0, user.usergroupid, user.displaygroupid) AS displaygroupid,
IF(dateline_to = 0, 1, 0) AS singleday
, subscribeevent.eventid AS subscribed
FROM event AS event
LEFT JOIN user AS user ON (user.userid = event.userid)
LEFT JOIN socialgroupmember sgm ON sgm.userid = 01 AND sgm.groupid = event.socialgroupcalendar
LEFT JOIN (SELECT groupid, name FROM socialgroup) sg ON sg.groupid = event.socialgroupcalendar
LEFT JOIN subscribeevent AS subscribeevent ON (subscribeevent.eventid = event.eventid AND subscribeevent.userid = 1)
WHERE calendarid = 1 AND
((dateline_to >= 1270036800 AND dateline_from < 1272715200) OR (dateline_to = 0 AND dateline_from >= 1270036800 AND dateline_from <= 1272715200 )) AND
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 'SELECT groupid, name FROM socialgroup) sg ON sg.groupid = event
Error Number : 1064
Request Date : Friday, April 16th 2010 @ 03:02:39 PM
Error Date : Friday, April 16th 2010 @ 03:02:41 PM
Script : http://sonoma.ca.theparentpack.org/
Referrer :
IP Address : XXXXXXXXXXX
Username : Tina
Classname : vb_database
MySQL Version : 4.0.27-max-log
Database error in vBulletin 3.8.2:
Invalid SQL:
SELECT event.*, sg.name as socialgroupname,
user.username, IF(user.displaygroupid = 0, user.usergroupid, user.displaygroupid) AS displaygroupid,
IF(dateline_to = 0, 1, 0) AS singleday
, subscribeevent.eventid AS subscribed
FROM event AS event
LEFT JOIN user AS user ON (user.userid = event.userid)
LEFT JOIN socialgroupmember sgm ON sgm.userid = 01 AND sgm.groupid = event.socialgroupcalendar
LEFT JOIN (SELECT groupid, name FROM socialgroup) sg ON sg.groupid = event.socialgroupcalendar
LEFT JOIN subscribeevent AS subscribeevent ON (subscribeevent.eventid = event.eventid AND subscribeevent.userid = 1)
WHERE calendarid = 1 AND
((dateline_to >= 1270036800 AND dateline_from < 1272715200) OR (dateline_to = 0 AND dateline_from >= 1270036800 AND dateline_from <= 1272715200 )) AND
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 'SELECT groupid, name FROM socialgroup) sg ON sg.groupid = event
Error Number : 1064
Request Date : Friday, April 16th 2010 @ 03:02:39 PM
Error Date : Friday, April 16th 2010 @ 03:02:41 PM
Script : http://sonoma.ca.theparentpack.org/
Referrer :
IP Address : XXXXXXXXXXX
Username : Tina
Classname : vb_database
MySQL Version : 4.0.27-max-log
Comment