RE: [Ruqueue-user] problem with escaping single quotes?

[John Fulton]

Michiel,

Thank you for reporting this.  I've added it to the FAQ for now
and will add it to the next version of the documentation.

  John

On Mon, 5 Dec 2005, van Mil, Michiel wrote:

> OK this will be the last mail. I feel like a dolt. Although you might
> want to mention the following in the install docs:
>
>
>
> Make sure that in php.ini the following settings are set:
>
> ; Magic quotes for incoming GET/POST/Cookie data.
>
> magic_quotes_gpc = On
>
>
>
> ; Magic quotes for runtime-generated data, e.g. data from SQL, from
> exec(), etc.
>
> magic_quotes_runtime = Off
>
>
>
> ; Use Sybase-style magic quotes (escape ' with '' instead of \').
>
> magic_quotes_sybase = Off
>
>
>
> This makes sure the system enters AND renders all mails correctly.
>
>
>
> Thanks for your time, much appreciated.
>
>
>
> Michiel
>
>
>
> ________________________________
>
> From: Ramon P. Quezada [mailto:address@hidden
> Sent: maandag 5 december 2005 21:34
> To: van Mil, Michiel; address@hidden
> Cc: John Fulton
> Subject: RE: [Ruqueue-user] problem with escaping single quotes?
>
>
>
> Hi Michiel,
>
>
>
> I'm glad you got it to work properly.  I will look into correcting the
> two renderings.  Thanks a lot.
>
>
>
> -Ray
>
> ________________________________
>
> From: van Mil, Michiel [mailto:address@hidden
> Sent: Monday, December 05, 2005 3:10 PM
> To: Ramon P. Quezada
> Cc: John Fulton
> Subject: RE: [Ruqueue-user] problem with escaping single quotes?
>
>
>
> Sorry for the flurry of spam but I confirm it is a php.ini setting that
> caused this:
>
>
>
> ; Magic quotes for incoming GET/POST/Cookie data.
>
> magic_quotes_gpc = On
>
> ; Magic quotes for runtime-generated data, e.g. data from SQL, from
> exec(), etc.
>
> magic_quotes_runtime = On
>
> ; Use Sybase-style magic quotes (escape ' with '' instead of \').
>
> magic_quotes_sybase = Off
>
>
>
> I turned the first two options On (they were off by default) and now the
> tickets don't disappear.
>
> A minor glitch: now any quote is escaped by a backslash in the ticket
> comments:
>
> Single quote: \'
> Two quotes  : \'\'
> Two quotes with text: \'test\'
> Double Quote: "
> Double quote text: "test"
> Double quotes: ""
>
>
>
> However, in the mail the system sends out this shows up as:
>
> Single quote: '
>
>
>
> Two quotes  : ''
>
>
>
> Two quotes with text: 'test'
>
>
>
> Double Quote: "
>
>
>
> Double quote text: "test"
>
>
>
> Double quotes: ""
>
>
>
> Note the extra lines in between, and the single quotes render well.
> Double quotes are turned into " for some reason.
>
>
>
> I googled around for a bit on the single quote problem and people on the
> internet(s) are saying things like
>
> Use mysql_escape_string() before insert to db, then stripslashes()
> before dsiplaying it.
>
> Which doesn't mean a lot to me but maybe it does to you?
>
>
>
> Regards,
>
> Michiel
>
>
>
> ________________________________
>
> From: Ramon P. Quezada [mailto:address@hidden
> Sent: maandag 5 december 2005 20:09
> To: van Mil, Michiel
> Cc: John Fulton
> Subject: [Ruqueue-user] problem with escaping single quotes?
>
>
>
> Hi Michiel,
>
>
>
> I'm glad you enjoy the project.  I tried adding and editing the ticket
> with quotes and could not reproduce this problem.  Each time I was able
> to view the ticket in its queue with its appropriate subject and body.
> Can you provide me with the exact steps, including the information you
> typed into the form with single quotes that you took when this happened?
>
>
>
> Thanks,
>
> Ray
>
>