Forum
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)
Runway 3.0.11:
Boom!!