bugphpGroupWare - Bugs: bug #8247, Error when adding New Years Day in...

 
 

You are not allowed to post comments on this tracker with your current authentication level.

bug #8247: Error when adding New Years Day in holiday

Submitter:  None
Submitted:  Mon 22 Mar 2004 06:55:06 PM UTC
   
 
Category:  calendar Item Group:  0.9.16.000 release
Severity:  3 - Normal Priority:  1 - Later
Status:  Fixed Privacy:  Public
Assigned to:  skwashd Open/Closed:  Closed
Component Version:  SVN Operating System:  *BSD
Reproducibility:  Every Time Planned Release:  None
Fixed Release: 

Thu 15 Jul 2004 04:16:21 AM UTC, comment #2: 

This has been fixed in CVS and should be available in the next
release.

Dave Hall <skwashd>
Group administrator
Thu 25 Mar 2004 10:03:35 PM UTC, comment #1: 

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.

Bridgit Griffin <thegriffgeeks>
Mon 22 Mar 2004 06:55:06 PM UTC, 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.

Anonymous

 

(Note: upload size limit is set to 16384 kB, after insertion of the required escape characters.)

No files currently attached

 

Depends on the following items: None found

Items that depend on this one: None found

 

CC list is empty

 

There are 0 votes so far. Votes easily highlight which items people would like to see resolved in priority, independently of the priority of the item set by tracker managers.

 

Follow 3 latest changes.

Date Changed by Updated Field Previous Value => Replaced by
2004-07-15 skwashd Assigned toNone skwashd
    Open/ClosedOpen Closed
2004-07-15 skwashd StatusNone Fixed

Back to the top

Powered by Savane 3.15.
Corresponding source code