Database error: Invalid SQL:
| From: | wisuttorn | Date: | Thu, 24 May 2007 04:42:36 +0000 |
| Subject: | Database error: Invalid SQL: | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-255489@lists.php.net to get a copy of this message | ||
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.