Fast Forms
Posted: Mon Nov 19, 2018 1:04 am
Hi Steven,
i cant create fastforms properly.
i get
'SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'sbr_align' at row 1'
looking into this the table sbr_align is CHAR(1) but examining the code in nubuilders.php
the routine is trying to insert 'left' (four characters) into a one character field thus generating the error
altering this to appears to correct the issue
i cant create fastforms properly.
i get
'SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'sbr_align' at row 1'
looking into this the table sbr_align is CHAR(1) but examining the code in nubuilders.php
Code: Select all
$sql = "
INSERT
INTO zzzzsys_browse
(zzzzsys_browse_id,
sbr_zzzzsys_form_id,
sbr_title,
sbr_display,
sbr_align,
sbr_format,
sbr_order,
sbr_width)
VALUES
(?, ?, ?, ?, ?, ?, ?, ?)
";
$array = Array(nuID(), $form_id, $lab, $id, 'left', '', ($i+1) * 10, 250);
nuRunQuery($sql, $array);altering this to appears to correct the issue
Code: Select all
$array = Array(nuID(), $form_id, $lab, $id, 'l', '', ($i+1) * 10, 250);