Duplicate updates

I’ve just upgraded our RT system from 3.0.2 to 3.6.3, and found
something that keeps coming up and making a problem. If I click on
“resolve” to close a ticket for example, even if I enter no comments it
will show in the history that a comment was added. What’s worse, if I
do add a comment it’ll show up twice - including the “time worked” field
being applied twice!

Even if I just click “resolve” and then back out of the page, having
done nothing to the contents of the resolve page, it will still show
that there was a comment added, when nothing was done at all.

To see an example: http://www.astro.princeton.edu/~huston/rt.png (the
two comments, at 17:47:00 and 17:47:07 are identical). I don’t even
remember what I did at 17:47:[42,52] which caused the second set of
comments to show up.

While I say I “upgraded” from 3.0.2 to 3.6.3, it was not a standard
upgrade like you may think. The entire machine was upgraded from RH8 to
Fedora 6; the upgrade on RT was done by copying off the config and
dumping the database, then restoring the database on the new install of
the machine and recreating the config file. So I know there’s no old
scripts or files laying around that could be causing this.

Steve Huston - W2SRH - Unix Sysadmin, Dept. of Astrophysical Sciences
Princeton University | ICBM Address: 40.346525 -74.651285
126 Peyton Hall |“On my ship, the Rocinante, wheeling through
Princeton, NJ 08544 | the galaxies; headed for the heart of Cygnus,
(609) 258-7375 | headlong into mystery.” -Rush, ‘Cygnus X-1’

I’ve just upgraded our RT system from 3.0.2 to 3.6.3, and found
something that keeps coming up and making a problem. If I click on
“resolve” to close a ticket for example, even if I enter no comments it
will show in the history that a comment was added. What’s worse, if I
do add a comment it’ll show up twice - including the “time worked” field
being applied twice!

Even if I just click “resolve” and then back out of the page, having
done nothing to the contents of the resolve page, it will still show
that there was a comment added, when nothing was done at all.

You’re running on a mysql without innodb is my guess.

Even if I just click “resolve” and then back out of the page, having
done nothing to the contents of the resolve page, it will still show
that there was a comment added, when nothing was done at all.
You’re running on a mysql without innodb is my guess.

Yes, I am running mysql; innodb, I have no idea (I do so little with SQL
here, I just had to google it). I do see that the mysql-server package
includes a /usr/bin/innochecksum…

Any more hints? An “rtfm” is sufficient, if it includes a link to the FM :>

Thanks!

Steve Huston - W2SRH - Unix Sysadmin, Dept. of Astrophysical Sciences
Princeton University | ICBM Address: 40.346525 -74.651285
126 Peyton Hall |“On my ship, the Rocinante, wheeling through
Princeton, NJ 08544 | the galaxies; headed for the heart of Cygnus,
(609) 258-7375 | headlong into mystery.” -Rush, ‘Cygnus X-1’

Even if I just click “resolve” and then back out of the page, having
done nothing to the contents of the resolve page, it will still show
that there was a comment added, when nothing was done at all.
You’re running on a mysql without innodb is my guess.

Yes, I am running mysql; innodb, I have no idea (I do so little
with SQL
here, I just had to google it). I do see that the mysql-server
package
includes a /usr/bin/innochecksum…

This usually means your tables are myisam and transactions aren’t
being handled correctly. you may need to explcitly convert your
tables to innodb

PGP.sig (186 Bytes)

This usually means your tables are myisam and transactions aren’t being
handled correctly. you may need to explcitly convert your tables to innodb

That was it. Did the conversion, and it looks like the problem is gone.

Thank you very much!

Steve Huston - W2SRH - Unix Sysadmin, Dept. of Astrophysical Sciences
Princeton University | ICBM Address: 40.346525 -74.651285
126 Peyton Hall |“On my ship, the Rocinante, wheeling through
Princeton, NJ 08544 | the galaxies; headed for the heart of Cygnus,
(609) 258-7375 | headlong into mystery.” -Rush, ‘Cygnus X-1’