Cannot add custom fields

All installation and configuration problems and questions

Moderators: gerski, enjay, williamconley, Op3r, Staydog, gardo, mflorell, MJCoate, mcargile, Kumba, Michael_N

Cannot add custom fields

Postby wjohnson133 » Thu Feb 01, 2018 1:56 pm

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
Architecture: x86_64 CPU(s): 2 CPU family: 15 Model: 6
Model name: Intel(R) Pentium(R) 4 CPU 3.20GHz
Linux version 4.1.39-56-default (geeko@buildhost) (gcc version 4.8.5 (SUSE Linux) )
VICIDIAL VERSION: 2.14-524c BUILD: 170531-0937
wjohnson133
 
Posts: 40
Joined: Wed Mar 15, 2017 2:00 pm

Re: Cannot add custom fields

Postby jor.hug » Fri Apr 06, 2018 2:51 pm

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
Version: 2.14-644a | Build: 171130-0036
jor.hug
 
Posts: 3
Joined: Wed Feb 14, 2018 1:36 pm

Re: Cannot add custom fields

Postby jor.hug » Fri Apr 06, 2018 3:14 pm

Just solved ours funnily enough. The issue was a database permissions issue. The Cron user did not have access to the CREATE TABLE function.
Version: 2.14-644a | Build: 171130-0036
jor.hug
 
Posts: 3
Joined: Wed Feb 14, 2018 1:36 pm

Re: Cannot add custom fields

Postby williamconley » Fri Apr 06, 2018 6:02 pm

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.
Vicidial Installation and Repair, plus Hosting and Colocation
SugarCRM integration - Customization and Add-ons - We Bring It All Together.
http://www.PoundTeam.com # 352-269-0000 # +44 (203) 769-2294 # +506 4001-8914
williamconley
 
Posts: 17049
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)


Return to Support

Who is online

Users browsing this forum: Google [Bot] and 18 guests