Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- {
- "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' )",
- "traces": [
- {
- "file": "\/var\/www\/synergy-domains\/pp55\/erp\/core\/db.php",
- "line": "105",
- "function": "exec",
- "class": "ErrorThrowDatabase",
- "type": "->",
- "args": [
- "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' )"
- ]
- },
- {
- "file": "\/var\/www\/synergy-domains\/pp55\/api\/application\/classes\/Db.php",
- "line": "214",
- "function": "execute",
- "class": "Database",
- "type": "->",
- "args": [
- "\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' )"
- ]
- },
- {
- "file": "\/var\/www\/synergy-domains\/pp55\/api\/application\/classes\/Concept\/Base.php",
- "line": "237",
- "function": "getAll",
- "class": "Alsma\\Db",
- "type": "::",
- "args": [
- "\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' )",
- null,
- "1",
- "1",
- "0"
- ]
- },
- {
- "file": "\/var\/www\/synergy-domains\/pp55\/api\/application\/classes\/Concept\/Base.php",
- "line": "350",
- "function": "fetchRawData",
- "class": "Alsma\\Concept\\Base",
- "type": "->",
- "args": [
- "0",
- "1",
- "1",
- "0"
- ]
- },
- {
- "file": "\/var\/www\/synergy-domains\/pp55\/api\/application\/classes\/Concept\/Base.php",
- "line": "517",
- "function": "getData",
- "class": "Alsma\\Concept\\Base",
- "type": "->",
- "args": [
- "0",
- "1",
- "1",
- "0"
- ]
- },
- {
- "file": "\/var\/www\/synergy-domains\/pp55\/api\/application\/classes\/Concept\/Base.php",
- "line": "905",
- "function": "getConcept",
- "class": "Alsma\\Concept\\Base",
- "type": "->",
- "args": []
- },
- {
- "file": "\/var\/www\/synergy-domains\/pp55\/api\/application\/classes\/Concept\/Base.php",
- "line": "72",
- "function": "getConceptData",
- "class": "Alsma\\Concept\\Base",
- "type": "->",
- "args": []
- },
- {
- "file": "\/var\/www\/synergy-domains\/pp55\/api\/application\/classes\/Concept\/CollectorBase.php",
- "line": "102",
- "function": "__construct",
- "class": "Alsma\\Concept\\Base",
- "type": "->",
- "args": [
- "2882303762436816729",
- [],
- null
- ]
- },
- {
- "file": "\/var\/www\/synergy-domains\/pp55\/api\/application\/classes\/Concept\/ScheduleOpenStatus.php",
- "line": "39",
- "function": "__construct",
- "class": "Alsma\\Concept\\CollectorBase",
- "type": "->",
- "args": [
- "2882303762436816729",
- [],
- null
- ]
- },
- {
- "file": "\/var\/www\/synergy-domains\/pp55\/api\/application\/classes\/Concept\/ScheduleOpenStatus.php",
- "line": "74",
- "function": "__construct",
- "class": "Alsma\\Concept\\ScheduleOpenStatus",
- "type": "->",
- "args": [
- "2882303762436816729"
- ]
- },
- {
- "file": "\/var\/www\/synergy-domains\/pp55\/api\/application\/classes\/Concept\/SpSelector.php",
- "line": "965",
- "function": "getFilteredData",
- "class": "Alsma\\Concept\\ScheduleOpenStatus",
- "type": "->",
- "args": [
- "2882303762436816729",
- null,
- null,
- [],
- null,
- "50",
- "1",
- "-1",
- "-1"
- ]
- },
- {
- "file": "\/var\/www\/synergy-domains\/pp55\/api\/application\/controllers\/ViewController.php",
- "line": "383",
- "function": "run",
- "class": "Alsma\\Concept\\SpSelector",
- "type": "->",
- "args": [
- "2882303762436816729",
- null,
- null,
- [],
- null,
- "50",
- "1",
- "-1",
- "-1"
- ]
- },
- {
- "function": "exploreAction",
- "class": "Alsma\\ViewController",
- "type": "->",
- "args": []
- },
- {
- "file": "\/var\/www\/synergy-domains\/pp55\/erp\/core\/BaseController.php",
- "line": "87",
- "function": "call_user_func",
- "args": [
- [
- {},
- "exploreAction"
- ]
- ]
- },
- {
- "file": "\/var\/www\/synergy-domains\/pp55\/api\/application\/controllers\/BaseController.php",
- "line": "272",
- "function": "invokeAction",
- "class": "ERP_Core_BaseController",
- "type": "->",
- "args": [
- "explore"
- ]
- },
- {
- "file": "\/var\/www\/synergy-domains\/pp55\/erp\/core\/Application.php",
- "line": "169",
- "function": "invokeAction",
- "class": "Alsma\\BaseController",
- "type": "->",
- "args": [
- "explore"
- ]
- },
- {
- "file": "\/var\/www\/synergy-domains\/pp55\/api\/application\/MainApplication.php",
- "line": "193",
- "function": "processURI",
- "class": "ERP_Core_Application",
- "type": "->",
- "args": []
- },
- {
- "file": "\/var\/www\/synergy-domains\/pp55\/erp\/core\/Application.php",
- "line": "59",
- "function": "processURI",
- "class": "Alsma\\MainApplication",
- "type": "->",
- "args": []
- },
- {
- "file": "\/var\/www\/synergy-domains\/pp55\/api\/api.php",
- "line": "5",
- "function": "run",
- "class": "ERP_Core_Application",
- "type": "->",
- "args": []
- }
- ],
- "error_id": "-1",
- "common_fw_time": 0.12844300270081,
- "ts": 1542703724805
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement