Re: Database error: Invalid SQL:

wisuttorn wrote:

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)

I guess that whatever database you are using doesn't allow 'JOIN' as a join type. Usually you need to specify the type: inner join, left join, right join, straight join etc. Ask your specific database list about it. -- Postgresql & php tutorials http://www.designmagick.com/