Advertisement
Guest User

Untitled

a guest
Nov 20th, 2018
81
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 8.06 KB | None | 0 0
  1. {
  2. "error": "Alsma:: PGSQL_EMPTY_QUERY\nERROR: column reference \"is_24h\" is ambiguous\nLINE 1: ...array_agg(row_to_json(d))) AS Intervals, bool_and(is_24h) AS...\n ^\nDETAIL: It could refer to either a PL\/pgSQL variable or a table column.\nQUERY: SELECT array_to_json(array_agg(row_to_json(d))) AS Intervals, bool_and(is_24h) AS is_24h FROM (\n SELECT\n val(GREATEST(x_from, t_from)) AS \"from\",\n val(LEAST(x_to, t_to)) AS \"to\",\n t_from <= x_from AND t_to >= x_to AS is_24h\n FROM cts_schedule_cache_class_intervals scci\n WHERE t_s.ct_last_sc_id = ct_schedule_cache_id AND x_from <= t_to AND x_to > t_from AND ct_classification_id = 2882303762435771950\n ORDER BY val(t_from) NULLS FIRST\n ) d\nCONTEXT: PL\/pgSQL function s_check_open_now_faze2(bigint) line 57 at SQL statement\nSELECT f.* FROM cts_schedules s_schedules, s_check_open_now_faze2(s_schedules.id) as f\n\t\t\t where ( s_schedules.id = '2882303762436816729' )",
  3. "traces": [
  4. {
  5. "file": "\/var\/www\/synergy-domains\/pp55\/erp\/core\/db.php",
  6. "line": "105",
  7. "function": "exec",
  8. "class": "ErrorThrowDatabase",
  9. "type": "->",
  10. "args": [
  11. "SELECT f.* FROM cts_schedules s_schedules, s_check_open_now_faze2(s_schedules.id) as f\n\t\t\t where ( s_schedules.id = '2882303762436816729' )"
  12. ]
  13. },
  14. {
  15. "file": "\/var\/www\/synergy-domains\/pp55\/api\/application\/classes\/Db.php",
  16. "line": "214",
  17. "function": "execute",
  18. "class": "Database",
  19. "type": "->",
  20. "args": [
  21. "\n\t\t\t\tSELECT f.* FROM cts_schedules s_schedules, s_check_open_now_faze2(s_schedules.id) as f\n\t\t\t where ( s_schedules.id = '2882303762436816729' )"
  22. ]
  23. },
  24. {
  25. "file": "\/var\/www\/synergy-domains\/pp55\/api\/application\/classes\/Concept\/Base.php",
  26. "line": "237",
  27. "function": "getAll",
  28. "class": "Alsma\\Db",
  29. "type": "::",
  30. "args": [
  31. "\n\t\t\t\tSELECT f.* FROM cts_schedules s_schedules, s_check_open_now_faze2(s_schedules.id) as f\n\t\t\t where ( s_schedules.id = '2882303762436816729' )",
  32. null,
  33. "1",
  34. "1",
  35. "0"
  36. ]
  37. },
  38. {
  39. "file": "\/var\/www\/synergy-domains\/pp55\/api\/application\/classes\/Concept\/Base.php",
  40. "line": "350",
  41. "function": "fetchRawData",
  42. "class": "Alsma\\Concept\\Base",
  43. "type": "->",
  44. "args": [
  45. "0",
  46. "1",
  47. "1",
  48. "0"
  49. ]
  50. },
  51. {
  52. "file": "\/var\/www\/synergy-domains\/pp55\/api\/application\/classes\/Concept\/Base.php",
  53. "line": "517",
  54. "function": "getData",
  55. "class": "Alsma\\Concept\\Base",
  56. "type": "->",
  57. "args": [
  58. "0",
  59. "1",
  60. "1",
  61. "0"
  62. ]
  63. },
  64. {
  65. "file": "\/var\/www\/synergy-domains\/pp55\/api\/application\/classes\/Concept\/Base.php",
  66. "line": "905",
  67. "function": "getConcept",
  68. "class": "Alsma\\Concept\\Base",
  69. "type": "->",
  70. "args": []
  71. },
  72. {
  73. "file": "\/var\/www\/synergy-domains\/pp55\/api\/application\/classes\/Concept\/Base.php",
  74. "line": "72",
  75. "function": "getConceptData",
  76. "class": "Alsma\\Concept\\Base",
  77. "type": "->",
  78. "args": []
  79. },
  80. {
  81. "file": "\/var\/www\/synergy-domains\/pp55\/api\/application\/classes\/Concept\/CollectorBase.php",
  82. "line": "102",
  83. "function": "__construct",
  84. "class": "Alsma\\Concept\\Base",
  85. "type": "->",
  86. "args": [
  87. "2882303762436816729",
  88. [],
  89. null
  90. ]
  91. },
  92. {
  93. "file": "\/var\/www\/synergy-domains\/pp55\/api\/application\/classes\/Concept\/ScheduleOpenStatus.php",
  94. "line": "39",
  95. "function": "__construct",
  96. "class": "Alsma\\Concept\\CollectorBase",
  97. "type": "->",
  98. "args": [
  99. "2882303762436816729",
  100. [],
  101. null
  102. ]
  103. },
  104. {
  105. "file": "\/var\/www\/synergy-domains\/pp55\/api\/application\/classes\/Concept\/ScheduleOpenStatus.php",
  106. "line": "74",
  107. "function": "__construct",
  108. "class": "Alsma\\Concept\\ScheduleOpenStatus",
  109. "type": "->",
  110. "args": [
  111. "2882303762436816729"
  112. ]
  113. },
  114. {
  115. "file": "\/var\/www\/synergy-domains\/pp55\/api\/application\/classes\/Concept\/SpSelector.php",
  116. "line": "965",
  117. "function": "getFilteredData",
  118. "class": "Alsma\\Concept\\ScheduleOpenStatus",
  119. "type": "->",
  120. "args": [
  121. "2882303762436816729",
  122. null,
  123. null,
  124. [],
  125. null,
  126. "50",
  127. "1",
  128. "-1",
  129. "-1"
  130. ]
  131. },
  132. {
  133. "file": "\/var\/www\/synergy-domains\/pp55\/api\/application\/controllers\/ViewController.php",
  134. "line": "383",
  135. "function": "run",
  136. "class": "Alsma\\Concept\\SpSelector",
  137. "type": "->",
  138. "args": [
  139. "2882303762436816729",
  140. null,
  141. null,
  142. [],
  143. null,
  144. "50",
  145. "1",
  146. "-1",
  147. "-1"
  148. ]
  149. },
  150. {
  151. "function": "exploreAction",
  152. "class": "Alsma\\ViewController",
  153. "type": "->",
  154. "args": []
  155. },
  156. {
  157. "file": "\/var\/www\/synergy-domains\/pp55\/erp\/core\/BaseController.php",
  158. "line": "87",
  159. "function": "call_user_func",
  160. "args": [
  161. [
  162. {},
  163. "exploreAction"
  164. ]
  165. ]
  166. },
  167. {
  168. "file": "\/var\/www\/synergy-domains\/pp55\/api\/application\/controllers\/BaseController.php",
  169. "line": "272",
  170. "function": "invokeAction",
  171. "class": "ERP_Core_BaseController",
  172. "type": "->",
  173. "args": [
  174. "explore"
  175. ]
  176. },
  177. {
  178. "file": "\/var\/www\/synergy-domains\/pp55\/erp\/core\/Application.php",
  179. "line": "169",
  180. "function": "invokeAction",
  181. "class": "Alsma\\BaseController",
  182. "type": "->",
  183. "args": [
  184. "explore"
  185. ]
  186. },
  187. {
  188. "file": "\/var\/www\/synergy-domains\/pp55\/api\/application\/MainApplication.php",
  189. "line": "193",
  190. "function": "processURI",
  191. "class": "ERP_Core_Application",
  192. "type": "->",
  193. "args": []
  194. },
  195. {
  196. "file": "\/var\/www\/synergy-domains\/pp55\/erp\/core\/Application.php",
  197. "line": "59",
  198. "function": "processURI",
  199. "class": "Alsma\\MainApplication",
  200. "type": "->",
  201. "args": []
  202. },
  203. {
  204. "file": "\/var\/www\/synergy-domains\/pp55\/api\/api.php",
  205. "line": "5",
  206. "function": "run",
  207. "class": "ERP_Core_Application",
  208. "type": "->",
  209. "args": []
  210. }
  211. ],
  212. "error_id": "-1",
  213. "common_fw_time": 0.12844300270081,
  214. "ts": 1542703724805
  215. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement