Error 500 after trying to login.

[poradniki]

Hello, after upgrade from 6~ to 7.03 version i have problem to login into crm. There is Error 500.

Chrome console:
Failed to load resource: the server responded with a status of 500 ()

EspoCRM log:
[2021-10-07 08:57:43] ERROR: Auth: SQLSTATE[21S01]: Insert value list does not match column list: 1136 Column count doesn't match value count at row 1 [] []

What to do?

[yuri]

Hi,

Try setting printTrace => true for the logger https://docs.espocrm.com/administrat...trace-printing and then re-produce the error. Then copy the error message here.

[poradniki]

Hej, nothing change after that (chrome console and logs still the same).

[yuri]

Could you copy the logger part of the config here? I want to make sure that the parameter is correct. Thanks.

[poradniki]

I want to add, that changing password is working in every possibilities (in ssh and "forgot password") and successfully changes in database.

[poradniki]

Yes, sure.

'logger' => [
'path' => 'data/logs/espo.log',
'level' => 'WARNING',
'rotation' => true,
'maxFileNumber' => 30,
'printTrace' => true
],

[yuri]

try to add the line

throw $e; 

here https://github.com/espocrm/espocrm/b.../Auth.php#L222

and then try to reproduce the error. I hope there will be something in the log.

[poradniki]

Yes, there is something more:

[2021-10-07 10:33:03] ERROR: (21S01) SQLSTATE[21S01]: Insert value list does not match column list: 1136 Column count doesn't match value count at row 1; GET /App/user; line: 70, file: /home/server574239/ftp/import/crm/application/Espo/ORM/SqlExecutor.php :: #0 /home/server574239/ftp/import/crm/application/Espo/ORM/SqlExecutor.php(70): PDO->query('INSERT INTO `au...') #1 /home/server574239/ftp/import/crm/application/Espo/ORM/SqlExecutor.php(62): Espo\ORM\SqlExecutor->executeSqlWithDeadlockHandling('INSERT INTO `au...') #2 /home/server574239/ftp/import/crm/application/Espo/ORM/Mapper/BaseMapper.php(713): Espo\ORM\SqlExecutor->execute('INSERT INTO `au...', true) #3 /home/server574239/ftp/import/crm/application/Espo/ORM/Mapper/BaseMapper.php(1224): Espo\ORM\Mapper\BaseMapper->executeSql('INSERT INTO `au...', true) #4 /home/server574239/ftp/import/crm/application/Espo/ORM/Mapper/BaseMapper.php(1196): Espo\ORM\Mapper\BaseMapper->insertInternal(Object(Espo\Entities\AuthLogReco rd )) #5 /home/server574239/ftp/import/crm/application/Espo/ORM/Repository/RDBRepository.php(143): Espo\ORM\Mapper\BaseMapper->insert(Object(Espo\Entities\AuthLogRecord)) #6 /home/server574239/ftp/import/crm/application/Espo/Core/Repositories/Database.php(134): Espo\ORM\Repository\RDBRepository->save(Object(Espo\Entities\AuthLogRecord), Array) #7 /home/server574239/ftp/import/crm/application/Espo/ORM/EntityManager.php(280): Espo\Core\Repositories\Database->save(Object(Espo\Entities\AuthLogRecord), Array) #8 /home/server574239/ftp/import/crm/application/Espo/Core/ORM/EntityManagerProxy.php(69): Espo\ORM\EntityManager->saveEntity(Object(Espo\Entities\AuthLogRecord), Array) #9 /home/server574239/ftp/import/crm/application/Espo/Core/Authentication/Authentication.php(296): Espo\Core\ORM\EntityManagerProxy->saveEntity(Object(Espo\Entities\AuthLogRecord)) #10 /home/server574239/ftp/import/crm/application/Espo/Core/Api/Auth.php(151): Espo\Core\Authentication\Authentication->login(Object(Espo\Core\Authentication\Authentic at ionData), Object(Espo\Core\Api\RequestWrapper), Object(Espo\Core\Api\ResponseWrapper)) #11 /home/server574239/ftp/import/crm/application/Espo/Core/Api/Auth.php(106): Espo\Core\Api\Auth->processWithAuthData(Object(Espo\Core\Authentica ti on\AuthenticationData), Object(Espo\Core\Api\RequestWrapper), Object(Espo\Core\Api\ResponseWrapper)) #12 /home/server574239/ftp/import/crm/application/Espo/Core/Api/RequestProcessor.php(99): Espo\Core\Api\Auth->process(Object(Espo\Core\Api\RequestWrapper), Object(Espo\Core\Api\ResponseWrapper)) #13 /home/server574239/ftp/import/crm/application/Espo/Core/Api/RequestProcessor.php(82): Espo\Core\Api\RequestProcessor->processInternal(Object(Espo\Core\Api\Route), Object(Espo\Core\Api\RequestWrapper), Object(Espo\Core\Api\ResponseWrapper)) #14 /home/server574239/ftp/import/crm/application/Espo/Core/Api/Starter.php(103): Espo\Core\Api\RequestProcessor->process(Object(Espo\Core\Api\Route), Object(Espo\Core\Api\RequestWrapper), Object(Espo\Core\Api\ResponseWrapper)) #15 /home/server574239/ftp/import/crm/vendor/slim/slim/Slim/Handlers/Strategies/RequestResponse.php(43): Espo\Core\Api\Starter->Espo\Core\Api\{closure}(Object(Slim\Psr7\Reques t) , Object(Slim\Psr7\Response), Array) #16 /home/server574239/ftp/import/crm/vendor/slim/slim/Slim/Routing/Route.php(384): Slim\Handlers\Strategies\RequestResponse->__invoke(Object(Closure), Object(Slim\Psr7\Request), Object(Slim\Psr7\Response), Array) #17 /home/server574239/ftp/import/crm/vendor/slim/slim/Slim/MiddlewareDispatcher.php(81): Slim\Routing\Route->handle(Object(Slim\Psr7\Request)) #18 /home/server574239/ftp/import/crm/vendor/slim/slim/Slim/MiddlewareDispatcher.php(81): Slim\MiddlewareDispatcher->handle(Object(Slim\Psr7\Request)) #19 /home/server574239/ftp/import/crm/vendor/slim/slim/Slim/Routing/Route.php(341): Slim\MiddlewareDispatcher->handle(Object(Slim\Psr7\Request)) #20 /home/server574239/ftp/import/crm/vendor/slim/slim/Slim/Routing/RouteRunner.php(84): Slim\Routing\Route->run(Object(Slim\Psr7\Request)) #21 /home/server574239/ftp/import/crm/vendor/slim/slim/Slim/Middleware/RoutingMiddleware.php(59): Slim\Routing\RouteRunner->handle(Object(Slim\Psr7\Request)) #22 /home/server574239/ftp/import/crm/vendor/slim/slim/Slim/MiddlewareDispatcher.php(147): Slim\Middleware\RoutingMiddleware->process(Object(Slim\Psr7\Request), Object(Slim\Routing\RouteRunner)) #23 /home/server574239/ftp/import/crm/vendor/slim/slim/Slim/Middleware/ErrorMiddleware.php(107): class@anonymous->handle(Object(Slim\Psr7\Request)) #24 /home/server574239/ftp/import/crm/vendor/slim/slim/Slim/MiddlewareDispatcher.php(147): Slim\Middleware\ErrorMiddleware->process(Object(Slim\Psr7\Request), Object(class@anonymous)) #25 /home/server574239/ftp/import/crm/vendor/slim/slim/Slim/MiddlewareDispatcher.php(81): class@anonymous->handle(Object(Slim\Psr7\Request)) #26 /home/server574239/ftp/import/crm/vendor/slim/slim/Slim/App.php(215): Slim\MiddlewareDispatcher->handle(Object(Slim\Psr7\Request)) #27 /home/server574239/ftp/import/crm/vendo... [] []

[yuri]

Try to comment out this line: https://github.com/espocrm/espocrm/b...ation.php#L582

[poradniki]

The same result on log.

[yuri]

Try to comment out this one: https://github.com/espocrm/espocrm/b...ation.php#L296

[poradniki]

Yes, it works. I can log in.

[yuri]

Do you have any customizations made manaully?

[poradniki]

Nope, nothing. I had only Dubas Light Theme from devIT, but I removed it after this problem.

Anyway, it will be good to fix that problem for others in next upgrade.

[yuri]

I don't know how to fix w/o being able to reproduce. Could you provide your custom folder?

[poradniki]

If you want, I can archive all files and send it to You without data in config. CRM is available on site yankeecars.eu/crm