bugphpGroupWare - Bugs: bug #1942, Single quotes in filters which are...

 
 

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

bug #1942: Single quotes in filters which are stored in preferences cause preference crash

Submitted by:  Shamim Islam <kellin>
Submitted on:  Mon 09 Dec 2002 01:11:29 PM UTC  
 
Item Group: 0.9.14.001 releaseCategory: email
Severity: 3 - NormalPriority: 5 - Normal
Status: FixedPrivacy: Public
Assigned to: Angelo Tony Puglisi <angles>Open/Closed: Closed
Component Version: SVNOperating System: GNU/Linux - Mandrake
Reproducibility: Every TimePlanned Release: None
Fixed Release: 

Fri 27 Jun 2003 02:21:00 AM UTC, comment #3:

This has been corrected in CVS.

To grab a complete update of all fixes:

1) Check to see if you have cvs installed: 'cvs --help'.
1a) If not, install a copy of cvs-cli from your favorite
distro.

2) Then just type:
'cd <your phpgroupware dir>; cvs update -dP'.

You can do step 2 as many times in a day as you wish, and
will always get the most current bug fixes.

Thanks,

Chris Weiss <cw>
Project Administrator
Sat 21 Dec 2002 01:41:27 PM UTC, comment #2:

This is fixed in anglemail-1.1-pre9-02.tar.bz2
Available at:
http://www.anglemail.org/files/anglemail-1.1-pre9-02.tar.bz2

Angelo Tony Puglisi <angles>In charge of this item.
Thu 12 Dec 2002 07:12:02 AM UTC, comment #1:

This is a known problem with the preferences database. I'll apply the same database "defang" procedure to the filters that is already applied to the other email prefs.

Angelo Tony Puglisi <angles>In charge of this item.
Mon 09 Dec 2002 01:11:29 PM UTC, original submission:

Preferences are lost if the filter in the email contains a single quote.

Don't know if this is a problem in any other area where a single quote can be entered in a preference.

Would suggest an object for the preferences that can add and remove items as needed, or an interface to add and remove them so that single quotes can be handled correctly, instead of erroring out.

Suspect the error is in the SQL statement generated by the preferences module since MySQL use single quotes to delimit character data.

No proof. Just an educated guess for who ever is going to fix it.

Shamim
BA BS

P.S. I lost my preferences 10 times last night like clockwork. Lucky I had saved the array.

Shamim Islam <kellin>

 

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
Fri 27 Jun 2003 02:21:00 AM UTCcwStatusNone=>(Error - Not Found)
  Open/ClosedOpen=>(Error - Not Found)
Thu 12 Dec 2002 01:46:35 AM UTCskwashdAssigned toNone=>NA

Back to the top


Powered by Savane 3.1-cleanup1