Warning: pg_query() [function.pg-query]: Query failed: ERROR: insert or update on table "stores" violates foreign key constraint "portable_stores_fkey_artist_id"
DETAIL: Key (artist_id)=(0) is not present in table "tblartist".
CONTEXT: SQL statement "insert into stores (artist_id, name) values (artist_id_in, name_in)"
PL/pgSQL function "store_assert" line 12 at SQL statement
SQL statement "insert into stores (artist_id, name, parent_id) select artist_id_in, name_in, store_assert(artist_id_in, 'DEFAULT')"
PL/pgSQL function "store_assert" line 26 at SQL statement in /home/nrp/versions/v3_1_27/www/nrp/includes/APP_Database.php on line 443
Warning: pg_query() [function.pg-query]: Query failed: ERROR: invalid input syntax for integer: ""
LINE 1: /*NO LOAD BALANCE*/ select * from stores where id = ''
^ in /home/nrp/versions/v3_1_27/www/nrp/includes/APP_Database.php on line 443
Fatal error: Uncaught exception 'Exception' with message 'Error while retrieveing a record. <!-- stores:id: -->' in /home/nrp/versions/v3_1_27/www/nrp/includes/APP.php:180
Stack trace:
#0 /home/nrp/versions/v3_1_27/www/nrp/includes/APP_Database.php(159): APP_Toolset->bail('Error while ret...')
#1 /home/nrp/versions/v3_1_27/www/nrp/includes/DBEntity.php(64): APP_Database->entity('stores', NULL, 'id')
#2 /home/nrp/versions/v3_1_27/www/nrp/models/PortableStore.php(89): DBEntity->reload(NULL)
#3 /home/nrp/versions/v3_1_27/www/nrp/views/artists/index.php(24): Store->load_artist_default(0)
#4 /home/nrp/versions/v3_1_27/www/nrp/dispatch.php(188): include('/home/nrp/versi...')
#5 {main}
thrown in /home/nrp/versions/v3_1_27/www/nrp/includes/APP.php on line 180