Warning (2): pg_query() [function.pg-query]: Query failed: ERROR:  invalid input syntax for integer: "-" [CORE/cake/libs/model/datasources/dbo/dbo_postgres.php, line 167]
Code | Context
$sql	=	"SELECT "TrainingProvider"."id" AS "TrainingProvider__id", "TrainingProvider"."name" AS "TrainingProvider__name", "TrainingProvider"."etqa" AS "TrainingProvider__etqa", "TrainingProvider"."decision_number" AS "TrainingProvider__decision_number", "TrainingProvider"."contact_name" AS "TrainingProvider__contact_name", "TrainingProvider"."phone_number" AS "TrainingProvider__phone_number", "TrainingProvider"."fax_number" AS "TrainingProvider__fax_number", "TrainingProvider"."cell_number" AS "TrainingProvider__cell_number", "TrainingProvider"."is_active" AS "TrainingProvider__is_active", "TrainingProvider"."image" AS "TrainingProvider__image", "TrainingProvider"."email" AS "TrainingProvider__email", "TrainingProvider"."website" AS "TrainingProvider__website", "TrainingProvider"."login_name" AS "TrainingProvider__login_name", "TrainingProvider"."login_email" AS "TrainingProvider__login_email", "TrainingProvider"."login_password" AS "TrainingProvider__login_password", "TrainingProvider"."postal_address_1" AS "TrainingProvider__postal_address_1", "TrainingProvider"."postal_address_2" AS "TrainingProvider__postal_address_2", "TrainingProvider"."postal_address_3" AS "TrainingProvider__postal_address_3", "TrainingProvider"."postal_code" AS "TrainingProvider__postal_code", "TrainingProvider"."short_description" AS "TrainingProvider__short_description", "TrainingProvider"."detailed_description" AS "TrainingProvider__detailed_description", "TrainingProvider"."accreditation_id" AS "TrainingProvider__accreditation_id", "TrainingProvider"."html_area" AS "TrainingProvider__html_area", "Accreditation"."id" AS "Accreditation__id", "Accreditation"."name" AS "Accreditation__name" FROM "training_providers" AS "TrainingProvider" LEFT JOIN "accreditations" AS "Accreditation" ON ("TrainingProvider"."accreditation_id" = "Accreditation"."id")  WHERE "TrainingProvider"."id" = '-'    LIMIT 1"
pg_query - [internal], line ??
DboPostgres::_execute() - CORE/cake/libs/model/datasources/dbo/dbo_postgres.php, line 167
DboSource::execute() - CORE/cake/libs/model/datasources/dbo_source.php, line 243
DboSource::fetchAll() - CORE/cake/libs/model/datasources/dbo_source.php, line 400
DboSource::read() - CORE/cake/libs/model/datasources/dbo_source.php, line 805
Model::find() - CORE/cake/libs/model/model.php, line 2084
Model::read() - CORE/cake/libs/model/model.php, line 1122
TrainingProvidersController::course() - APP/controllers/training_providers_controller.php, line 21
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 204
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 171
[main] - APP/webroot/index.php, line 88

Warning (512): SQL Error: ERROR:  invalid input syntax for integer: "-" [CORE/cake/libs/model/datasources/dbo_source.php, line 666]
Code | Context
            $out = null;
            if ($error) {
                trigger_error('<span style="color:Red;text-align:left"><b>' . __('SQL Error:', true) . "</b> {$this->error}</span>", E_USER_WARNING);
$sql	=	"SELECT "TrainingProvider"."id" AS "TrainingProvider__id", "TrainingProvider"."name" AS "TrainingProvider__name", "TrainingProvider"."etqa" AS "TrainingProvider__etqa", "TrainingProvider"."decision_number" AS "TrainingProvider__decision_number", "TrainingProvider"."contact_name" AS "TrainingProvider__contact_name", "TrainingProvider"."phone_number" AS "TrainingProvider__phone_number", "TrainingProvider"."fax_number" AS "TrainingProvider__fax_number", "TrainingProvider"."cell_number" AS "TrainingProvider__cell_number", "TrainingProvider"."is_active" AS "TrainingProvider__is_active", "TrainingProvider"."image" AS "TrainingProvider__image", "TrainingProvider"."email" AS "TrainingProvider__email", "TrainingProvider"."website" AS "TrainingProvider__website", "TrainingProvider"."login_name" AS "TrainingProvider__login_name", "TrainingProvider"."login_email" AS "TrainingProvider__login_email", "TrainingProvider"."login_password" AS "TrainingProvider__login_password", "TrainingProvider"."postal_address_1" AS "TrainingProvider__postal_address_1", "TrainingProvider"."postal_address_2" AS "TrainingProvider__postal_address_2", "TrainingProvider"."postal_address_3" AS "TrainingProvider__postal_address_3", "TrainingProvider"."postal_code" AS "TrainingProvider__postal_code", "TrainingProvider"."short_description" AS "TrainingProvider__short_description", "TrainingProvider"."detailed_description" AS "TrainingProvider__detailed_description", "TrainingProvider"."accreditation_id" AS "TrainingProvider__accreditation_id", "TrainingProvider"."html_area" AS "TrainingProvider__html_area", "Accreditation"."id" AS "Accreditation__id", "Accreditation"."name" AS "Accreditation__name" FROM "training_providers" AS "TrainingProvider" LEFT JOIN "accreditations" AS "Accreditation" ON ("TrainingProvider"."accreditation_id" = "Accreditation"."id")  WHERE "TrainingProvider"."id" = '-'    LIMIT 1"
$error	=	"ERROR:  invalid input syntax for integer: "-""
$out	=	null
DboSource::showQuery() - CORE/cake/libs/model/datasources/dbo_source.php, line 666
DboSource::execute() - CORE/cake/libs/model/datasources/dbo_source.php, line 256
DboSource::fetchAll() - CORE/cake/libs/model/datasources/dbo_source.php, line 400
DboSource::read() - CORE/cake/libs/model/datasources/dbo_source.php, line 805
Model::find() - CORE/cake/libs/model/model.php, line 2084
Model::read() - CORE/cake/libs/model/model.php, line 1122
TrainingProvidersController::course() - APP/controllers/training_providers_controller.php, line 21
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 204
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 171
[main] - APP/webroot/index.php, line 88

Query: SELECT "TrainingProvider"."id" AS "TrainingProvider__id", "TrainingProvider"."name" AS "TrainingProvider__name", "TrainingProvider"."etqa" AS "TrainingProvider__etqa", "TrainingProvider"."decision_number" AS "TrainingProvider__decision_number", "TrainingProvider"."contact_name" AS "TrainingProvider__contact_name", "TrainingProvider"."phone_number" AS "TrainingProvider__phone_number", "TrainingProvider"."fax_number" AS "TrainingProvider__fax_number", "TrainingProvider"."cell_number" AS "TrainingProvider__cell_number", "TrainingProvider"."is_active" AS "TrainingProvider__is_active", "TrainingProvider"."image" AS "TrainingProvider__image", "TrainingProvider"."email" AS "TrainingProvider__email", "TrainingProvider"."website" AS "TrainingProvider__website", "TrainingProvider"."login_name" AS "TrainingProvider__login_name", "TrainingProvider"."login_email" AS "TrainingProvider__login_email", "TrainingProvider"."login_password" AS "TrainingProvider__login_password", "TrainingProvider"."postal_address_1" AS "TrainingProvider__postal_address_1", "TrainingProvider"."postal_address_2" AS "TrainingProvider__postal_address_2", "TrainingProvider"."postal_address_3" AS "TrainingProvider__postal_address_3", "TrainingProvider"."postal_code" AS "TrainingProvider__postal_code", "TrainingProvider"."short_description" AS "TrainingProvider__short_description", "TrainingProvider"."detailed_description" AS "TrainingProvider__detailed_description", "TrainingProvider"."accreditation_id" AS "TrainingProvider__accreditation_id", "TrainingProvider"."html_area" AS "TrainingProvider__html_area", "Accreditation"."id" AS "Accreditation__id", "Accreditation"."name" AS "Accreditation__name" FROM "training_providers" AS "TrainingProvider" LEFT JOIN "accreditations" AS "Accreditation" ON ("TrainingProvider"."accreditation_id" = "Accreditation"."id")  WHERE "TrainingProvider"."id" = '-'    LIMIT 1