sugarcrm
sugarcrm copied to clipboard
get_relationships on Documents "revisions" link_field is borked
This is an issue with SugarCRM and has been assigned bug number 42414. Details below:
get_relationships: Request:
{
"session": "8e02276e1c093c134aa5763b85d599ca",
"module_name": "Documents",
"module_id": "",
"link_field_name": "revisions",
"related_module_query": "",
"related_fields": ["id"],
"related_module_link_name_to_fields_array": [],
"deleted": 0
}
SugarCRM::UnhandledResponse: Database failure. Please refer to sugarcrm.log for details.
from ./sugarcrm/connection/connection.rb:128:in `process_response'
from ./sugarcrm/connection/connection.rb:104:in `handle_response'
from ./sugarcrm/connection/connection.rb:79:in `send!'
from ./sugarcrm/connection/api/get_relationships.rb:27:in `get_relationships'
from ./sugarcrm/associations/association_collection.rb:116:in `load_associated_records'
from ./sugarcrm/associations/association_collection.rb:30:in `load'
from ./sugarcrm/associations/association_collection.rb:14:in `initialize'
from ./sugarcrm/associations/association_methods.rb:85:in `new'
from ./sugarcrm/associations/association_methods.rb:85:in `query_association'
from (eval):3:in `revisions'
from (irb):14
sugarcrm.log contains: Mon Feb 21 20:00:52 2011 [7206][1][FATAL] Query Failed: SELECT documents.id , documents.assigned_user_id FROM documents where ( document_revisions.document_id= '' AND document_revisions.deleted=0) AND documents.deleted=0: MySQL error 1054: Unknown column 'document_revisions.document_id' in 'where clause'
I've confirmed this in 6.1.2 and 6.2.0 beta.