androlizer

Untitled

Oct 20th, 2016
40
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 4.12 KB | None | 0 0
  1. {"name":"Database Exception","message":"SQLSTATE[21000]: Cardinality violation: 7 ERROR:  more than one row returned by a subquery used as an expression\nThe SQL being executed was: select round(cast(sum((select 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)) show_price \n\t\tfrom post_price , \"user\" store where store.id = post_price.user_id_store and post_price.post_id = post_link.post_id_linked and post_price.type = 0)*order_line.quantity) as numeric),2) p_total\n\t\tfrom order_line, \"order\" , post_link , post post_stylist, post post_item\nwhere \n\"order\".user_id = 1906\nand order_line.order_id = \"order\".id\nand post_link.id = order_line.post_link_id\nand post_link.post_id = post_stylist.id\nand post_link.post_id_linked = post_item.id\nand \"order\".order_type = 'cart'","code":21000,"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 round(ca...')","#1 \/var\/app\/current\/vendor\/yiisoft\/yii2\/db\/Command.php(376): yii\\db\\Command->queryInternal('fetch', NULL)","#2 \/var\/app\/current\/common\/models\/Lists.php(252): yii\\db\\Command->queryOne()","#3 \/var\/app\/current\/rest\/versions\/v1\/controllers\/ListController.php(43): common\\models\\Lists->getListCart(Object(common\\models\\UserAuth), Object(common\\models\\UserAuth))","#4 [internal function]: rest\\versions\\v1\\controllers\\ListController->actionGetlist('user', 'self', 'cart', '', 27, false, NULL, '')","#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('getlist', Array)","#8 \/var\/app\/current\/vendor\/yiisoft\/yii2\/web\/Application.php(87): yii\\base\\Module->runAction('v1\/list\/getlist', 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":["21000",7,"ERROR:  more than one row returned by a subquery used as an expression"],"previous":{"name":"Exception","message":"SQLSTATE[21000]: Cardinality violation: 7 ERROR:  more than one row returned by a subquery used as an expression","code":"21000","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(376): yii\\db\\Command->queryInternal('fetch', NULL)","#2 \/var\/app\/current\/common\/models\/Lists.php(252): yii\\db\\Command->queryOne()","#3 \/var\/app\/current\/rest\/versions\/v1\/controllers\/ListController.php(43): common\\models\\Lists->getListCart(Object(common\\models\\UserAuth), Object(common\\models\\UserAuth))","#4 [internal function]: rest\\versions\\v1\\controllers\\ListController->actionGetlist('user', 'self', 'cart', '', 27, false, NULL, '')","#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('getlist', Array)","#8 \/var\/app\/current\/vendor\/yiisoft\/yii2\/web\/Application.php(87): yii\\base\\Module->runAction('v1\/list\/getlist', 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}"]}}
Add Comment
Please, Sign In to add comment