Create FORMS ERROR WITH DATABASE

El_Giorgio · February 13, 2020, 7:04pm

Hi,

I’ve try to create à FORMS, but when I click on “CREATE”, i have an error…

The problem come from my database (MariaDB, I use phpMyAdmin for manage it), but I don’t know how resolve it…

Here is the log:

-------------------------------------------------------- LOG START ---------------------------------------------------------

Doctrine\DBAL\Exception\DriverException: An exception occurred while executing ‘INSERT INTO oc_forms_events (title, description, is_anonymous, unique, access, owner, created, hash) VALUES(?, ?, ?, ?, ?, ?, ?, ?)’ with params [“Test”, “Test”, 0, false, “public”, “Giorgios”, “2020-02-13 18:51:47”, “HD1ZVR8oTbNfapHF”]: SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect integer value: ‘’ for column nextcloud.oc_forms_events.unique at row 1

/var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php - line 169:

Doctrine\DBAL\Driver\AbstractMySQLDriver->convertException(“An exceptio … 1”, Doctrine\DBA … ]})

/var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php - line 145:

Doctrine\DBAL\DBALException::wrapException(Doctrine\DBA … {}, Doctrine\DBA … ]}, “An exceptio … 1”)

/var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php - line 1063:

Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Doctrine\DBA … {}, Doctrine\DBA … ]}, “INSERT INTO … )”, { 1: “Test”, … "})

/var/www/nextcloud/lib/private/DB/Connection.php - line 216:

Doctrine\DBAL\Connection->executeUpdate(“INSERT INTO … )”, [ “Test”,"Te … "], [ 2,2,1,2,2,2,2,2])

/var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php - line 203:

OC\DB\Connection->executeUpdate(“INSERT INTO … )”, { dcValue1: … "}, { dcValue1: … 2})

/var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php - line 214:

Doctrine\DBAL\Query\QueryBuilder->execute()

/var/www/nextcloud/lib/public/AppFramework/Db/QBMapper.php - line 121:

OC\DB\QueryBuilder\QueryBuilder->execute()

/var/www/nextcloud/apps/forms/lib/Controller/ApiController.php - line 495:

OCP\AppFramework\Db\QBMapper->insert(OCA\Forms\Db\Event { id: null})

/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php - line 170:

OCA\Forms\Controller\ApiController->writeForm({ id: 0,hash … "}, { formQuizQu … ]}, [], “create”)

/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php - line 99:

OC\AppFramework\Http\Dispatcher->executeController(OCA\Forms\Co … "}, “writeForm”)

/var/www/nextcloud/lib/private/AppFramework/App.php - line 126:

OC\AppFramework\Http\Dispatcher->dispatch(OCA\Forms\Co … "}, “writeForm”)

/var/www/nextcloud/lib/private/AppFramework/Routing/RouteActionHandler.php - line 47:

OC\AppFramework\App::main(“OCA\Forms\ … r”, “writeForm”, OC\AppFramew … {}, { _route: "f … "})

<>

OC\AppFramework\Routing\RouteActionHandler->__invoke({ _route: "f … "})

/var/www/nextcloud/lib/private/Route/Router.php - line 297:

call_user_func(OC\AppFramew … {}, { _route: "f … "})

/var/www/nextcloud/lib/base.php - line 997:

OC\Route\Router->match("/apps/forms/write/form")

/var/www/nextcloud/index.php - line 42:

OC::handleRequest()

Enveloppé parDoctrine\DBAL\Driver\PDOException: SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect integer value: ‘’ for column nextcloud.oc_forms_events.unique at row 1

/var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php - line 1054:

Doctrine\DBAL\Driver\PDOStatement->execute()