Installation - UI Language Config - REST Call error somewhere... Action aborted

OK. I’ll try an install on local environment to see what happens.
You did delete browser cache and closed browser before reloading UI, didn’t you?

full system purge with ccleaner

Could you mention php version,
Database type and version
Browser name and version?

Chrome Version 70.0.3538.102 (Official Build) (64-bit)
Ubuntu 16.04 (x86_64)
PHP version: 7.0.32-0ubuntu0.16.04.1
MySQL: 5.7.24-0ubuntu0.16.04.1 - (Ubuntu)

Hello, I also get the same error on successful install relating to aclterritories etc.

Today on a fresh install and existing (semi-working environment) I cannot load any packages when selecting UI Language config or UI Config. Both give a blank screen.

The sub URL for language above works in the browser. Fresh master package install.

Regards, Jake.

You should find a mySQL error in sugarcrm.log. Please grab it and post it.

Hey.

I get two errors:

Mon Nov 19 15:31:16 2018 [5384][-none-][FATAL] json_decode error on REST response from reference server. Response: Slim Application Errorbody{margin:0;padding:30px;font:12px/1.5 Helvetica,Arial,Verdana,sans-serif;}h1{margin:0;font-size:48px;font-weight:normal;line-height:48px;}strong{display:inline-block;width:65px;}

Slim Application Error

The application could not run because of the following error:

Details

Type: ErrorException
Code: 8
Message: Undefined index: name
File: /var/www/spicecrm_package_proxy/PackageHandler/PackageHandler.php
Line: 24

Trace

#0 /var/www/spicecrm_package_proxy/PackageHandler/PackageHandler.php(24): Slim\Slim::handleErrors(8, ‘Undefined index…’, ‘/var/www/spicec…’, 24, Array)
#1 /var/www/spicecrm_package_proxy/index.php(36): PackageHandler::getAvailable(true)
#2 [internal function]: {closure}()
#3 /var/www/spicecrm_package_proxy/Slim/Route.php(468): call_user_func_array(Object(Closure), Array)
#4 /var/www/spicecrm_package_proxy/Slim/Slim.php(1357): Slim\Route->dispatch()
#5 /var/www/spicecrm_package_proxy/Slim/Middleware/Flash.php(85): Slim\Slim->call()
#6 /var/www/spicecrm_package_proxy/Slim/Middleware/MethodOverride.php(92): Slim\Middleware\Flash->call()
#7 /var/www/spicecrm_package_proxy/Slim/CorsSlim.php(117): Slim\Middleware\MethodOverride->call()
#8 /var/www/spicecrm_package_proxy/Slim/Middleware/PrettyExceptions.php(67): CorsSlim\CorsSlim->call()
#9 /var/www/spicecrm_package_proxy/Slim/Slim.php(1302): Slim\Middleware\PrettyExceptions->call()
#10 /var/www/spicecrm_package_proxy/index.php(62): Slim\Slim->run()
#11 {main}. URL: https://packages.spicecrm.io/releaseconfig. Please check call parameters!

and

Mon Nov 19 15:31:17 2018 [5384][-none-][FATAL] unable to load DB manager for:

We are preparing November release which will include improvements regarding UI config loading.
I think it’ll be better to wait for the release packages. Thanks for your patience.

Hey mate,

Fresh install with the latest versions and still hitting the similar issues, the installer and modules seem to be loading better though

Component PiplContainer Missing (see attached screenshot)

Just for testing purposes so I can remove the element of my server,
Question - Do you have a working backup which I could restore on our environment?

Really keen to move forward with Spice

Same with the records, I have the demo data and created a new test record. It shows the recent records but the lists are empty

Page errors
Failed to load resource: the server responded with a status of 404 ()
core.umd.min.js:491 ERROR Error: Uncaught (in promise): Error: Fetch error: 404
Instantiating https://domain.com/spicecrm_fe_release_core-master/app/modules/deployment/moduledeployment.js
Loading app/modules/deployment/moduledeployment
Error: Fetch error: 404
at system.js:4
at e.invoke (zone.min.js:1)
at Object.onInvoke (core.umd.min.js:549)
at e.invoke (zone.min.js:1)
at r.run (zone.min.js:1)
at zone.min.js:1
at e.invokeTask (zone.min.js:1)
at Object.onInvokeTask (core.umd.min.js:549)
at e.invokeTask (zone.min.js:1)
at r.runTask (zone.min.js:1)
at system.js:4
at e.invoke (zone.min.js:1)
at Object.onInvoke (core.umd.min.js:549)
at e.invoke (zone.min.js:1)
at r.run (zone.min.js:1)
at zone.min.js:1
at e.invokeTask (zone.min.js:1)
at Object.onInvokeTask (core.umd.min.js:549)
at e.invokeTask (zone.min.js:1)
at r.runTask (zone.min.js:1)
at u (zone.min.js:1)
at u (zone.min.js:1)
at zone.min.js:1
at e.invokeTask (zone.min.js:1)
at Object.onInvokeTask (core.umd.min.js:549)
at e.invokeTask (zone.min.js:1)
at r.runTask (zone.min.js:1)
at o (zone.min.js:1)
ec @ core.umd.min.js:491
e.handleError @ core.umd.min.js:498
next @ core.umd.min.js:556
n.object.i @ core.umd.min.js:345
SafeSubscriber.__tryOrUnsub @ Subscriber.ts:270
SafeSubscriber.next @ Subscriber.ts:212
Subscriber._next @ Subscriber.ts:141
Subscriber.next @ Subscriber.ts:101
Subject.next @ Subject.ts:68
n.emit @ core.umd.min.js:345
(anonymous) @ core.umd.min.js:549
e.invoke @ zone.min.js:1
r.run @ zone.min.js:1
e.runOutsideAngular @ core.umd.min.js:549
onHandleError @ core.umd.min.js:549
e.handleError @ zone.min.js:1
r.runGuarded @ zone.min.js:1
e @ zone.min.js:1
n.microtaskDrainDone @ zone.min.js:1
o @ zone.min.js:1
/spicecrm_fe_release_core-master/proxy/181207/territories:1 Failed to load resource: the server responded with a status of 404 ()
core.umd.min.js:491 ERROR HttpErrorResponse
ec @ core.umd.min.js:491
e.handleError @ core.umd.min.js:498
next @ core.umd.min.js:556
n.object.i @ core.umd.min.js:345
SafeSubscriber.__tryOrUnsub @ Subscriber.ts:270
SafeSubscriber.next @ Subscriber.ts:212
Subscriber._next @ Subscriber.ts:141
Subscriber.next @ Subscriber.ts:101
Subject.next @ Subject.ts:68
n.emit @ core.umd.min.js:345
(anonymous) @ core.umd.min.js:549
e.invoke @ zone.min.js:1
r.run @ zone.min.js:1
e.runOutsideAngular @ core.umd.min.js:549
onHandleError @ core.umd.min.js:549
e.handleError @ zone.min.js:1
r.runTask @ zone.min.js:1
t.invokeTask @ zone.min.js:1
a.useG.invoke @ zone.min.js:1
n @ zone.min.js:1
core.umd.min.js:491 ERROR HttpErrorResponse
ec @ core.umd.min.js:491
e.handleError @ core.umd.min.js:498
next @ core.umd.min.js:556
n.object.i @ core.umd.min.js:345
SafeSubscriber.__tryOrUnsub @ Subscriber.ts:270
SafeSubscriber.next @ Subscriber.ts:212
Subscriber._next @ Subscriber.ts:141
Subscriber.next @ Subscriber.ts:101
Subject.next @ Subject.ts:68
n.emit @ core.umd.min.js:345
(anonymous) @ core.umd.min.js:549
e.invoke @ zone.min.js:1
r.run @ zone.min.js:1
e.runOutsideAngular @ core.umd.min.js:549
onHandleError @ core.umd.min.js:549
e.handleError @ zone.min.js:1
r.runTask @ zone.min.js:1
t.invokeTask @ zone.min.js:1
a.useG.invoke @ zone.min.js:1
n @ zone.min.js:1
/spicecrm_fe_release_core-master/proxy/181207/module/Dashboards/1:1 Failed to load resource: the server responded with a status of 404 ()
/spicecrm_fe_release_core-master/proxy/181207/module/History/Contacts/f79f082a-3073-70c8-e888-c9caf867cd9b?count=1&limit=5&objects=%5B%5D&own=:1 Failed to load resource: the server responded with a status of 500 ()
core.umd.min.js:491 ERROR HttpErrorResponse
ec @ core.umd.min.js:491
e.handleError @ core.umd.min.js:498
next @ core.umd.min.js:556
n.object.i @ core.umd.min.js:345
SafeSubscriber.__tryOrUnsub @ Subscriber.ts:270
SafeSubscriber.next @ Subscriber.ts:212
Subscriber._next @ Subscriber.ts:141
Subscriber.next @ Subscriber.ts:101
Subject.next @ Subject.ts:68
n.emit @ core.umd.min.js:345
(anonymous) @ core.umd.min.js:549
e.invoke @ zone.min.js:1
r.run @ zone.min.js:1
e.runOutsideAngular @ core.umd.min.js:549
onHandleError @ core.umd.min.js:549
e.handleError @ zone.min.js:1
r.runTask @ zone.min.js:1
t.invokeTask @ zone.min.js:1
a.useG.invoke @ zone.min.js:1
n @ zone.min.js:1
core.umd.min.js:491 ERROR HttpErrorResponse
ec @ core.umd.min.js:491
e.handleError @ core.umd.min.js:498
next @ core.umd.min.js:556
n.object.i @ core.umd.min.js:345
SafeSubscriber.__tryOrUnsub @ Subscriber.ts:270
SafeSubscriber.next @ Subscriber.ts:212
Subscriber._next @ Subscriber.ts:141
Subscriber.next @ Subscriber.ts:101
Subject.next @ Subject.ts:68
n.emit @ core.umd.min.js:345
(anonymous) @ core.umd.min.js:549
e.invoke @ zone.min.js:1
r.run @ zone.min.js:1
e.runOutsideAngular @ core.umd.min.js:549
onHandleError @ core.umd.min.js:549
e.handleError @ zone.min.js:1
r.runTask @ zone.min.js:1
t.invokeTask @ zone.min.js:1
a.useG.invoke @ zone.min.js:1
n @ zone.min.js:1
core.umd.min.js:491 ERROR HttpErrorResponse
ec @ core.umd.min.js:491
e.handleError @ core.umd.min.js:498
next @ core.umd.min.js:556
n.object.i @ core.umd.min.js:345
SafeSubscriber.__tryOrUnsub @ Subscriber.ts:270
SafeSubscriber.next @ Subscriber.ts:212
Subscriber._next @ Subscriber.ts:141
Subscriber.next @ Subscriber.ts:101
Subject.next @ Subject.ts:68
n.emit @ core.umd.min.js:345
(anonymous) @ core.umd.min.js:549
e.invoke @ zone.min.js:1
r.run @ zone.min.js:1
e.runOutsideAngular @ core.umd.min.js:549
onHandleError @ core.umd.min.js:549
e.handleError @ zone.min.js:1
r.runTask @ zone.min.js:1
t.invokeTask @ zone.min.js:1
a.useG.invoke @ zone.min.js:1
n @ zone.min.js:1
core.umd.min.js:491 ERROR HttpErrorResponse
ec @ core.umd.min.js:491
e.handleError @ core.umd.min.js:498
next @ core.umd.min.js:556
n.object.i @ core.umd.min.js:345
SafeSubscriber.__tryOrUnsub @ Subscriber.ts:270
SafeSubscriber.next @ Subscriber.ts:212
Subscriber._next @ Subscriber.ts:141
Subscriber.next @ Subscriber.ts:101
Subject.next @ Subject.ts:68
n.emit @ core.umd.min.js:345
(anonymous) @ core.umd.min.js:549
e.invoke @ zone.min.js:1
r.run @ zone.min.js:1
e.runOutsideAngular @ core.umd.min.js:549
onHandleError @ core.umd.min.js:549
e.handleError @ zone.min.js:1
r.runTask @ zone.min.js:1
t.invokeTask @ zone.min.js:1
a.useG.invoke @ zone.min.js:1
n @ zone.min.js:1
core.umd.min.js:491 ERROR HttpErrorResponse
ec @ core.umd.min.js:491
e.handleError @ core.umd.min.js:498
next @ core.umd.min.js:556
n.object.i @ core.umd.min.js:345
SafeSubscriber.__tryOrUnsub @ Subscriber.ts:270
SafeSubscriber.next @ Subscriber.ts:212
Subscriber._next @ Subscriber.ts:141
Subscriber.next @ Subscriber.ts:101
Subject.next @ Subject.ts:68
n.emit @ core.umd.min.js:345
(anonymous) @ core.umd.min.js:549
e.invoke @ zone.min.js:1
r.run @ zone.min.js:1
e.runOutsideAngular @ core.umd.min.js:549
onHandleError @ core.umd.min.js:549
e.handleError @ zone.min.js:1
r.runTask @ zone.min.js:1
t.invokeTask @ zone.min.js:1
a.useG.invoke @ zone.min.js:1
n @ zone.min.js:1
core.umd.min.js:491 ERROR HttpErrorResponse
ec @ core.umd.min.js:491
core.umd.min.js:491 ERROR HttpErrorResponse
ec @ core.umd.min.js:491
core.umd.min.js:491 ERROR HttpErrorResponse
ec @ core.umd.min.js:491
core.umd.min.js:491 ERROR HttpErrorResponse
ec @ core.umd.min.js:491
core.umd.min.js:491 ERROR HttpErrorResponse
ec @ core.umd.min.js:491
core.umd.min.js:491 ERROR HttpErrorResponse
ec @ core.umd.min.js:491
zone.min.js:1 [Violation] ‘setTimeout’ handler took 96ms

Hi,

I have re-installed up with the latest package updates and the method to truncate and re-install as above.

My installation now just present the following errors in console and also lists no entries even though demo data is present in the backend UI. Similar I think to what tornmarketing describes.

Failed to load resource: the server responded with a status of 404 (Not Found)

ERROR core.umd.min.js:491
HttpErrorResponseerror: {error: {…}}headers: HttpHeaders {normalizedNames: Map(0), lazyUpdate: null, lazyInit: ƒ}message: "Http failure response for https://www..co.uk/backend/KREST/territories: 404 Not Found"name: "HttpErrorResponse"ok: falsestatus: 404statusText: "Not Found"url: "https://www..co.uk/backend/KREST/territories"proto: HttpResponseBase
ec @ core.umd.min.js:491

Only thing of note is I have the backend in a subdirectory and SpiceUI in the index directory. Any reason this isn’t the recommended method as it would seem the most logical for most users to access the SpiceUI Interface directly from the top level domain?

Thanks, Jake.

I donwloaded latest master packages.
My Architecture:
spicecrm/[frontend files]
spicecrm/backend/[backend file]
I installed backend. Did Repair/rebuild after installation.
I pulled UI Config (ONLY CORE !), UI Languages , SpiceBeanGuides and FTS defaults.
Then I called the frontend: install screen of UI came up, I populated the fields, saved and was redirected to login screen.
I logged in: no error messages in console in UI.

Still a problem:

  1. I noticed that FTS Setup in Frontend doesn’t work properly.
    Only FTS Manager in backend works properly. I clicked put mapping for Accounts then index.
  2. No listview in Frontend just like Jake
    I could see in my index (spicecore is my prefix)
    http://localhost:9200/spicecoreaccounts/_search
    total of 50 accounts are indexed.
    Still they are not displayed in listview in frontend. elastic search throws following error: no mapping found for[name.raw] in order to sort on.
    sort flag is set in FTS setup, I assume there is a problem in the mapping generation.
    It will be analyzed and hopefully fixed for January release.
    Unfortunately indexed search is necessary to use UI.

I just committed a hotfix for FTS in master branch. Wrong config was loaded.
Fix committed to file modules/Administration/FTSDefault.php
Download and overwrite.
Then Go to backend Administration FTS default and load current config.
Then index your records. Start with module Accounts using backend Administration FTS Manager. Select Accounts and click “index”. It will index accounts. If you loaded demo data during installation, you shall have 50 entries.

no good still covered in errors, spent way too many dev hours on this
Might wait it out until new year and seen others up and running

Cheers mate for the efforts

I followed the above but haven’t seen any changes in either backend or UI.

I still get the error related to ‘/prism/KREST/territories’ 404. Have you seen this error maretval?
I also have ‘/prism/KREST/module/Dashboards/1’ showing 404 in console

I am not certain FTS is working correctly with ElasticSearch. I have following the documentation, ElasticSearch is running. Can you clarify what should be set as the FTS prefix? I have the following details when I curl ‘localhost:9200’:

{
“name” : “",
“cluster_name” : "
”,
“cluster_uuid” : “",
“version” : {
“number” : “6.5.3”,
“build_flavor” : “default”,
“build_type” : “rpm”,
“build_hash” : "
”,
“build_date” : “2018-12-06T20:11:28.826501Z”,
“build_snapshot” : false,
“lucene_version” : “7.5.0”,
“minimum_wire_compatibility_version” : “5.6.0”,
“minimum_index_compatibility_version” : “5.0.0”
},
“tagline” : “You Know, for Search”
}

I am hoping to get both backend and UI working, although I have other solutions working well, spice with the UI frontend still seems to be the best… almost there, it seems a shame to have these small errors. Roughly when will the January release be?

Thanks, Jake.

Jake,
FTS works with elasticsearch (5.x -6.x supported, version 6 recommanded)
If you didn’t fill in elastic search variables during backend installation then add following set to your config.php
Adapt the value for server and port if needed
‘fts’ =>
array (
‘server’ => ‘localhost’,
‘port’ => ‘9200’,
‘prefix’ => ‘spicecrm’,
‘loglevel’ => ‘0’,
‘schedulerpackagesize’ => 25000,
),

Make sure you downloaded the master branch packages

Delete you browser cache.

Hi,

I had these settings in config.php but thank you.

I have successfully got some data populating in UI, demo contact data seems to work mainly and account records setup in UI. I will do some digging with elastic and ensure it’s running reliably and spice is able to index correctly.

I still have the error related to /territories module.

Also, in order to get KREST working I still have to perform the code edit here when updating from master package:

Is necessary for you also?

Regards, Jake.

No, this function is native in all our installations.
But thanks for reading community threads and for reminding me.
I thought we had this code already somewhere in KREST but apparently not. I will see that it gets integrated.

No problem. I am able to see records in UI now, I will tweak the server to make sure elasticsearch is running more efficiently (it fails periodically at the moment).

Thanks for looking into these.

May be having a similar issue. I am seeing this in my apache error log when I try and load UI_config:
Wed Jan 2 23:44:03 2019 [31561][-none-][FATAL] json_decode error on REST response from reference server. Response: <html><head><title>Slim Application Error</title><style>body{margin:0;padding:30px;font:12px/1.5 Helvetica,Arial,Verdana,sans-serif;}h1{margin:0;font-size:48px;font-weight:normal;line-height:48px;}strong{display:inline-block;width:65px;}</style></head><body><h1>Slim Application Error</h1><p>The application could not run because of the following error:</p><h2>Details</h2><div><strong>Type:</strong> ErrorException</div><div><strong>Code:</strong> 8</div><div><strong>Message:</strong> Undefined index: package_type</div><div><strong>File:</strong> /var/www/spicecrm_package_proxy/PackageHandler/PackageHandler.php</div><div><strong>Line:</strong> 24</div><h2>Trace</h2><pre><div>#0 /var/www/spicecrm_package_proxy/PackageHandler/PackageHandler.php(24): Slim\Slim::handleErrors(8, ‘Undefined index…’, ‘/var/www/spicec…’, 24, Array)</div><div>#1 /var/www/spicecrm_package_proxy/index.php(36): PackageHandler::getAvailable(true)</div><div>#2 [internal function]: {closure}()</div><div>#3 /var/www/spicecrm_package_proxy/Slim/Route.php(468): call_user_func_array(Object(Closure), Array)</div><div>#4 /var/www/spicecrm_package_proxy/Slim/Slim.php(1357): Slim\Route-&gt;dispatch()</div><div>#5 /var/www/spicecrm_package_proxy/Slim/Middleware/Flash.php(85): Slim\Slim-&gt;call()</div><div>#6 /var/www/spicecrm_package_proxy/Slim/Middleware/MethodOverride.php(92): Slim\Middleware\Flash-&gt;call()</div><div>#7 /var/www/spicecrm_package_proxy/Slim/CorsSlim.php(117): Slim\Middleware\MethodOverride-&gt;call()</div><div>#8 /var/www/spicecrm_package_proxy/Slim/Middleware/PrettyExceptions.php(67): CorsSlim\CorsSlim-&gt;call()</div><div>#9 /var/www/spicecrm_package_proxy/Slim/Slim.php(1302): Slim\Middleware\PrettyExceptions-&gt;call()</div><div>#10 /var/www/spicecrm_package_proxy/index.php(62): Slim\Slim-&gt;run()</div><div>#11 {main}</pre></body></html>. URL: https://packages.spicecrm.io/releaseconfig. Please check call parameters!
Wed Jan 2 23:44:03 2019 [31561][-none-][FATAL] Exception in Controller: REST Call error somewhere… Action aborted

I am also seeing lots of these in my apache error logs:
Wed Jan 2 23:45:02 2019 [31721][-none-][ERROR] Unable to load custom logic file: modules/SpiceACLTerritories/SpiceACLHooks.php
Wed Jan 2 23:45:02 2019 [31721][-none-][FATAL] Query Failed: SELECT id, deleted FROM WHERE (date_indexed IS NULL OR date_indexed = ‘’ OR date_indexed < date_modified) LIMIT 0,24993: MySQL error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘WHERE (date_indexed IS NULL OR date_indexed = ‘’ OR date_indexed < date_modified’ at line 1
Wed Jan 2 23:45:02 2019 [31721][-none-][ERROR] Unable to load custom logic file: modules/SpiceACLTerritories/SpiceACLHooks.php

Any thoughts on how to correct these?

I got it working
There were three key issues resolved via the below but there are still issues with KREST not loading the tabular pages such as opportunities, reports etc. Able to get the list not the tabular layouts
Territories and Dashboards module is missing from KREST
There is still the contact Component PiplContainer Missing


The directory being read in this case,’./modules/Schedulers/ScheduledTasks’, does not exist in the code base. On linux environment the code was getting stuck in the loop. Removal of this while allowed the indexing in elasticsearch to work due to which records are now visible on the list view.


The statement is checking is $GLOBALS[‘installing’] is true, when the code is not installing the CRM this value is not even set so we first need to check if the value is even set. This was causing error logs to fill in needlessly.


The same issue is repeated here.

The installation was simple, in order to get the indexing to work smoothly you needed to trigger Repair & Rebuild, configure FTS, configure UI language and configure UI settings. Even right now there are a couple of issues that are persisting on the UI

Dashboard not loading
territories are accessed in the UI but are not available in the KREST installed.

1 Like