Error 500 after trying to login.

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • poradniki
    Junior Member
    • Oct 2021
    • 13

    Error 500 after trying to login.

    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
    Member
    • Mar 2014
    • 8845

    #2
    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.
    If you find EspoCRM good, we would greatly appreciate if you could give the project a star on GitHub. We believe our work truly deserves more recognition. Thanks.

    Comment

    • poradniki
      Junior Member
      • Oct 2021
      • 13

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

      Comment

      • yuri
        Member
        • Mar 2014
        • 8845

        #4
        Could you copy the logger part of the config here? I want to make sure that the parameter is correct. Thanks.
        If you find EspoCRM good, we would greatly appreciate if you could give the project a star on GitHub. We believe our work truly deserves more recognition. Thanks.

        Comment

        • poradniki
          Junior Member
          • Oct 2021
          • 13

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

          Comment

          • poradniki
            Junior Member
            • Oct 2021
            • 13

            #6
            Yes, sure.

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

            Comment

            • yuri
              Member
              • Mar 2014
              • 8845

              #7
              try to add the line

              PHP Code:
              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.
              If you find EspoCRM good, we would greatly appreciate if you could give the project a star on GitHub. We believe our work truly deserves more recognition. Thanks.

              Comment

              • poradniki
                Junior Member
                • Oct 2021
                • 13

                #8
                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... [] []

                Comment

                • yuri
                  Member
                  • Mar 2014
                  • 8845

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

                  If you find EspoCRM good, we would greatly appreciate if you could give the project a star on GitHub. We believe our work truly deserves more recognition. Thanks.

                  Comment


                  • poradniki
                    poradniki commented
                    Editing a comment
                    The same result on log.
                • yuri
                  Member
                  • Mar 2014
                  • 8845

                  #10
                  Try to comment out this one: https://github.com/espocrm/espocrm/b...ation.php#L296
                  If you find EspoCRM good, we would greatly appreciate if you could give the project a star on GitHub. We believe our work truly deserves more recognition. Thanks.

                  Comment

                  • poradniki
                    Junior Member
                    • Oct 2021
                    • 13

                    #11
                    Yes, it works. I can log in.

                    Comment

                    • yuri
                      Member
                      • Mar 2014
                      • 8845

                      #12
                      Do you have any customizations made manaully?
                      If you find EspoCRM good, we would greatly appreciate if you could give the project a star on GitHub. We believe our work truly deserves more recognition. Thanks.

                      Comment

                      • poradniki
                        Junior Member
                        • Oct 2021
                        • 13

                        #13
                        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.

                        Comment

                        • yuri
                          Member
                          • Mar 2014
                          • 8845

                          #14
                          I don't know how to fix w/o being able to reproduce. Could you provide your custom folder?
                          If you find EspoCRM good, we would greatly appreciate if you could give the project a star on GitHub. We believe our work truly deserves more recognition. Thanks.

                          Comment

                          • poradniki
                            Junior Member
                            • Oct 2021
                            • 13

                            #15
                            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

                            Comment

                            Working...