Page 1 of 1

Cannot add custom fields

PostPosted: Thu Feb 01, 2018 1:56 pm
by wjohnson133
Everytime I try to add a custom field to a list I get the following error:

"Could not execute: |CREATE TABLE custom_405 (lead_id INT(9) UNSIGNED PRIMARY KEY NOT NULL, OPPORTUNITYID VARCHAR(9) );|
FIELD NOT ADDED, PLEASE GO BACK AND TRY AGAIN"

Before anybody says I should have used Vicibox I just want to point out that I really tried but the server that I purchased had an array hd and I was unable to find any installs that had that driver without going back to an early Centos installation which I then updated to CENTOS 6.9 and then installed and then did a scratch install of vicidial.

I have just completed a scratch install on CENTOS 6.9

Linux localhost.localdomain 2.6.32-696.18.7.el6.x86_64 #1 SMP Thu Jan 4 17:31:22 UTC 2018 x86_64 x86_64 x86_64 GNU/Linux

VERSION: 2.14-650a
BUILD: 180111-1544

H/W path Device Class Description
=====================================================
system ProLiant DL380 G5 (430027-005)
/0 bus Motherboard
/0/0 memory 64KiB BIOS
/0/400 processor Xeon
/0/400/710 memory 32KiB L1 cache
/0/400/720 memory 4MiB L2 cache
/0/406 processor Xeon
/0/406/716 memory 32KiB L1 cache
/0/406/726 memory 4MiB L2 cache
/0/1000 memory 8GiB System Memory
/0/1000/0 memory 1GiB FB-DIMM DDR2 FB-DIMM Synchronous 667 MHz (1.5 ns)
/0/1000/1 memory 1GiB FB-DIMM DDR2 FB-DIMM Synchronous 667 MHz (1.5 ns)
/0/1000/2 memory 1GiB FB-DIMM DDR2 FB-DIMM Synchronous 667 MHz (1.5 ns)
/0/1000/3 memory 1GiB FB-DIMM DDR2 FB-DIMM Synchronous 667 MHz (1.5 ns)
/0/1000/4 memory 1GiB FB-DIMM DDR2 FB-DIMM Synchronous 667 MHz (1.5 ns)
/0/1000/5 memory 1GiB FB-DIMM DDR2 FB-DIMM Synchronous 667 MHz (1.5 ns)
/0/1000/6 memory 1GiB FB-DIMM DDR2 FB-DIMM Synchronous 667 MHz (1.5 ns)
/0/1000/7 memory 1GiB FB-DIMM DDR2 FB-DIMM Synchronous 667 MHz (1.5 ns)
/0/100 bridge 5000P Chipset Memory Controller Hub
/0/100/2 bridge 5000 Series Chipset PCI Express x4 Port 2
/0/100/2/0 bridge 6311ESB/6321ESB PCI Express Upstream Port
/0/100/2/0/0 bridge 6311ESB/6321ESB PCI Express Downstream Port E1
/0/100/2/0/1 bridge 6311ESB/6321ESB PCI Express Downstream Port E2
/0/100/2/0/2 bridge 6311ESB/6321ESB PCI Express Downstream Port E3
/0/100/2/0.3 bridge 6311ESB/6321ESB PCI Express to PCI-X Bridge
/0/100/3 bridge 5000 Series Chipset PCI Express x4 Port 3
/0/100/3/0 scsi0 storage Smart Array Controller
/0/100/4 bridge 5000 Series Chipset PCI Express x8 Port 4-5
/0/100/5 bridge 5000 Series Chipset PCI Express x4 Port 5
/0/100/6 bridge 5000 Series Chipset PCI Express x8 Port 6-7
/0/100/7 bridge 5000 Series Chipset PCI Express x4 Port 7
/0/100/1c bridge 631xESB/632xESB/3100 Chipset PCI Express Root Port 1
/0/100/1c/0 bridge EPB PCI-Express to PCI-X Bridge
/0/100/1c/0/0 eth0 network NetXtreme II BCM5708 Gigabit Ethernet
/0/100/1c.1 bridge 631xESB/632xESB/3100 Chipset PCI Express Root Port 2
/0/100/1c.1/0 bridge EPB PCI-Express to PCI-X Bridge
/0/100/1c.1/0/0 eth1 network NetXtreme II BCM5708 Gigabit Ethernet
/0/100/1d bus 631xESB/632xESB/3100 Chipset UHCI USB Controller #1
/0/100/1d/1 usb2 bus UHCI Host Controller
/0/100/1d.1 bus 631xESB/632xESB/3100 Chipset UHCI USB Controller #2
/0/100/1d.1/1 usb3 bus UHCI Host Controller
/0/100/1d.2 bus 631xESB/632xESB/3100 Chipset UHCI USB Controller #3
/0/100/1d.2/1 usb4 bus UHCI Host Controller
/0/100/1d.2/1/2 input USB Receiver
/0/100/1d.3 bus 631xESB/632xESB/3100 Chipset UHCI USB Controller #4
/0/100/1d.3/1 usb5 bus UHCI Host Controller
/0/100/1d.7 bus 631xESB/632xESB/3100 Chipset EHCI USB2 Controller
/0/100/1d.7/1 usb1 bus EHCI Host Controller
/0/100/1e bridge 82801 PCI Bridge
/0/100/1e/3 display ES1000
/0/100/1e/4 generic Integrated Lights Out Controller
/0/100/1e/4.2 generic Integrated Lights Out Processor
/0/100/1e/4.4 bus Integrated Lights-Out Standard Virtual USB Controller
/0/100/1e/4.4/1 usb6 bus UHCI Host Controller
/0/100/1e/4.4/1/1 input Virtual Keyboard
/0/100/1e/4.4/1/2 bus Virtual Hub
/0/100/1e/4.6 bus Integrated Lights-Out Standard KCS Interface
/0/100/1f bridge 631xESB/632xESB/3100 Chipset LPC Interface Controller
/0/100/1f.1 scsi1 storage 631xESB/632xESB IDE Controller

Re: Cannot add custom fields

PostPosted: Fri Apr 06, 2018 2:51 pm
by jor.hug
Has anyone found a solution to this issue? I'm experiencing the same problem.

Could not execute: |CREATE TABLE custom_101 (lead_id INT(9) UNSIGNED PRIMARY KEY NOT NULL, test VARCHAR(255) default '');|
FIELD NOT ADDED, PLEASE GO BACK AND TRY AGAIN

Re: Cannot add custom fields

PostPosted: Fri Apr 06, 2018 3:14 pm
by jor.hug
Just solved ours funnily enough. The issue was a database permissions issue. The Cron user did not have access to the CREATE TABLE function.

Re: Cannot add custom fields

PostPosted: Fri Apr 06, 2018 6:02 pm
by williamconley
sounds like a permission issue. the cron user likely doesn't have the proper permission to create a new table. If you installed with older written instructions, that could be the problem.

But if you installed with goautodial's centos installation system, it should work.

If you check the vicibox install scripts for the creation of the cron/1234 user and its permissions, you may find the missing permission.

test by running the command as root. duct tape fix would be to give the cron/1234 user full permissions. but restrict access of the cron user to the local IP address (or specific IP address list) to avoid a hack of the cron user. remove the "any ip" permission.