If this error persists, please have your administrator disable Ajax for this module

SuiteCRM Forum - English Language SuiteCRM Feedback
1

Hi all, I start getting this message when I click on a user under contacts.

I did some research and tried doing system settings > Configure AJAX user interface > disabling contacts

After I perform this, it resolved getting “If this error persists, please have your administrator disable Ajax for this module” pop-up message but I encountered a new problem.

When I click on users under contacts, the page does not display any modules that had relationship field set to contacts.

This problem persists even after I enable Contacts under system settings.

Please help and thank you

2

Have you done any customisations?

Normally, this is caused by missing records in the fields_meta_data table or bad cache.

Can you run a Quick Repair & Rebuild in Administrator?

Can you check your sugarcrm.log or suitecrm.log to see what errors are displayed?

Thanks,

Will.

3

Will,

Thank you for the reply.

I used module builder/studio for creating/customizing modules but I have not customized any config for crm.

Mon Jul 18 18:53:10 2016 [9838][4680bd7d-7945-8494-7129-5762e6120949][FATAL] Error running count query for Contact List: Query Failed: ( SELECT count(*) c FROM rg_reserveguard INNER JOIN rg_reverseguard_contacts_c ON rg_reverseguard.id=rg_reverseguard_contacts_c.rg_reverseguard_contactsrg_reverseguard_ida AND rg_reverseguard_contacts_c.rg_reverseguard_contactscontacts_idb=‘10decda8-20e6-f8e6-0f6f-5762df180b0b’ AND rg_reverseguard_contacts_c.deleted=0

I found this error. So i changed the typo and changed the module to proper name.

However, after editting the module name, I am back to where I started.

When i click on any contacts, I get the pop-up that says “If this error persists, please have your administrator disable Ajax for this module” at the bottom of the pop-up.

Thank you so much for your help

4

Will,

I fixed the issue by recreating the module that was mentioned in the log file.

Thanks you all for your help!

5

Hi Will

I have been experiencing the same issue in Leads module.
Sometimes the detail view of a record opens properly. while other times it is all clumsy with no layout or anything(just plain text).

I did make some modifications relating to subpanel and the adding custom fields(through Studio), but I don’t know why sometimes the issue occurs while other times it does not.

Thanks

6

Instead of disabling contacts, I disabled Home. The Ajax warning stopped, but I am certain it did not fix the underlying problem.

7

Sorry to bring up an old thread, but I can’t make head or tale of the log… I’ve got the same issue, log below - Any help would be greatly appreciated

[spoiler]Tue Jun 11 13:56:06 2019 [7791][1][FATAL] Mysqli_query failed.
Tue Jun 11 13:56:06 2019 [7791][1][FATAL] Error retrieving Lead list: Query Failed: (SELECT meetings.id , meetings.assigned_user_id , meetings.name , meetings.status , ’ ’ contact_name , ’ ’ contact_id , meetings.date_modified , meetings.date_entered , meetings.date_end as date_due , jt1.user_name assigned_user_name , jt1.created_by assigned_user_name_owner , ‘Users’ assigned_user_name_mod, 0 reply_to_status , ’ ’ contact_name_owner , ’ ’ contact_name_mod , meetings.parent_id , meetings.parent_type , ’ ’ filename , meetings.recurring_source , ’ ’ assigned_user_owner , ’ ’ assigned_user_mod , meetings.created_by , ‘meetings’ panel_name, NULL date_end, NULL category_id FROM meetings LEFT JOIN meetings_cstm ON meetings.id = meetings_cstm.id_c LEFT JOIN users jt1 ON meetings.assigned_user_id=jt1.id AND jt1.deleted=0

AND jt1.deleted=0 INNER JOIN meetings_leads ON meetings.id=meetings_leads.meeting_id AND meetings_leads.lead_id=‘d616c9a5-18ff-8cfd-7fb4-5cf662a44a6f’ AND meetings_leads.deleted=0

where ((meetings.status=‘Held’ OR meetings.status=‘Not Held’)) AND meetings.deleted=0) UNION ALL ( SELECT meetings.id , meetings.assigned_user_id , meetings.name , meetings.status , ’ ’ contact_name , ’ ’ contact_id , meetings.date_modified , meetings.date_entered , meetings.date_end as date_due , jt1.user_name assigned_user_name , jt1.created_by assigned_user_name_owner , ‘Users’ assigned_user_name_mod, 0 reply_to_status , ’ ’ contact_name_owner , ’ ’ contact_name_mod , meetings.parent_id , meetings.parent_type , ’ ’ filename , meetings.recurring_source , ’ ’ assigned_user_owner , ’ ’ assigned_user_mod , meetings.created_by , ‘oldmeetings’ panel_name, NULL date_end, NULL category_id FROM meetings LEFT JOIN meetings_cstm ON meetings.id = meetings_cstm.id_c LEFT JOIN users jt1 ON meetings.assigned_user_id=jt1.id AND jt1.deleted=0

AND jt1.deleted=0 where ( meetings.parent_id = ‘d616c9a5-18ff-8cfd-7fb4-5cf662a44a6f’
AND meetings.parent_type = ‘Leads’ AND meetings.id NOT IN ( SELECT meeting_id FROM meetings_leads ) AND (meetings.status=‘Held’ OR meetings.status=‘Not Held’)) AND meetings.deleted=0 ) UNION ALL ( SELECT tasks.id , tasks.assigned_user_id , tasks.name , tasks.status , LTRIM(RTRIM(CONCAT(IFNULL(contacts.first_name,’’),’ ‘,IFNULL(contacts.last_name,’’)))) contact_name , tasks.contact_id , tasks.date_modified , tasks.date_entered , NULL date_due, jt1.user_name assigned_user_name , jt1.created_by assigned_user_name_owner , ‘Users’ assigned_user_name_mod, 0 reply_to_status , ’ ’ contact_name_owner , ’ ’ contact_name_mod , tasks.parent_id , tasks.parent_type , ’ ’ filename , NULL recurring_source, ’ ’ assigned_user_owner , ’ ’ assigned_user_mod , tasks.created_by , ‘tasks’ panel_name, tasks.date_end , NULL category_id FROM tasks LEFT JOIN contacts contacts ON tasks.contact_id=contacts.id AND contacts.deleted=0

AND contacts.deleted=0 LEFT JOIN users jt1 ON tasks.assigned_user_id=jt1.id AND jt1.deleted=0

AND jt1.deleted=0 INNER JOIN leads tasks_rel ON tasks.parent_id=tasks_rel.id AND tasks_rel.deleted=0
AND tasks.parent_type = ‘Leads’
where ( tasks.parent_id=‘d616c9a5-18ff-8cfd-7fb4-5cf662a44a6f’ AND (tasks.status=‘Completed’ OR tasks.status=‘Deferred’)) AND tasks.deleted=0 ) UNION ALL ( SELECT calls.id , calls.assigned_user_id , calls.name , calls.status , ’ ’ contact_name , ’ ’ contact_id , calls.date_modified , calls.date_entered , calls.date_end as date_due , jt1.user_name assigned_user_name , jt1.created_by assigned_user_name_owner , ‘Users’ assigned_user_name_mod, 0 reply_to_status , ’ ’ contact_name_owner , ’ ’ contact_name_mod , calls.parent_id , calls.parent_type , ’ ’ filename , calls.recurring_source , ’ ’ assigned_user_owner , ’ ’ assigned_user_mod , calls.created_by , ‘calls’ panel_name, NULL date_end, NULL category_id FROM calls LEFT JOIN users jt1 ON calls.assigned_user_id=jt1.id AND jt1.deleted=0

AND jt1.deleted=0 INNER JOIN calls_leads ON calls.id=calls_leads.call_id AND calls_leads.lead_id=‘d616c9a5-18ff-8cfd-7fb4-5cf662a44a6f’ AND calls_leads.deleted=0

where ((calls.status=‘Held’ OR calls.status=‘Not Held’)) AND calls.deleted=0 ) UNION ALL ( SELECT calls.id , calls.assigned_user_id , calls.name , calls.status , ’ ’ contact_name , ’ ’ contact_id , calls.date_modified , calls.date_entered , calls.date_end as date_due , jt1.user_name assigned_user_name , jt1.created_by assigned_user_name_owner , ‘Users’ assigned_user_name_mod, 0 reply_to_status , ’ ’ contact_name_owner , ’ ’ contact_name_mod , calls.parent_id , calls.parent_type , ’ ’ filename , calls.recurring_source , ’ ’ assigned_user_owner , ’ ’ assigned_user_mod , calls.created_by , ‘oldcalls’ panel_name, NULL date_end, NULL category_id FROM calls LEFT JOIN users jt1 ON calls.assigned_user_id=jt1.id AND jt1.deleted=0

AND jt1.deleted=0 where ( calls.parent_id = ‘d616c9a5-18ff-8cfd-7fb4-5cf662a44a6f’
AND calls.parent_type = ‘Leads’ AND calls.id NOT IN ( SELECT call_id FROM calls_leads ) AND (calls.status=‘Held’ OR calls.status=‘Not Held’)) AND calls.deleted=0 ) UNION ALL ( SELECT notes.id , notes.assigned_user_id , notes.name , ’ ’ status , LTRIM(RTRIM(CONCAT(IFNULL(contacts.first_name,’’),’ ‘,IFNULL(contacts.last_name,’’)))) contact_name , notes.contact_id , notes.date_modified , notes.date_entered , NULL date_due, jt1.user_name assigned_user_name , jt1.created_by assigned_user_name_owner , ‘Users’ assigned_user_name_mod, 0 reply_to_status , ’ ’ contact_name_owner , ’ ’ contact_name_mod , notes.parent_id , notes.parent_type , notes.filename , NULL recurring_source, ’ ’ assigned_user_owner , ’ ’ assigned_user_mod , notes.created_by , ‘notes’ panel_name, NULL date_end, NULL category_id FROM notes LEFT JOIN contacts contacts ON notes.contact_id=contacts.id AND contacts.deleted=0

AND contacts.deleted=0 LEFT JOIN users jt1 ON notes.assigned_user_id=jt1.id AND jt1.deleted=0

AND jt1.deleted=0 INNER JOIN leads notes_rel ON notes.parent_id=notes_rel.id AND notes_rel.deleted=0
AND notes.parent_type = ‘Leads’
where ( notes.parent_id=‘d616c9a5-18ff-8cfd-7fb4-5cf662a44a6f’) AND notes.deleted=0 ) UNION ALL ( SELECT emails.id , emails.assigned_user_id , emails.name , emails.status , ’ ’ contact_name , ’ ’ contact_id , emails.date_modified , emails.date_entered , NULL date_due, jt0.user_name assigned_user_name , jt0.created_by assigned_user_name_owner , ‘Users’ assigned_user_name_mod, emails.reply_to_status , ’ ’ contact_name_owner , ’ ’ contact_name_mod , emails.parent_id , emails.parent_type , ’ ’ filename , NULL recurring_source, ’ ’ assigned_user_owner , ’ ’ assigned_user_mod , emails.created_by , ‘emails’ panel_name, NULL date_end, emails.category_id FROM emails LEFT JOIN users jt0 ON emails.assigned_user_id=jt0.id AND jt0.deleted=0

AND jt0.deleted=0 INNER JOIN emails_beans ON emails.id=emails_beans.email_id AND emails_beans.bean_id=‘d616c9a5-18ff-8cfd-7fb4-5cf662a44a6f’ AND emails_beans.deleted=0
AND emails_beans.bean_module = ‘Leads’
where emails.deleted=0 ) UNION ALL ( SELECT emails.id , emails.assigned_user_id , emails.name , emails.status , ’ ’ contact_name , ’ ’ contact_id , emails.date_modified , emails.date_entered , NULL date_due, jt0.user_name assigned_user_name , jt0.created_by assigned_user_name_owner , ‘Users’ assigned_user_name_mod, emails.reply_to_status , ’ ’ contact_name_owner , ’ ’ contact_name_mod , emails.parent_id , emails.parent_type , ’ ’ filename , NULL recurring_source, ’ ’ assigned_user_owner , ’ ’ assigned_user_mod , emails.created_by , ‘linkedemails’ panel_name, NULL date_end, emails.category_id FROM emails LEFT JOIN users jt0 ON emails.assigned_user_id=jt0.id AND jt0.deleted=0

AND jt0.deleted=0 JOIN (select DISTINCT email_id from emails_email_addr_rel eear

join email_addr_bean_rel eabr on eabr.bean_id ='d616c9a5-18ff-8cfd-7fb4-5cf662a44a6f' and eabr.bean_module = 'Leads' and
eabr.email_address_id = eear.email_address_id and eabr.deleted=0
where eear.deleted=0 and eear.email_id not in
(select eb.email_id from emails_beans eb where eb.bean_module ='Leads' and eb.bean_id = 'd616c9a5-18ff-8cfd-7fb4-5cf662a44a6f')
) derivedemails on derivedemails.email_id = emails.id  where emails.deleted=0 ) ORDER BY date_entered desc LIMIT 0,10: MySQL error 1054: Unknown column 'tasks.date_end' in 'field list'

Tue Jun 11 13:56:06 2019 [7791][1][FATAL] Exception handling in /home/cipioint/mycentivise.com/louise/include/MVC/Controller/SugarController.php:400
Tue Jun 11 13:56:06 2019 [7791][1][FATAL] Exception in Controller: Database failure. Please refer to suitecrm.log for details.
Tue Jun 11 13:56:06 2019 [7791][1][FATAL] backtrace:
#0 /home/cipioint/mycentivise.com/louise/include/database/DBManager.php(353): sugar_die(‘Database failur…’)
#1 /home/cipioint/mycentivise.com/louise/include/database/DBManager.php(328): DBManager->registerError(‘Error retrievin…’, ‘Error retrievin…’, true)
#2 /home/cipioint/mycentivise.com/louise/include/database/MysqliManager.php(179): DBManager->checkError(‘Error retrievin…’, true)
#3 /home/cipioint/mycentivise.com/louise/include/database/MysqlManager.php(285): MysqliManager->query(’(SELECT meeting…’, true, ‘Error retrievin…’)
#4 /home/cipioint/mycentivise.com/louise/data/SugarBean.php(1284): MysqlManager->limitQuery(’(SELECT meeting…’, 0, 10, true, ‘Error retrievin…’)
#5 /home/cipioint/mycentivise.com/louise/data/SugarBean.php(1016): SugarBean->process_union_list_query(Object(Lead), ‘(SELECT meeting…’, 0, 10, 10, ‘’, Object(aSubPanel), ‘( SELECT count(…’, Array)
#6 /home/cipioint/mycentivise.com/louise/include/ListView/ListView.php(1141): SugarBean::get_union_related_list(Object(Lead), ‘date_entered de…’, ‘desc’, ‘’, 0, -1, 10, ‘’, Object(aSubPanel))
#7 /home/cipioint/mycentivise.com/louise/include/ListView/ListViewSubPanel.php(142): ListView->processUnionBeans(Object(Lead), Object(aSubPanel), ‘history_CELL’, false)
#8 /home/cipioint/mycentivise.com/louise/include/SubPanel/SubPanel.php(220): ListViewSubPanel->process_dynamic_listview(‘Leads’, Object(Lead), Object(aSubPanel), false)
#9 /home/cipioint/mycentivise.com/louise/include/SubPanel/SubPanelTiles.php(357): SubPanel->ProcessSubPanelListView(‘include/SubPane…’, Array)
#10 /home/cipioint/mycentivise.com/louise/include/MVC/View/SugarView.php(1167): SubPanelTiles->display()
#11 /home/cipioint/mycentivise.com/louise/include/MVC/View/SugarView.php(240): SugarView->_displaySubPanels()
#12 /home/cipioint/mycentivise.com/louise/include/MVC/Controller/SugarController.php(435): SugarView->process()
#13 /home/cipioint/mycentivise.com/louise/include/MVC/Controller/SugarController.php(375): SugarController->processView()
#14 /home/cipioint/mycentivise.com/louise/include/MVC/SugarApplication.php(113): SugarController->execute()
#15 /home/cipioint/mycentivise.com/louise/index.php(52): SugarApplication->execute()
#16 {main}[/spoiler]

8

Unfortunately this is an ongoing issue and nobody has been able to find the solution. The workaround is to clear the queries on the module you are receiving the error.
To do so you have to customize the following URL:

For Accounts:
http://yoursite/index.php?action=index&module=Accounts&searchFormTab=advanced_search&query=true&clear_query=true

For Contacts:
http://yoursite/index.php?action=index&module=Contacts&searchFormTab=advanced_search&query=true&clear_query=true

For Opportunities:
http://yoursite/index.php?action=index&module=Accounts&searchFormTab=advanced_search&query=true&clear_query=true

… And customize for any other module.

Hope it helps

2 Likes
9

You may use this if problem is stopping you working, however not recommended…

at your config_override.php

[$sugar_config[‘disableAjaxUI’] = true];

10

[quote=“AlxGr” post=85752]Unfortunately this is an ongoing issue and nobody has been able to find the solution. The workaround is to clear the queries on the module you are receiving the error.
To do so you have to customize the following URL:

For Accounts:
http://yoursite/index.php?action=index&module=Accounts&searchFormTab=advanced_search&query=true&clear_query=true

For Contacts:
http://yoursite/index.php?action=index&module=Contacts&searchFormTab=advanced_search&query=true&clear_query=true

For Opportunities:
http://yoursite/index.php?action=index&module=Accounts&searchFormTab=advanced_search&query=true&clear_query=true

… And customize for any other module.

Hope it helps[/quote]

Thanks for getting back to me, I have tried this changing module=Accounts to module=Leads as this is what is affected at the moment, but this seems to just take me to the Leads page without fixing anything, is there something that I’m doing wrong?

This seemed to just stop the CRM loading up at all? Again is there something that I’m doing wrong?

Thanks again guys,

11

correct lines were


$sugar_config['disableAjaxUI'] =true;
12

I ran into this error as well and I was able to resolve it by doing the following:

Admin --> Repair --> Quick Repair and Rebuild

After letting this run my Contacts Module stopped reporting this error and now seems to be functioning normally. Perhaps disabling Ajax would be what is needed, but I would try this first.