Error Log and Error 500

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • tayling
    Member
    • Apr 2023
    • 45

    Error Log and Error 500

    Hi
    I have been trying to upgrade for a few months but keep getting errors. I have started again - I can upgrade from 7.5.6 to 8.06 without error 500 error and all seems to be working BUT the error log shows as below. Does someone have the patience to help fix and errors before I do the next upgrade?
    Thanks
    [2024-05-07 05:39:02] WARNING: E_WARNING: foreach() argument must be of type array|object, null given {"code":2,"message":"foreach() argument must be of type array|object, null given","file":"C:\\wamp64\\www\\Espo\\application\ \Espo\\Core\\Utils\\Database\\Orm\\Converter.php", "line":249}
    [2024-05-07 05:39:02] WARNING: E_WARNING: foreach() argument must be of type array|object, null given {"code":2,"message":"foreach() argument must be of type array|object, null given","file":"C:\\wamp64\\www\\Espo\\application\ \Espo\\Core\\Utils\\Database\\Orm\\Converter.php", "line":249}
    [2024-05-07 05:39:02] WARNING: E_WARNING: foreach() argument must be of type array|object, null given {"code":2,"message":"foreach() argument must be of type array|object, null given","file":"C:\\wamp64\\www\\Espo\\application\ \Espo\\Core\\Utils\\Database\\Orm\\Converter.php", "line":249}
    [2024-05-07 05:39:02] WARNING: E_WARNING: foreach() argument must be of type array|object, null given {"code":2,"message":"foreach() argument must be of type array|object, null given","file":"C:\\wamp64\\www\\Espo\\application\ \Espo\\Core\\Utils\\Database\\Orm\\Converter.php", "line":319}
    [2024-05-07 05:39:02] WARNING: E_WARNING: foreach() argument must be of type array|object, null given {"code":2,"message":"foreach() argument must be of type array|object, null given","file":"C:\\wamp64\\www\\Espo\\application\ \Espo\\Core\\Utils\\Database\\Orm\\Converter.php", "line":319}
    [2024-05-07 05:39:02] WARNING: E_WARNING: foreach() argument must be of type array|object, null given {"code":2,"message":"foreach() argument must be of type array|object, null given","file":"C:\\wamp64\\www\\Espo\\application\ \Espo\\Core\\Utils\\Database\\Orm\\Converter.php", "line":319}
    [2024-05-07 05:39:02] WARNING: Schema\Builder: Column type [foreignid] not supported, EmailTemplateCategoryPath:ascendorId
    [2024-05-07 05:39:02] WARNING: Schema\Builder: Column type [foreignid] not supported, EmailTemplateCategoryPath:descendorId
    [2024-05-07 05:39:02] WARNING: Schema\Builder: Column type [foreignid] not supported, DocumentFolderPath:ascendorId
    [2024-05-07 05:39:02] WARNING: Schema\Builder: Column type [foreignid] not supported, DocumentFolderPath:descendorId
    [2024-05-07 05:39:02] WARNING: Schema\Builder: Column type [foreignid] not supported, KnowledgeBaseCategoryPath:ascendorId
    [2024-05-07 05:39:02] WARNING: Schema\Builder: Column type [foreignid] not supported, KnowledgeBaseCategoryPath:descendorId
    [2024-05-07 05:39:03] WARNING: E_WARNING: foreach() argument must be of type array|object, null given {"code":2,"message":"foreach() argument must be of type array|object, null given","file":"C:\\wamp64\\www\\Espo\\application\ \Espo\\Core\\Utils\\Database\\Orm\\Converter.php", "line":249}​
  • victor
    Active Community Member
    • Aug 2022
    • 727

    #2
    What version of php are you using? EspoCRM 8.0.6 still works on php 8.0, but starting with EspoCRM 8.1.0: https://github.com/espocrm/espocrm/releases/tag/8.1.0, php 8.0 is no longer supported. That is, before upgrading EspoCRM from 8.0.6, you need to upgrade php to version 8.1 (or 8.2, or 8.3).

    Comment

    • tayling
      Member
      • Apr 2023
      • 45

      #3
      Hi VIctor
      thanks for helping. My php version is 8.2.18. These arrors are from upgrading to 8.06 = all working apart from the errors - then the next upgrade gives the error 500 do trying to fix as I go.

      Thanks
      Tony

      Comment

      • tayling
        Member
        • Apr 2023
        • 45

        #4
        Hi
        Upgrading the next step to 8.1.5 also keeps working with same errors the next step to 8.2.3 causes the error 500

        [2024-05-07 05:39:02] WARNING: E_WARNING: foreach() argument must be of type array|object, null given {"code":2,"message":"foreach() argument must be of type array|object, null given","file":"C:\\wamp64\\www\\Espo\\application\ \Espo\\Core\\Utils\\Database\\Orm\\Converter.php", "line":249}
        [2024-05-07 05:39:02] WARNING: E_WARNING: foreach() argument must be of type array|object, null given {"code":2,"message":"foreach() argument must be of type array|object, null given","file":"C:\\wamp64\\www\\Espo\\application\ \Espo\\Core\\Utils\\Database\\Orm\\Converter.php", "line":249}
        [2024-05-07 05:39:02] WARNING: E_WARNING: foreach() argument must be of type array|object, null given {"code":2,"message":"foreach() argument must be of type array|object, null given","file":"C:\\wamp64\\www\\Espo\\application\ \Espo\\Core\\Utils\\Database\\Orm\\Converter.php", "line":249}
        [2024-05-07 05:39:02] WARNING: E_WARNING: foreach() argument must be of type array|object, null given {"code":2,"message":"foreach() argument must be of type array|object, null given","file":"C:\\wamp64\\www\\Espo\\application\ \Espo\\Core\\Utils\\Database\\Orm\\Converter.php", "line":319}
        [2024-05-07 05:39:02] WARNING: E_WARNING: foreach() argument must be of type array|object, null given {"code":2,"message":"foreach() argument must be of type array|object, null given","file":"C:\\wamp64\\www\\Espo\\application\ \Espo\\Core\\Utils\\Database\\Orm\\Converter.php", "line":319}
        [2024-05-07 05:39:02] WARNING: E_WARNING: foreach() argument must be of type array|object, null given {"code":2,"message":"foreach() argument must be of type array|object, null given","file":"C:\\wamp64\\www\\Espo\\application\ \Espo\\Core\\Utils\\Database\\Orm\\Converter.php", "line":319}
        [2024-05-07 05:39:02] WARNING: Schema\Builder: Column type [foreignid] not supported, EmailTemplateCategoryPath:ascendorId
        [2024-05-07 05:39:02] WARNING: Schema\Builder: Column type [foreignid] not supported, EmailTemplateCategoryPath:descendorId
        [2024-05-07 05:39:02] WARNING: Schema\Builder: Column type [foreignid] not supported, DocumentFolderPath:ascendorId
        [2024-05-07 05:39:02] WARNING: Schema\Builder: Column type [foreignid] not supported, DocumentFolderPath:descendorId
        [2024-05-07 05:39:02] WARNING: Schema\Builder: Column type [foreignid] not supported, KnowledgeBaseCategoryPath:ascendorId
        [2024-05-07 05:39:02] WARNING: Schema\Builder: Column type [foreignid] not supported, KnowledgeBaseCategoryPath:descendorId
        [2024-05-07 05:39:03] WARNING: E_WARNING: foreach() argument must be of type array|object, null given {"code":2,"message":"foreach() argument must be of type array|object, null given","file":"C:\\wamp64\\www\\Espo\\application\ \Espo\\Core\\Utils\\Database\\Orm\\Converter.php", "line":249}
        [2024-05-07 05:39:03] WARNING: E_WARNING: foreach() argument must be of type array|object, null given {"code":2,"message":"foreach() argument must be of type array|object, null given","file":"C:\\wamp64\\www\\Espo\\application\ \Espo\\Core\\Utils\\Database\\Orm\\Converter.php", "line":249}
        [2024-05-07 05:39:03] WARNING: E_WARNING: foreach() argument must be of type array|object, null given {"code":2,"message":"foreach() argument must be of type array|object, null given","file":"C:\\wamp64\\www\\Espo\\application\ \Espo\\Core\\Utils\\Database\\Orm\\Converter.php", "line":249}
        [2024-05-07 05:39:03] WARNING: E_WARNING: foreach() argument must be of type array|object, null given {"code":2,"message":"foreach() argument must be of type array|object, null given","file":"C:\\wamp64\\www\\Espo\\application\ \Espo\\Core\\Utils\\Database\\Orm\\Converter.php", "line":319}
        [2024-05-07 05:39:03] WARNING: E_WARNING: foreach() argument must be of type array|object, null given {"code":2,"message":"foreach() argument must be of type array|object, null given","file":"C:\\wamp64\\www\\Espo\\application\ \Espo\\Core\\Utils\\Database\\Orm\\Converter.php", "line":319}
        [2024-05-07 05:39:03] WARNING: E_WARNING: foreach() argument must be of type array|object, null given {"code":2,"message":"foreach() argument must be of type array|object, null given","file":"C:\\wamp64\\www\\Espo\\application\ \Espo\\Core\\Utils\\Database\\Orm\\Converter.php", "line":319}
        [2024-05-07 05:39:04] WARNING: Schema\Builder: Column type [foreignid] not supported, EmailTemplateCategoryPath:ascendorId
        [2024-05-07 05:39:04] WARNING: Schema\Builder: Column type [foreignid] not supported, EmailTemplateCategoryPath:descendorId
        [2024-05-07 05:39:04] WARNING: Schema\Builder: Column type [foreignid] not supported, DocumentFolderPath:ascendorId
        [2024-05-07 05:39:04] WARNING: Schema\Builder: Column type [foreignid] not supported, DocumentFolderPath:descendorId
        [2024-05-07 05:39:04] WARNING: Schema\Builder: Column type [foreignid] not supported, KnowledgeBaseCategoryPath:ascendorId
        [2024-05-07 05:39:04] WARNING: Schema\Builder: Column type [foreignid] not supported, KnowledgeBaseCategoryPath:descendorId
        [2024-05-07 07:20:29] ERROR: (500) Your EspoCRM version (8.1.5) is not supported. Required version: 8.0.6.; POST /Admin/action/uploadUpgradePackage; line: 282, file: C:\wamp64\www\Espo\application\Espo\Core\Upgrades\ Actions\Base.php

        Comment

        • tayling
          Member
          • Apr 2023
          • 45

          #5
          ANd finally after ugradint to to 8.2.3 - we get the error 500 and the below log addition

          [2024-05-07 07:20:29] ERROR: (500) Your EspoCRM version (8.1.5) is not supported. Required version: 8.0.6.; POST /Admin/action/uploadUpgradePackage; line: 282, file: C:\wamp64\www\Espo\application\Espo\Core\Upgrades\ Actions\Base.php
          [2024-05-07 07:46:55] ERROR: Slim Application Error Type: Error Code: 0 Message: Class "Espo\Services\Attachment" not found File: C:\wamp64\www\Espo\application\Espo\Modules\EblaLa bels\Services\Attachment.php Line: 9 Trace: #0 C:\wamp64\www\Espo\vendor\composer\ClassLoader.php (576): include() #1 C:\wamp64\www\Espo\vendor\composer\ClassLoader.php (427): Composer\Autoload\{closure}('C:\\wamp64\\www\\E... ') #2 [internal function]: Composer\Autoload\ClassLoader->loadClass('Espo\\Modules\\Eb...') #3 C:\wamp64\www\Espo\application\Espo\Core\Utils\Fil e\ClassMap.php(170): ReflectionClass->__construct('Espo\\Modules\\Eb...') #4 C:\wamp64\www\Espo\application\Espo\Core\Utils\Fil e\ClassMap.php(130): Espo\Core\Utils\File\ClassMap->fillHashFromFileList(Array, 'application/Esp...', NULL, Array) #5 C:\wamp64\www\Espo\application\Espo\Core\Utils\Fil e\ClassMap.php(88): Espo\Core\Utils\File\ClassMap->getClassNameHash(Array, NULL, false) #6 C:\wamp64\www\Espo\application\Espo\Core\Utils\Cla ssFinder.php(78): Espo\Core\Utils\File\ClassMap->getData('Services', 'classmapService...', NULL, false) #7 C:\wamp64\www\Espo\application\Espo\Core\Utils\Cla ssFinder.php(68): Espo\Core\Utils\ClassFinder->load('Services', false) #8 C:\wamp64\www\Espo\application\Espo\Core\Utils\Cla ssFinder.php(55): Espo\Core\Utils\ClassFinder->getMap('Services', false) #9 C:\wamp64\www\Espo\application\Espo\Core\ServiceFa ctory.php(56): Espo\Core\Utils\ClassFinder->find('Services', 'Lead') #10 C:\wamp64\www\Espo\application\Espo\Core\ServiceFa ctory.php(61): Espo\Core\ServiceFactory->getClassName('Lead') #11 C:\wamp64\www\Espo\application\Espo\Core\Record\Se rviceFactory.php(134): Espo\Core\ServiceFactory->checkExists('Lead') #12 C:\wamp64\www\Espo\application\Espo\Core\Record\Se rviceFactory.php(100): Espo\Core\Record\ServiceFactory->createInternal('Lead') #13 C:\wamp64\www\Espo\application\Espo\Core\Record\Se rviceContainer.php(82): Espo\Core\Record\ServiceFactory->create('Lead') #14 C:\wamp64\www\Espo\application\Espo\Core\Record\Se rviceContainer.php(74): Espo\Core\Record\ServiceContainer->load('Lead') #15 C:\wamp64\www\Espo\application\Espo\Core\Controlle rs\RecordBase.php(135): Espo\Core\Record\ServiceContainer->get('Lead') #16 C:\wamp64\www\Espo\application\Espo\Core\Controlle rs\RecordBase.php(247): Espo\Core\Controllers\RecordBase->getRecordService() #17 C:\wamp64\www\Espo\application\Espo\Core\Api\Contr ollerActionProcessor.php(87): Espo\Core\Controllers\RecordBase->getActionList(Object(Espo\Core\Api\RequestWrapp er ), Object(Espo\Core\Api\ResponseWrapper)) #18 C:\wamp64\www\Espo\application\Espo\Core\Api\Contr ollerActionHandler.php(65): Espo\Core\Api\ControllerActionProcessor->process('Lead', 'list', Object(Espo\Core\Api\RequestWrapper), Object(Espo\Core\Api\ResponseWrapper)) #19 C:\wamp64\www\Espo\vendor\slim\slim\Slim\Middlewar eDispatcher.php(65): Espo\Core\Api\ControllerActionHandler->handle(Object(Slim\Psr7\Request)) #20 C:\wamp64\www\Espo\application\Espo\Core\Api\Route Processor.php(222): Slim\MiddlewareDispatcher->handle(Object(Slim\Psr7\Request)) #21 C:\wamp64\www\Espo\application\Espo\Core\Api\Route Processor.php(149): Espo\Core\Api\RouteProcessor->processControllerAction(Object(Espo\Core\Api\Pr oc essData), Object(Slim\Psr7\Request), Object(Espo\Core\Api\ResponseWrapper)) Unminify assets or how to recreate t...o.min.js file? C:\wamp64\www\Espo\application\Espo\Core\Api\Route Processor.php(127): Espo\Core\Api\RouteProcessor->processAfterAuth(Object(Espo\Core\Api\ProcessDa ta ), Object(Slim\Psr7\Request), Object(Espo\Core\Api\ResponseWrapper)) Unminify assets or how to recreate t...o.min.js file? C:\wamp64\www\Espo\application\Espo\Core\Api\Route Processor.php(78): Espo\Core\Api\RouteProcessor->processInternal(Object(Espo\Core\Api\ProcessDat a) , Object(Slim\Psr7\Request), Object(Espo\Core\Api\RequestWrapper), Object(Espo\Core\Api\ResponseWrapper)) #24 C:\wamp64\www\Espo\application\Espo\Core\Api\Start er.php(109): Espo\Core\Api\RouteProcessor->process(Object(Espo\Core\Api\ProcessData), Object(Slim\Psr7\Request), Object(Slim\Psr7\Response)) Unminify assets or how to recreate t...o.min.js file? C:\wamp64\www\Espo\vendor\slim\slim\Slim\Handlers\ Strategies\RequestResponse.php(38): Espo\Core\Api\Starter->Espo\Core\Api\{closure}(Object(Slim\Psr7\Reques t) , Object(Slim\Psr7\Response), Array) how to upgrade ? C:\wamp64\www\Espo\vendor\slim\slim\Slim\Routing\R oute.php(358): Slim\Handlers\Strategies\RequestResponse->__invoke(Object(Closure), Object(Slim\Psr7\Request), Object(Slim\Psr7\Response), Array) how to upgrade ? C:\wamp64\www\Espo\vendor\slim\slim\Slim\Middlewar eDispatcher.php(65): Slim\Routing\Route->handle(Object(Slim\Psr7\Request)) #28 C:\wamp64\www\Espo\vendor\slim\slim\Slim\Middlewar eDispatcher.php(65): Slim\MiddlewareDispatcher->handle(Object(Slim\Psr7\Request)) #29 C:\wamp64\www\Espo\vendor\slim\slim\Slim\Routing\R oute.php(315): Slim\MiddlewareDispatcher->handle(Object(Slim\Psr7\Request)) #30 C:\wamp64\www\Espo\vendor\slim\slim\Slim\Routing\R outeRunner.php(68): Slim\Routing\Route->run(Object(Slim\Psr7\Request)) #31 C:\wamp64\www\Espo\vendor\slim\slim\Slim\Middlewar e\RoutingMiddleware.php(45): Slim\Routing\RouteRunner->handle(Object(Slim\Psr7\Request)) Unminify assets or how to recreate t...o.min.js file? C:\wamp64\www\Espo\vendor\slim\slim\Slim\Middlewar eDispatcher.php(121): Slim\Middleware\RoutingMiddleware->process(Object(Slim\Psr7\Request), Object(Slim\Routing\RouteRunner)) Quotes C:\wamp64\www\Espo\vendor\slim\slim\Slim\Middlewar e\ErrorMiddleware.php(76): Psr\Http\Server\RequestHandlerInterface@anonymous->handle(Object(Slim\Psr7\Request)) Quotes C:\wamp64\www\Espo\vendor\slim\slim\Slim\Middlewar eDispatcher.php(121): Slim\Middleware\ErrorMiddleware->process(Object(Slim\Psr7\Request), Object(Psr\Http\Server\RequestHandlerInterface@ano nymous)) #35 C:\wamp64\www\Espo\vendor\slim\slim\Slim\Middlewar eDispatcher.php(65): Psr\Http\Server\RequestHandlerInterface@anonymous->handle(Object(Slim\Psr7\Request)) how to upgrade ? C:\wamp64\www\Espo\vendor\slim\slim\Slim\App.php(1 99): Slim\MiddlewareDispatcher->handle(Object(Slim\Psr7\Request)) how to upgrade ? C:\wamp64\www\Espo\vendor\slim\slim\Slim\App.php(1 83): Slim\App->handle(Object(Slim\Psr7\Request)) how to upgrade ? C:\wamp64\www\Espo\application\Espo\Core\Api\Start er.php(76): Slim\App->run() #39 C:\wamp64\www\Espo\application\Espo\Core\Applicati onRunners\Api.php(45): Espo\Core\Api\Starter->start() how to upgrade ? C:\wamp64\www\Espo\application\Espo\Core\Applicati on\RunnerRunner.php(84): Espo\Core\ApplicationRunners\Api->run() how to upgrade ? C:\wamp64\www\Espo\application\Espo\Core\Applicati on.php(78): Espo\Core\Application\RunnerRunner->run('Espo\\Core\\Appli...', NULL) how to upgrade ? C:\wamp64\www\Espo\public\api\v1\index.php(35): Espo\Core\Application->run('Espo\\Core\\Appli...') how to upgrade ? {main} Tips: To display error details in HTTP response set "displayErrorDetails" to true in the ErrorHandler constructor.

          Comment

          • dnkta
            Junior Member
            • May 2024
            • 1

            #6
            By me with Docker Compose was because of the mysql 8.4.0 changes:

            Deprecation and Removal Notes
            • Important Change: The deprecated mysql_native_password authentication plugin is now disabled by default. It can be enabled by starting MySQL with the new --mysql-native-password=ON server option, or by adding mysql_native_password=ON to the [mysqld] section of your MySQL configuration file.
            As soon as i adapted the docker compose file it started working again


            Comment

            • tayling
              Member
              • Apr 2023
              • 45

              #7
              Hi
              after digging though the forums - I restored back to 8,1,5 and removed all external extensions and upgraded successfully to 8.2.3 without error 500
              Hope this also helps others

              Comment


              • victor
                victor commented
                Editing a comment
                It is best to always perform EspoCRM upgrade with disabled extensions, especially unofficial ones. And after a successful upgrade, reinstall the extensions.
            Working...