Error running query
Summary:
Hello,
I am getting " Error running query" when inserting a new custom object record because some Integer field is missing a default value, though, making it required.
Field is set as Is Nullable in Object designed and has no other settings added.
I am attaching error log:
DB API Error
SQL Fcn: execute() [SQLStatement.cpp: 902]
Called By: iapiu_pair_create() [iapi_subtbl.c: 461]
Program: php
API Fcn.: _sql_execute() returned 1364
SQL Error: Field 'Power_KW' doesn't have a default value
Error: Error running query
Errno: 0
SQL Stmt.: INSERT INTO CO$Vehicle ( Brand, Color, CreatedTime, Cylindrical_Capacity, FuelType, Manufacturing_Year, Maximum_Load, Maximum_Weight_MMA, Model, Registration_Number, Used_for, VIN, Vehicle_Status, Vehicle_Weight_MP) VALUES ( 34, 1, CONVERT_TZ('2021-11-14 13:53:57', @@time_zone, @@time_zone), 2200, 2, 2010, 4, '1', 37, :Registration_Number, 16, :VIN, 1, '1800')