Hi everyone,
After creation of custom module, i’ve created record on that module but there are no any records on Web GUI.
Records are seen on database.
Hello,
that sounds a bit odd.
By any chance: Is the column “deleted” set to 1 in your record?
If not, data should usually display right away.
What’s your SuiteCRM version? What’s your server environment?
Any issues in the browser console and network tab?
Are there error messages in your log files?
Does everything else work?
Hi,
column name “deleted” cannot be edited after creation of custom module.
SuiteCRM version:8.8.0, Ubuntu 24.04
Console errors:
JQMIGRATE: Migrate is installed, version 3.4.0
/legacy/cache/index.php?entryPoint=getImage&themeName=suite8&themeName=suite8&imageName=sugar-yui-sprites.png:1
Failed to load resource: the server responded with a status of 403 (Forbidden)Understand this error
/legacy/cache/index.php?entryPoint=getImage&themeName=suite8&themeName=suite8&imageName=sugar-yui-sprites.png:1 Failed to load resource: the server responded with a status of 403 (Forbidden)
Understand this error
2browser-integration.js:2 port disconnected from addon code: 2f5074e4-d43b-4c16-aae9-f70ac0084da7
(anonymous) @ browser-integration.js:2Understand this warning
sugar_grp1_jquery.js?v=mIcCi50DF9fwfSzj3Y43mg:6 JQMIGRATE: Migrate is installed, version 3.4.0
inlineEditing.js:52 Uncaught ReferenceError: action_sugar_grp1 is not definedUnderstand this error
3sugar_grp1_jquery.js?v=mIcCi50DF9fwfSzj3Y43mg:6 JQMIGRATE: Migrate is installed, version 3.4.0
sugar_grp1_jquery.js?v=mIcCi50DF9fwfSzj3Y43mg:6 JQMIGRATE: Migrate is installed, version 3.4.0
browser-integration.js:2 port disconnected from addon code: 2f5074e4-d43b-4c16-aae9-f70ac0084da7
There are still issues with your server setup.
Failed to load resource: the server responded with a status of 403
That’s what I see in a custom module, where all records are being loaded right away:
Try to re-configure your permissions:
Doublecheck your server setup:
and the compatibility matrix (SuiteCRM version:8.8.0, Ubuntu 24.04 sounds good - how about PHP, DB?)
I reconfigured permissions as documents asked and Rebooted machine after.
I will check about webserver configurations from stratch.
There are php and mariadb versions: PHP 8.4.7 (cli) (built: May 9 2025 06:54:31) (NTS)
Copyright (c) The PHP Group
Zend Engine v4.4.7, Copyright (c) Zend Technologies with Zend OPcache v8.4.7, Copyright (c), by Zend Technologies
mariadb Ver 15.1 Distrib 10.11.13-MariaDB, for debian-linux-gnu (x86_64) using EditLine wrapper
8.4 isn’t yet supported.
There are quite a few deprecated errors when using 8.4 and maybe some other issues.
Try 8.3 (and if things are still not looking right, delete the module and re-create it)
(best to restore a snapshot / backup before the module deployment, the modules can be tricky to delete).
1 Like
Dear Bastian,
I’ve downgraded php from 8.4 to 8.3 and re-created the module that related.
Restarted apache services, rebooted machine just in case.
I’m currently looking at Server Setup Checks, according to my screenshots, every subject is okay.
That is custom module I’ve deployed.
And it’s still not working?
What are the error messages in your log files?
The server setup checks aren’t check 100% - it’s just a first indicator for the environment. There can still be issues though.
ObjectUnsubscribeError has been occurred at the devtools console.
I researched this error and it says upgrade to min 8.6.0 , but current version is 8.8
How about the log files in:
/logs/prod
and
/logs/legacy
?
Dear Bastian,
Sorry for my late response. Related logs are down below;
Best Regards,
legacy$ tail -f suitecrm.log
where accounts.deleted=0 : MySQL error 1267: Illegal mix of collations (utf8mb3_general_ci,IMPLICIT) and (utf8mb3_turkish_ci,IMPLICIT) for operation ‘=’
Wed Nov 5 2025 at 11:11:09 [14789][1][FATAL] Mysqli_query failed.
Wed Nov 5 2025 at 11:11:09 [14789][1][FATAL] Query Failed: SELECT inv_inventory.id , inv_inventory.modified_user_id , inv_inventory.created_by , inv_inventory.assigned_user_id , inv_inventory.aos_product_categories_id_c , inv_inventory.aos_products_id_c , inv_inventory.account_id_c , inv_inventory.aos_contracts_id_c , inv_inventory.name , inv_inventory.date_entered , inv_inventory.date_modified , jt0.user_name modified_by_name , jt0.created_by modified_by_name_owner , ‘Users’ modified_by_name_mod , jt1.user_name created_by_name , jt1.created_by created_by_name_owner , ‘Users’ created_by_name_mod, inv_inventory.description , inv_inventory.deleted , jt2.user_name assigned_user_name , jt2.created_by assigned_user_name_owner , ‘Users’ assigned_user_name_mod, jt3.name product_category , jt4.name product , jt5.name account , jt6.name support_contract , inv_inventory.warranty_start_date , inv_inventory.warranty_end_date , inv_inventory.serial_number , inv_inventory.serial_number2 FROM inv_inventory LEFT JOIN users jt0 ON inv_inventory.modified_user_id=jt0.id AND jt0.deleted=0
AND jt0.deleted=0 LEFT JOIN users jt1 ON inv_inventory.created_by=jt1.id AND jt1.deleted=0
AND jt1.deleted=0 LEFT JOIN users jt2 ON inv_inventory.assigned_user_id=jt2.id AND jt2.deleted=0
AND jt2.deleted=0 LEFT JOIN aos_product_categories jt3 ON inv_inventory.aos_product_categories_id_c = jt3.id AND jt3.deleted=0 LEFT JOIN aos_products jt4 ON inv_inventory.aos_products_id_c = jt4.id AND jt4.deleted=0 LEFT JOIN accounts jt5 ON inv_inventory.account_id_c = jt5.id AND jt5.deleted=0 LEFT JOIN aos_contracts jt6 ON inv_inventory.aos_contracts_id_c = jt6.id AND jt6.deleted=0 where inv_inventory.deleted=0 LIMIT 0,101: MySQL error 1267: Illegal mix of collations (utf8mb3_turkish_ci,IMPLICIT) and (utf8mb3_general_ci,IMPLICIT) for operation ‘=’
prod
tail -f prod.log
[2025-11-05 11:11:03] php.WARNING: Warning: require( cache/prod/ContainerAOLE7kI/getSecurity_Authentication_KernelExceptionListener_TwoFactor_MainService.php): Failed to open stream: No such file or directory {“exception”:“[object] (ErrorException(code: 0): Warning: require( cache/prod/ContainerAOLE7kI/getSecurity_Authentication_KernelExceptionListener_TwoFactor_MainService.php): Failed to open stream: No such file or directory at cache/prod/ContainerAOLE7kI/App_KernelProdContainer.php:569)”}
[2025-11-05 11:11:03] php.CRITICAL: Uncaught Error: Failed opening required ’ cache/prod/ContainerAOLE7kI/getSecurity_Authentication_KernelExceptionListener_TwoFactor_MainService.php’ (include_path=’ public/legacy/include/…:.:/usr/share/php’) {“exception”:“[object] (Error(code: 0): Failed opening required ’ cache/prod/ContainerAOLE7kI/getSecurity_Authentication_KernelExceptionListener_TwoFactor_MainService.php’ (include_path=’ public/legacy/include/…:.:/usr/share/php’) at cache/prod/ContainerAOLE7kI/App_KernelProdContainer.php:569)”}
[2025-11-05 11:11:04] php.WARNING: Warning: require( cache/prod/ContainerAOLE7kI/get_Security_RequestMatcher_KLbKLHaService.php): Failed to open stream: No such file or directory {“exception”:“[object] (ErrorException(code: 0): Warning: require( cache/prod/ContainerAOLE7kI/get_Security_RequestMatcher_KLbKLHaService.php): Failed to open stream: No such file or directory at cache/prod/ContainerAOLE7kI/App_KernelProdContainer.php:569)”}
[2025-11-05 11:11:04] php.WARNING: Warning: require( cache/prod/ContainerAOLE7kI/getSecurity_Authentication_KernelExceptionListener_TwoFactor_MainService.php): Failed to open stream: No such file or directory {“exception”:“[object] (ErrorException(code: 0): Warning: require( cache/prod/ContainerAOLE7kI/getSecurity_Authentication_KernelExceptionListener_TwoFactor_MainService.php): Failed to open stream: No such file or directory at cache/prod/ContainerAOLE7kI/App_KernelProdContainer.php:569)”}
[2025-11-05 11:11:04] php.CRITICAL: Uncaught Error: Failed opening required ’ cache/prod/ContainerAOLE7kI/getSecurity_Authentication_KernelExceptionListener_TwoFactor_MainService.php’ (include_path=’ public/legacy/include/…:.:/usr/share/php’) {“exception”:“[object] (Error(code: 0): Failed opening required ’ cache/prod/ContainerAOLE7kI/getSecurity_Authentication_KernelExceptionListener_TwoFactor_MainService.php’ (include_path=’ public/legacy/include/…:.:/usr/share/php’) at cache/prod/ContainerAOLE7kI/App_KernelProdContainer.php:569)”}
[2025-11-05 11:11:04] php.WARNING: Warning: require( cache/prod/ContainerAOLE7kI/getSecurity_Authentication_KernelExceptionListener_TwoFactor_MainService.php): Failed to open stream: No such file or directory {“exception”:“[object] (ErrorException(code: 0): Warning: require( cache/prod/ContainerAOLE7kI/getSecurity_Authentication_KernelExceptionListener_TwoFactor_MainService.php): Failed to open stream: No such file or directory at cache/prod/ContainerAOLE7kI/App_KernelProdContainer.php:569)”}
[2025-11-05 11:11:04] php.CRITICAL: Uncaught Error: Failed opening required ’ cache/prod/ContainerAOLE7kI/getSecurity_Authentication_KernelExceptionListener_TwoFactor_MainService.php’ (include_path=’ public/legacy/include/…:.:/usr/share/php’) {“exception”:“[object] (Error(code: 0): Failed opening required ’ cache/prod/ContainerAOLE7kI/getSecurity_Authentication_KernelExceptionListener_TwoFactor_MainService.php’ (include_path=’ public/legacy/include/…:.:/usr/share/php’) at cache/prod/ContainerAOLE7kI/App_KernelProdContainer.php:569)”}
[2025-11-05 11:12:01] php.WARNING: Notice: SessionHandler::gc(): ps_files_cleanup_dir: opendir(/var/lib/php/sessions) failed: Permission denied (13) {“exception”:“[object] (ErrorException(code: 0): Notice: SessionHandler::gc(): ps_files_cleanup_dir: opendir(/var/lib/php/sessions) failed: Permission denied (13) at vendor/symfony/http-foundation/Session/Storage/Handler/StrictSessionHandler.php:87)”}
[2025-11-05 11:32:23] php.WARNING: Notice: SessionHandler::gc(): ps_files_cleanup_dir: opendir(/var/lib/php/sessions) failed: Permission denied (13) {“exception”:“[object] (ErrorException(code: 0): Notice: SessionHandler::gc(): ps_files_cleanup_dir: opendir(/var/lib/php/sessions) failed: Permission denied (13) at vendor/symfony/http-foundation/Session/Storage/Handler/StrictSessionHandler.php:87)”}
[2025-11-05 11:34:25] php.WARNING: Notice: SessionHandler::gc(): ps_files_cleanup_dir: opendir(/var/lib/php/sessions) failed: Permission denied (13) {“exception”:“[object] (ErrorException(code: 0): Notice: SessionHandler::gc(): ps_files_cleanup_dir: opendir(/var/lib/php/sessions) failed: Permission denied (13) at vendor/symfony/http-foundation/Session/Storage/Handler/StrictSessionHandler.php:87)”}
Ok.
You can ignore the warnings about the sessions for now.
Focus on the
Illegal mix of collations (utf8mb3_general_ci,IMPLICIT) and (utf8mb3_turkish_ci,IMPLICIT)
Likely an AI can help with suggestions here.
Warning: require( cache/prod/ContainerAOLE7kI/getSecurity_Authentication_KernelExceptionListener_TwoFactor_MainService.php): Failed to open stream: No such file or directory
This is likely about the permissions.
Make sure to correct these:
Dear Bastian,
Thank you for your support.
I’ve marked your answer as a solution.
Glad that it worked out 