hello I'm new to egroupware, and I've installed it on my Windows 2003 Server with SQL and it launches but when I log into it, I get this error below.
Database error: Invalid SQL: (SELECT 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 (10,-2)) AND cal_status != 'R' AND 1209621600 < cal_end AND cal_start < 1209707999 AND recur_type IS NULL AND cal_recur_date=0) UNION (SELECT 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 (10,-2)) AND cal_status != 'R' AND 1209621600 < cal_end AND cal_start < 1209707999 AND cal_recur_date=cal_start) ORDER BY cal_start
mssql Error: 37000 ([Microsoft][ODBC SQL Server Driver][SQL Server]The text data type cannot be selected as DISTINCT because it is not comparable.)
