Kanban View

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.

Free 30 day trial

Try it Now

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

Open Bug? created by sandstone Verified Purchase 5 years 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

sandstone Verified Purchase
5 years 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?

reply
- Vedisoft Provider
  5 years 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
  
  reply
Vedisoft Provider
5 years 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

reply
- sandstone Verified Purchase
  5 years 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
  
  reply

Vedisoft Provider

5 years 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 &#039;0&#039;,
  `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 Verified Purchase
5 years 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!

reply

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

Saving Comment...

Kanban View

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

"Clicking on the card shows a window of the module but does not present the associated submodules. Simple interface" - rafaingg

Other add-ons of interest

Glances - Integrate SuiteCRM with all your apps

Mokas SalesPipe