[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: Dave Hall <address@hidden>
Date: 2002-Dec-12 12:46 (Australia/Melbourne)

            What     | Removed                   | Added
---------------------------------------------------------------------------
         Assigned to | None                      | angles
                  CC |                           | address@hidden




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


Submitted by: kellin                    Project: phpGroupWare                   
Submitted on: 2002-Dec-10 00: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.



No Followups Have Been Posted


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