I have a very strange problem with MySQL. I'm using an AUTO_INCREMENT column as the primary key in one of my tables. Data is inserted into the table from remote clients through a HTML form. The server-side app is PHP/FastCGI. The problem is that sometimes I get double entries into the table from one post. The AUTO_INCREMENT column increments correctly, but it duplicates the data and creates two rows in the table. This seems to only be occurring when the remote client is using a firewall. If the client turns off their firewall, the duplicate entries stop.
The AUTO_INCREMENT item is a bigint(18) unsigned. It functions as the primary key and is the only index in the table.
I've had this problem across several different versions of PHP and MySQL. Has anyone had a similar experience?
I dont think this is a MySQL issue, but an application issue. I have seen this in some places before with an Image Gallery app a few months ago.
__________________
I rarely give code examples.
No, I have never used IIS or Windows of any kind as a web server. Get a real OS!
Please don't PM me, I won't respond.
Must read Review for Serious PHP Developers
NuSphere PhpED 5.0
: The Staff of php-editors.com recently spent a few days working with NuSphere
PhpED 5.0
(a popular PHP IDE) and
NuCoder 1.4
(a PHP Encoding Utility), read up on all the details.