Re: Database error: Invalid SQL:

On Wed, May 23, 2007 11:42 pm, 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) This is an SQL error. Ask an SQL list. At a guess, I'd say the version of SQL you have doesn't support all JOIN types. -- Some people have a "gift" link here. Know what I want? I want you to buy a CD from some indie artist. http://cdbaby.com/browse/from/lynch Yeah, I get a buck. So?