[Phpgroupware-tracker] [bugs #8247] Error when adding New Years Day in holiday

[Dave Hall]

This mail is an automated notification from the bugs tracker
 of the project: phpGroupWare.

/**************************************************************************/
[bugs #8247] Latest Modifications:

Changes by: 
                Dave Hall <address@hidden>
'Date: 
                Thu 07/15/2004 at 04:16 (Australia/Melbourne)

            What     | Removed                   | Added
---------------------------------------------------------------------------
          Resolution | None                      | Fixed
         Assigned to | None                      | skwashd
              Status | Open                      | Closed


------------------ Additional Follow-up Comments ----------------------------
This has been fixed in CVS and should be available in the next
release.






/**************************************************************************/
[bugs #8247] Full Item Snapshot:

URL: <http://savannah.gnu.org/bugs/?func=detailitem&item_id=8247>
Project: phpGroupWare
Submitted by: 0
On: Mon 03/22/2004 at 18:55

Category:  calendar
Item Group:  0.9.16.000 release
Severity:  5 - Average
Priority:  1 - Later
Resolution:  Fixed
Assigned to:  skwashd
Status:  Closed
Component Version:  CVS
Platform Version:  BSD
Reproducibility:  Every Time


Summary:  Error when adding New Years Day in holiday

Original Submission:  When I enter the date for New Years into the 
calendar/holiday the following error results.

Database error: Invalid SQL: INSERT INTO 
phpgw_cal_holidays(locale,name,mday,month_num,occurence,dow,observance_rule) 
VALUES('UD','New Year's Day',1,1,0,0,0)
MySQL Error: 1064 (You have an error in your SQL syntax. Check the manual that 
corresponds to your MySQL server version for the right syntax to use near 's 
Day',1,1,0,0,0)' at line 1)

File: 
/usr/local/www/isi.sensors.com/html/phpgroupware/calendar/inc/class.soholiday.inc.php
Line: 45
Session halted.

Follow-up Comments
------------------


-------------------------------------------------------
Date: Thu 07/15/2004 at 04:16       By: skwashd
This has been fixed in CVS and should be available in the next
release.

-------------------------------------------------------
Date: Thu 03/25/2004 at 22:03       By: thegriffgeeks
The same error occurs when editing any holidays that have the "'s" in them. You 
have to edit the name to have "'s" before you can save the edit.












For detailed info, follow this link:
<http://savannah.gnu.org/bugs/?func=detailitem&item_id=8247>

_______________________________________________
  Message sent via/by Savannah
  http://savannah.gnu.org/