vicidial custom fields error UNSIGNED PRIMARY KEY NOT NULL

Estimated read time: 1 min

| Topic: Vicidial custom filed error UNSIGNED PRIMARY KEY NOT NULL

| Overview

While creating custom fields in vicidial you might get the below error

Could not execute: |CREATE TABLE custom_ (lead_id INT(9) UNSIGNED PRIMARY KEY NOT NULL, name VARCHAR(5) );|

| Root Cause:

Custom filed form uses the below credentials to create custom fields

necessary permission are not provided for the mysql user custom

or user custom with password custom1234 is not created

custom / custom1234

| Workaround

create user custom run below command in mysql

CREATE USER 'custom'@'localhost' IDENTIFIED BY 'custom1234';

Provide necessary permission to user custom, run below command in mysql

GRANT SELECT,INSERT,UPDATE,DELETE,LOCK,ALTER,CREATE TABLES on asterisk.* TO custom@'%' IDENTIFIED BY 'custom1234';
GRANT SELECT,INSERT,UPDATE,DELETE,LOCK,ALTER,CREATE TABLES on asterisk.* TO custom@localhost IDENTIFIED BY 'custom1234';
GRANT RELOAD ON *.* TO custom@'%';
GRANT RELOAD ON *.* TO custom@localhost;
flush privileges;