Error display after creating a new contact from business card

[ddgadmin]

Operating system type and version Centos 5.1 Hosted under Plesk 8.3
» Sugar Suite version Version 5.0.0b (Build 3150)
» Webserver type and version Apache 2.x
» PHP version 5.x
» MySQL server version 5.x

Clean install everthing perfect, installed open sales prodcut/quotes/contracts.

When creating contact using the enter business card link from home page and not creating an account/opportunity/appointment from the links at the bottom, When the contact is saved and I go to contacts and open the contact again the following error is displayed.

Is this a transient problem that will go away after other items are added to the record e.g. Account etc.

Any help would be much appreciated?

Error running count query for Contact List: Query Failed SELECT count(*) c FROM meetings LEFT JOIN users jt1 ON jt1.id= meetings.assigned_user_id AND jt1.deleted=0 AND jt1.deleted=0 INNER JOIN meetings_contacts ON (meetings.id=meetings_contacts.meeting_id AND meetings_contacts.contact_id= 'f3ee09d0-a97f-0530-3bf3-47dff28c4867') where ( meetings_contacts.deleted=0 AND meetings.deleted=0 AND (meetings.status='Planned')) AND meetings.deleted=0 ) UNION ALL ( SELECT count(*) c FROM tasks AND contacts.deleted=0 LEFT JOIN users jt1 ON jt1.id= tasks.assigned_user_id AND jt1.deleted=0 AND jt1.deleted=0 where ((taskscontacts.status='Not Started' OR taskscontacts.status='In Progress' OR taskscontacts.status='Pending Input')) AND tasks.deleted=0 ) UNION ALL ( SELECT count(*) c FROM calls LEFT JOIN users jt1 ON jt1.id= calls.assigned_user_id AND jt1.deleted=0 AND jt1.deleted=0 INNER JOIN calls_contacts ON (calls.id=calls_contacts.call_id AND calls_contacts.contact_id= 'f3ee09d0-a97f-0530-3bf3-47dff28c4867') where ( calls_contacts.deleted=0 AND calls.deleted=0 AND (calls.status='Planned')) AND calls.deleted=0 )::MySQL error 1064:

[dpatech]

It seems like the relationship between Tasks and Contacts isn't working properly in this case. This only happens for those Contacts that are created via the Business Card function from the home page, correct?

I tried this on my version 5.0B and it worked correctly. I chose "Enter Business Card" from the Home page, entered as few Contacts fields as possible and then clicked Save. Then clicked on the link to display that newly created Contacts and ended up with no errors.

Perhaps you can try repairing relationships using Admin->Repair->Rebuild Relationships.