Hi everyone,

I´ve been working with sugar 6.4.0RC installed in our webserver without problems, but after some layout changes made in studio (mostly notes and tasks modules related, including custom "relate" fields in both editview and detailview) i get this "database failure" error in a weird-looking popup window anytime I click on a note in the listview

I´ve tried to restore files from original release to modules\notes, custom\modules\notes and metadata directories, plus executing a quick repair & rebuild + rebuild relationships but it doesn´t seem to work.

This is what i get in sugarcrm.log:

[FATAL] Error running count query for Note List: Query Failed: ( SELECT count(*) c FROM meetings INNER JOIN notes notes_activities_meetings_rel ON meetings.parent_id=notes_activities_meetings_rel.i d AND notes_activities_meetings_rel.deleted=0
AND parent_type = 'Notes'
where ( meetings.parent_id='c91a6599-f442-d683-93b8-4f210c5260c9' AND (meetings.status !='Held' AND meetings.status !='Not Held')) AND meetings.deleted=0 ) UNION ALL ( SELECT count(*) c FROM tasks INNER JOIN notes notes_activities_tasks_rel ON tasks.parent_id=notes_activities_tasks_rel.id AND notes_activities_tasks_rel.deleted=0
AND parent_type = 'Notes'
where ( tasks.parent_id='c91a6599-f442-d683-93b8-4f210c5260c9' AND (tasks.status != 'Completed' AND tasks.status != 'Deferred')) AND tasks.deleted=0 ) UNION ALL ( SELECT count(*) c FROM calls INNER JOIN notes notes_activities_calls_rel ON calls.parent_id=notes_activities_calls_rel.id AND notes_activities_calls_rel.deleted=0
AND parent_type = 'Notes'
where ( calls.parent_id='c91a6599-f442-d683-93b8-4f210c5260c9' AND (calls.status != 'Held' AND calls.status != 'Not Held')) AND calls.deleted=0 ): MySQL error 1052: Column 'parent_type' in on clause is ambiguous
I guess this is consequence of a sloppy customization work by my side, but i´m not really experienced with this kind of tasks, and any help provided would be appreciated.

Thanks in advance.