[rt-users] Empty comment/correspondence entries

[Loren Cole]

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?

Thanks,
Loren



On Thu, Mar 25, 2010 at 3:18 PM, Jeff Voskamp <javoskam at uwaterloo.ca> 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?
>>
>> -
>> Loren
>>
>>
>>
>> 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.
>
> Jeff
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20100325/c2730f86/attachment.htm>