Error with widget customization

parijke · 13 March 2020 06:48

Does anyone know how to solve this?

When I try to change the Invoice widget I get an error:
error

There was an error handling this request.

This is the log:
Fri Mar 13 06:43:55 2020 [1268][-none-][DEBUG] current_language is: nl_NL
Fri Mar 13 06:43:55 2020 [1268][-none-][DEBUG] Found cache backend SugarCacheMemcache
Fri Mar 13 06:43:55 2020 [1268][-none-][DEBUG] Found cache backend SugarCachesMash
Fri Mar 13 06:43:55 2020 [1268][-none-][DEBUG] Found cache backend SugarCacheMemcached
Fri Mar 13 06:43:55 2020 [1268][-none-][DEBUG] Using cache backend SugarCacheMemcached, since 900 is less than 1000
Fri Mar 13 06:43:55 2020 [1268][-none-][DEBUG] Found cache backend SugarCacheAPC
Fri Mar 13 06:43:55 2020 [1268][-none-][DEBUG] Found cache backend SugarCacheRedis
Fri Mar 13 06:43:55 2020 [1268][-none-][DEBUG] Found cache backend SugarCacheFile
Fri Mar 13 06:43:55 2020 [1268][-none-][DEBUG] Found cache backend SugarCacheMemory
Fri Mar 13 06:43:55 2020 [1268][-none-][DEBUG] Found cache backend SugarCacheZend
Fri Mar 13 06:43:55 2020 [1268][-none-][DEBUG] Found cache backend SugarCacheWincache
Fri Mar 13 06:43:55 2020 [1268][-none-][INFO] Found language file: en_us.lang.php
Fri Mar 13 06:43:55 2020 [1268][-none-][INFO] Found extended language file: en_us.lang.ext.php
Fri Mar 13 06:43:55 2020 [1268][-none-][INFO] Found custom language file: en_us.lang.php
Fri Mar 13 06:43:55 2020 [1268][-none-][INFO] Found language file: nl_NL.lang.php
Fri Mar 13 06:43:55 2020 [1268][-none-][INFO] Found extended language file: nl_NL.lang.ext.php
Fri Mar 13 06:43:55 2020 [1268][-none-][INFO] Found custom language file: nl_NL.lang.php
Fri Mar 13 06:43:55 2020 [1268][-none-][INFO] Query:SELECT id, name, symbol, conversion_rate FROM currencies WHERE status = ‘Active’ and deleted = 0
Fri Mar 13 06:43:55 2020 [1268][-none-][INFO] Query Execution Time:0.00051212310791016
Fri Mar 13 06:43:55 2020 [1268][-none-][DEBUG] rebuilding cache for Users
Fri Mar 13 06:43:55 2020 [1268][-none-][INFO] Query:SELECT * FROM fields_meta_data WHERE custom_module=‘Users’ AND deleted = 0
Fri Mar 13 06:43:55 2020 [1268][-none-][INFO] Query Execution Time:0.0005650520324707
Fri Mar 13 06:43:55 2020 [1268][-none-][DEBUG] rebuilding cache for Employees
Fri Mar 13 06:43:55 2020 [1268][-none-][INFO] Query:SELECT * FROM fields_meta_data WHERE custom_module=‘Employees’ AND deleted = 0
Fri Mar 13 06:43:55 2020 [1268][-none-][INFO] Query Execution Time:0.00040793418884277
Fri Mar 13 06:43:55 2020 [1268][-none-][DEBUG] rebuilding cache for EmailAddresses
Fri Mar 13 06:43:55 2020 [1268][-none-][INFO] Query:SELECT * FROM fields_meta_data WHERE custom_module=‘EmailAddresses’ AND deleted = 0
Fri Mar 13 06:43:55 2020 [1268][-none-][INFO] Query Execution Time:0.00057387351989746
Fri Mar 13 06:43:55 2020 [1268][-none-][DEBUG] rebuilding cache for UserPreferences
Fri Mar 13 06:43:55 2020 [1268][-none-][INFO] Query:SELECT * FROM fields_meta_data WHERE custom_module=‘UserPreferences’ AND deleted = 0
Fri Mar 13 06:43:55 2020 [1268][-none-][INFO] Query Execution Time:0.00020384788513184
Fri Mar 13 06:43:55 2020 [1268][-none-][DEBUG] rebuilding cache for Administration
Fri Mar 13 06:43:55 2020 [1268][-none-][INFO] Query:SELECT * FROM fields_meta_data WHERE custom_module=‘Administration’ AND deleted = 0
Fri Mar 13 06:43:55 2020 [1268][-none-][INFO] Query Execution Time:0.0003361701965332
Fri Mar 13 06:43:55 2020 [1268][-none-][INFO] Query:SELECT category, name, value FROM config
Fri Mar 13 06:43:55 2020 [1268][-none-][INFO] Query Execution Time:0.00028300285339355
Fri Mar 13 06:43:55 2020 [1268][-none-][INFO] Query:SELECT id FROM outbound_email WHERE type = ‘system’
Fri Mar 13 06:43:55 2020 [1268][-none-][INFO] Query Execution Time:0.00022006034851074
Fri Mar 13 06:43:55 2020 [1268][-none-][INFO] Query:SELECT * FROM outbound_email WHERE id = ‘f32f2960-e7f7-c4ff-6cf0-5e1c7d633843’
Fri Mar 13 06:43:55 2020 [1268][-none-][INFO] Query Execution Time:0.00014996528625488
Fri Mar 13 06:43:55 2020 [1268][-none-][DEBUG] Hook called: ::after_entry_point
Fri Mar 13 06:43:55 2020 [1268][-none-][DEBUG] Including module specific hook file for custom/modules
Fri Mar 13 06:43:55 2020 [1268][-none-][DEBUG] Including Ext hook file for custom/application
Fri Mar 13 06:43:55 2020 [1268][-none-][DEBUG] Hook called: ::after_session_start
Fri Mar 13 06:43:55 2020 [1268][-none-][DEBUG] Unable to find SugarController:: DynamicAction
Fri Mar 13 06:43:55 2020 [1268][-none-][DEBUG] We have an authenticated user id: 1
Fri Mar 13 06:43:55 2020 [1268][-none-][DEBUG] Hook called: Users::before_retrieve
Fri Mar 13 06:43:55 2020 [1268][-none-][DEBUG] Including module specific hook file for custom/modules/Users
Fri Mar 13 06:43:55 2020 [1268][-none-][DEBUG] Retrieve User : SELECT users.* FROM users WHERE users.id = ‘1’ AND users.deleted=0
Fri Mar 13 06:43:55 2020 [1268][-none-][DEBUG] Limit Query:SELECT users.* FROM users WHERE users.id = ‘1’ AND users.deleted=0 Start: 0 count: 1
Fri Mar 13 06:43:55 2020 [1268][-none-][INFO] Query:SELECT users.* FROM users WHERE users.id = ‘1’ AND users.deleted=0 LIMIT 0,1
Fri Mar 13 06:43:55 2020 [1268][-none-][INFO] Query Execution Time:0.00038409233093262
Fri Mar 13 06:43:55 2020 [1268][1][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
Fri Mar 13 06:43:55 2020 [1268][1][INFO] Query:SELECT id, first_name, last_name, user_name FROM users WHERE 1=1 ORDER BY first_name, last_name ASC
Fri Mar 13 06:43:55 2020 [1268][1][INFO] Query Execution Time:0.00030016899108887
Fri Mar 13 06:43:55 2020 [1268][1][INFO] Query:SELECT u1.first_name, u1.last_name from users u1, users u2 where u1.id = u2.reports_to_id AND u2.id = ‘1’ and u1.deleted=0
Fri Mar 13 06:43:55 2020 [1268][1][INFO] Query Execution Time:0.00020599365234375
Fri Mar 13 06:43:55 2020 [1268][1][DEBUG] SugarBean[User].load_relationships, Loading relationship (reports_to_link).
Fri Mar 13 06:43:55 2020 [1268][1][INFO] Query:SELECT
ea.email_address,
ea.email_address_caps,
ea.invalid_email,
ea.opt_out,
ea.confirm_opt_in,
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 = ‘1’
AND ear.deleted = 0
ORDER BY ear.reply_to_address, ear.primary_address DESC
Fri Mar 13 06:43:55 2020 [1268][1][INFO] Query Execution Time:0.00030016899108887
Fri Mar 13 06:43:55 2020 [1268][1][DEBUG] Hook called: Users::after_retrieve
Fri Mar 13 06:43:55 2020 [1268][1][DEBUG] FACTOR AUTH: -------------------------------------------------------------
Fri Mar 13 06:43:55 2020 [1268][1][DEBUG] FACTOR AUTH: --------------------- CHECK FACTOR AUtH ---------------------
Fri Mar 13 06:43:55 2020 [1268][1][DEBUG] FACTOR AUTH: -------------------------------------------------------------
Fri Mar 13 06:43:55 2020 [1268][1][DEBUG] FACTOR AUTH: User needs factor auth, request is not Logout
Fri Mar 13 06:43:55 2020 [1268][1][DEBUG] FACTOR AUTH: User does`nt need factor auth
Fri Mar 13 06:43:55 2020 [1268][1][DEBUG] Current user is: Paul Rijke
Fri Mar 13 06:43:55 2020 [1268][1][DEBUG] Current user is: Paul Rijke
Fri Mar 13 06:43:55 2020 [1268][1][DEBUG] setting cookie ck_login_id_20 to 1
Fri Mar 13 06:43:55 2020 [1268][1][DEBUG] setting cookie ck_login_language_20 to nl_NL
Fri Mar 13 06:43:55 2020 [1268][1][DEBUG] current_language is: nl_NL
Fri Mar 13 06:43:55 2020 [1268][1][INFO] Found language file: en_us.lang.php
Fri Mar 13 06:43:55 2020 [1268][1][INFO] Found language file: nl_NL.lang.php
Fri Mar 13 06:43:55 2020 [1268][1][INFO] Found extended language file: en_us.lang.ext.php
Fri Mar 13 06:43:55 2020 [1268][1][INFO] Found custom language file: en_us.lang.php
Fri Mar 13 06:43:55 2020 [1268][1][INFO] Found extended language file: nl_NL.lang.ext.php
Fri Mar 13 06:43:55 2020 [1268][1][INFO] Found custom language file: nl_NL.lang.php
Fri Mar 13 06:43:55 2020 [1268][1][DEBUG] Module:Home using file: DynamicAction
Fri Mar 13 06:43:55 2020 [1268][1][DEPRECATED] Array
(
)

Fri Mar 13 06:43:55 2020 [1268][1][DEBUG] rebuilding cache for AOS_Invoices
Fri Mar 13 06:43:55 2020 [1268][1][INFO] Query:SELECT * FROM fields_meta_data WHERE custom_module=‘AOS_Invoices’ AND deleted = 0
Fri Mar 13 06:43:55 2020 [1268][1][INFO] Query Execution Time:0.00040197372436523
Fri Mar 13 06:43:55 2020 [1268][1][DEBUG] rebuilding cache for Accounts
Fri Mar 13 06:43:55 2020 [1268][1][INFO] Query:SELECT * FROM fields_meta_data WHERE custom_module=‘Accounts’ AND deleted = 0
Fri Mar 13 06:43:55 2020 [1268][1][INFO] Query Execution Time:0.00024700164794922
Fri Mar 13 06:43:55 2020 [1268][1][INFO] Query:SELECT
id,
title
FROM accounts
WHERE deleted = 0
ORDER BY title ASC
Fri Mar 13 06:43:55 2020 [1268][1][DEBUG] Mysqli_query failed, error was: MySQL error 1054: Unknown column ‘title’ in ‘field list’, query was:
Fri Mar 13 06:43:55 2020 [1268][1][FATAL] Mysqli_query failed.
Fri Mar 13 06:43:55 2020 [1268][1][INFO] Query Execution Time:0.00035905838012695
Fri Mar 13 06:43:55 2020 [1268][1][FATAL] Query Failed: SELECT
id,
title
FROM accounts
WHERE deleted = 0
ORDER BY title ASC: MySQL error 1054: Unknown column ‘title’ in ‘field list’
Fri Mar 13 06:43:55 2020 [1268][1][DEBUG] get_user_array query: SELECT id, first_name, last_name, user_name from users WHERE status=‘Active’ AND portal_only=0 ORDER BY first_name, last_name ASC
Fri Mar 13 06:43:55 2020 [1268][1][INFO] Query:SELECT id, first_name, last_name, user_name from users WHERE status=‘Active’ AND portal_only=0 ORDER BY first_name, last_name ASC
Fri Mar 13 06:43:55 2020 [1268][1][INFO] Query Execution Time:0.0002288818359375
Fri Mar 13 06:43:55 2020 [1268][1][DEBUG] Hook called: Home::after_ui_frame
Fri Mar 13 06:43:55 2020 [1268][1][DEBUG] Creating new instance of hook class hooks without parameters
Fri Mar 13 06:43:55 2020 [1268][1][DEBUG] Creating new instance of hook class AssignGroups without parameters
Fri Mar 13 06:43:55 2020 [1268][1][DEBUG] Hook called: ::after_ui_footer
Fri Mar 13 06:43:55 2020 [1268][1][DEBUG] Creating new instance of hook class AssignGroups without parameters
Fri Mar 13 06:43:55 2020 [1268][1][DEBUG] Hook called: ::server_round_trip
Fri Mar 13 06:43:55 2020 [1268][1][DEBUG] Calling MySQLi::disconnect()

Also this in the javascript console
MySugar.js?v=8Iur8mHIFOHYyuWLiKw4GA:50 Uncaught ReferenceError: newTop is not defined
at Object.fillInConfigureDiv (MySugar.js?v=8Iur8mHIFOHYyuWLiKw4GA:50)
at Object.handleTransactionResponse (sugar_grp1_yui.js?v=SgnFFJPooyBx68QIfQI8vw:109)
at sugar_grp1_yui.js?v=SgnFFJPooyBx68QIfQI8vw:109
index.php:1 Failed to load resource: the server responded with a status of 403 ()
MySugar.js?v=8Iur8mHIFOHYyuWLiKw4GA:50 Uncaught ReferenceError: newTop is not defined
at Object.fillInConfigureDiv (MySugar.js?v=8Iur8mHIFOHYyuWLiKw4GA:50)
at Object.handleTransactionResponse (sugar_grp1_yui.js?v=SgnFFJPooyBx68QIfQI8vw:109)
at sugar_grp1_yui.js?v=SgnFFJPooyBx68QIfQI8vw:109

dhaivatnaik · 13 March 2020 08:41

I would suggest you to set the set the Log Level to Fatal as the debug should be used when you want to trace out the issue, or the flow of execution. The production instance should be fatal in most of the case.

Admin → System Settings → Logger Settings

In regards to javascript console MySugar.js Try to perform below
Admin → Repair →
Repair JS Files
Rebuild JS Compressed Files
Rebuild JS Grouping Files

Clear the browser cache and try

parijke · 13 March 2020 09:01

I did, unfortunately with the same result

blqt · 13 March 2020 09:56

There is no title field in Accounts. Only in Contacts and Leads.

parijke · 13 March 2020 10:24

So, how is this possible and how to fix this?

andopes · 13 March 2020 11:40

Field title has been, somehow, added into Accounts’ metadata, probably by hand instead of through Studio.
You need to search for field “title” into custom/modules/Accounts/metadata/ in order to identify what is the buggy metadata file.
After that run Quick Repair and Rebuild from Admin -> Repair.

Regards

parijke · 13 March 2020 11:56

a grep in that folder gives me this:

paul@paul-Inspiron-3793:~/w/S/c/m/A/metadata:master$ grep -rni --include \*.php  . -e "title"
./detailviewdefs.php:14:            'customCode' => '<input type="submit" class="button hidden" disabled="disabled" title="{$APP.LBL_SEND_CONFIRM_OPT_IN_EMAIL}" onclick="this.form.return_module.value=\'Accounts\'; this.form.return_action.value=\'Accounts\'; this.form.return_id.value=\'{$fields.id.value}\'; this.form.action.value=\'sendConfirmOptInEmail\'; this.form.module.value=\'Accounts\'; this.form.module_tab.value=\'Accounts\';" name="send_confirm_opt_in_email" value="{$APP.LBL_SEND_CONFIRM_OPT_IN_EMAIL}"/>',

./detailviewdefs.php:23:                'title' => '{$APP.LBL_SEND_CONFIRM_OPT_IN_EMAIL}',

But is is a standard, non-tickered with installation.

andopes · 13 March 2020 13:38

Those “title” strings are basically html related not vardefs’ related, so not a big deal.
Eventually the “title” fields are somehow saved on user preferences. Try to reset user preferences in a copy of your production instance and try again.

Regards

parijke · 13 March 2020 14:02

Reset my user prefs… same behaviour unfortunatelly

But then I don’t think it is the issue of the title field (although strange) because when I add the field to the account table, the fatal error is gone from the logfile, but the same behaviour exists