Error Log and Error 500

[tayling]

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]

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).

[tayling]

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

[tayling]

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

[tayling]

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.

[dnkta]

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

[tayling]

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

[victor]

It is best to always perform EspoCRM upgrade with disabled extensions, especially unofficial ones. And after a successful upgrade, reinstall the extensions.