Sheryl Canter wrote:
I've got a weird problem that's driving me nuts. I'm updating a set of
scripts for a customer database that supports sending out software
registration codes in real time. I've had this working for some time now,
but I'm having the most frustrating problem. Data I've inserted si
> -Original Message-
> From: Sheryl (Permutations Software) [mailto:[EMAIL PROTECTED]
> Sent: maandag 31 januari 2005 14:44
> To: 'leegold'; mysql@lists.mysql.com
> Subject: RE: disappearing data - please help!
>
> > Par down the PHP or what ever script
Lee wrote:
> Are you escaping the data you insert? If you have apostrophies eg.
"Sheryl's Website", you could have problem if you do not escape special
chars. See if it happens with just "aa" (without the quotes) in all
the fields in the record...then try unescaped words with apostrophies.
I'
> > From: Sheryl (Permutations Software) [mailto:[EMAIL PROTECTED]
> > Sent: zondag 30 januari 2005 21:31
> > To: mysql@lists.mysql.com
> > Subject: disappearing data - please help!
> >
> > What makes this all the more mysterious is that it happens
> > intermittently. Sometimes when the script
> -Original Message-
> From: Sheryl (Permutations Software) [mailto:[EMAIL PROTECTED]
> Sent: zondag 30 januari 2005 21:31
> To: mysql@lists.mysql.com
> Subject: disappearing data - please help!
>
> What makes this all the more mysterious is that it happens
> intermittently. Sometimes wh
On Sun, Jan 30, 2005 at 04:03:37PM -0500, Sheryl (Permutations Software) wrote:
> transactions. It's just the default. I don't know where I'd check AutoCommit
> settings (or it they even apply to the default database type). It doesn't
> refer to this in phpinfo.php.
Try doing this immediately after
l
-Original Message-
From: Jason Martin [mailto:[EMAIL PROTECTED]
Sent: Sunday, January 30, 2005 3:38 PM
To: mysql@lists.mysql.com
Subject: Re: disappearing data - please help!
On Sun, Jan 30, 2005 at 03:28:56PM -0500, Sheryl (Permutations Software)
wrote:
> but I'm having the mo
On Sun, Jan 30, 2005 at 03:28:56PM -0500, Sheryl (Permutations Software) wrote:
> but I'm having the most frustrating problem. Data I've inserted simply
> VANISHES.
What is the setting for AutoCommit? If it is 0, are you sure
that commit is being called before the session ends?
-Jason Martin
--
F
