{"name":"Database Exception","message":"SQLSTATE[22P02]: Invalid text representation: 7 ERROR:  invalid input syntax for integer: \"\/instagram.com\/p\/BJ1X4Phgnea\/\/\"\nThe SQL being executed was: select row_to_json(result) \"data\" from (select \"now\", '\/v1\/search\/collection\/'||(json(posts->>json_array_length(posts)-1)->>'post_id')::bigint-1 \"next\" , posts from (select floor(extract(epoch from now())) \"now\", array_to_json (array_agg(post)) posts from (select row_to_json (post) post from (select post.id \"post_id\" , post.user_id, post.status ,post.created_at \"created_at\" ,post.updated_at \"updated_at\",(select row_to_json(counts) counts from (select post.count_like \"like\" , post.count_comment \"comment\" , post.count_wish \"wish\" , post.count_order \"shop\" ,(select count(case when post_like.user_id = 1906 then 1 end) \"liked\" from post_like where post_like.post_id = post.id) \"liked\" ) counts),(select row_to_json(\"user\") \"user\" from (select u.\"username\", \"u\".id \"user_id\" , (select \"thumbnail\" \"profile_picture\" from \"imagec_user\" WHERE \"imagec_user\".\"id\" = \"u\".id) \"profile_picture\", (case when 1906 != \"u\".id then coalesce((select true from \"user_follow\" where \"u\".id = user_follow.user_id_following and user_follow.user_id = 1906)::boolean,false)end) followed from \"user\" u where \"u\".id = post.user_id) \"user\") \"user\" ,(select array_to_json (array_agg(com)) \"comments\" from (select row_to_json(com) \"comment\" from ( select id , comment_out(\"comment\") \"text\" ,created_at \"created_at\" , case post_comment_status when 0 then 'comment' when 10 then 'fabric' when 11 then 'description' when 20 then 'title' when 21 then 'other' when 1 then 'first' when -1 then 'deleted' end \"type\" ,(select row_to_json(\"user\") \"user\" from (select u.\"username\", \"u\".id \"user_id\" , (select \"thumbnail\" \"profile_picture\" from \"imagec_user\" WHERE \"imagec_user\".\"id\" = \"u\".id) \"profile_picture\", (case when 1906 != \"u\".id then coalesce((select true from \"user_follow\" where \"u\".id = user_follow.user_id_following and user_follow.user_id = 1906)::boolean,false)end) followed from \"user\" u where \"u\".id = post_comment.user_id) \"user\") \"user\" from post_comment where post_comment.post_id = post.id and post_comment_status between 0 and 19 ORDER BY post_comment.post_comment_status , post_comment.id DESC LIMIT 3 ) com ) com ) \"comments\",(select array_to_json (array_agg(image)) images from (select row_to_json(image) image from (select \"type\", \"id\" image_id ,case when attribs::char(2) = '[]' then null else attribs end attribs , json('{\"url\":\"' || \"original\" || '\",\"size\":'||coalesce(\"original_size\",'null')||'}') \"original\" , json('{\"url\":\"' || \"low_resolution\" || '\",\"size\":'||coalesce(\"low_resolution_size\",'null')||'}') \"low_resolution\" , json('{\"url\":\"' || \"thumbnail\" || '\",\"size\":'||coalesce(\"thumbnail_size\",'null')||'}') \"thumbnail\" , json('{\"url\":\"' || \"standard_resolution\" || '\",\"size\":'||coalesce(\"standard_resolution_size\",'null')||'}') \"standard_resolution\" from imagec where imagec.post_id = post.id and imagec_status = 0 order by position) image ) image ) images ,(select array_to_json (array_agg(items)) items from (select row_to_json(item) item FROM (select post_link.id \"link_id\" , post_link.post_id_linked \"post_id\", (select row_to_json(price) price from (select round(cast(ceil(case when post_link.pricing_type = '%' THEN (1+post_link.pricing_attribute::float\/100) ELSE NULL END *price*currency_xch(post_price.currency,'AUD'::char(3)) )* (1\/(1+store.discount*0.15)) as numeric),2) show_price, 'AUD'::char(3) show_currency , '' subtitle, case when attribs::char(2) = '[]' then null else attribs end attribs, \"flags\" from post_price , \"user\" store where store.id = post_price.user_id_store and post_price.post_id = post_item.id and post_price.type = 0) \"price\" ) \"price\",(select array_to_json (array_agg(com)) \"comments\" from (select row_to_json(com) \"comment\" from ( select id , comment_out(\"comment\") \"text\" ,created_at \"created_at\" , case post_comment_status when 0 then 'comment' when 10 then 'fabric' when 11 then 'description' when 20 then 'title' when 21 then 'other' when 1 then 'first' when -1 then 'deleted' end \"type\" ,(select row_to_json(\"user\") \"user\" from (select u.\"username\", \"u\".id \"user_id\" , (select \"thumbnail\" \"profile_picture\" from \"imagec_user\" WHERE \"imagec_user\".\"id\" = \"u\".id) \"profile_picture\", (case when 1906 != \"u\".id then coalesce((select true from \"user_follow\" where \"u\".id = user_follow.user_id_following and user_follow.user_id = 1906)::boolean,false)end) followed from \"user\" u where \"u\".id = post_comment.user_id) \"user\") \"user\" from post_comment where post_comment.post_id = post_item.id and post_comment_status between 0 and 19 ORDER BY post_comment.post_comment_status , post_comment.id DESC LIMIT 3 ) com ) com ) \"comments\",(select row_to_json(counts) counts from (select post_item.count_like \"like\" , post_item.count_comment \"comment\" , post_item.count_wish \"wish\" , post_item.count_order \"shop\" ,(select count(case when post_like.user_id = 1906 then 1 end) \"liked\" from post_like where post_like.post_id = post_item.id) \"liked\" ) counts),(select array_to_json (array_agg(image)) images from (select row_to_json(image) image from (select \"type\", \"id\" image_id ,case when attribs::char(2) = '[]' then null else attribs end attribs , json('{\"url\":\"' || \"original\" || '\",\"size\":'||coalesce(\"original_size\",'null')||'}') \"original\" , json('{\"url\":\"' || \"low_resolution\" || '\",\"size\":'||coalesce(\"low_resolution_size\",'null')||'}') \"low_resolution\" , json('{\"url\":\"' || \"thumbnail\" || '\",\"size\":'||coalesce(\"thumbnail_size\",'null')||'}') \"thumbnail\" , json('{\"url\":\"' || \"standard_resolution\" || '\",\"size\":'||coalesce(\"standard_resolution_size\",'null')||'}') \"standard_resolution\" from imagec where imagec.post_id = post_item.id and imagec_status = 0 order by position) image ) image ) images from post_link , \"user\" user_shop, \"post\" post_item where post_link.post_id = post.id and post_link.post_id_linked = post_item.id and post_item.user_id = user_shop.id and post_link.position != -1 ) item ) items) from post , \"user\" , post_collection where post.user_id = \"user\".id and post_collection.collection = (select collection from post_collection pc where pc.id = '\/instagram.com\/p\/BJ1X4Phgnea\/\/') and \"user\".user_type = 'p' and post.status = 1 and post_collection.post_id = post.id) post ORDER BY post.post_id DESC LIMIT 30 ) posts ) result) result","code":22,"type":"yii\\db\\Exception","file":"\/var\/app\/current\/vendor\/yiisoft\/yii2\/db\/Schema.php","line":633,"stack-trace":["#0 \/var\/app\/current\/vendor\/yiisoft\/yii2\/db\/Command.php(915): yii\\db\\Schema->convertException(Object(PDOException), 'select row_to_j...')","#1 \/var\/app\/current\/vendor\/yiisoft\/yii2\/db\/Command.php(362): yii\\db\\Command->queryInternal('fetchAll', NULL)","#2 \/var\/app\/current\/common\/models\/Lists.php(1560): yii\\db\\Command->queryAll()","#3 \/var\/app\/current\/rest\/versions\/v1\/controllers\/SearchController.php(176): common\\models\\Lists->getCollectionFeed(Object(common\\models\\User), '', '\/instagram.com\/...', '\/v1\/search\/coll...', '', 1)","#4 [internal function]: rest\\versions\\v1\\controllers\\SearchController->actionCollection('')","#5 \/var\/app\/current\/vendor\/yiisoft\/yii2\/base\/InlineAction.php(55): call_user_func_array(Array, Array)","#6 \/var\/app\/current\/vendor\/yiisoft\/yii2\/base\/Controller.php(154): yii\\base\\InlineAction->runWithParams(Array)","#7 \/var\/app\/current\/vendor\/yiisoft\/yii2\/base\/Module.php(454): yii\\base\\Controller->runAction('collection', Array)","#8 \/var\/app\/current\/vendor\/yiisoft\/yii2\/web\/Application.php(87): yii\\base\\Module->runAction('v1\/search\/colle...', Array)","#9 \/var\/app\/current\/vendor\/yiisoft\/yii2\/base\/Application.php(375): yii\\web\\Application->handleRequest(Object(yii\\web\\Request))","#10 \/var\/app\/current\/rest\/web\/index.php(22): yii\\base\\Application->run()","#11 {main}"],"error-info":["22P02",7,"ERROR:  invalid input syntax for integer: \"\/instagram.com\/p\/BJ1X4Phgnea\/\/\""],"previous":{"name":"Exception","message":"SQLSTATE[22P02]: Invalid text representation: 7 ERROR:  invalid input syntax for integer: \"\/instagram.com\/p\/BJ1X4Phgnea\/\/\"","code":"22P02","type":"PDOException","file":"\/var\/app\/current\/vendor\/yiisoft\/yii2\/db\/Command.php","line":900,"stack-trace":["#0 \/var\/app\/current\/vendor\/yiisoft\/yii2\/db\/Command.php(900): PDOStatement->execute()","#1 \/var\/app\/current\/vendor\/yiisoft\/yii2\/db\/Command.php(362): yii\\db\\Command->queryInternal('fetchAll', NULL)","#2 \/var\/app\/current\/common\/models\/Lists.php(1560): yii\\db\\Command->queryAll()","#3 \/var\/app\/current\/rest\/versions\/v1\/controllers\/SearchController.php(176): common\\models\\Lists->getCollectionFeed(Object(common\\models\\User), '', '\/instagram.com\/...', '\/v1\/search\/coll...', '', 1)","#4 [internal function]: rest\\versions\\v1\\controllers\\SearchController->actionCollection('')","#5 \/var\/app\/current\/vendor\/yiisoft\/yii2\/base\/InlineAction.php(55): call_user_func_array(Array, Array)","#6 \/var\/app\/current\/vendor\/yiisoft\/yii2\/base\/Controller.php(154): yii\\base\\InlineAction->runWithParams(Array)","#7 \/var\/app\/current\/vendor\/yiisoft\/yii2\/base\/Module.php(454): yii\\base\\Controller->runAction('collection', Array)","#8 \/var\/app\/current\/vendor\/yiisoft\/yii2\/web\/Application.php(87): yii\\base\\Module->runAction('v1\/search\/colle...', Array)","#9 \/var\/app\/current\/vendor\/yiisoft\/yii2\/base\/Application.php(375): yii\\web\\Application->handleRequest(Object(yii\\web\\Request))","#10 \/var\/app\/current\/rest\/web\/index.php(22): yii\\base\\Application->run()","#11 {main}"]}}