by Enjay IT Solutions Ltd.

Know exactly what your employees are doing in SuiteCRM. This User Activity module tracks each user's activity on several different SuiteCRM modules. Track and report on activity across multiple modules in a single report.

Cancel at any time!
Free Trial

#1400 - SQL Errors on missing column

Closed Bug? created by anthony-e2eperformance 4 months ago

Query Failed: SELECT eua_enjayusersactivity.id AS 'eua_enjayusersactivity_id', eua_enjayusersactivity.name AS 'Name0', eua_enjayusersactivity.action AS 'Action1', eua_enjayusersactivity.parent_module AS 'Parent_Module2', eua_enjayusersactivity.date_entered AS 'Date_Created3', eua_enjayusersactivity.user_name AS 'Username4' FROM eua_enjayusersactivity WHERE ( eua_enjayusersactivity.parent_module = 'Users' AND ( eua_enjayusersactivity.date_entered BETWEEN "2018-09-03 00:00:00" AND "2018-09-10 00:00:00" ) AND eua_enjayusersactivity.deleted = 0 ) GROUP BY eua_enjayusersactivity.action, eua_enjayusersactivity.parent_module, eua_enjayusersactivity.id, eua_enjayusersactivity.name, eua_enjayusersactivity.date_entered, eua_enjayusersactivity.user_name ORDER BY eua_enjayusersactivity.date_entered DESC LIMIT 0,20: MySQL error 1054: Unknown column 'eua_enjayusersactivity.user_name' in 'field list'

  1. limeshparekh member avatar

    Enjay IT Solutions Ltd. Provider Affiliate

    4 months ago

    Hi Anthony sir,

    Which database server you are using, please let us know.
    Can we check this issue on remotely please share your Skype ID.
    Our Skype ID is :- enjayworld.

    Thanks & Regards
    Team Addon.

    • anthony-e2eperformance member avatar

      anthony-e2eperformance

      4 months ago

      MYSQL 5.7.23 The the issue looks like your code does not define that field.

      function post_install ()
      {
          global $db;
          global $current_user;

      $sql_1a = "DROP TABLE IF EXISTS `eua_enjayusersactivity`";
      $sql_1b = "CREATE TABLE IF NOT EXISTS `eua_enjayusersactivity` (
          `id` char(36) NOT NULL,
          `name` varchar(255) DEFAULT NULL,
          `date_entered` datetime DEFAULT NULL,
          `date_modified` datetime DEFAULT NULL,
          `modified_user_id` char(36) DEFAULT NULL,
          `created_by` char(36) DEFAULT NULL,
          `description` text,
          `deleted` tinyint(1) DEFAULT '0',
          `assigned_user_id` char(36) DEFAULT NULL,
          `action` varchar(100) DEFAULT 'Added',
          `parent_type` varchar(255) DEFAULT NULL,
          `parent_id` char(36) DEFAULT NULL,
          `parent_module` varchar(100) DEFAULT 'Accounts'
      ) ENGINE=InnoDB DEFAULT CHARSET=utf8";
      

      user_name is not defined in the above table.

    • limeshparekh member avatar

      Enjay IT Solutions Ltd. Provider Affiliate

      4 months ago

      Hi Anthony sir,

      Can we check the issue on remotely?
      Please share your skype ID, so we can connect & resolve your issue.

      Thanks & Regards
      Team Addon.

    • anthony-e2eperformance member avatar

      anthony-e2eperformance

      4 months ago

      anthony_nieves_e2e

  2. anthony-e2eperformance member avatar

    anthony-e2eperformance

    4 months ago

    Please cancel the order I dont want to use it

  3. limeshparekh member avatar

    Enjay IT Solutions Ltd. Provider Affiliate

    4 months ago

    Hello Anthony,

    We are connected online. Please let us check.

  4. anthony-e2eperformance member avatar

    anthony-e2eperformance

    4 months ago

    Still getting error on edit of a record.
    Screenshot 2018-09-12 09.04.37.png

  5. limeshparekh member avatar

    Enjay IT Solutions Ltd. Provider Affiliate

    4 months ago

    Dear Sir,

    We have already informed you that we have not given privilege to edit to create User Activity record. If we would have given it, then all users can edit their logged activity.

    But you need to edit activity than we can do it.

    Thanks & Regards
    Team Addon

    • anthony-e2eperformance member avatar

      anthony-e2eperformance

      4 months ago

      I am the system admin I should not need any privilege. And not I am getting another error.

      Please cancel the subscription I do not want to use it.

  6. limeshparekh member avatar

    Enjay IT Solutions Ltd. Provider Affiliate

    4 months ago

    Hello Anthony,

    We have got your Document on Skype. We need to check it once from our end. Please activate user credential provided to us.

    Thanks & Regards
    Team Addon

    • anthony-e2eperformance member avatar

      anthony-e2eperformance

      3 months ago

      Please cancel subscription and don't charge my credit card for this package. I do not want to use this package.

    • jason member avatar

      Jason

      3 months ago

      Hello,

      The trial is now canceled. Thanks for giving it a try!

      Cheers,
      Jason Eggers
      The SuiteCRM Store

    • limeshparekh member avatar

      Enjay IT Solutions Ltd. Provider Affiliate

      3 months ago

      Dear Sir

      We are ready to help and solve your problem, please share with us credential or allow to give us screen on skype.

      If you want to cancel this subscription please cancel the subscription from your login.

      Thanks in Advance.

This case is public. Please leave out any sensitive information such as URLs, passwords, etc.
Saving Comment Saving Comment...
Rating
  • "Had a small problem with the installing and they gave me a call and fixed the problem right away."

    Read More Reviews