Upgraded from 7.13 to 7.14 - Now "Case" Page Grid Won't Load

📦 Install & Upgrade Help
21

Clear the cache between every test you do, otherwise it won’t make sense

22

Yep…I have been.
Typically doing a “Quick Repair” too…and when JS is involved, rebuilding the minified JS stuff.
Not Sure if that’s overkill…but, been doing it…heh.

23

If you still have a FATAL in a tpl file, I would focus on that, and it’s really enough to just delete that file and watch it get recreated when you visit the screen. That way you don’t make your tests unnecessarily cumbersome and slow.

24

Yeah…thanks! Good advice.

I’m still getting that fatal error when adding the Created By or Modified By user fields into the filter.

Thu Sep 14 13:39:43 2023 [29032][1][FATAL] Exception handling in /var/www/html/include/MVC/Controller/SugarController.php:397
Thu Sep 14 13:39:43 2023 [29032][1][FATAL] Exception in Controller: Syntax error in template “file:/var/www/html/cache/themes/BadKarmaTheme/modules/Cases/SearchForm_advanced.tpl” on line 519 “{php}$this->_tpl_vars[‘user_options’] = get_user_array(false);{/php}” unknown tag ‘php’

I wonder if there were some changed to SuiteP theme (which is what this BadKarma theme is a copy of), that I may need to pick up? (Although, when I switch themes over to SuiteP, I still see the issue…).

25

Please share this file that is giving the error

26

Thanks for looking at this!

SearchForm_advanced.zip (4.7 KB)
(Can’t seem to upload the file without zipping)

27

Are you getting issue on other listviews as well?

28

@abuzarfaris

Damn…yes…now that you mention it…“IF” I add the ‘Created By’ to (for example) Leads page, that will kill the grid from loading as well!

Is there perhaps some ‘data’ bad in a user account somewhere??

29

Try this fix again
And delete the cache folder (not just repair and rebuild) after this

30

the “If (true)” fix?

31

Yes please try it if true fix

32

Ok…when you say Delete the cache folder…do you mean the ‘entire’ cache folder…or Just like the “Case” module cache folder??

33

You can delete the contents of the entire cache folder
The first couple of requests might be slow but no issues

34

Ok…did that.

Grid still not loading…but got a new error:

Thu Sep 14 14:54:08 2023 [30778][1][FATAL] Exception handling in /var/www/html/include/MVC/Controller/SugarController.php:397

Thu Sep 14 14:54:08 2023 [30778][1][FATAL] Exception in Controller: Unable to load template ‘file:/include/SugarFields/Fields/Multienum/EditViewFunction.tpl’ in ‘include/SugarFields/Fields/Assigned_user_name/EditViewFunction.tpl’

35

I can confirm that it’s completely broken for me too
You should report it on github as an issue

36

Ahh…I guess I’m kinda glad it’s not ‘just me’…heh.

THANK YOU for the help!!!

I’ll be honest, I’m not 100% sure how to enter an issue on GitHub appropriately.
I’ll do my best…perhaps you could look it over, and let me know how ‘poor’ it is…heh.

1 Like
37

The thing I have noticed is that adding the assigned to in the filter does not cause the issue
But created by and modified by cause issue

you can fix this issue (at least for time being)by going to
‘custom/modules/Cases/metadata/searchdefs.php’
Search in this file assigned_to and compare it with created_by

Change the created_by similar to assigned_to
And do the whole delete cache thing

38

Here is the current code:

‘assigned_user_id’ =>
array (
‘name’ => ‘assigned_user_id’,
‘type’ => ‘enum’,
‘label’ => ‘LBL_ASSIGNED_TO’,
‘function’ =>
array (
‘name’ => ‘get_user_array’,
‘params’ =>
array (
0 => false,
),
),
‘default’ => true,
‘width’ => ‘10%’,
),
‘created_by’ =>
array (
‘type’ => ‘assigned_user_name’,
‘label’ => ‘LBL_CREATED’,
‘width’ => ‘10%’,
‘default’ => true,
‘name’ => ‘created_by’,
),

Looks like the Created By is looking for the assigned_user_name rather than ID…
Would you recommend just swapping the ‘name’ for the Id???

SAMPLE??:
‘created_by’ =>
array (
‘type’ => ‘assigned_user_name’,
‘label’ => ‘LBL_CREATED’,
‘width’ => ‘10%’,
‘default’ => true,
‘name’ => ‘assigned_user_id’, // ← Here being the only change??
),

39 
‘created_by’ =>
array (
‘name’ => ‘created_by’,
‘type’ => ‘enum’,
‘label’ => ‘LBL_CREATED’,
‘function’ =>
array (
‘name’ => ‘get_user_array’,
‘params’ =>
array (
0 => false,
),
),
‘default’ => true,
‘width’ => ‘10%’,
),

This is how your created by should look like

1 Like
40

Oh…I see…the ‘whole’ thing…heh.

I’ve done so, and it DOES seem to be working now! (Filtering also works).

I guess I’ll do the same for other modules!

1 Like