by Vedisoft

Visualize and manage your "work in progress" by dragging and dropping your records. Add a Kanban view for any SuiteCRM module. Great for sales pipelines, leads pipeline, account pipeline, support team boards, project management, and more.

Cancel at any time!
Free Trial

#1772 - MySQL error: Table 'crm.kanban' doesn't exist

Open Bug? created by sandstone Verified Purchase a year ago

Hello,
During the installation I see the following error:
MySQL error 1146: Table 'crm.kanban' doesn't exist

I did not find any table creation for a table "kanban" in the installer, which makes me think that I am missing an other module this one requires, but the installer has no reference as to what is required.

If this is not the case, can you send me the manual table creation or let me know what file this is in?

Thank you

  1. sandstone member avatar

    sandstone Verified Purchase

    a year ago

    Hello,

    Any way to get support for this? I installed it, then installed it on a clean instance of CRM and the same thing is happening.

    I am in the trial period and 1 week into the trial I couldn't even test this. Nor am I getting any kind of help here.

    What is a good way to get in touch with developers? Seems like they don't get notifications of "tickets" here, or that they just ignore them.

    Any advice?

    • Vedisoft member avatar

      Vedisoft Provider

      a year ago

      Hi,
      I'm sorry I did not answer you earlier.

      The most common issue for this error is Quick Repair can't be completed (one of the step is update your database and it did not happen). It could be becaues of wrong file permissions on your server's file system.

      Is it possible to give us access to your test CRM instance by http(s) and by ssh? If yes, please send it to a@vedisoft.info.

      Best regards
      Andrey Uymin
      Project manager, Vedisoft
      a@vedisoft.info
      skype: andrew.uymin

  2. Vedisoft member avatar

    Vedisoft Provider

    a year ago

    Hi,
    Regarding SQL that you can manually run - of cause we can prepair it for you, but I afraid you will meet js-problems or something. First of all we have to successfully run all steps of Quick Repair including SQL-tables update

    • sandstone member avatar

      sandstone Verified Purchase

      a year ago

      Hello,

      Can you send me the table creation I have to run? I can manually run it. A Quick repair didn't do anything. Installed/reinstalled, same thing.

      The installer is sitting in the cache directory. The web user has R/W to the entire directory.

      The only DB creation I see in your installer is
      ./scripts/post_install.php:        $db->createTableParams('so_users',$fieldDefs,$indices);
      and so_users is created successfully.

      I am more than happy to run the DB creation script manually, but I don't know what the actual query is.

      Can you please send me the query?

      Thank you in advance
      SandStone

  3. Vedisoft member avatar

    Vedisoft Provider

    a year ago

    Hi,
    It is a wrong way to solve the problem. Quick Repair should suggest you to create new table. If it does not happen, then you've got problems in your instance.

    You can give us access to your instance and we will take a look.

    Here is the requested SQL:

    CREATE TABLE IF NOT EXISTS `kanban` (
      `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,
      `self_name` varchar(255) DEFAULT NULL,
      `type` varchar(255) DEFAULT NULL,
      `target_module` varchar(255) DEFAULT NULL,
      `target_field` varchar(255) DEFAULT NULL,
      `target_values` text,
      `target_close_values` text,
      `header_fields` text,
      `body_fields` text,
      PRIMARY KEY (`id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    

    Best regards
    Andrey Uymin
    Project manager, Vedisoft
    a@vedisoft.info
    skype: andrew.uymin

    • sandstone member avatar

      sandstone Verified Purchase

      a year ago

      Thank you for the help.

      The Quick fix DID OFFER to execute the query, I just somehow missed it. I just did an other quick fix, executed the query there and now I can create a new Kanban View.

      Now it is installed and we can test functionality.

      Thank you a lot!

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