Hallo zusammen,
ich habe ein Problem mit der Ext. "cal" Version 1.1.0. Diese Fehlermeldung tritt nur auf, wenn ich im Frontend die Wochenansicht wähle. Komisch ist, dass trotz der Fehlermeldung die Ergebnisse in der folgenden Wochenansicht trotzdem angezeigt werden. Alle anderen eingebundenen Ansichten (Monats- und Eventansicht) funktionieren ohne Probleme. Woran liegt das? Wer kann mir einen Tipp geben, so dass ich das Problem beheben kann?
Ich habe zur näheren Erkenntnis die Ausgabe des SQLDebug-Moduses angehängt.
Viele Grüße
THETREE
caller t3lib_DB::exec_SELECTquery
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 'AND tx_cal_event_attendee_mm.uid_local = tx_cal_event.uid AND tx_cal_event_atten' at line 4
lastBuiltQuery SELECT tx_cal_calendar.uid AS calendar_uid, tx_cal_calendar.owner AS calendar_owner, tx_cal_event.*, tx_cal_event_category_mm.uid_foreign AS category_uid
FROM tx_cal_event, tx_cal_calendar, tx_cal_event_category_mm, tx_cal_attendee, tx_cal_event_attendee_mm
WHERE
tx_cal_calendar.uid = tx_cal_event.calendar_id AND tx_cal_event_category_mm.uid_local = tx_cal_event.uid AND tx_cal_event_category_mm.uid_foreign IN (1,4,2,3,5) AND tx_cal_calendar.uid IN (4,1) AND tx_cal_event.pid IN (177) AND tx_cal_event.deleted=0 AND ((tx_cal_event.start_date>=20080903 AND tx_cal_event.start_date<=20090111) OR (tx_cal_event.end_date<=20090111 AND tx_cal_event.end_date>=20080903) OR (tx_cal_event.end_date>=20090111 AND tx_cal_event.start_date<=20080903) OR (tx_cal_event.start_date<=20090111 AND (tx_cal_event.freq IN ("day","week","month","year") AND tx_cal_event.until>=20080903))) AND tx_cal_attendee.status IN ("0","NEEDS-ACTION") AND tx_cal_attendee.attendance <> "CHAIR" AND tx_cal_event.type = 3 AND tx_cal_attendee.fe_user_id = AND tx_cal_event_attendee_mm.uid_local = tx_cal_event.uid AND tx_cal_event_attendee_mm.uid_foreign = tx_cal_attendee.uid AND tx_cal_event.sys_language_uid IN (0,-1)
GROUP BY tx_cal_event.uid
ORDER BY tx_cal_event.start_date ASC, tx_cal_event.start_time ASC, tx_cal_event.uid,tx_cal_event_category_mm.sorting
debug_backtrace require // include // TSpagegen::renderContent // tslib_cObj->cObjGet // tslib_cObj->cObjGetSingle // tslib_cObj->TEMPLATE // tslib_cObj->cObjGetSingle // tslib_cObj->CONTENT // tslib_cObj->cObjGetSingle // tslib_cObj->cObjGetSingle // tslib_cObj->CASEFUNC // tslib_cObj->cObjGetSingle // tslib_cObj->COBJ_ARRAY // tslib_cObj->cObjGet // tslib_cObj->cObjGetSingle // tslib_cObj->CASEFUNC // tslib_cObj->cObjGetSingle // tslib_cObj->cObjGetSingle // tslib_cObj->USER // tslib_cObj->callUserFunction // call_user_method // tx_cal_controller->main // tx_cal_controller->getContent // tx_cal_controller->week // tx_cal_viewcontroller->drawWeek // tx_cal_weekview->drawWeek // tx_cal_base_view->finish // tx_cal_base_view->getMarker // tx_cal_base_view->getMeetingInformationMarker // tx_cal_event_service->findMeetingEventsWithEmptyStatus // tx_cal_event_service->getEventsFromTable // t3lib_DB->exec_SELECTquery // t3lib_DB->debug
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /var/www/vhosts/xxx/httpdocs/typo3_src-4.1.5/t3lib/class.t3lib_db.php on line 796
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /var/www/vhosts/xxx/httpdocs/typo3_src-4.1.5/t3lib/class.t3lib_db.php on line 823
caller t3lib_DB::exec_SELECTquery
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 'AND tx_cal_event.uid NOT IN (11,13,14,15,16,17,18,20,21,22,23,24,25,26,27,28,29,' at line 4
lastBuiltQuery SELECT tx_cal_calendar.uid AS calendar_uid, tx_cal_calendar.owner AS calendar_owner, tx_cal_event.*
FROM tx_cal_event, tx_cal_calendar, tx_cal_attendee, tx_cal_event_attendee_mm
WHERE
tx_cal_calendar.uid = tx_cal_event.calendar_id AND tx_cal_calendar.uid IN (4,1) AND tx_cal_event.pid IN (177) AND tx_cal_event.deleted=0 AND ((tx_cal_event.start_date>=20080903 AND tx_cal_event.start_date<=20090111) OR (tx_cal_event.end_date<=20090111 AND tx_cal_event.end_date>=20080903) OR (tx_cal_event.end_date>=20090111 AND tx_cal_event.start_date<=20080903) OR (tx_cal_event.start_date<=20090111 AND (tx_cal_event.freq IN ("day","week","month","year") AND tx_cal_event.until>=20080903))) AND tx_cal_attendee.status IN ("0","NEEDS-ACTION") AND tx_cal_attendee.attendance <> "CHAIR" AND tx_cal_event.type = 3 AND tx_cal_attendee.fe_user_id = AND tx_cal_event.uid NOT IN (11,13,14,15,16,17,18,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86) AND tx_cal_event_attendee_mm.uid_local = tx_cal_event.uid AND tx_cal_event_attendee_mm.uid_foreign = tx_cal_attendee.uid AND tx_cal_event.sys_language_uid IN (0,-1)
GROUP BY uid
ORDER BY tx_cal_event.start_date ASC, tx_cal_event.start_time ASC
debug_backtrace require // include // TSpagegen::renderContent // tslib_cObj->cObjGet // tslib_cObj->cObjGetSingle // tslib_cObj->TEMPLATE // tslib_cObj->cObjGetSingle // tslib_cObj->CONTENT // tslib_cObj->cObjGetSingle // tslib_cObj->cObjGetSingle // tslib_cObj->CASEFUNC // tslib_cObj->cObjGetSingle // tslib_cObj->COBJ_ARRAY // tslib_cObj->cObjGet // tslib_cObj->cObjGetSingle // tslib_cObj->CASEFUNC // tslib_cObj->cObjGetSingle // tslib_cObj->cObjGetSingle // tslib_cObj->USER // tslib_cObj->callUserFunction // call_user_method // tx_cal_controller->main // tx_cal_controller->getContent // tx_cal_controller->week // tx_cal_viewcontroller->drawWeek // tx_cal_weekview->drawWeek // tx_cal_base_view->finish // tx_cal_base_view->getMarker // tx_cal_base_view->getMeetingInformationMarker // tx_cal_event_service->findMeetingEventsWithEmptyStatus // tx_cal_event_service->getEventsFromTable // tx_cal_event_service->getEventsFromTable // t3lib_DB->exec_SELECTquery // t3lib_DB->debug
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /var/www/vhosts/xxx/httpdocs/typo3_src-4.1.5/t3lib/class.t3lib_db.php on line 796
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /var/www/vhosts/xxx/httpdocs/typo3_src-4.1.5/t3lib/class.t3lib_db.php on line 823
Warning: Cannot modify header information - headers already sent by (output started at /var/www/vhosts/xxx/httpdocs/typo3_src-4.1.5/t3lib/class.t3lib_db.php:1103) in /var/www/vhosts/xxx/httpdocs/typo3_src-4.1.5/typo3/sysext/cms/tslib/class.tslib_fe.php on line 2907