LinkBack URL
About LinkBacks
Sub Panels vanished in 'detail view' for all modules - Home module also blank!
Hi,
I'm new to Sugar but have managed to create new fields and lists for some modules successfully, but as soon as I tried to create relationship between Documents module and Opportunities module, ALL sub-panels in the 'detail view' have disappeared and been replaced with following type of error message:
Error running count query for Opportunity List: Query FailedSELECT count(*) c FROM meetings where ( meetings.parent_id= 'e6726708-c98f-af27-1fd1-4b6942d943f6' AND meetings.parent_type='Opportunities' AND meetings.deleted=0 AND (meetings.status='Held' OR meetings.status='Not Held')) AND meetings.deleted=0 ) UNION ALL ( SELECT count(*) c FROM tasks where ( tasks.parent_id= 'e6726708-c98f-af27-1fd1-4b6942d943f6' AND tasks.parent_type='Opportunities' AND tasks.deleted=0 AND (tasks.status='Completed' OR tasks.status='Deferred')) AND tasks.deleted=0 ) UNION ALL ( SELECT count(*) c FROM calls where ( calls.parent_id= 'e6726708-c98f-af27-1fd1-4b6942d943f6' AND calls.parent_type='Opportunities' AND calls.deleted=0 AND (calls.status='Held' OR calls.status='Not Held')) AND calls.deleted=0 ) UNION ALL ( SELECT count(*) c FROM notes where ( notes.parent_id= 'e6726708-c98f-af27-1fd1-4b6942d943f6' AND notes.parent_type='Opportunities' AND notes.deleted=0) AND notes.deleted=0 ) UNION ALL ::MySQL error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
I subsequently logged in as Admin and performed the one repair relating to relationships but no avail. I also checked to see if the relationships created had been removed after this and they have.
ALSO, my module Home has completely gone and been replaced with a blank white page?
The site is hosted elsewhere so I am afraid I don't know the server, version of MySQL etc. but I am using Win XP and version 5.2.0 of Sugar Community Edition.
Is this even repairable??
Reply With Quote
Bookmarks