[Phpgroupware-tracker] [Bug #1942] Single quotes in filters which are stored in preferences cause preference crash

[nobody]

=================== BUG #1942: LATEST MODIFICATIONS ==================
http://savannah.gnu.org/bugs/?func=detailbug&bug_id=1942&group_id=509

Changes by: Angelo Tony Puglisi <address@hidden>
Date: 2002-Dec-21 08:41 (America/New_York)

------------------ Additional Follow-up Comments ----------------------------
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




=================== BUG #1942: FULL BUG SNAPSHOT ===================


Submitted by: kellin                    Project: phpGroupWare                   
Submitted on: 2002-Dec-09 08:11
Category:  email                        Bug Group:  0.9.14.001 release          
Severity:  5 - Major                    Priority:  High                         
Resolution:  None                       Assigned to:  angles                    
Status:  Open                           Component Version:  CVS                 
Platform Version:  Linux - Mandrake     Reproducibility:  Every Time            

Summary:  Single quotes in filters which are stored in preferences cause 
preference crash

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.

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

-------------------------------------------------------
Date: 2002-Dec-21 08:41             By: angles
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


-------------------------------------------------------
Date: 2002-Dec-12 02:12             By: angles
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.


CC List
*******

CC Address                          | Comment
------------------------------------+-----------------------------
address@hidden           | another one for the list



No files currently attached


For detailed info, follow this link:
http://savannah.gnu.org/bugs/?func=detailbug&bug_id=1942&group_id=509