Stuck on 'loading language'

Hi,

I’m looking for a replacement for sugarce 6.5 so i’m trying to test this crm.

I made a ubuntu 22.04 VM with php 8.2, mysql 8, apache 2.4.52 and elasticsearch 8. I cloned the latest release of spice in webserver root and configured it according to the docs (i think). www-data is owner of the spicecrm web root dir and has 0755 permissions on cache, custom, media and upload folder. I also activated https and this works as intended. When i complete the installation via webbrowser everything is as expected and i get no errors.

After installation it refreshes the page and shows the login screen. When i fill i my credentials it loads but get stuck on ‘loading language’. Tried several browsers.

Does anyone have an idea what’s the cause and how i can solve it?

Many thanks in advance,

Johan

@Johan do you see any error in api/spicecrm.log? or in the php error log?

2024-07-09 12:11:44 [734][1][FATAL][SQL] {"error":"Table 'spicecrm2.ldap_settings' doesn't exist","query":"SELECT * from ldap_settings where is_active = 1 AND deleted = 0 order by priority"}

2024-07-09 14:13:43 [733][-none-][FATAL][SQL] {"error":"Table 'spicecrm2.ipaddresses' doesn't exist","query":"SELECT count(*) FROM ipaddresses WHERE date_deleted IS NULL AND color='b' AND address = '10.11.100.154' LIMIT 0,1"}
2024-07-09 14:13:43 [733][-none-][FATAL][SQLERROR]  Get One Failed:SELECT count(*) FROM ipaddresses WHERE date_deleted IS NULL AND color='b' AND address = '10.11.100.154': MySQL error 1146: Table 'spicecrm2.ipaddresses' doesn't exist

Those errors keep recurring. User that connects to db has all grants on .

This is from the apache2 log:

[Tue Jul 09 12:07:37.216670 2024] [proxy_fcgi:error] [pid 1654] [client 10.11.100.154:49803] AH01071: Got error 'PHP message: Slim Application Error\nType: TypeError\nCode: 0\nMessage: array_values(): Argu>
[Tue Jul 09 12:07:42.110735 2024] [mpm_prefork:notice] [pid 1653] AH00170: caught SIGWINCH, shutting down gracefully
[Tue Jul 09 12:10:33.936850 2024] [ssl:warn] [pid 1475] AH01909: spicecrm.centio.internal:443:0 server certificate does NOT include an ID which matches the server name
[Tue Jul 09 12:10:33.938590 2024] [ssl:error] [pid 1475] AH02604: Unable to configure certificate spicecrm.centio.internal:443:0 for stapling

@maretval Are my logs of any use?

I have now also tried installing everything on a new ubuntu 22 server; same thing. Also tried older release of spice.

A new line has appeared in error.log:

[Mon Jul 15 12:48:38.032625 2024] [php:notice] [pid 986] [client 10.11.100.154:52887] Slim Application Error Type: TypeError Code: 0 Message: array_values(): 
Argument #1 ($array) must be of type array, null given File: /var/www/spicecrm/api/include/SpiceDictionary/SpiceDictionaryDomainValidations.php Line: 97 Trace: 
#0 /var/www/spicecrm/api/include/SpiceDictionary/SpiceDictionaryDomainValidations.php(97): array_values() 
#1 /var/www/spicecrm/api/include/SpiceDictionary/SpiceDictionaryDomainValidations.php(35): SpiceCRM\\includes\\SpiceDictionary\\SpiceDictionaryDomainValidations->__construct() 
#2 /var/www/spicecrm/api/include/utils/SpiceUtils.php(1298): SpiceCRM\\includes\\SpiceDictionary\\SpiceDictionaryDomainValidations::getInstance() 
#3 /var/www/spicecrm/api/include/SpiceUI/api/controllers/CoreController.php(237): SpiceCRM\\includes\\utils\\SpiceUtils::returnAppListStringsLanguage() 
#4 /var/www/spicecrm/api/vendor/slim/slim/Slim/Handlers/Strategies/RequestResponse.php(38): SpiceCRM\\includes\\SpiceUI\\api\\controllers\\CoreController->getLanguage() 
#5 /var/www/spicecrm/api/vendor/slim/slim/Slim/Routing/Route.php(358): Slim\\Handlers\\Strategies\\RequestResponse->__invoke() 
#6 /var/www/spicecrm/api/include/Middleware/ValidationMiddleware.php(72): Slim\\Routing\\Route->handle() 
#7 /var/www/spicecrm/api/vendor/slim/slim/Slim/MiddlewareDispatcher.php(168): SpiceCRM\\includes\\Middleware\\ValidationMiddleware->__invoke() 
#8 /var/www/spicecrm/api/vendor/slim/slim/Slim/MiddlewareDispatcher.php(65): Psr\\Http\\Server\\RequestHandlerInterface@anonymous->handle() 
#9 /var/www/spicecrm/api/vendor/slim/slim/Slim/MiddlewareDispatcher.php(65): Slim\\MiddlewareDispatcher->handle() 
#10 /var/www/spicecrm/api/vendor/slim/slim/Slim/Routing/Route.php(315): Slim\\MiddlewareDispatcher->handle() 
#11 /var/www/spicecrm/api/vendor/slim/slim/Slim/Routing/RouteRunner.php(68): Slim\\Routing\\Route->run() 
#12 /var/www/spicecrm/api/vendor/slim/slim/Slim/Middleware/BodyParsingMiddleware.php(64): Slim\\Routing\\RouteRunner->handle() 
#13 /var/www/spicecrm/api/vendor/slim/slim/Slim/MiddlewareDispatcher.php(121): Slim\\Middleware\\BodyParsingMiddleware->process() 
#14 /var/www/spicecrm/api/include/Middleware/DeveloperMiddleware.php(20): Psr\\Http\\Server\\RequestHandlerInterface@anonymous->handle() 
#15 /var/www/spicecrm/api/vendor/slim/slim/Slim/MiddlewareDispatcher.php(168): SpiceCRM\\includes\\Middleware\\DeveloperMiddleware->__invoke() 
#16 /var/www/spicecrm/api/include/Middleware/TransactionMiddleware.php(22): Psr\\Http\\Server\\RequestHandlerInterface@anonymous->handle() 
#17 /var/www/spicecrm/api/vendor/slim/slim/Slim/MiddlewareDispatcher.php(168): SpiceCRM\\includes\\Middleware\\TransactionMiddleware->__invoke() 
#18 /var/www/spicecrm/api/include/RESTManager.php(145): Psr\\Http\\Server\\RequestHandlerInterface@anonymous->handle() #
19 /var/www/spicecrm/api/vendor/slim/slim/Slim/MiddlewareDispatcher.php(269): SpiceCRM\\includes\\RESTManager->SpiceCRM\\includes\\{closure}() 
#20 /var/www/spicecrm/api/include/Middleware/ErrorMiddleware.php(21): Psr\\Http\\Server\\RequestHandlerInterface@anonymous->handle() 
#21 /var/www/spicecrm/api/vendor/slim/slim/Slim/MiddlewareDispatcher.php(168): SpiceCRM\\includes\\Middleware\\ErrorMiddleware->__invoke() 
#22 /var/www/spicecrm/api/include/Middleware/ExceptionMiddleware.php(17): Psr\\Http\\Server\\RequestHandlerInterface@anonymous->handle() 
#23 /var/www/spicecrm/api/vendor/slim/slim/Slim/MiddlewareDispatcher.php(168): SpiceCRM\\includes\\Middleware\\ExceptionMiddleware->__invoke() 
#24 /var/www/spicecrm/api/vendor/slim/slim/Slim/Middleware/ErrorMiddleware.php(76): Psr\\Http\\Server\\RequestHandlerInterface@anonymous->handle() 
#25 /var/www/spicecrm/api/vendor/slim/slim/Slim/MiddlewareDispatcher.php(121): Slim\\Middleware\\ErrorMiddleware->process() 
#26 /var/www/spicecrm/api/include/Middleware/LoggerMiddleware.php(51): Psr\\Http\\Server\\RequestHandlerInterface@anonymous->handle() 
#27 /var/www/spicecrm/api/vendor/slim/slim/Slim/MiddlewareDispatcher.php(168): SpiceCRM\\includes\\Middleware\\LoggerMiddleware->__invoke() 
#28 /var/www/spicecrm/api/vendor/slim/slim/Slim/Middleware/RoutingMiddleware.php(45): Psr\\Http\\Server\\RequestHandlerInterface@anonymous->handle() 
#29 /var/www/spicecrm/api/vendor/slim/slim/Slim/MiddlewareDispatcher.php(121): Slim\\Middleware\\RoutingMiddleware->process() 
#30 /var/www/spicecrm/api/vendor/slim/slim/Slim/MiddlewareDispatcher.php(65): Psr\\Http\\Server\\RequestHandlerInterface@anonymous->handle() 
#31 /var/www/spicecrm/api/vendor/slim/slim/Slim/App.php(199): Slim\\MiddlewareDispatcher->handle() 
#32 /var/www/spicecrm/api/vendor/slim/slim/Slim/App.php(183): Slim\\App->handle() 
#33 /var/www/spicecrm/api/index.php(121): Slim\\App->run() 
#34 {main}, referer: http://spice.centio.internal/

Any help would be appreciated!

Please, check server access writes for api/include/SpiceDictionary/system/systemcached.dump
Set the user www-data as the owner.
remove folders api/cache, api/custom, api/media/, api/upload and api/config.php
delete the database that was created
Launch the installer again