Tickets Fixed MySQL Error when creating ticket for other user

I wanted to create a ticket for another (test) user.
  1. Opened ticket for Example Category as "admin"
  2. Changed the user name to the test user name
  3. Checked the "Alert User" checkmark
  4. Pasted example text into the editor.
  5. Hit Send
Code:
Error Info
Mysqli statement execute error : Data too long for column 'password' at row 1 - library/Zend/Db/Statement/Mysqli.php:214

Stack Trace
#0 /var/www/clients/client180/web812/web/library/Zend/Db/Statement.php(297): Zend_Db_Statement_Mysqli->_execute(Array)
#1 /var/www/clients/client180/web812/web/library/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#2 /var/www/clients/client180/web812/web/library/Zend/Db/Adapter/Abstract.php(574): Zend_Db_Adapter_Abstract->query('INSERT INTO `xf...', Array)
#3 /var/www/clients/client180/web812/web/library/XenForo/DataWriter.php(1638): Zend_Db_Adapter_Abstract->insert('xf_nixfifty_tic...', Array)
#4 /var/www/clients/client180/web812/web/library/XenForo/DataWriter.php(1627): XenForo_DataWriter->_insert()
#5 /var/www/clients/client180/web812/web/library/XenForo/DataWriter.php(1419): XenForo_DataWriter->_save()
#6 /var/www/clients/client180/web812/web/library/NixFifty/Tickets/ControllerPublic/Ticket.php(528): XenForo_DataWriter->save()
#7 /var/www/clients/client180/web812/web/library/XenForo/FrontController.php(351): NixFifty_Tickets_ControllerPublic_Ticket->actionInsert()
#8 /var/www/clients/client180/web812/web/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#9 /var/www/clients/client180/web812/web/index.php(13): XenForo_FrontController->run()
#10 {main}

Request State
Array
(
    [url] => https://www.mywebsite.com/tickets/insert
    [_GET] => Array
        (
            [/tickets/insert] => 
        )

    [_POST] => Array
        (
            [ticket_owner] => Test User
            [ticket_owner_alert] => 1
            [priority] => 2
            [title] => Test Ticket
            [message_html] => <p>Aliquam et nisl vel ligula consectetuer suscipit. Morbi euismod enim eget neque. Donec sagittis massa. Vestibulum quis augue sit amet ipsum laoreet pretium. Nulla facilisi. Duis tincidunt, felis et luctus placerat, ipsum libero vestibulum sem, vitae elementum wisi ipsum a metus. Nulla a enim sed dui hendrerit lobortis. Donec lacinia vulputate magna. Vivamus suscipit lectus at quam. In lectus est, viverra a, ultricies ut, pulvinar vitae, tellus. Donec et lectus et sem rutrum sodales. Morbi cursus. Aliquam a odio. Sed tortor velit, convallis eget, porta interdum, convallis sed, tortor. Phasellus ac libero a lorem auctor mattis. Lorem ipsum dolor sit amet, consectetuer adipiscing elit.</p>
            [_xfRelativeResolver] => https://www.mywebsite.com/tickets/new
            [attachment_hash] => b6bf643b1eb9f113b83ae21767f3fede
            [category_id] => 1
            [_xfToken] => ********
            [_xfRequestUri] => /tickets/new
            [_xfNoRedirect] => 1
            [_xfResponseType] => json
        )

)
 
Back
Top