This is driving me crazy and has effectively stopped me working
How do i use decimal fields with the new database manager?
No type of decimal field is available in the picker
If i set them externally via navicat
then type appears blank in the properties
and I get weird errors in server actions when updating
{“code”:“22007”,“file”:“C:\woodburn\woodburnrenewables.co.uk\public_html\dmxConnectLib\lib\db\Connection.php”,“line”:114,“message”:“SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect decimal value: ‘’ for column woodburnrenewables.models.output_min at row 1”,“trace”:"#0 C:\woodburn\woodburnrenewables.co.uk\public_html\dmxConnectLib\lib\db\Connection.php(114): PDOStatement->execute()\n#1 C:\woodburn\woodburnrenewables.co.uk\public_html\dmxConnectLib\modules\dbupdater.php(68): lib\db\Connection->execute(‘UPDATE models…’, Array)\n#2 C:\woodburn\woodburnrenewables.co.uk\public_html\dmxConnectLib\lib\App.php(173): modules\dbupdater->update(Object(stdClass), ‘update_model_by…’)\n#3 C:\woodburn\woodburnrenewables.co.uk\public_html\dmxConnectLib\lib\App.php(137): lib\App->execSteps(Object(stdClass))\n#4 C:\woodburn\woodburnrenewables.co.uk\public_html\dmxConnectLib\lib\App.php(107): lib\App->execSteps(Array)\n#5 C:\woodburn\woodburnrenewables.co.uk\public_html\dmxConnectLib\lib\App.php(72): lib\App->exec(Object(stdClass))\n#6 C:\woodburn\woodburnrenewables.co.uk\public_html\dmxConnect\api\admin\save_model.php(8): lib\App->define(Object(stdClass))\n#7 {main}"}
There is no datetime fields in the table
Last updated: