[Vtigercrm-developers] vtlib adding a picklist field

[Alan Lord (News)]

Look at the SQL versus the name of your field...

Hint: Get rid of the underscores in your column name (for ease I always 
set the column name and the field name to be the same), there is no need 
to specify the table.

Al


On 28/07/15 12:57, Kevin Alderton wrote:
> Hi,
>
> In the vtiger logs I am getting the following:
>
>     INFO VT - PearDatabase ->ADODB error  Query Failed:INSERT INTO
>     vtiger_testpicklist (testpicklist id, testpicklist , sortorderid,
>     presence) VALUES(?,?,?,?)::->[1064]You have an error in your SQL
>     syntax; check the manual that corresponds to your MySQL server
>     version for the right syntax to use near 'id, testpicklist ,
>     sortorderid, presence) VALUES(0,'Value2',2,1)' at line 1
>
> Is this a bug???????
>
>
>
>
>
>
>
> Hello,
>
> I am having trouble with vtlib and vtiger 6.3.
>
> I am trying to add a picklist field in the Leads module.
>
> All is well except no values are stored in the database nor table
> inserted.  Having tried three new instances of vtiger I am now wondering
> if there has been an alteration in vtlib for 6.x.  It maybe something
> that I am missing.  Has anyone had anything similar?
>
> My code is:
>
>     <?php
>
>     include_once('vtlib/Vtiger/Module.php');
>     include_once('vtlib/Vtiger/Utils.php');
>
>     $module = Vtiger_Module::getInstance('Leads');
>
>     $blockInstance =  new vtiger_block();
>
>     $blockInstance->label = 'LBL_TEST_PICKLIST';
>     $module ->addBlock($blockInstance);
>
>     $fieldInstance = new Vtiger_Field();
>     $fieldInstance->name = 'test_picklist_field ';
>     $fieldInstance->label = 'Test Picklist Field';
>     $fieldInstance->column = 'test_picklist_field';
>     $fieldInstance->columntype = 'VARCHAR(50)';
>     $fieldInstance-> table =  $module->basetable;
>     $fieldInstance->uitype = 16;
>     $fieldInstance->typeofdata = 'V~O';
>     $blockInstance->addField($fieldInstance);
>     echo "Added field <br />";
>     $fieldInstance->setPicklistValues( Array ('Value1', 'Value2') );
>
>     Tia
>
>
>
> _______________________________________________
> http://www.vtiger.com/
>


-- 
Libertus Solutions
http://www.libertus.co.uk