sugarcrm icon indicating copy to clipboard operation
sugarcrm copied to clipboard

get_relationships on Documents "revisions" link_field is borked

Open chicks opened this issue 14 years ago • 0 comments

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.

chicks avatar Apr 11 '11 00:04 chicks