error.txt

<OpenLife.ApiOnboardingResponse
	URL : "http://dev.openlife.staging.globus-ltd.com/v1/slides"
	MIMEType : "application/json"
	StatusCode : internal server error (500)
	Headers : {
		"X-Rate-Limit-Reset" : "0",
		"X-Rate-Limit-Limit" : "4",
		"Content-Type" : "application/json; charset=UTF-8",
		"Server" : "nginx/1.10.3",
		"X-Rate-Limit-Remaining" : "2",
		"Transfer-Encoding" : "Identity",
		"Date" : "Fri, 16 Jun 2017 11:07:36 GMT",
		"Connection" : "keep-alive",
	}
	Body : {
		"error-info" : [
			"42703",
			7,
			"ERROR:  column pc.address does not exist
LINE 1: ...resentation.id WHERE ((concat('г. ',pc.city, ', ',pc.address...
                                                             ^",
		],
		"code" : 42703,
		"file" : "/var/www/openlife.dev/releases/20170616090832/vendor/yiisoft/yii2/db/Schema.php",
		"message" : "SQLSTATE[42703]: Undefined column: 7 ERROR:  column pc.address does not exist
LINE 1: ...resentation.id WHERE ((concat('г. ',pc.city, ', ',pc.address...
                                                             ^
The SQL being executed was: SELECT "p"."id" FROM ((SELECT "onb_presentation"."id", 100 as order FROM "onb_presentation" WHERE ("onb_presentation"."default"=TRUE) AND ("onb_presentation"."active"=TRUE)) UNION ( SELECT DISTINCT "onb_presentation"."id", (case when  pc.city is null then 900 else 1 end) as order FROM "onb_presentation" LEFT JOIN "presentation_city" "pc" ON pc.presentation_id = onb_presentation.id WHERE ((concat('г. ',pc.city, ', ',pc.address)='Якутск') OR ("onb_presentation"."all_cities"=TRUE)) AND ("onb_presentation"."active"=TRUE) ) UNION ( SELECT DISTINCT "onb_presentation"."id", (case when pr.rank is null then 901 else 2 end) as order FROM "onb_presentation" LEFT JOIN "presentation_rank" "pr" ON pr.presentation_id = onb_presentation.id WHERE (("pr"."rank"='Executive Director (ED)') OR ("onb_presentation"."all_ranks"=TRUE)) AND ("onb_presentation"."active"=TRUE) ) UNION ( SELECT DISTINCT "onb_presentation"."id", (case when ps.structure_id is null then 902 else 3 end) as order FROM "onb_presentation" LEFT JOIN "presentation_structure" "ps" ON ps.presentation_id = onb_presentation.id WHERE ((0=1) OR ("onb_presentation"."all_structures"=TRUE)) AND ("onb_presentation"."active"=TRUE) )) "p" GROUP BY "p"."id" HAVING COUNT(*) >= 3",
		"stack-trace" : [
			"#0 /var/www/openlife.dev/releases/20170616090832/vendor/yiisoft/yii2/db/Command.php(930): yii\db\Schema->convertException(Object(PDOException), 'SELECT "p"."id"...')",
			"#1 /var/www/openlife.dev/releases/20170616090832/vendor/yiisoft/yii2/db/Command.php(405): yii\db\Command->queryInternal('fetchAll', 7)",
			"#2 /var/www/openlife.dev/releases/20170616090832/vendor/yiisoft/yii2/db/Query.php(285): yii\db\Command->queryColumn()",
			"#3 /var/www/openlife.dev/releases/20170616090832/modules/api/common/models/search/SlideSearch.php(103): yii\db\Query->column()",
			"#4 /var/www/openlife.dev/releases/20170616090832/modules/api/common/controllers/SlidesController.php(43): app\modules\api\common\models\search\SlideSearch->search()",
			"#5 [internal function]: app\modules\api\common\controllers\SlidesController->actionIndex()",
			"#6 /var/www/openlife.dev/releases/20170616090832/vendor/yiisoft/yii2/base/InlineAction.php(57): call_user_func_array(Array, Array)",
			"#7 /var/www/openlife.dev/releases/20170616090832/vendor/yiisoft/yii2/base/Controller.php(156): yii\base\InlineAction->runWithParams(Array)",
			"#8 /var/www/openlife.dev/releases/20170616090832/vendor/yiisoft/yii2/base/Module.php(523): yii\base\Controller->runAction('', Array)",
			"#9 /var/www/openlife.dev/releases/20170616090832/vendor/yiisoft/yii2/web/Application.php(102): yii\base\Module->runAction('v1/slides', Array)",
			"#10 /var/www/openlife.dev/releases/20170616090832/vendor/yiisoft/yii2/base/Application.php(380): yii\web\Application->handleRequest(Object(yii\web\Request))",
			"#11 /var/www/openlife.dev/releases/20170616090832/web/index.php(11): yii\base\Application->run()",
			"#12 {main}",
		],
		"previous" : {
			"code" : "42703",
			"file" : "/var/www/openlife.dev/releases/20170616090832/vendor/yiisoft/yii2/db/Command.php",
			"message" : "SQLSTATE[42703]: Undefined column: 7 ERROR:  column pc.address does not exist
LINE 1: ...resentation.id WHERE ((concat('г. ',pc.city, ', ',pc.address...
                                                             ^",
			"stack-trace" : [
				"#0 /var/www/openlife.dev/releases/20170616090832/vendor/yiisoft/yii2/db/Command.php(915): PDOStatement->execute()",
				"#1 /var/www/openlife.dev/releases/20170616090832/vendor/yiisoft/yii2/db/Command.php(405): yii\db\Command->queryInternal('fetchAll', 7)",
				"#2 /var/www/openlife.dev/releases/20170616090832/vendor/yiisoft/yii2/db/Query.php(285): yii\db\Command->queryColumn()",
				"#3 /var/www/openlife.dev/releases/20170616090832/modules/api/common/models/search/SlideSearch.php(103): yii\db\Query->column()",
				"#4 /var/www/openlife.dev/releases/20170616090832/modules/api/common/controllers/SlidesController.php(43): app\modules\api\common\models\search\SlideSearch->search()",
				"#5 [internal function]: app\modules\api\common\controllers\SlidesController->actionIndex()",
				"#6 /var/www/openlife.dev/releases/20170616090832/vendor/yiisoft/yii2/base/InlineAction.php(57): call_user_func_array(Array, Array)",
				"#7 /var/www/openlife.dev/releases/20170616090832/vendor/yiisoft/yii2/base/Controller.php(156): yii\base\InlineAction->runWithParams(Array)",
				"#8 /var/www/openlife.dev/releases/20170616090832/vendor/yiisoft/yii2/base/Module.php(523): yii\base\Controller->runAction('', Array)",
				"#9 /var/www/openlife.dev/releases/20170616090832/vendor/yiisoft/yii2/web/Application.php(102): yii\base\Module->runAction('v1/slides', Array)",
				"#10 /var/www/openlife.dev/releases/20170616090832/vendor/yiisoft/yii2/base/Application.php(380): yii\web\Application->handleRequest(Object(yii\web\Request))",
				"#11 /var/www/openlife.dev/releases/20170616090832/web/index.php(11): yii\base\Application->run()",
				"#12 {main}",
			],
			"type" : "PDOException",
			"line" : 915,
			"name" : "Exception",
		},
		"type" : "yii\db\Exception",
		"line" : 636,
		"name" : "Database Exception",
	}