Strange mysql double query

richie

I am seeing some very strange behavior on my servers.

When I try to edit a mysql record, the query often gets run TWICE. This seems to only happen when I UPDATE a record.

Look at the query below. I ran it from phpmyadmin.

-------------BEGIN---------------

Affected rows: 1

SQL-query:
UPDATE users SET usercat = 'homebuilder,homebuilder',
active = 'n' WHERE id =65 LIMIT 1 ;

UPDATE users SET usercat = 'homebuilder,homebuilder',
active = 'n' WHERE id =65 LIMIT 1 ;

--------------END------------------

Notice how:

The query was ran twice,
The query was formatted wrong. "homebuilder" appears twice for some really bizzare reason.

The correct query, which should have been run only once is:

-------------BEGIN---------------

UPDATE users SET usercat = 'homebuilder', active = 'n' WHERE id =65 LIMIT 1 ;

--------------END------------------

I thought phpmyadmin had a bug, so I upgraded it to the latest version 2.6.1. But same problem.

I then upgraded mysql from 3.23 to 4.0.21. Same problem.

I'm running php 4.2.2 + Apache 2.0.40 on RedHat 9. Could this version of php be the problem? I don't want to upgrade php now if I don't have to.

Any help would be appreciated.

Richie.

andrewm

Have you tried running it from command line?

Roger_Ramjet

Just a question. If you were upgrading MySQL, why stop at 4.0, why not use 4.1 anyway?

Forget what phpmyqdmin printed on the screen. What did it do to the DATA? I mean, did it actually set the value to 'homebuilder,homebuilder' or not?

richie

Roger,

mysql 4.1 has radical changes according to mysql.com that may affect existing apps. I'll upgrade once I've done extensive testing.

andrewm,

I don't want to bore everyone with details, but I built a new box and installed newer apps. That's when the double posting started. Some of my scripts which used to run fine, suddenly are now updating records twice. So, running things from the command line wouldn't tell me if the problem is with php, phpmyadmin, or from some other source.

I'll go ahead and upgrade to mysql 4.1, php 4.3x, apache 2.0.44. I'll posting the outcome here then.

Thanks.

Richie.

Roger_Ramjet

OK. But what happened to the data? Did it update it to 'homebuilder,homebuilder' or not?

richie

It can't update to 'homebuilder,homebuilder' because I have an enum column.

richie

I uninstalled all my rpm installation of apache, mysql, and php and compilled from source.

That solved my problem.

Unfortunately, I never did find out the source of the problem in the first place.