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

Could you login after your new installation on ubuntu?
That’s important to know.
If yes, then you need to follow the next steps described in the installation guide.

@johancentio A file was missing. Please, pull the master branch again, that shall do it

Hi Maretval,

Thankyou for your responses, but i have moved to a different product. I understand you cannot respond to all forum posts promptly but i had to find a solution for my clients problem and unfortunately could not wait any longer. You probably have a wonderful product but the ability of getting support from the developers or an active community are very important to my client. I wish you the best in developing your product.

Kind regards,

Johan

@johancentio Thank you for your feedback. I wish you all the best with the product of your choice.
:+1:

EDIT: I CAN LOGIN!
But Cant use any packages, i just have “users”: Failed to load packages opportunitymanagement

EDIT 2:

I wanted to share my experience with setting up SpiceCRM. During the installation, I noticed that many packages were installed or installed “wrong” even though the system indicated otherwise (like accounts because i cant create a record) . There were numerous error messages, which I hope are just due to ongoing development and will resolve themselves shortly. It’s frustrating that these errors don’t clear up on their own after a few seconds. (maybe its an easy fix to have a better impression)

Despite these initial hurdles, I’m impressed with the project’s potential. It offers many customization options and significant functional power. The short time looking the codebase it seems to be well-designed for developers.

I spent several hours working through these issues (setup), but I’m not deterred. I see a lot of promise in SpiceCRM and look forward to exploring it further.

Just wanted to share my experience and let others know that despite the initial challenges, the project seems promising!

power over spice is power over all


OLD POST:

same problem: Table ‘spicecrm.ldap_settings’ doesn’t exist

2024-08-13 17:22:58 [22][-none-][FATAL][SQL] {“error”:“Table ‘spicecrm.ldap_settings’ doesn’t exist”,“query”:“SELECT * from ldap_settings where is_active = 1 AND deleted = 0 order by priority”}

It seems that the configuration includes SQLEXPRESS for the “Database host instance,” which is meant for SQL Server Express. Since I’m using MySQL, this reference seems incorrect.

I have three containers set up for this application and would like to correct this configuration.

I check myspicecrm/src/include/spiceinstaller/components/spiceinstallerdatatabase.ts:54

We didn’t take the time to check the SpiceCRM version 2024.01.001. We will for sure do better for 2024.02.001

2 Likes