Database error: Invalid SQL:

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux