Skip to content

General error: 1366 Incorrect integer value: '' for column 'transparent' at row 1 #4165

@LukasReschke

Description

@LukasReschke
Doctrine\DBAL\Exception\DriverException: An exception occurred while executing 'INSERT INTO `oc_calendars` (`principaluri`, `uri`, `synctoken`, `transparent`, `components`, `displayname`, `timezone`, `calendarorder`, `calendarcolor`) VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?)' with params ["principals\/users\/XXXXXX", "5B1DAC5A-8988-43F1-B737-60FADC3E3385", 1, false, "VTODO", "Neue Liste", "BEGIN:VCALENDAR\r\nVERSION:2.0\r\nPRODID:-\/\/Apple Inc.\/\/Mac OS X 10.12.4\/\/EN\r\nCALSCALE:GREGORIAN\r\nBEGIN:VTIMEZONE\r\nTZID:Europe\/Berlin\r\nBEGIN:DAYLIGHT\r\nTZOFFSETFROM:+0100\r\nRRULE:FREQ=YEARLY;BYMONTH=3;BYDAY=-1SU\r\nDTSTART:19810329T020000\r\nTZNAME:MESZ\r\nTZOFFSETTO:+0200\r\nEND:DAYLIGHT\r\nBEGIN:STANDARD\r\nTZOFFSETFROM:+0200\r\nRRULE:FREQ=YEARLY;BYMONTH=10;BYDAY=-1SU\r\nDTSTART:19961027T030000\r\nTZNAME:MEZ\r\nTZOFFSETTO:+0100\r\nEND:STANDARD\r\nEND:VTIMEZONE\r\nEND:VCALENDAR\r\n", "854", "#0E61B9FF"]: SQLSTATE[HY000]: General error: 1366 Incorrect integer value: '' for column 'transparent' at row 1
/var/www/html/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php - line 128: Doctrine\DBAL\Driver\AbstractMySQLDriver->convertException('An exception oc...', Object(Doctrine\DBAL\Driver\PDOException))
/var/www/html/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php - line 996: Doctrine\DBAL\DBALException driverExceptionDuringQuery(Object(Doctrine\DBAL\Driver\PDOMySql\Driver), Object(Doctrine\DBAL\Driver\PDOException), 'INSERT INTO `oc...', Array)
/var/www/html/lib/private/DB/Connection.php - line 215: Doctrine\DBAL\Connection->executeUpdate('INSERT INTO `oc...', Array, Array)
/var/www/html/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php - line 208: OC\DB\Connection->executeUpdate('INSERT INTO `oc...', Array, Array)
/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php - line 177: Doctrine\DBAL\Query\QueryBuilder->execute()
/var/www/html/apps/dav/lib/CalDAV/CalDavBackend.php - line 622: OC\DB\QueryBuilder\QueryBuilder->execute()
/var/www/html/3rdparty/sabre/dav/lib/CalDAV/CalendarHome.php - line 265: OCA\DAV\CalDAV\CalDavBackend->createCalendar('principals/user...', '5B1DAC5A-8988-4...', Array)
/var/www/html/3rdparty/sabre/dav/lib/DAV/Server.php - line 1173: Sabre\CalDAV\CalendarHome->createExtendedCollection('5B1DAC5A-8988-4...', Object(Sabre\DAV\MkCol))
/var/www/html/3rdparty/sabre/dav/lib/CalDAV/Plugin.php - line 303: Sabre\DAV\Server->createCollection('calendars/matth...', Object(Sabre\DAV\MkCol))
[internal function] Sabre\CalDAV\Plugin->httpMkCalendar(Object(Sabre\HTTP\Request), Object(Sabre\HTTP\Response))
/var/www/html/3rdparty/sabre/event/lib/EventEmitterTrait.php - line 105: call_user_func_array(Array, Array)
/var/www/html/3rdparty/sabre/dav/lib/DAV/Server.php - line 479: Sabre\Event\EventEmitter->emit('method MKCALEND...', Array)
/var/www/html/3rdparty/sabre/dav/lib/DAV/Server.php - line 254: Sabre\DAV\Server->invokeMethod(Object(Sabre\HTTP\Request), Object(Sabre\HTTP\Response))
/var/www/html/apps/dav/lib/Server.php - line 227: Sabre\DAV\Server->exec()
/var/www/html/apps/dav/appinfo/v2/remote.php - line 30: OCA\DAV\Server->exec()
/var/www/html/remote.php - line 165: require_once('/var/www/html/a...')
{main}

{"reqId":"9vkwYsDFWJt4UbU56U4c","remoteAddr":"XXXX.XXX.XXX.XX","app":"webdav","message":"Exception: {"Message":"An exception occurred while executing 'INSERT INTO oc_calendars (principaluri, uri, synctoken, transparent, components, displayname, timezone, calendarorder, calendarcolor) VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?)' with params [\"principals\\\/users\\\/matthias\", \"5B1DAC5A-8988-43F1-B737-60FADC3E3385\", 1, false, \"VTODO\", \"Neue Liste\", \"BEGIN:VCALENDAR\\r\\nVERSION:2.0\\r\\nPRODID:-\\\/\\\/Apple Inc.\\\/\\\/Mac OS X 10.12.4\\\/\\\/EN\\r\\nCALSCALE:GREGORIAN\\r\\nBEGIN:VTIMEZONE\\r\\nTZID:Europe\\\/Berlin\\r\\nBEGIN:DAYLIGHT\\r\\nTZOFFSETFROM:+0100\\r\\nRRULE:FREQ=YEARLY;BYMONTH=3;BYDAY=-1SU\\r\\nDTSTART:19810329T020000\\r\\nTZNAME:MESZ\\r\\nTZOFFSETTO:+0200\\r\\nEND:DAYLIGHT\\r\\nBEGIN:STANDARD\\r\\nTZOFFSETFROM:+0200\\r\\nRRULE:FREQ=YEARLY;BYMONTH=10;BYDAY=-1SU\\r\\nDTSTART:19961027T030000\\r\\nTZNAME:MEZ\\r\\nTZOFFSETTO:+0100\\r\\nEND:STANDARD\\r\\nEND:VTIMEZONE\\r\\nEND:VCALENDAR\\r\\n\", \"854\", \"#0E61B9FF\"]:\n\nSQLSTATE[HY000]: General error: 1366 Incorrect integer value: '' for column 'transparent' at row 1","Exception":"Doctrine\\DBAL\\Exception\\DriverException","Code":0,"Trace":"#0 \/var\/www\/html\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/DBALException.php(128): Doctrine\\DBAL\\Driver\\AbstractMySQLDriver->convertException('An exception oc...', Object(Doctrine\\DBAL\\Driver\\PDOException))\n#1 \/var\/www\/html\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Connection.php(996): Doctrine\\DBAL\\DBALException::driverExceptionDuringQuery(Object(Doctrine\\DBAL\\Driver\\PDOMySql\\Driver), Object(Doctrine\\DBAL\\Driver\\PDOException), 'INSERT INTO oc...', Array)\\n#2 \\\/var\\\/www\\\/html\\\/lib\\\/private\\\/DB\\\/Connection.php(215): Doctrine\\\\DBAL\\\\Connection->executeUpdate('INSERT INTO oc...', Array, Array)\n#3 \/var\/www\/html\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Query\/QueryBuilder.php(208): OC\\DB\\Connection->executeUpdate('INSERT INTO `oc...', Array, Array)\n#4 \/var\/www\/html\/lib\/private\/DB\/QueryBuilder\/QueryBuilder.php(177): Doctrine\\DBAL\\Query\\QueryBuilder->execute()\n#5 \/var\/www\/html\/apps\/dav\/lib\/CalDAV\/CalDavBackend.php(622): OC\\DB\\QueryBuilder\\QueryBuilder->execute()\n#6 \/var\/www\/html\/3rdparty\/sabre\/dav\/lib\/CalDAV\/CalendarHome.php(265): OCA\\DAV\\CalDAV\\CalDavBackend->createCalendar('principals\/user...', '5B1DAC5A-8988-4...', Array)\n#7 \/var\/www\/html\/3rdparty\/sabre\/dav\/lib\/DAV\/Server.php(1173): Sabre\\CalDAV\\CalendarHome->createExtendedCollection('5B1DAC5A-8988-4...', Object(Sabre\\DAV\\MkCol))\n#8 \/var\/www\/html\/3rdparty\/sabre\/dav\/lib\/CalDAV\/Plugin.php(303): Sabre\\DAV\\Server->createCollection('calendars\/matth...', Object(Sabre\\DAV\\MkCol))\n#9 [internal function]: Sabre\\CalDAV\\Plugin->httpMkCalendar(Object(Sabre\\HTTP\\Request), Object(Sabre\\HTTP\\Response))\n#10 \/var\/www\/html\/3rdparty\/sabre\/event\/lib\/EventEmitterTrait.php(105): call_user_func_array(Array, Array)\n#11 \/var\/www\/html\/3rdparty\/sabre\/dav\/lib\/DAV\/Server.php(479): Sabre\\Event\\EventEmitter->emit('method:MKCALEND...', Array)\n#12 \/var\/www\/html\/3rdparty\/sabre\/dav\/lib\/DAV\/Server.php(254): Sabre\\DAV\\Server->invokeMethod(Object(Sabre\\HTTP\\Request), Object(Sabre\\HTTP\\Response))\n#13 \/var\/www\/html\/apps\/dav\/lib\/Server.php(227): Sabre\\DAV\\Server->exec()\n#14 \/var\/www\/html\/apps\/dav\/appinfo\/v2\/remote.php(30): OCA\\DAV\\Server->exec()\n#15 \/var\/www\/html\/remote.php(165): require_once('\/var\/www\/html\/a...')\n#16 {main}","File":"\/var\/www\/html\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Driver\/AbstractMySQLDriver.php","Line":116,"User":"XXXX"}","level":4,"time":"2017-03-30T15:48:30+00:00","method":"MKCALENDAR","url":"/remote.php/dav/calendars/XXXX/5B1DAC5A-8988-43F1-B737-60FADC3E3385/","user":"XXXX","version":"11.0.2.7"}

cc @georgehrke @nickvergessen

Metadata

Metadata

Assignees

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions