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

Submitted by:  None
Submitted on:  Mon 22 Mar 2004 06:55:06 PM UTC  
 
Item Group: 0.9.16.000 releaseCategory: calendar
Severity: 3 - NormalPriority: 1 - Later
Status: FixedPrivacy: Public
Assigned to: Dave Hall <skwashd>Open/Closed: Closed
Component Version: SVNOperating System: *BSD
Reproducibility: Every TimePlanned 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>
Project AdministratorIn charge of this item.
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

 

No files currently attached

 

Depends on the following items: None found

Items that depend on this one: None found

 

CC list is empty

 

Do you think this task is very important?
If so, you can click here to add your encouragement to it.
This task has 0 encouragements so far.

Only logged-in users can vote.

 

Please enter the title of George Orwell's famous dystopian book (it's a date):

 

 

Follow 3 latest changes.

Date Changed By Updated Field Previous Value => Replaced By
Thu 15 Jul 2004 04:16:21 AM UTCskwashdAssigned toNone=>skwashd
  Open/ClosedOpen=>Closed
Thu 15 Jul 2004 04:16:20 AM UTCskwashdStatusNone=>Fixed

Back to the top


Powered by Savane 3.1-cleanup1