Hi, I am showing a custom dashboard file in suitecrm using entrypoint_registry.php.
In that file , I have used full calendar , it works well. In that calendar, based on users, I set a url in localhost. if I click the url I face an error like,
"Bad data passed in; Return to Home". How to solve this.
When I check the Suitecrm Error Log file : I got this meesage:
Tue Apr 10 21:07:59 2018 [11863][-none-][DEBUG] current_language is: en_us
Tue Apr 10 21:07:59 2018 [11863][-none-][DEBUG] Found cache backend SugarCacheRedis
Tue Apr 10 21:07:59 2018 [11863][-none-][DEBUG] Found cache backend SugarCacheMemory
Tue Apr 10 21:07:59 2018 [11863][-none-][DEBUG] Using cache backend SugarCacheMemory, since 999 is less than 1000
Tue Apr 10 21:07:59 2018 [11863][-none-][DEBUG] Found cache backend SugarCacheWincache
Tue Apr 10 21:07:59 2018 [11863][-none-][DEBUG] Found cache backend SugarCacheFile
Tue Apr 10 21:07:59 2018 [11863][-none-][DEBUG] Found cache backend SugarCacheAPC
Tue Apr 10 21:07:59 2018 [11863][-none-][DEBUG] Found cache backend SugarCacheZend
Tue Apr 10 21:07:59 2018 [11863][-none-][DEBUG] Found cache backend SugarCachesMash
Tue Apr 10 21:07:59 2018 [11863][-none-][DEBUG] Found cache backend SugarCacheMemcached
Tue Apr 10 21:07:59 2018 [11863][-none-][DEBUG] Found cache backend SugarCacheMemcache
Tue Apr 10 21:07:59 2018 [11863][-none-][INFO] Found language file: en_us.lang.php
Tue Apr 10 21:07:59 2018 [11863][-none-][INFO] Found extended language file: en_us.lang.ext.php
Tue Apr 10 21:07:59 2018 [11863][-none-][INFO] Found custom language file: en_us.lang.php
Tue Apr 10 21:07:59 2018 [11863][-none-][FATAL] Configuration variable date.timezone is not set, guessed timezone Asia/Colombo. Please set date.timezone="Asia/Colombo" in php.ini!
Tue Apr 10 21:07:59 2018 [11863][-none-][INFO] Query:SELECT id, name, symbol, conversion_rate FROM currencies WHERE status = 'Active' and deleted = 0
Tue Apr 10 21:07:59 2018 [11863][-none-][INFO] Query Execution Time:0.00043392181396484
Tue Apr 10 21:07:59 2018 [11863][-none-][DEBUG] rebuilding cache for Users
Tue Apr 10 21:07:59 2018 [11863][-none-][INFO] Query:SELECT * FROM fields_meta_data WHERE custom_module='Users' AND deleted = 0
Tue Apr 10 21:07:59 2018 [11863][-none-][INFO] Query Execution Time:0.00042295455932617
Tue Apr 10 21:07:59 2018 [11863][-none-][DEBUG] rebuilding cache for Employees
Tue Apr 10 21:07:59 2018 [11863][-none-][INFO] Query:SELECT * FROM fields_meta_data WHERE custom_module='Employees' AND deleted = 0
Tue Apr 10 21:07:59 2018 [11863][-none-][INFO] Query Execution Time:0.00037002563476562
Tue Apr 10 21:07:59 2018 [11863][-none-][DEBUG] rebuilding cache for EmailAddresses
Tue Apr 10 21:07:59 2018 [11863][-none-][INFO] Query:SELECT * FROM fields_meta_data WHERE custom_module='EmailAddresses' AND deleted = 0
Tue Apr 10 21:07:59 2018 [11863][-none-][INFO] Query Execution Time:0.00046896934509277
Tue Apr 10 21:07:59 2018 [11863][-none-][DEBUG] rebuilding cache for UserPreferences
Tue Apr 10 21:07:59 2018 [11863][-none-][INFO] Query:SELECT * FROM fields_meta_data WHERE custom_module='UserPreferences' AND deleted = 0
Tue Apr 10 21:07:59 2018 [11863][-none-][INFO] Query Execution Time:0.00048494338989258
Tue Apr 10 21:07:59 2018 [11863][-none-][DEBUG] rebuilding cache for Administration
Tue Apr 10 21:07:59 2018 [11863][-none-][INFO] Query:SELECT * FROM fields_meta_data WHERE custom_module='Administration' AND deleted = 0
Tue Apr 10 21:07:59 2018 [11863][-none-][INFO] Query Execution Time:0.00046801567077637
Tue Apr 10 21:07:59 2018 [11863][-none-][INFO] Query:SELECT category, name, value FROM config
Tue Apr 10 21:07:59 2018 [11863][-none-][INFO] Query Execution Time:0.00050902366638184
Tue Apr 10 21:07:59 2018 [11863][-none-][INFO] Query:SELECT id FROM outbound_email WHERE type = 'system'
Tue Apr 10 21:07:59 2018 [11863][-none-][INFO] Query Execution Time:0.00032496452331543
Tue Apr 10 21:07:59 2018 [11863][-none-][INFO] Query:SELECT * FROM outbound_email WHERE id = 'c6c95c29-b0f0-a472-c003-5a0d85e41b51'
Tue Apr 10 21:07:59 2018 [11863][-none-][INFO] Query Execution Time:0.00035786628723145
Tue Apr 10 21:07:59 2018 [11863][-none-][DEBUG] Hook called: ::after_entry_point
Tue Apr 10 21:07:59 2018 [11863][-none-][DEBUG] Including module specific hook file for custom/modules
Tue Apr 10 21:07:59 2018 [11863][-none-][DEBUG] Including Ext hook file for custom/application
Tue Apr 10 21:07:59 2018 [11863][-none-][DEBUG] Hook called: ::after_session_start
Tue Apr 10 21:07:59 2018 [11863][-none-][DEBUG] We have an authenticated user id: 5791e31d-1551-40cd-de54-5a718bef1f13
Tue Apr 10 21:07:59 2018 [11863][-none-][DEBUG] Hook called: Users::before_retrieve
Tue Apr 10 21:07:59 2018 [11863][-none-][DEBUG] Including module specific hook file for custom/modules/Users
Tue Apr 10 21:07:59 2018 [11863][-none-][DEBUG] Retrieve User : SELECT users.* FROM users WHERE users.id = '5791e31d-1551-40cd-de54-5a718bef1f13' AND users.deleted=0
Tue Apr 10 21:07:59 2018 [11863][-none-][DEBUG] Limit Query:SELECT users.* FROM users WHERE users.id = '5791e31d-1551-40cd-de54-5a718bef1f13' AND users.deleted=0 Start: 0 count: 1
Tue Apr 10 21:07:59 2018 [11863][-none-][INFO] Query:SELECT users.* FROM users WHERE users.id = '5791e31d-1551-40cd-de54-5a718bef1f13' AND users.deleted=0 LIMIT 0,1
Tue Apr 10 21:07:59 2018 [11863][-none-][INFO] Query Execution Time:0.00046491622924805
Tue Apr 10 21:07:59 2018 [11863][5791e31d-1551-40cd-de54-5a718bef1f13][DEBUG] get_user_array query: SELECT id, first_name, last_name, user_name FROM users WHERE 1=1 ORDER BY first_name, last_name ASC
Tue Apr 10 21:07:59 2018 [11863][5791e31d-1551-40cd-de54-5a718bef1f13][INFO] Query:SELECT id, first_name, last_name, user_name FROM users WHERE 1=1 ORDER BY first_name, last_name ASC
Tue Apr 10 21:07:59 2018 [11863][5791e31d-1551-40cd-de54-5a718bef1f13][INFO] Query Execution Time:0.00055408477783203
Tue Apr 10 21:07:59 2018 [11863][5791e31d-1551-40cd-de54-5a718bef1f13][INFO] Query:SELECT u1.first_name, u1.last_name from users u1, users u2 where u1.id = u2.reports_to_id AND u2.id = '5791e31d-1551-40cd-de54-5a718bef1f13' and u1.deleted=0
Tue Apr 10 21:07:59 2018 [11863][5791e31d-1551-40cd-de54-5a718bef1f13][INFO] Query Execution Time:0.00040698051452637
Tue Apr 10 21:07:59 2018 [11863][5791e31d-1551-40cd-de54-5a718bef1f13][INFO] Query:SELECT ea.email_address, ea.email_address_caps, ea.invalid_email, ea.opt_out, ea.date_created, ea.date_modified,
ear.id, ear.email_address_id, ear.bean_id, ear.bean_module, ear.primary_address, ear.reply_to_address, ear.deleted
FROM email_addresses ea LEFT JOIN email_addr_bean_rel ear ON ea.id = ear.email_address_id
WHERE ear.bean_module = 'Users'
AND ear.bean_id = '5791e31d-1551-40cd-de54-5a718bef1f13'
AND ear.deleted = 0
ORDER BY ear.reply_to_address, ear.primary_address DESC
Tue Apr 10 21:07:59 2018 [11863][5791e31d-1551-40cd-de54-5a718bef1f13][INFO] Query Execution Time:0.00066590309143066
Tue Apr 10 21:07:59 2018 [11863][5791e31d-1551-40cd-de54-5a718bef1f13][DEBUG] Hook called: Users::after_retrieve
Tue Apr 10 21:07:59 2018 [11863][5791e31d-1551-40cd-de54-5a718bef1f13][DEBUG] Current user is: ado
Tue Apr 10 21:07:59 2018 [11863][5791e31d-1551-40cd-de54-5a718bef1f13][DEBUG] Current user is: ado
Tue Apr 10 21:07:59 2018 [11863][5791e31d-1551-40cd-de54-5a718bef1f13][DEBUG] setting cookie ck_login_id_20 to 5791e31d-1551-40cd-de54-5a718bef1f13
Tue Apr 10 21:07:59 2018 [11863][5791e31d-1551-40cd-de54-5a718bef1f13][DEBUG] setting cookie ck_login_language_20 to en_us
Tue Apr 10 21:07:59 2018 [11863][5791e31d-1551-40cd-de54-5a718bef1f13][DEBUG] current_language is: en_us
Tue Apr 10 21:07:59 2018 [11863][5791e31d-1551-40cd-de54-5a718bef1f13][INFO] Found language file: en_us.lang.php
Tue Apr 10 21:07:59 2018 [11863][5791e31d-1551-40cd-de54-5a718bef1f13][INFO] Found extended language file: en_us.lang.ext.php
Tue Apr 10 21:07:59 2018 [11863][5791e31d-1551-40cd-de54-5a718bef1f13][INFO] Found custom language file: en_us.lang.php
Tue Apr 10 21:07:59 2018 [11863][5791e31d-1551-40cd-de54-5a718bef1f13][DEBUG] rebuilding cache for Alerts
Tue Apr 10 21:07:59 2018 [11863][5791e31d-1551-40cd-de54-5a718bef1f13][INFO] Query:SELECT * FROM fields_meta_data WHERE custom_module='Alerts' AND deleted = 0
Tue Apr 10 21:07:59 2018 [11863][5791e31d-1551-40cd-de54-5a718bef1f13][INFO] Query Execution Time:0.00047397613525391
Tue Apr 10 21:07:59 2018 [11863][5791e31d-1551-40cd-de54-5a718bef1f13][DEBUG] Performing action: action_get MODULE: Alerts
Tue Apr 10 21:07:59 2018 [11863][5791e31d-1551-40cd-de54-5a718bef1f13][DEBUG] get_full_list: order_by = 'alerts.date_entered' and where = 'alerts.assigned_user_id = '5791e31d-1551-40cd-de54-5a718bef1f13' AND is_read != '1''
Tue Apr 10 21:07:59 2018 [11863][5791e31d-1551-40cd-de54-5a718bef1f13][DEBUG] SugarBean[Alert].load_relationships, Loading relationship (modified_user_link).
Tue Apr 10 21:07:59 2018 [11863][5791e31d-1551-40cd-de54-5a718bef1f13][DEBUG] SugarBean[Alert].load_relationships, Loading relationship (created_by_link).
Tue Apr 10 21:07:59 2018 [11863][5791e31d-1551-40cd-de54-5a718bef1f13][DEBUG] SugarBean[Alert].load_relationships, Loading relationship (assigned_user_link).
Tue Apr 10 21:07:59 2018 [11863][5791e31d-1551-40cd-de54-5a718bef1f13][DEBUG] process_order_by: (alerts.date_entered) does not have a vardef entry.
Tue Apr 10 21:07:59 2018 [11863][5791e31d-1551-40cd-de54-5a718bef1f13][DEBUG] process_full_list_query: query is SELECT alerts.* , 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 , jt2.user_name assigned_user_name , jt2.created_by assigned_user_name_owner , 'Users' assigned_user_name_mod FROM alerts LEFT JOIN users jt0 ON alerts.modified_user_id=jt0.id AND jt0.deleted=0
AND jt0.deleted=0 LEFT JOIN users jt1 ON alerts.created_by=jt1.id AND jt1.deleted=0
AND jt1.deleted=0 LEFT JOIN users jt2 ON alerts.assigned_user_id=jt2.id AND jt2.deleted=0
AND jt2.deleted=0 where (alerts.assigned_user_id = '5791e31d-1551-40cd-de54-5a718bef1f13' AND is_read != '1') AND alerts.deleted=0
Tue Apr 10 21:07:59 2018 [11863][5791e31d-1551-40cd-de54-5a718bef1f13][INFO] Query: SELECT alerts.* , 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 , jt2.user_name assigned_user_name , jt2.created_by assigned_user_name_owner , 'Users' assigned_user_name_mod FROM alerts LEFT JOIN users jt0 ON alerts.modified_user_id=jt0.id AND jt0.deleted=0
AND jt0.deleted=0 LEFT JOIN users jt1 ON alerts.created_by=jt1.id AND jt1.deleted=0
AND jt1.deleted=0 LEFT JOIN users jt2 ON alerts.assigned_user_id=jt2.id AND jt2.deleted=0
AND jt2.deleted=0 where (alerts.assigned_user_id = '5791e31d-1551-40cd-de54-5a718bef1f13' AND is_read != '1') AND alerts.deleted=0
Tue Apr 10 21:07:59 2018 [11863][5791e31d-1551-40cd-de54-5a718bef1f13][INFO] Query Execution Time:0.00059914588928223
Tue Apr 10 21:07:59 2018 [11863][5791e31d-1551-40cd-de54-5a718bef1f13][DEBUG] process_full_list_query: result is mysqli_result Object
(
[current_field] => 0
[field_count] => 22
[lengths] =>
[num_rows] => 0
[type] => 0
)
Tue Apr 10 21:07:59 2018 [11863][5791e31d-1551-40cd-de54-5a718bef1f13][DEBUG] Hook called: ::server_round_trip
Tue Apr 10 21:07:59 2018 [11863][5791e31d-1551-40cd-de54-5a718bef1f13][DEBUG] Calling MySQLi::disconnect()