by CRM Ninjas

Have conversations about any record in Suite CRM just like on Facebook or any social network.

Cancel at any time!
Free Trial

#580 - DB error on module name select

Open Bug? created by aureh12 3 years ago

in function action_GetRecord()

$query = "SELECT id, $field_name AS name FROM $table WHERE deleted = 0";

the log is: Query Failed: SELECT id, name AS name FROM users WHERE deleted = 0: MySQL error 1054: Unknown column 'name' in 'field list'

because there is no field called name in the module Users.
i have this problem with other modules like Documents and all my custom modules with a document base.

This case is public. Please leave out any sensitive information such as URLs, passwords, etc.
Saving Comment Saving Comment...