Code:
[OK] Inserted new tl_user instance for LDAP person " (uid: bmxxsavi)".
20:13:33 CRITICAL [console] Error thrown while running command "huh_ldap:sync_persons -vv". Message: "An exception occurred while executing 'INSERT INTO tl_user (ldapUidNumber,email,username,name,groups,admin,dateAdded,tstamp,password,language,backendTheme,uploader) VALUES ('10005','xxx.xxx@xxx.net','bmxxsavi','','a:0:{}','',1665598413,1665598413,'$argon2id$v=19$m=65536,t=4,p=1$zaY5/GanJ+/6fehjGxxxxxxxxxCYwIOW1qE2hNWXvc6scC44dKZFsXk','de','flexible','DropZone')':
SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'groups,admin,dateAdded,tstamp,password,language,backendTheme,uploader) VALUES ('' at line 1" ["exception" => Doctrine\DBAL\Exception\SyntaxErrorException^ { …},"command" => "huh_ldap:sync_persons -vv","message" => """ An exception occurred while executing 'INSERT INTO tl_user (ldapUidNumber,email,username,name,groups,admin,dateAdded,tstamp,password,language,backendTheme,uploader) VALUES ('10005','xxx.xxx@xxx.net','bmxxsavi','','a:0:{}','',1665598413,1665598413,'$argon2id$v=19$m=65536,t=4,p=1$zaYxxxxxxJUStCYwIOW1qE2hNWXvc6scC44dKZFsXk','de','flexible','DropZone')':\n \n SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'groups,admin,dateAdded,tstamp,password,language,backendTheme,uploader) VALUES ('' at line 1 """]
In AbstractMySQLDriver.php line 98:
[Doctrine\DBAL\Exception\SyntaxErrorException]
An exception occurred while executing 'INSERT INTO tl_user (ldapUidNumber,email,username,name,groups,admin,dateAdded,tstamp,password,language,backendTheme,uploader) VALUES ('10005','x.xx
osavi@xx.net','bmxxsavi','','a:0:{}','',1665598413,1665598413,'$argon2id$v=19$m=65536,t=4,p=1$zaY5/xxxxxxxymryRFAJUStCYwIOW1qE2hNWXvc6scC44dKZFsXk','de','flexible','DropZo
ne')':
SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'g
roups,admin,dateAdded,tstamp,password,language,backendTheme,uploader) VALUES ('' at line 1
Exception trace:
at /var/www/xxx/website/contao/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:98
Doctrine\DBAL\Driver\AbstractMySQLDriver->convertException() at /var/www/xxx/website/contao/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:182
Doctrine\DBAL\DBALException::wrapException() at /var/www/xxx/website/contao/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:159
Doctrine\DBAL\DBALException::driverExceptionDuringQuery() at /var/www/xxx/website/contao/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:2226
Doctrine\DBAL\Connection->handleExceptionDuringQuery() at /var/www/xxx/website/contao/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:1313
Doctrine\DBAL\Connection->executeQuery() at /var/www/xxx/website/contao/vendor/contao/core-bundle/src/Resources/contao/library/Contao/Database/Statement.php:274
Contao\Database\Statement->query() at /var/www/xxx/website/contao/vendor/contao/core-bundle/src/Resources/contao/library/Contao/Database/Statement.php:248
Contao\Database\Statement->execute() at /var/www/xxx/website/contao/vendor/heimrichhannot/contao-utils-bundle/src/Database/DatabaseUtil.php:908
HeimrichHannot\UtilsBundle\Database\DatabaseUtil->insert() at /var/www/xxx/website/contao/vendor/heimrichhannot/contao-ldap-bundle/src/Util/LdapUtil.php:494
HeimrichHannot\LdapBundle\Util\LdapUtil->syncPersons() at /var/www/xxx/website/contao/vendor/heimrichhannot/contao-ldap-bundle/src/Command/SyncPersonsCommand.php:112
HeimrichHannot\LdapBundle\Command\SyncPersonsCommand->execute() at /var/www/xxx/website/contao/vendor/symfony/console/Command/Command.php:255
Symfony\Component\Console\Command\Command->run() at /var/www/xxx/website/contao/vendor/symfony/console/Application.php:1027
Symfony\Component\Console\Application->doRunCommand() at /var/www/xxx/website/contao/vendor/symfony/framework-bundle/Console/Application.php:97
Symfony\Bundle\FrameworkBundle\Console\Application->doRunCommand() at /var/www/xxx/website/contao/vendor/symfony/console/Application.php:273
Symfony\Component\Console\Application->doRun() at /var/www/xxx/website/contao/vendor/symfony/framework-bundle/Console/Application.php:83
Symfony\Bundle\FrameworkBundle\Console\Application->doRun() at /var/www/xxx/website/contao/vendor/symfony/console/Application.php:149
Symfony\Component\Console\Application->run() at /var/www/xxx/website/contao/vendor/contao/manager-bundle/bin/contao-console:38
include() at /var/www/xxx/website/contao/vendor/bin/contao-console:115
---------------------
Lesezeichen