Is it so that it is not possible to add a recipient by using that âTo:â -button when using Quick Compose? I Tried it with my own setup and also reproduced with SuiteCRM demo version. Both give same error.
âUncaught TypeError: Cannot read property âstyleâ of nullsugar_grp_quickcomp.js:268 SE.addressBook.selectContactsDialogueindex.php?action=DetailView&module=Opportunities&record=1b27dc3f-6b36-8c68-3be2-54f5a344f9e4&offsetâŚ:1 onclickâ
Maybe a design flaw or restriction? or is it just me
Problem seems to be in a Query which is trigged when pressing To: -button.
Query dies on error so that mean âInnerhtmlâ cannot get any context to it.
Query error:
[FATAL] Query Failed: SELECT contacts.id ref_id , jt0.assigned_user_id opportunity_role_fields_owner, 'Opportunities' opportunity_role_fields_mod, opportunities_contacts.opportunity_id opportunity_id, opportunities_contacts.id opportunity_role_id, opportunities_contacts.contact_role opportunity_role , accounts.name account_name, jtl1.account_id account_id FROM contacts LEFT JOIN accounts_contacts jtl1 ON contacts.id=jtl1.contact_id AND jtl1.deleted=0
LEFT JOIN accounts accounts ON accounts.id=jtl1.account_id AND accounts.deleted=0
AND accounts.deleted=0 INNER JOIN opportunities_contacts ON contacts.id=opportunities_contacts.contact_id AND opportunities_contacts.opportunity_id='7c4e6d9f-3155-5387-434e-54fef471c5ae' AND opportunities_contacts.deleted=0
where contacts.deleted=0: MySQL error 1054: Unknown column 'jt0.assigned_user_id' in 'field list'
"jt0"is a some kind of temp user which is created in advance, but it is not defined anywhere.
This problem seems to occur quite often, when âjt0â temp user is in action somehow. I found some solutions regarding similar problem, and the solution is to add âjoin_nameâ => âcontactsâ, which forces this jt0 user to be replaced by âcontact_assigned_user_idâ.
Only problem still is that I am not quite sure which Vardef file assigns this Query which is used when pressing that To: -button? (Note! This is only in a situation when one using a Quick Compose window)
Im not sure how this âjt0â temp user is handled system wide, but obviously best fix would be to find out the source of this problem if it is a system wide, not Component or single file related bug.
Hmm, I think i have to take my words back. After i got AOD work well, I cannot reproduce this error anymore, but still To: -button issue is on. So i think iâll have to move towards .js file.
I have something similar from the quick compose (email). I can see the errors in the log, but the user does not get an error and the email is still sent
03/17/15 11:25:43 [61080][73c99215-edfb-c89c-09b8-5321afbe16ea][FATAL] Query Failed: SELECT contacts.id ref_id , jt0.assigned_user_id opportunity_role_fields_owner, âOpportunitiesâ opportunity_role_fields_mod, opportunities_contacts.opportunity_id opportunity_id, opportunities_contacts.id opportunity_role_id, opportunities_contacts.contact_role opportunity_role , accounts.name account_name, jtl1.account_id account_id FROM contacts LEFT JOIN accounts_contacts jtl1 ON contacts.id=jtl1.contact_id AND jtl1.deleted=0
LEFT JOIN accounts accounts ON accounts.id=jtl1.account_id AND accounts.deleted=0
AND accounts.deleted=0 INNER JOIN opportunities_contacts ON contacts.id=opportunities_contacts.contact_id AND opportunities_contacts.opportunity_id=âe27521e6-72f0-6d68-9156-51f63588a179â AND opportunities_contacts.deleted=0
where contacts.deleted=0: MySQL error 1054: Unknown column âjt0.assigned_user_idâ in âfield listâ
03/17/15 11:31:48 [61080][73c99215-edfb-c89c-09b8-5321afbe16ea][ERROR] Unable to load related bean by id
03/17/15 12:15:43 [61080][1][ERROR] Unable to load related bean by id
I found an easy way to reproduce the error shown, and did so on a completely clean installation of 7.2.1
Add a contact to an opportunity, and every time you access the opportunity the error appears as a FATAL error in the suitecrm.log (but no error is reported on screen). Unlink/remove the contact from the subpanel and error stops showing
Because of this error, certain data is not being populated into that Contacts subpanel.
As for figuring out where jt0 is defined, or which table is supposed to be being referred to, not a clue.
Any ideas on how I can send an email from within a Project now?
Or, within a Task?
Iâm new to SuiteCRM. I can send emails through âEmails > Composeâ but that means I need to search for project each time. Would be nice just to live within projects and tasks then email where necessary with everything auto filled.
PS: I would expect a project with one contact to auto fill the âTo:â box with that one contactâs emails :-/
