Adding a new ticket

[ediblemanager]

I'm experiencing a bug when trying to add a ticket to the system.

Browser: Chrome Version 51.0.2704.103 (64-bit) OS: OSX 10.9.5

Server: Ubuntu 14.04 LTS Prod log output:

[2016-06-21 11:25:42] security.DEBUG: Invoked controller "Diamante\DeskBundle\Api\Internal\TicketApiServiceImpl::createTicket". (MASTER_REQUEST) [] [] [2016-06-21 11:25:42] diamante.ERROR: DiamanteAPI Exception::An exception occurred while executing 'INSERT INTO diamante_automation_context (targetEntityId, targetEntityClass, action, editor_id, targetEntityChangeset, state) VALUES (?, ?, ?, ?, ?, ?)' with params [3, "Diamante\\DeskBundle\\Entity\\Ticket", "created", "diamante_1", "YToyMDp7czoyOiJpZCI7YToyOntpOjA7TjtpOjE7aTozO31zOj...<truncated>", "new"]: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'editor_id' in 'field list' [] []

app_check.txt oro_install.txt

When checking through the admin interface, the tickets show up with attachments etc. intact. When checking in the users interface, the tickets also show up. However, on adding a ticket an error is shown. I've attached a screenshot of the error.

In trying to add a comment to one of the saved tickets, the same error is thrown in the logs: PHP Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'editor_id' in 'field list'' in /var/www/helpdesk/diamantedesk-application-master/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:91\nStack trace:\n#0 /var/www/helpdesk/diamantedesk-application-master/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(91): PDOStatement->execute(NULL)\n#1 /var/www/helpdesk/diamantedesk-application-master/vendor/doctrine/dbal/lib/Doctrine/DBAL/Statement.php(165): Doctrine\\DBAL\\Driver\\PDOStatement->execute(NULL)\n#2 /var/www/helpdesk/diamantedesk-application-master/vendor/doctrine/orm/lib/Doctrine/ORM/Persisters/Entity/BasicEntityPersister.php(281): Doctrine\\DBAL\\Statement->execute()\n#3 /var/www/helpdesk/diamantedesk-application-master/vendor/doctrine/orm/lib/Doctrine/ORM/UnitOfWork.php(1018): Doctrine\\ORM\\Persisters\\Entity\\BasicEntityPersister->executeInserts()\n#4 /var/www/helpdesk/diamantedesk-application-master/vendor/doctrine/orm/lib/Doctrine/ORM/Unit in /var/www/helpdesk/diamantedesk-application-master/vendor/doctrine/orm/lib/Doctrine/ORM/ORMException.php on line 144, referer: https://support.sumac.ac.uk/desk/comments/create/4

On screen, the error message was "Sorry, page was not loaded correctly". This was from the admin interface.

[chris-freedom]

Hello ediblemanager.

This will be fixed soon. Quick fix for you is run this command: php app/console doctrine:schema:update --force

[ediblemanager]

@chris-freedom Thanks! Seems to be working.

One other thing I noticed (I can file a new report if need-be) is that certain characters cause passwords/emails to be rejected, like using an exclamation mark in a password. Let me know if you want a new report and I'll file it.

[chris-freedom]

@ediblemanager please create a new report, and I'll check it.