I have a problem please help me when i loged in to egroup this show " Database error: Invalid SQL: SELECT DISTINCT egw_cal_repeats.*,egw_cal.*,cal_start,cal_end,cal_recur_date FROM egw_cal JOIN egw_cal_dates ON egw_cal.cal_id=egw_cal_dates.cal_id JOIN egw_cal_user ON egw_cal.cal_id=egw_cal_user.cal_id LEFT JOIN egw_cal_repeats ON egw_cal.cal_id=egw_cal_repeats.cal_id WHERE (cal_user_type='u' AND cal_user_id IN (6,-1)) AND cal_status != 'R' AND 1179939600 < cal_end AND cal_start < 1180025999 AND (recur_type IS NULL AND cal_recur_date=0 OR cal_recur_date=cal_start) ORDER BY cal_start mysql Error: 1064 (You have an error in your SQL syntax near 'ON egw_cal.cal_id=egw_cal_dates.cal_id JOIN egw_cal_user ON egw_cal.cal_id=egw_c' at line 1) File: /home/lecturer/account/wisuttorn/public_html/work/calendar/inc/class.socal.inc.php Line: 372 Function: egw_db::select / socal::search / bocal::search / uiviews::day / uiviews::index / execmethod(calendar.uiviews.index) Session halted." How can i fix this problem? Thank you -- View this message in context: http://www.nabble.com/Database-error%3A-Invalid-SQL%3A-tf3807948.html#a10777304 Sent from the PHP - General mailing list archive at Nabble.com. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
