Leads error

[jonaslagneryd]

I resolved the issue below by running Quick Repair and Rebuild Quick Repair and Rebuild and Executing the suggested script.
Jonas :-)

I get this error message in Leads now after having updated from 5.0 to 5.1.0a .

::::::::::::::::::::::::::::::::::
Error running count query for Lead List: Query Failed SELECT count(*) c FROM meetings INNER JOIN meetings_leads ON (meetings.id=meetings_leads.meeting_id AND meetings_leads.lead_id= '9d0562dd-bb3c-ba8a-fc90-48ecb682e1bb') where ( meetings_leads.deleted=0 AND meetings.deleted=0 AND (meetings.status='Planned')) AND meetings.deleted=0 ) UNION ALL ( SELECT count(*) c FROM meetings where ( meetings.parent_id = '9d0562dd-bb3c-ba8a-fc90-48ecb682e1bb' AND meetings.parent_type = 'Leads' AND meetings.id NOT IN ( SELECT meeting_id FROM meetings_leads ) AND (meetings.status='Planned')) AND meetings.deleted=0 ) UNION ALL ( SELECT count(*) c FROM tasks where ( tasks.parent_id= '9d0562dd-bb3c-ba8a-fc90-48ecb682e1bb' AND tasks.parent_type='Leads' AND tasks.deleted=0 AND (tasks.status='Not Started' OR tasks.status='In Progress' OR tasks.status='Pending Input')) AND tasks.deleted=0 ) UNION ALL ( SELECT count(*) c FROM calls INNER JOIN calls_leads ON (calls.id=calls_leads.call_id AND calls_leads.lead_id= '9d0562dd-bb3c-ba8a-fc90-48ecb682e1bb') where ( calls_leads.deleted=0 AND calls.deleted=0 AND (calls.status='Planned')) AND calls.deleted=0 ) UNION ALL ( SELECT count(*) c FROM calls where ( calls.parent_id = '9d0562dd-bb3c-ba8a-fc90-48ecb682e1bb' AND calls.parent_type = 'Leads' AND calls.id NOT IN ( SELECT call_id FROM calls_leads ) AND (calls.status='Planned')) AND calls.deleted=0 )::MySQL error 1146: Table 'campusre_crm.meetings_leads' doesn't exist
::::::::::::::::::::::::::::::::::
Very thankful for good advice!
Kind regards,
Jonas


» Operating system type and version (Linux, Kernel version 2.6.18-028stab053.17 )
» Sugar Suite version Version 5.1.0a (Build 4837) Community Edition
» Webserver type and version (1.3.41 (Unix))
» PHP version (5.2.5)
» MySQL server version (5.0.45-community-log)
» I use Firefox v3.0.3, released September 26, 2008