What's new in Customer Journeys?

Connect and learn more! ×
Error running query — Cloud Customer Connect
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
23
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!