8.4 any create record function about suitecrm-core HOT 4 CLOSED

Hey @gib1991

Thanks for getting in touch!

hmmmm, I've given this a try on a local copy of 8.4.0 (php82/mariadb10.4), and I seem to be able to create records without issue.

I've also specifically tried Contacts->Activities Subpanel->Log Call, and this appears to work fine too

I've also tried to replicate a similar Change to Calls as your video shows, by removing the default Date/Time field, and replacing it with a custom Date field, but this doesn't appear to prompt the error

Do you perhaps know which changes you made in studio?
Was this to any of the affected modules? (ie: Calls/Meetings/Contacts)
It might help with replication if I can make the same changes locally.

Also, do you experience this issue across the entire CRM?
(ie: Cannot create Accounts / Cannot create Leads / etc)

Or just for this relationship?

Thanks!

from suitecrm-core.

In the calls section in studio all I've done is remove the mandatory fill requirements on the start/end/duration/direction and subject fields.

I've changed the layout of the call in Display & Edit view to suit

I've added in a field for purely date - as datetime isn't relevant for scenario - and added that into the display and edit views.

What i find interesting is that each method i go to create a call be it a subpanel or through the main navigation bars i'm still getting thrown that unique error and the SQL query below appears in the log at every eventuality.

I log into the phpmyadmin to try and run that query independant of the system and it's throwing the same error.

SELECT meetings.`date_end` AS `meetings_date_end`  FROM calls   LEFT JOIN  users jt1 ON calls.a$

 AND jt1.deleted=0 INNER JOIN  calls_contacts ON calls.id=calls_contacts.call_id AND calls_contacts.contact_id='722a2b29-ba10-4c6e-4cf8-64f83c5dcda1' AND calls_contacts.deleted=0

  where ((calls.status='Held' OR calls.status='Not Held')) AND calls.deleted=0   ORDER BY `meetings_date_end` DESC LIMIT 1

When i use reset module to calls to bring it back to default - I'm still met with the same error, I don't understand why the calls is trying to alias "MEETINGS" table when there isn't a default relationship between those two on a fresh install? And there isn't a join on the query to bring the meetings. table into the relation (does that make sense?)

I can provide you with access to my install if you'd like to take a nosy - I'm trying to eliminate all the snags before putting too much effort into production.

May be helpful to also note that the record does create - but it always throws up the "Error occured while fetching records"

I've experienced a few relationship issues with a few of the other modules and a few that i've created from new (basic fields) - using the nav bar on subpanel to create the record it's not linking them to the parent (i.e. Studio > Module Builder > Basic > Many to Many relationship > FoodBank to Contacts

Load up the contact, expand the foodbank subpanel, click add record - input details & save, screen refreshes but there's no record on the parent record - have to manually link them.

from suitecrm-core.

Hey!

Thank you for getting in touch with further info!

hmmm, I've noticed that the field list in your Studio->Calls->Fields screenshot doesn't list any custom fields, whereas your Youtube video does. (ie: Next Call Date / Flag Reason / etc)

Typically, when custom fields are created via studio, they show with an asterisk.
ie:

Have you perhaps added any fields/custom changes to these modules directly via the codebase?
(ie: through /extensions/ or /custom/ directories? Or via the detailview metadata? or elsewhere? )

If so, this may also explain the "Error occured while fetching records" error showing on page-load, and would be a good place to investigate further.

Thanks!

from suitecrm-core.

I figured out why i'm getting these responses and i've remedied at this end.
In the activities/history sub panels i commented out a few lines on the subpaneldefs within each respective module and it's working as intended :)

from suitecrm-core.