We'd love to hear from you! Provide  feedback  to earn a badge today. Take our quick survey
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Error running query

Received Response
1
Views
3
Comments

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') 

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!