marketing-factory / oauth2

Generic OAuth2 authentication and authorization for TYPO3 CMS
Other
9 stars 18 forks source link

OAuth2LoginService -> db insert named parameter defaulting to PARAM_STR -> leads to errors with PostgreSQL in the be_user's `uc` field #28

Closed bernhardberger closed 2 years ago

bernhardberger commented 3 years ago
An exception occurred while executing 'UPDATE "be_users" SET "uid" = ?, "pid" = ?, "tstamp" = ?, "crdate" = ?, "cruser_id" = ?, "deleted" = ?, "disable" = ?, "starttime" = ?, "endtime" = ?, "description" = ?, "username" = ?, "avatar" = ?, "password" = ?, "admin" = ?, "usergroup" = ?, "lang" = ?, "email" = ?, "db_mountpoints" = ?, "options" = ?, "realName" = ?, "userMods" = ?, "allowed_languages" = ?, "uc" = ?, "file_mountpoints" = ?, "file_permissions" = ?, "workspace_perms" = ?, "lockToDomain" = ?, "disableIPlock" = ?, "TSconfig" = ?, "lastlogin" = ?, "createdByAction" = ?, "usergroup_cached_list" = ?, "workspace_id" = ?, "category_perms" = ?, "tx_news_categorymounts" = ?, "oauth_identifier" = ?, "password_reset_token" = ? WHERE "uid" = ?' with params [24, 0, 1634898151, 1634898151, 0, 0, 0, 0, 0, null, "username.something@example.com.co.at", 0, "some_password_hash", 1, "", "", "username.something@example.com.co.at", null, 3, "username Test", null, "", "a:15:{s:14:\"interfaceSetup\";s:0:\"\";s:10:\"moduleData\";a:4:{s:10:\"web_layout\";a:2:{s:8:\"function\";s:1:\"1\";s:8:\"language\";s:1:\"0\";}s:9:\"tx_beuser\";s:532:\"O:40:\"TYPO3\\CMS\\Beuser\\Domain\\Model\\ModuleData\":2:{s:9:\"\u0000*\u0000demand\";O:36:\"TYPO3\\CMS\\Beuser\\Domain\\Model\\Demand\":12:{s:11:\"\u0000*\u0000userName\";s:0:\"\";s:11:\"\u0000*\u0000userType\";i:0;s:9:\"\u0000*\u0000status\";i:0;s:9:\"\u0000*\u0000logins\";i:0;s:19:\"\u0000*\u0000backendUserGroup\";i:0;s:6:\"\u0000*\u0000uid\";N;s:16:\"\u0000*\u0000_localizedUid\";N;s:15:\"\u0000*\u0000_languageUid\";N;s:16:\"\u0000*\u0000_versionedUid\";N;s:6:\"\u0000*\u0000pid\";N;s:61:\"\u0000TYPO3\\CMS\\Extbase\\DomainObject\\AbstractDomainObject\u0000_isClone\";b:0;s:69:\"\u0000TYPO3\\CMS\\Extbase\\DomainObject\\AbstractDomainObject\u0000_cleanProperties\";a:0:{}}s:18:\"\u0000*\u0000compareUserList\";a:0:{}}\";s:10:\"FormEngine\";a:2:{i:0;a:1:{s:32:\"acc3a209bc035077168a4420942b481f\";a:4:{i:0;s:26:\"username.something@example.com.co.at\";i:1;a:5:{s:4:\"edit\";a:1:{s:8:\"be_users\";a:1:{i:24;s:4:\"edit\";}}s:7:\"defVals\";N;s:12:\"overrideVals\";N;s:11:\"columnsOnly\";N;s:6:\"noView\";N;}i:2;s:32:\"&edit%5Bbe_users%5D%5B24%5D=edit\";i:3;a:5:{s:5:\"table\";s:8:\"be_users\";s:3:\"uid\";i:24;s:3:\"pid\";i:0;s:3:\"cmd\";s:4:\"edit\";s:12:\"deleteAccess\";b:1;}}}i:1;s:32:\"acc3a209bc035077168a4420942b481f\";}s:57:\"TYPO3\\CMS\\Backend\\Utility\\BackendUtility::getUpdateSignal\";a:0:{}}s:19:\"thumbnailsByDefault\";s:1:\"1\";s:14:\"emailMeAtLogin\";i:0;s:8:\"titleLen\";i:50;s:8:\"edit_RTE\";s:1:\"1\";s:20:\"edit_docModuleUpload\";s:1:\"0\";s:15:\"resizeTextareas\";i:1;s:25:\"resizeTextareas_MaxHeight\";i:500;s:24:\"resizeTextareas_Flexible\";i:0;s:13:\"condensedMode\";s:1:\"0\";s:12:\"extendedView\";s:1:\"1\";s:4:\"lang\";s:0:\"\";s:19:\"firstLoginTimeStamp\";i:1634898151;s:15:\"moduleSessionID\";a:4:{s:10:\"web_layout\";s:40:\"7aea6f71369649eeaee58ccf813ce546af03f9e4\";s:9:\"tx_beuser\";s:40:\"7aea6f71369649eeaee58ccf813ce546af03f9e4\";s:10:\"FormEngine\";s:40:\"7aea6f71369649eeaee58ccf813ce546af03f9e4\";s:57:\"TYPO3\\CMS\\Backend\\Utility\\BackendUtility::getUpdateSignal\";s:40:\"7aea6f71369649eeaee58ccf813ce546af03f9e4\";}}", null, null, 1, "", 0, null, 1634898151, 0, null, 0, null, "", "azure|SOME_SECRET_HASH", "", 24]:

SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input syntax for type bytea