[rt-users] Unable to create tickets after MySQL update?

[Martin Wheldon]

Hi Alex,

You could try disabling the PriorityAsString as a test, as least it will 
narrow down your problem space.

Best Regards

Martin

On 2016-11-14 21:15, Alex Hall wrote:
> Update: still not working. I tried setting sql-mode to an empty
> string, like it would have been in 5.5, and to all the 5.7 standard
> ones except strict_trans_tables. Neither helped. Updating existing
> tickets, and all data retrieval, seem to work fine. It's just that
> priority getting a string (that looks like a variable pointer) instead
> of an integer that's causing the problem. Until I fix this, no one can
> make tickets, so if anyone has any suggestions, please share them.
> Thanks.
> 
> On Mon, Nov 14, 2016 at 11:37 AM, Alex Hall <ahall at autodist.com>
> wrote:
> 
>> Hello again all,
>> I just discovered I have a more serious problem than full-text
>> indexing not working. I'm getting an error when anyone tries to make
>> a ticket, and the ticket is never created. Here's the message:
>> 
>> Nov 14 11:31:03 server24 RT: [2522] DBD::mysql::st execute failed:
>> Incorrect integer value: 'ARRAY(0x18325928)' for column 'Priority'
>> at row 1 at /usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 586.
>> 
>> I have the PriorityAsString extension installed, but that's been
>> working perfectly for weeks. I've also modified some files so that
>> the user can select a priority on the main ticket creation page
>> instead of going to the details view, but that's also been working
>> smoothly. The only major change is the MySQL 5.5 upgrade to 5.7, but
>> why that would be the cause, given the error message, I'm not sure.
>> If RT were trying to insert a string like that before, it should
>> have never worked. Is there anything I can do to fix this? I'd
>> rather not revert to 5.5, because I still want that full-text
>> indexing at some point and would rather fix this problem so I can
>> keep trying to do that. Thanks!
>> 
>> --
>> 
>> Alex Hall
>> Automatic Distributors, IT department
>> ahall at autodist.com
> 
> --
> 
> Alex Hall
> Automatic Distributors, IT department
> ahall at autodist.com
> 
> ---------
> RT 4.4 and RTIR training sessions, and a new workshop day!
> https://bestpractical.com/training
> * Los Angeles - January 9-11 2017