Forum

Thread tagged as: Error, Runway

Collections importer - Column 'itemCreatedBy' cannot be null

Hi,

I've noticed when using the Collections import API, that if I don't log in to Perch from the same machine, I'll find an error like this somewhere along the line

ItemPerchContent_CollectionItem Object ( [table:protected] => perch3_collection_items [pk:protected] => itemRowID [latest_rev] => [rev] => [db:protected] => PerchDB_MySQL Object ( [link:PerchDB_MySQL:private] => PDO Object ( ) [errored] => 1 [error_msg] => SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'itemCreatedBy' cannot be null [error_code] => [config:PerchDB_MySQL:private] => Array ( ) [dsn] => mysql:host=localhost;dbname=dhprojei_mallorca; ) [details:protected] => Array ( [itemRowID] => 2107 [itemID] => 1961 [itemRev] => 1 [collectionID] => 2 [itemJSON] => [itemSearch] => [itemUpdated] => 2018-01-21 21:55:06 [itemUpdatedBy] => 1 ) [index_table:protected] => [optimize_index:protected] => 1 [api:protected] => [event_prefix:protected] => [suppress_events] => 1 [can_log_resources:protected] => 1 [modified_date_column:protected] => [pk_is_int:protected] => 1 [exclude_from_api:protected] => Array ( ) [prefix_vars] => 1 )

I wondered if that's expected, maybe I'm supposed to authenticate in code when using the API?

I'm on Runway 3.0.10 (planning to upgrade soon for the import api updates)

Matt Keehan

Matt Keehan 0 points

  • 3 years ago
Duncan Revell

Duncan Revell 78 points
Registered Developer

Runway 3.0.11:

Runway: fixes an issue where the Collection Import API required a logged in user

Boom!!