Warning (2): pg_query() [http://php.net/function.pg-query]: Query failed: ERROR: insert or update on table "quicks_votes" violates foreign key constraint "quicks_votes_user_id_fkey"
DETAIL: Key (user_id)=(0) is not present in table "users". [CORE/cake/libs/model/datasources/dbo/dbo_postgres.php, line 156]
Code |
Context$sql = "INSERT INTO "quicks_votes" ("user_id", "quick_id", "vote") VALUES ('0', '545', '1')"pg_query - [internal], line ??
DboPostgres::_execute() - CORE/cake/libs/model/datasources/dbo/dbo_postgres.php, line 156
DboSource::execute() - CORE/cake/libs/model/datasources/dbo_source.php, line 190
DboSource::create() - CORE/cake/libs/model/datasources/dbo_source.php, line 587
Model::save() - CORE/cake/libs/model/model.php, line 1283
QuicksController::vote() - APP/controllers/quicks_controller.php, line 79
Object::dispatchMethod() - CORE/cake/libs/object.php, line 120
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 227
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 194
[main] - APP/webroot/index.php, line 94
Warning (512): SQL Error: ERROR: insert or update on table "quicks_votes" violates foreign key constraint "quicks_votes_user_id_fkey"
DETAIL: Key (user_id)=(0) is not present in table "users". [CORE/cake/libs/model/datasources/dbo_source.php, line 527]
Code |
Context$sql = "INSERT INTO "quicks_votes" ("user_id", "quick_id", "vote") VALUES ('0', '545', '1')"
$error = "ERROR: insert or update on table "quicks_votes" violates foreign key constraint "quicks_votes_user_id_fkey"
DETAIL: Key (user_id)=(0) is not present in table "users"."
$out = null $out = null;
if ($error) {
trigger_error("<span style = \"color:Red;text-align:left\"><b>SQL Error:</b> {$this->error}</span>", E_USER_WARNING);
DboSource::showQuery() - CORE/cake/libs/model/datasources/dbo_source.php, line 527
DboSource::execute() - CORE/cake/libs/model/datasources/dbo_source.php, line 203
DboSource::create() - CORE/cake/libs/model/datasources/dbo_source.php, line 587
Model::save() - CORE/cake/libs/model/model.php, line 1283
QuicksController::vote() - APP/controllers/quicks_controller.php, line 79
Object::dispatchMethod() - CORE/cake/libs/object.php, line 120
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 227
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 194
[main] - APP/webroot/index.php, line 94
Query: INSERT INTO "quicks_votes" ("user_id", "quick_id", "vote") VALUES ('0', '545', '1')

1
