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

[van Mil, Michiel]

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