Activities Module - Meetings have disappeared

[benitap]

Hi there

I'm running Sugar 4.5.1 free edition and some strange things are going on.
Meetings were appearing in the Activities module but now only calls are listing there. All the meetings are only in the Calendar module. I need to get them back into the Activities module.
Is there some setting that could have changed?

Any help would be appreciated!

[andopes]

Hi benitap

Did you customize anything?
Did you install any patch, package, language pack?

Regards

[benitap]

Hi there

I haven't installed anything - it is a standard install of SugarCRM 4.5.1.
I also haven't customized anything yet.

The only thing that I have worked on is the sql database to remove test data. Could that have had an effect?

[andopes]

Hi benitap

I'm not sure.

Perhaps it is due to user preferences.
All users are facing the same issue or only a couple?

Regards

[benitap]

All users - including Admin - have this problem.

I've gone through the admin and global settings and I can't get the Meetings to show under Activities.

[andopes]

This may be a sql issue.

Edit the file include/ListView/ListViewData.php and add this line

 echo "<LI>$main_query"; 
  

Just after the line

 $main_query = $ret_array['select'] . $params['custom_select'] . $ret_array['from'] . $params['custom_from'] . $ret_array['where'] . $params['custom_where'] . $ret_array['order_by'] . $params['custom_order_by']; 
  

Then try to access the ListView again.
You should see a query string at the screen. Copy this one and execute that into phpMyAdmin.

Let us know both query string and error message from phpMyAdmin.

Regards

[benitap]

Hi there

I have added the line that you gave me and the query was:

SELECT calls.id , calls.status , calls.direction , calls.name , CONCAT(IFNULL(contacts.first_name,''),' ',IFNULL(contacts.last_name,'')) contact_name, jtl0.contact_id contact_id, calls.parent_id , calls.parent_type , calls.date_start , calls.time_start , jt1.user_name assigned_user_name , jt1.created_by assigned_user_name_owner , 'Users' assigned_user_name_mod, calls.assigned_user_id FROM calls LEFT JOIN calls_contacts jtl0 ON calls.id=jtl0.call_id AND jtl0.deleted=0 LEFT JOIN contacts contacts ON contacts.id=jtl0.contact_id AND contacts.deleted=0 AND contacts.deleted=0 LEFT JOIN users jt1 ON jt1.id= calls.assigned_user_id AND jt1.deleted=0 AND jt1.deleted=0 where calls.deleted=0

There was no error on phpadmin but the query suggests that only calls and contacts are being selected and not meetings. The meeting table is not accessed at all as far as I can see.
Am I correct in my deduction?