Bugs item #1457571, was opened at 2006-03-24 09:08
Message generated for change (Tracker Item Submitted) made by Item Submitter
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=554338&aid=1457571&group_id=78745
Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: calendar
Group: 1.2 RC7, no more RC1-6 please !!!
Status: Open
Resolution: None
Priority: 5
Submitted By: Oldrich Dlouhy (odlouhy)
Assigned to: Ralf Becker (ralfbecker)
Summary: Calendar SQL error on MSSQL
Initial Comment:
Opening calendar app results in following message:
— START OF MESSAGE —
Database error: Invalid SQL: (SELECT
egw_cal_repeats.,egw_cal.,cal_start,cal_end,cal_recur_date
FROM egw_cal JOIN egw_cal_dates USING(cal_id) JOIN
egw_cal_user USING(cal_id) LEFT JOIN egw_cal_repeats
USING(cal_id) WHERE (cal_user_type=‘u’ AND cal_user_id
IN (8,-6,-7)) AND cal_status != ‘R’ AND 1143154800 <
cal_end AND cal_start < 1143241199 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 USING(cal_id) JOIN
egw_cal_user USING(cal_id) LEFT JOIN egw_cal_repeats
USING(cal_id) WHERE (cal_user_type=‘u’ AND cal_user_id
IN (8,-6,-7)) AND cal_status != ‘R’ AND 1143154800 <
cal_end AND cal_start < 1143241199 AND
cal_recur_date=cal_start) ORDER BY cal_start
mssql Error: 0 (‘cal_id’ is not a recognized OPTIMIZER
LOCK HINTS option.)
File:
E:\Inetpub\wwwroot\EGW\calendar\inc\class.socal.inc.php
Line: 352
Function: egw_db::union / socal::search / bocal::search
/ uiviews::day / uiviews::index /
ExecMethod(calendar.uiviews.index)
Session halted.
— END OF MESSAGE —
Configuration:
EGV 1.2 RC8
Windows 2000, IIS, PHP 5.1, MSSQL 2000
Problem is that MSSQL does not know the syntax “JOIN
table USING(field)”, it only supports “JOIN table ON
field1 = field2”
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=554338&aid=1457571&group_id=78745
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
eGroupWare-tracker mailing list
eGroupWare-tracker@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-tracker