Advertisement
Guest User

Untitled

a guest
Jan 22nd, 2019
121
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
JSON 4.65 KB | None | 0 0
  1. {
  2.   "id": false,
  3.   "error": [
  4.     {
  5.       "code": "0x000000",
  6.       "message": "SQLSTATE[22P02]: Invalid text representation: 7 ERROR:  invalid input syntax for integer: \"\\u0410\\u0431\\u0445\\u0430\\u0437\\u0438\\u044f, \\u0410\\u0431\\u0445\\u0430\\u0437\\u0438\\u044f, \\u0413\\u0443\\u0434\\u0430\\u0443\\u0442\\u0430\" (SQL: SELECT count(*) as count FROM adverts \\/*FROM*\\/\\/*ADD FROM*\\/ WHERE\r\n            \r\n                        (\r\n                            adverts.category_id = :category_id1\r\n                            \r\n                            AND\r\n                            (\r\n                                adverts.subcategory_id = :subcategory_id3\r\n                                \\/*ADD WHERE CATALOG23*\\/\r\n                                \\/*OR WHERE CATALOG2*\\/\r\n                            )\r\n                            \r\n                            \\/*OR WHERE CATALOG1*\\/\r\n                        )\r\n            AND adverts.amount_kzt >= :fromPrice AND adverts.amount_kzt <= :toPrice AND adverts.section_id = :section_id AND adverts.city_id = :city_id AND adverts.published = :published  AND adverts.paid_service_raise_active = true \\/*ORDERBY*\\/)"
  7.     },
  8.     {
  9.       "code": "0x000000",
  10.       "message": "SQLSTATE[22P02]: Invalid text representation: 7 ERROR:  invalid input syntax for integer: \"\\u0410\\u0431\\u0445\\u0430\\u0437\\u0438\\u044f, \\u0410\\u0431\\u0445\\u0430\\u0437\\u0438\\u044f, \\u0413\\u0443\\u0434\\u0430\\u0443\\u0442\\u0430\" (SQL: SELECT count(*) as count FROM adverts \\/*FROM*\\/\\/*ADD FROM*\\/ WHERE\r\n            \r\n                        (\r\n                            adverts.category_id = :category_id1\r\n                            \r\n                            AND\r\n                            (\r\n                                adverts.subcategory_id = :subcategory_id3\r\n                                \\/*ADD WHERE CATALOG23*\\/\r\n                                \\/*OR WHERE CATALOG2*\\/\r\n                            )\r\n                            \r\n                            \\/*OR WHERE CATALOG1*\\/\r\n                        )\r\n            AND adverts.amount_kzt >= :fromPrice AND adverts.amount_kzt <= :toPrice AND adverts.section_id = :section_id AND adverts.city_id = :city_id AND adverts.published = :published  AND ( adverts.paid_service_raise_active is null or adverts.paid_service_raise_active = false ) \\/*ADD WHERE*\\/ \\/*ORDERBY*\\/)"
  11.     },
  12.     {
  13.       "code": "0x000000",
  14.       "message": "SQLSTATE[22P02]: Invalid text representation: 7 ERROR:  invalid input syntax for integer: \"\\u0410\\u0431\\u0445\\u0430\\u0437\\u0438\\u044f, \\u0410\\u0431\\u0445\\u0430\\u0437\\u0438\\u044f, \\u0413\\u0443\\u0434\\u0430\\u0443\\u0442\\u0430\" (SQL: ((SELECT  adverts.* \\/*ADD SELECT*\\/ FROM adverts \\/*FROM*\\/\\/*ADD FROM*\\/ WHERE\r\n            \r\n                        (\r\n                            adverts.category_id = :category_id1\r\n                            \r\n                            AND\r\n                            (\r\n                                adverts.subcategory_id = :subcategory_id3\r\n                                \\/*ADD WHERE CATALOG23*\\/\r\n                                \\/*OR WHERE CATALOG2*\\/\r\n                            )\r\n                            \r\n                            \\/*OR WHERE CATALOG1*\\/\r\n                        )\r\n            AND adverts.amount_kzt >= :fromPrice AND adverts.amount_kzt <= :toPrice AND adverts.section_id = :section_id AND adverts.city_id = :city_id AND adverts.published = :published  AND adverts.paid_service_raise_active = true ORDER BY adverts.created ASC) UNION ALL (SELECT  adverts.* \\/*ADD SELECT*\\/ FROM adverts \\/*FROM*\\/\\/*ADD FROM*\\/ WHERE\r\n            \r\n                        (\r\n                            adverts.category_id = :category_id1\r\n                            \r\n                            AND\r\n                            (\r\n                                adverts.subcategory_id = :subcategory_id3\r\n                                \\/*ADD WHERE CATALOG23*\\/\r\n                                \\/*OR WHERE CATALOG2*\\/\r\n                            )\r\n                            \r\n                            \\/*OR WHERE CATALOG1*\\/\r\n                        )\r\n            AND adverts.amount_kzt >= :fromPrice AND adverts.amount_kzt <= :toPrice AND adverts.section_id = :section_id AND adverts.city_id = :city_id AND adverts.published = :published  AND ( adverts.paid_service_raise_active is null or adverts.paid_service_raise_active = false ) \\/*ADD WHERE*\\/ ORDER BY adverts.created ASC)) OFFSET :page LIMIT :list)"
  15.     }
  16.   ]
  17. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement