insert query as described has no results.

No replies
Last seen: 7 years 31 weeks ago
Joined: 2012-04-15

I am followinfg core concept "working with the database"

the insert function as described in the video simply does nothing in my database I have tried a few things.
I apologize if this is a duplicate issue. I need to find out why I cannot simply perform an insert on my database using drupal db abstraction layer.

here is the code snippet I am using:

$a = "600";

$thid = db_insert('field_data_field_sqft')
'entity_type' => 'node',
'bundle' => 'listing',
'field_sqft_value' => $a,
'field_sqft_format' => 'full_html',
'bundle' => 'listing',
'entity_id' => '143',

I found this error in my recent log entries:
PDOException: SQLSTATE[HY000]: General error: 1364 Field 'delta' doesn't have a default value:

Add to playlist

Add to , or

Add to new playlist:

Add to playlist
This is a member-only feature
But, it's easy to become a member

Add to cart:

Contact us

Below are the supported keyboard shortcuts for our video player.

Start / stop video
Go to next video
Go to previous video
Increase or decrease player speed by 20%
Skip ahead or go back by 15 seconds
Jump to a percentage (2 is 20%, for example)
Toggle full screen
Videos Pricing More Search
BuildAModule Logo Icon BuildAModule Logo Icon
Become a member!
1 month
6 months
10% off
12 months
20% off
All memberships come with the following:
24 / 7 access to the entire 1800+ video library
An innovative video player with a rolling transcript
Extensive Drupal and cross-platform training
A thorough and thoughtful training style
Progress tracking
Take notes on specific video sections
Intuitive multi-user management
How many users?
Go solo with a single user, or give multiple team members access through one account and get discounts by bundling multiple users into a single membership.