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'm
-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 you're using to the minimum
ie. make
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 simply
VANISHES.
I've
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
--
-
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 most frustrating problem. Data I've
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
-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 when
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 completes