Hi,
The difference in the behaviour of browser interpratation might only be on
Style sheet/CSS file. So the improperness might be of PHP. So better trace
the 'insert' or check the method. If it is GET method, sure the length is
a constraint and there may be chance for data to get eliminated if the
length exceeds 256 chars.
The best solution is trace the parameter values, whether they are
interpreted as it is.
Thanks
ViSolve DB Team
----- Original Message -----
From: "Matt Neimeyer" <[EMAIL PROTECTED]>
To: <mysql@lists.mysql.com>
Sent: Wednesday, December 27, 2006 8:15 PM
Subject: MySQL Data Vanishing with FireFox
We recently started getting reports that when users access our PHP based
CRM
system that it "didn't work". After much debugging and tracking down it
looks
like that ultimately what's happening is that SOMETIMES with a statement
like...
INSERT INTO Customers (A,B,C) VALUES ("One","Two","Three")
...that Three just doesn't make it into the database. So If I...
SELECT * FROM Customers WHERE A="One"
... I would get "One","Two",""
It seems to happen more often (maybe only) with FireFox. Other tables have
no
problems that we can see. C is indexed... but we have other indexed fields
in
the table that don't seem to be affected. It's not our biggest table by
far...
I'm baffled. Where do I look next?
This is on a hosted box so we have limited access to the "command line".
This is
using PHP 4.3.11 with MySQL 3.23.58 on Apache 2.0.51 on a Fedora system
(of
unknown version)
Thanks in advance...
Matt
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
