by eggsurplus

Control what your users can access and save time, money, and frustrations. Lock down sensitive data in SugarCRM or SuiteCRM to specific groups or teams. Supports unlimited assigned users, unlimited group assignments to records, custom layouts for each group, login/sudo capabilities and much more.

Free 30 day trial
Try it Now

By clicking you consent to share your profile with the developer

#306 - Mass Assign - error in where clause

Open Bug? created by liran 11 years ago
When I try to mass assign the entire data set, I receive the following error: "MySQL error 1054: Unknown column 'jt0.first_name' in 'where clause'" The bug is created in the file MassAssign.php, the query in $_SESSION['export_where'] has a condition for jt0 but the query's join does not have an alias for the tables and thus the errors is thrown. How can I fix this issue? Note: I'm using sugar version 6.5.15.
  1. eggsurplus member avatar

    eggsurplus Provider Affiliate

    11 years ago

  2. liran member avatar

    liran

    11 years ago

  3. eggsurplus member avatar

    eggsurplus Provider Affiliate

    10 years ago

  4. madmat member avatar

    madmat Verified Purchase

    9 years ago

This case is public. Please leave out any sensitive information such as URLs, passwords, etc.
Saving Comment Saving Comment...
Rating
Rating
  • "Works only EN lang, If run upgrade SecSuite under RU lang - error..." - vstgod

    Read More Reviews