[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: Chris Weiss <address@hidden>
Date: Thu 06/26/2003 at 21:21 (America/Chicago)

            What     | Removed                   | Added
---------------------------------------------------------------------------
          Resolution | None                      | Fixed
              Status | Open                      | Closed


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




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


Submitted by: kellin                  Project: phpGroupWare                 
Submitted on: Mon 12/09/2002 at 07:11
Category:  email                      Bug Group:  0.9.14.001 release        
Severity:  5 - Major                  Priority:  High                       
Resolution:  Fixed                    Assigned to:  angles                  
Status:  Closed                       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: Thu 06/26/2003 at 21:21       By: cw
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,


-------------------------------------------------------
Date: Sat 12/21/2002 at 07: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: Thu 12/12/2002 at 01: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

_______________________________________________
  Message sent via/by Savannah
  http://savannah.gnu.org/