We ran upgrade-mysql-schema.pl which ran cleanly without errors after a bit
of kajiggerring from one of our admins - we did the upgrade a while back, so
details are foggy but I think there were issues with the character encoding
on the Attachments table…
All of our tables are currently innodb and it’s set as the default storage
engine in my.cnf. Do you know which table being ISAM would cause this
problem, or any other details on the why and how of the thing? Is it an
issue with a transaction not getting rolled back properly?
LorenOn Thu, Mar 25, 2010 at 3:18 PM, Jeff Voskamp email@example.com wrote:
On 03/25/2010 04:12 PM, Loren Cole wrote:
After upgrading to 3.8.2 we’ve started getting empty comments if a user
clicks ‘comment’ or ‘reply’ but does not actually update the ticket.
This question was asked and answered back in 2005, but the answer just
links to a faq which has obviously been updated since and doesn’t contain
any reference to empty comments.
Does anyone know how to fix this?
Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
Did you run all the update scripts? Your mysql is not running with innodb
versions of the tables.