insert query as described has no results.

No replies
info90
Offline
Last seen: 4 years 27 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')
->fields(array(
'entity_type' => 'node',
'bundle' => 'listing',
'field_sqft_value' => $a,
'field_sqft_format' => 'full_html',
'bundle' => 'listing',
'entity_id' => '143',
))
->execute();

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:


Loading...
Contact us

Below are the supported keyboard shortcuts for our video player.

space
Start / stop video
shift
Go to next video
shift
Go to previous video
Increase or decrease player speed by 20%
Skip ahead or go back by 15 seconds
1...9
Jump to a percentage (2 is 20%, for example)
f
Toggle full screen
Videos Pricing More Search
BuildAModule Logo Icon BuildAModule Logo Icon
Become a member!
$29
1 month
$156
6 months
10% off
$276
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?
user
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.