SHOW:
|
|
- or go back to the newest paste.
| 1 | - | |
| 1 | + | |
| 2 | - | vps10*CLI> |
| 2 | + | |
| 3 | -- Executing [8463@from-internal:1] NoOp("SIP/703-00000002", "Running miscapp 3: PHPTimeclock") in new stack
| |
| 4 | -- Executing [8463@from-internal:2] Macro("SIP/703-00000002", "user-callerid,") in new stack
| |
| 5 | - | -- Executing [8463@from-internal:1] NoOp("SIP/703-0000001e", "Running miscapp 3: PHPTimeclock") in new stack
|
| 5 | + | -- Executing [s@macro-user-callerid:1] Set("SIP/703-00000002", "TOUCH_MONITOR=1376016451.2") in new stack
|
| 6 | - | -- Executing [8463@from-internal:2] Macro("SIP/703-0000001e", "user-callerid,") in new stack
|
| 6 | + | -- Executing [s@macro-user-callerid:2] Set("SIP/703-00000002", "AMPUSER=703") in new stack
|
| 7 | - | -- Executing [s@macro-user-callerid:1] Set("SIP/703-0000001e", "TOUCH_MONITOR=1376005828.96") in new stack
|
| 7 | + | -- Executing [s@macro-user-callerid:3] GotoIf("SIP/703-00000002", "0?report") in new stack
|
| 8 | - | -- Executing [s@macro-user-callerid:2] Set("SIP/703-0000001e", "AMPUSER=703") in new stack
|
| 8 | + | -- Executing [s@macro-user-callerid:4] ExecIf("SIP/703-00000002", "1?Set(REALCALLERIDNUM=703)") in new stack
|
| 9 | - | -- Executing [s@macro-user-callerid:3] GotoIf("SIP/703-0000001e", "0?report") in new stack
|
| 9 | + | -- Executing [s@macro-user-callerid:5] Set("SIP/703-00000002", "AMPUSER=703") in new stack
|
| 10 | - | -- Executing [s@macro-user-callerid:4] ExecIf("SIP/703-0000001e", "1?Set(REALCALLERIDNUM=703)") in new stack
|
| 10 | + | -- Executing [s@macro-user-callerid:6] Set("SIP/703-00000002", "AMPUSERCIDNAME=703") in new stack
|
| 11 | - | -- Executing [s@macro-user-callerid:5] Set("SIP/703-0000001e", "AMPUSER=703") in new stack
|
| 11 | + | -- Executing [s@macro-user-callerid:7] GotoIf("SIP/703-00000002", "0?report") in new stack
|
| 12 | - | -- Executing [s@macro-user-callerid:6] Set("SIP/703-0000001e", "AMPUSERCIDNAME=703") in new stack
|
| 12 | + | -- Executing [s@macro-user-callerid:8] Set("SIP/703-00000002", "AMPUSERCID=703") in new stack
|
| 13 | - | -- Executing [s@macro-user-callerid:7] GotoIf("SIP/703-0000001e", "0?report") in new stack
|
| 13 | + | -- Executing [s@macro-user-callerid:9] Set("SIP/703-00000002", "__DIAL_OPTIONS=") in new stack
|
| 14 | - | -- Executing [s@macro-user-callerid:8] Set("SIP/703-0000001e", "AMPUSERCID=703") in new stack
|
| 14 | + | -- Executing [s@macro-user-callerid:10] Set("SIP/703-00000002", "CALLERID(all)="703" <703>") in new stack
|
| 15 | - | -- Executing [s@macro-user-callerid:9] Set("SIP/703-0000001e", "__DIAL_OPTIONS=") in new stack
|
| 15 | + | -- Executing [s@macro-user-callerid:11] GotoIf("SIP/703-00000002", "0?limit") in new stack
|
| 16 | - | -- Executing [s@macro-user-callerid:10] Set("SIP/703-0000001e", "CALLERID(all)="703" <703>") in new stack
|
| 16 | + | -- Executing [s@macro-user-callerid:12] ExecIf("SIP/703-00000002", "0?Set(GROUP(concurrency_limit)=703)") in new stack
|
| 17 | - | -- Executing [s@macro-user-callerid:11] GotoIf("SIP/703-0000001e", "0?limit") in new stack
|
| 17 | + | -- Executing [s@macro-user-callerid:13] GosubIf("SIP/703-00000002", "7?sub-ccss,s,1(from-internal,8463)") in new stack
|
| 18 | - | -- Executing [s@macro-user-callerid:12] ExecIf("SIP/703-0000001e", "0?Set(GROUP(concurrency_limit)=703)") in new stack
|
| 18 | + | -- Executing [s@sub-ccss:1] ExecIf("SIP/703-00000002", "0?Return()") in new stack
|
| 19 | - | -- Executing [s@macro-user-callerid:13] GosubIf("SIP/703-0000001e", "7?sub-ccss,s,1(from-internal,8463)") in new stack
|
| 19 | + | -- Executing [s@sub-ccss:2] Set("SIP/703-00000002", "CCSS_SETUP=TRUE") in new stack
|
| 20 | - | -- Executing [s@sub-ccss:1] ExecIf("SIP/703-0000001e", "0?Return()") in new stack
|
| 20 | + | -- Executing [s@sub-ccss:3] GosubIf("SIP/703-00000002", "0?monitor_config,1(from-internal,8463):monitor_default,1(from-internal,8463)") in new stack
|
| 21 | - | -- Executing [s@sub-ccss:2] Set("SIP/703-0000001e", "CCSS_SETUP=TRUE") in new stack
|
| 21 | + | -- Executing [monitor_default@sub-ccss:1] GotoIf("SIP/703-00000002", "0?is_exten") in new stack
|
| 22 | - | -- Executing [s@sub-ccss:3] GosubIf("SIP/703-0000001e", "0?monitor_config,1(from-internal,8463):monitor_default,1(from-internal,8463)") in new stack
|
| 22 | + | -- Executing [monitor_default@sub-ccss:2] StackPop("SIP/703-00000002", "") in new stack
|
| 23 | - | -- Executing [monitor_default@sub-ccss:1] GotoIf("SIP/703-0000001e", "0?is_exten") in new stack
|
| 23 | + | -- Executing [monitor_default@sub-ccss:3] Return("SIP/703-00000002", "FALSE") in new stack
|
| 24 | - | -- Executing [monitor_default@sub-ccss:2] StackPop("SIP/703-0000001e", "") in new stack
|
| 24 | + | -- Executing [s@macro-user-callerid:14] GotoIf("SIP/703-00000002", "0?continue") in new stack
|
| 25 | - | -- Executing [monitor_default@sub-ccss:3] Return("SIP/703-0000001e", "FALSE") in new stack
|
| 25 | + | -- Executing [s@macro-user-callerid:15] Set("SIP/703-00000002", "__TTL=64") in new stack
|
| 26 | - | -- Executing [s@macro-user-callerid:14] GotoIf("SIP/703-0000001e", "0?continue") in new stack
|
| 26 | + | -- Executing [s@macro-user-callerid:16] GotoIf("SIP/703-00000002", "1?continue") in new stack
|
| 27 | - | -- Executing [s@macro-user-callerid:15] Set("SIP/703-0000001e", "__TTL=64") in new stack
|
| 27 | + | |
| 28 | - | -- Executing [s@macro-user-callerid:16] GotoIf("SIP/703-0000001e", "1?continue") in new stack
|
| 28 | + | -- Executing [s@macro-user-callerid:27] Set("SIP/703-00000002", "CALLERID(number)=703") in new stack
|
| 29 | -- Executing [s@macro-user-callerid:28] Set("SIP/703-00000002", "CALLERID(name)=703") in new stack
| |
| 30 | - | -- Executing [s@macro-user-callerid:27] Set("SIP/703-0000001e", "CALLERID(number)=703") in new stack
|
| 30 | + | -- Executing [s@macro-user-callerid:29] Set("SIP/703-00000002", "CDR(cnum)=703") in new stack
|
| 31 | - | -- Executing [s@macro-user-callerid:28] Set("SIP/703-0000001e", "CALLERID(name)=703") in new stack
|
| 31 | + | -- Executing [s@macro-user-callerid:30] Set("SIP/703-00000002", "CDR(cnam)=703") in new stack
|
| 32 | - | -- Executing [s@macro-user-callerid:29] Set("SIP/703-0000001e", "CDR(cnum)=703") in new stack
|
| 32 | + | -- Executing [s@macro-user-callerid:31] Set("SIP/703-00000002", "CHANNEL(language)=en") in new stack
|
| 33 | - | -- Executing [s@macro-user-callerid:30] Set("SIP/703-0000001e", "CDR(cnam)=703") in new stack
|
| 33 | + | -- Executing [8463@from-internal:3] Goto("SIP/703-00000002", "phptimeclock,s,1") in new stack
|
| 34 | - | -- Executing [s@macro-user-callerid:31] Set("SIP/703-0000001e", "CHANNEL(language)=en") in new stack
|
| 34 | + | |
| 35 | - | -- Executing [8463@from-internal:3] Goto("SIP/703-0000001e", "phptimeclock,s,1") in new stack
|
| 35 | + | -- Executing [s@phptimeclock:1] Answer("SIP/703-00000002", "") in new stack
|
| 36 | -- Executing [s@phptimeclock:2] Wait("SIP/703-00000002", "1") in new stack
| |
| 37 | - | -- Executing [s@phptimeclock:1] Answer("SIP/703-0000001e", "") in new stack
|
| 37 | + | > 0xb7403ca8 -- Probation passed - setting RTP source address to 66.87.77.230:32973 |
| 38 | - | -- Executing [s@phptimeclock:2] Wait("SIP/703-0000001e", "1") in new stack
|
| 38 | + | > 0xb7403ca8 -- Probation passed - setting RTP source address to 66.87.77.230:32973 |
| 39 | - | > 0xb7554b28 -- Probation passed - setting RTP source address to 66.87.77.230:63438 |
| 39 | + | -- Executing [s@phptimeclock:3] Read("SIP/703-00000002", "user,tm_userid,,,3,5") in new stack
|
| 40 | - | > 0xb7554b28 -- Probation passed - setting RTP source address to 66.87.77.230:63438 |
| 40 | + | -- <SIP/703-00000002> Playing 'tm_userid.gsm' (language 'en') |
| 41 | - | -- Executing [s@phptimeclock:3] Read("SIP/703-0000001e", "user,tm_userid,,,3,5") in new stack
|
| 41 | + | |
| 42 | - | -- <SIP/703-0000001e> Playing 'tm_userid.gsm' (language 'en') |
| 42 | + | -- Executing [s@phptimeclock:4] NoOp("SIP/703-00000002", "xxxx") in new stack
|
| 43 | -- Executing [s@phptimeclock:5] Wait("SIP/703-00000002", "2") in new stack
| |
| 44 | - | -- Executing [s@phptimeclock:4] NoOp("SIP/703-0000001e", "XXXX") in new stack
|
| 44 | + | -- Executing [s@phptimeclock:6] Read("SIP/703-00000002", "pass,tm_pass,,,3,5") in new stack
|
| 45 | - | -- Executing [s@phptimeclock:5] Wait("SIP/703-0000001e", "2") in new stack
|
| 45 | + | -- <SIP/703-00000002> Playing 'tm_pass.gsm' (language 'en') |
| 46 | - | -- Executing [s@phptimeclock:6] Read("SIP/703-0000001e", "pass,tm_pass,,,3,5") in new stack
|
| 46 | + | |
| 47 | - | -- <SIP/703-0000001e> Playing 'tm_pass.gsm' (language 'en') |
| 47 | + | -- Executing [s@phptimeclock:7] NoOp("SIP/703-00000002", "xxxx") in new stack
|
| 48 | -- Executing [s@phptimeclock:8] MYSQL("SIP/703-00000002", "Connect connid xxx.xxx.xxx.xxx phptimeclock phptimeclock phptimeclock") in new stack
| |
| 49 | - | -- Executing [s@phptimeclock:7] NoOp("SIP/703-0000001e", "XXXX") in new stack
|
| 49 | + | -- Executing [s@phptimeclock:9] NoOp("SIP/703-00000002", "1") in new stack
|
| 50 | - | -- Executing [s@phptimeclock:8] MYSQL("SIP/703-0000001e", "Connect connid 123.123.123.123 phptimeclock phptimeclock phptimeclock") in new stack
|
| 50 | + | -- Executing [s@phptimeclock:10] GotoIf("SIP/703-00000002", "0?error,1") in new stack
|
| 51 | - | -- Executing [s@phptimeclock:9] NoOp("SIP/703-0000001e", "1") in new stack
|
| 51 | + | -- Executing [s@phptimeclock:11] MYSQL("SIP/703-00000002", "Query resultid 1 SELECT tstamp FROM employees WHERE empfullname= USER AND employee_passwd= encrypt("1234","xy")") in new stack
|
| 52 | - | -- Executing [s@phptimeclock:10] GotoIf("SIP/703-0000001e", "0?error,1") in new stack
|
| 52 | + | [2013-08-08 21:47:42] WARNING[27331][C-00000002]: app_mysql.c:405 aMYSQL_query: aMYSQL_query: mysql_query failed. Error: Unknown column 'USER' in 'where clause' |
| 53 | - | -- Executing [s@phptimeclock:11] MYSQL("SIP/703-0000001e", "Query resultid 1 SELECT\ tstamp\ FROM\ employees\ WHERE\ empfullname=\1234\ AND\ employee_passwd\ =\ encrypt(\"1234\"\,\"xy\")") in new stack
|
| 53 | + | -- Executing [s@phptimeclock:12] MYSQL("SIP/703-00000002", "Fetch fetchid tstamp") in new stack
|
| 54 | - | [2013-08-08 18:50:46] WARNING[24476][C-00000031]: app_mysql.c:405 aMYSQL_query: aMYSQL_query: mysql_query failed. Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\ tstamp\ FROM\ employees\ WHERE\ empfullname=\1234\ AND\ employee_passwd\ =\ en' at line 1 |
| 54 | + | [2013-08-08 21:47:42] WARNING[27331][C-00000002]: app_mysql.c:506 aMYSQL_fetch: aMYSQL_fetch: missing some arguments |
| 55 | - | -- Executing [s@phptimeclock:12] MYSQL("SIP/703-0000001e", "Fetch fetchid tstamp") in new stack
|
| 55 | + | -- Executing [s@phptimeclock:13] MYSQL("SIP/703-00000002", "Clear ") in new stack
|
| 56 | - | [2013-08-08 18:50:46] WARNING[24476][C-00000031]: app_mysql.c:506 aMYSQL_fetch: aMYSQL_fetch: missing some arguments |
| 56 | + | [2013-08-08 21:47:42] WARNING[27331][C-00000002]: app_mysql.c:194 find_identifier: Identifier 0, identifier_type 2 not found in identifier list |
| 57 | - | -- Executing [s@phptimeclock:13] MYSQL("SIP/703-0000001e", "Clear ") in new stack
|
| 57 | + | [2013-08-08 21:47:42] WARNING[27331][C-00000002]: app_mysql.c:520 aMYSQL_clear: Invalid result identifier 0 passed in aMYSQL_clear |
| 58 | - | [2013-08-08 18:50:46] WARNING[24476][C-00000031]: app_mysql.c:194 find_identifier: Identifier 0, identifier_type 2 not found in identifier list |
| 58 | + | -- Executing [s@phptimeclock:14] NoOp("SIP/703-00000002", "") in new stack
|
| 59 | - | [2013-08-08 18:50:46] WARNING[24476][C-00000031]: app_mysql.c:520 aMYSQL_clear: Invalid result identifier 0 passed in aMYSQL_clear |
| 59 | + | -- Executing [s@phptimeclock:15] GotoIf("SIP/703-00000002", "0?fail:next") in new stack
|
| 60 | - | -- Executing [s@phptimeclock:14] NoOp("SIP/703-0000001e", "") in new stack
|
| 60 | + | |
| 61 | - | -- Executing [s@phptimeclock:15] GotoIf("SIP/703-0000001e", "0?fail:next") in new stack
|
| 61 | + | -- Executing [s@phptimeclock:18] NoOp("SIP/703-00000002", ""moving On"") in new stack
|
| 62 | -- Executing [s@phptimeclock:19] NoOp("SIP/703-00000002", "") in new stack
| |
| 63 | - | -- Executing [s@phptimeclock:18] NoOp("SIP/703-0000001e", ""moving On"") in new stack
|
| 63 | + | -- Executing [s@phptimeclock:20] Set("SIP/703-00000002", "stat="in"") in new stack
|
| 64 | - | -- Executing [s@phptimeclock:19] NoOp("SIP/703-0000001e", "") in new stack
|
| 64 | + | -- Executing [s@phptimeclock:21] GotoIf("SIP/703-00000002", "0?initial") in new stack
|
| 65 | - | -- Executing [s@phptimeclock:20] Set("SIP/703-0000001e", "stat="in"") in new stack
|
| 65 | + | -- Executing [s@phptimeclock:22] MYSQL("SIP/703-00000002", "Query resultid 1 SELECT info.inout FROM info WHERE fullname= USER AND timestamp= tstamp") in new stack
|
| 66 | - | -- Executing [s@phptimeclock:21] GotoIf("SIP/703-0000001e", "0?initial") in new stack
|
| 66 | + | [2013-08-08 21:47:42] WARNING[27331][C-00000002]: app_mysql.c:405 aMYSQL_query: aMYSQL_query: mysql_query failed. Error: Unknown column 'USER' in 'where clause' |
| 67 | - | -- Executing [s@phptimeclock:22] MYSQL("SIP/703-0000001e", "Query resultid 1 SELECT\ info.inout\ FROM\ info\ WHERE\ fullname=\1234\ AND\ timestamp=\") in new stack
|
| 67 | + | -- Executing [s@phptimeclock:23] MYSQL("SIP/703-00000002", "Fetch fetchid inout") in new stack
|
| 68 | - | [2013-08-08 18:50:46] WARNING[24476][C-00000031]: app_mysql.c:405 aMYSQL_query: aMYSQL_query: mysql_query failed. Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\ info.inout\ FROM\ info\ WHERE\ fullname=\1234\ AND\ timestamp=\' at line 1 |
| 68 | + | [2013-08-08 21:47:42] WARNING[27331][C-00000002]: app_mysql.c:506 aMYSQL_fetch: aMYSQL_fetch: missing some arguments |
| 69 | - | -- Executing [s@phptimeclock:23] MYSQL("SIP/703-0000001e", "Fetch fetchid inout") in new stack
|
| 69 | + | -- Executing [s@phptimeclock:24] MYSQL("SIP/703-00000002", "Clear ") in new stack
|
| 70 | - | [2013-08-08 18:50:46] WARNING[24476][C-00000031]: app_mysql.c:506 aMYSQL_fetch: aMYSQL_fetch: missing some arguments |
| 70 | + | [2013-08-08 21:47:42] WARNING[27331][C-00000002]: app_mysql.c:194 find_identifier: Identifier 0, identifier_type 2 not found in identifier list |
| 71 | - | -- Executing [s@phptimeclock:24] MYSQL("SIP/703-0000001e", "Clear ") in new stack
|
| 71 | + | [2013-08-08 21:47:42] WARNING[27331][C-00000002]: app_mysql.c:520 aMYSQL_clear: Invalid result identifier 0 passed in aMYSQL_clear |
| 72 | - | [2013-08-08 18:50:46] WARNING[24476][C-00000031]: app_mysql.c:194 find_identifier: Identifier 0, identifier_type 2 not found in identifier list |
| 72 | + | -- Executing [s@phptimeclock:25] NoOp("SIP/703-00000002", "") in new stack
|
| 73 | - | [2013-08-08 18:50:46] WARNING[24476][C-00000031]: app_mysql.c:520 aMYSQL_clear: Invalid result identifier 0 passed in aMYSQL_clear |
| 73 | + | [2013-08-08 21:47:42] WARNING[27331][C-00000002]: ast_expr2.fl:470 ast_yyerror: ast_yyerror(): syntax error: syntax error, unexpected '=', expecting $end; Input: |
| 74 | - | -- Executing [s@phptimeclock:25] NoOp("SIP/703-0000001e", "") in new stack
|
| 74 | + | |
| 75 | - | [2013-08-08 18:50:46] WARNING[24476][C-00000031]: ast_expr2.fl:470 ast_yyerror: ast_yyerror(): syntax error: syntax error, unexpected '=', expecting $end; Input: |
| 75 | + | |
| 76 | [2013-08-08 21:47:42] WARNING[27331][C-00000002]: ast_expr2.fl:474 ast_yyerror: If you have questions, please refer to https://wiki.asterisk.org/wiki/display/AST/Channel+Variables | |
| 77 | [2013-08-08 21:47:42] WARNING[27331][C-00000002]: func_logic.c:192 acf_if: Syntax IF(<expr>?[<true>][:<false>]) (expr must be non-null, and either <true> or <false> must be non-null) | |
| 78 | - | [2013-08-08 18:50:46] WARNING[24476][C-00000031]: ast_expr2.fl:474 ast_yyerror: If you have questions, please refer to https://wiki.asterisk.org/wiki/display/AST/Channel+Variables |
| 78 | + | [2013-08-08 21:47:42] WARNING[27331][C-00000002]: func_logic.c:193 acf_if: In this case, <expr>='', <true>='out', and <false>='in' |
| 79 | - | [2013-08-08 18:50:46] WARNING[24476][C-00000031]: func_logic.c:192 acf_if: Syntax IF(<expr>?[<true>][:<false>]) (expr must be non-null, and either <true> or <false> must be non-null) |
| 79 | + | -- Executing [s@phptimeclock:26] Set("SIP/703-00000002", "stat=") in new stack
|
| 80 | - | [2013-08-08 18:50:46] WARNING[24476][C-00000031]: func_logic.c:193 acf_if: In this case, <expr>='', <true>='out', and <false>='in' |
| 80 | + | -- Executing [s@phptimeclock:27] NoOp("SIP/703-00000002", "") in new stack
|
| 81 | - | -- Executing [s@phptimeclock:26] Set("SIP/703-0000001e", "stat=") in new stack
|
| 81 | + | -- Executing [s@phptimeclock:28] NoOp("SIP/703-00000002", "initial login") in new stack
|
| 82 | - | -- Executing [s@phptimeclock:27] NoOp("SIP/703-0000001e", "") in new stack
|
| 82 | + | -- Executing [s@phptimeclock:29] MYSQL("SIP/703-00000002", "Query resultid 1 SELECT unix_timestamp( utc_timestamp( ) ) ") in new stack
|
| 83 | - | -- Executing [s@phptimeclock:28] NoOp("SIP/703-0000001e", "initial login") in new stack
|
| 83 | + | -- Executing [s@phptimeclock:30] MYSQL("SIP/703-00000002", "Fetch fetchid 2 time") in new stack
|
| 84 | - | -- Executing [s@phptimeclock:29] MYSQL("SIP/703-0000001e", "Query resultid 1 SELECT\ unix_timestamp( utc_timestamp( ) ) ") in new stack
|
| 84 | + | -- Executing [s@phptimeclock:31] MYSQL("SIP/703-00000002", "Clear 2") in new stack
|
| 85 | - | [2013-08-08 18:50:46] WARNING[24476][C-00000031]: app_mysql.c:405 aMYSQL_query: aMYSQL_query: mysql_query failed. Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\ unix_timestamp( utc_timestamp( ) )' at line 1 |
| 85 | + | -- Executing [s@phptimeclock:32] NoOp("SIP/703-00000002", "1376034462") in new stack
|
| 86 | - | -- Executing [s@phptimeclock:30] MYSQL("SIP/703-0000001e", "Fetch fetchid time") in new stack
|
| 86 | + | -- Executing [s@phptimeclock:33] NoOp("SIP/703-00000002", ""CallerID is "703") in new stack
|
| 87 | - | [2013-08-08 18:50:46] WARNING[24476][C-00000031]: app_mysql.c:506 aMYSQL_fetch: aMYSQL_fetch: missing some arguments |
| 87 | + | -- Executing [s@phptimeclock:34] MYSQL("SIP/703-00000002", "Query resultid 1 UPDATE employees SET tstamp='1376034462' WHERE empfullname= USER") in new stack
|
| 88 | - | -- Executing [s@phptimeclock:31] MYSQL("SIP/703-0000001e", "Clear ") in new stack
|
| 88 | + | [2013-08-08 21:47:42] WARNING[27331][C-00000002]: app_mysql.c:405 aMYSQL_query: aMYSQL_query: mysql_query failed. Error: Unknown column 'USER' in 'where clause' |
| 89 | - | [2013-08-08 18:50:46] WARNING[24476][C-00000031]: app_mysql.c:194 find_identifier: Identifier 0, identifier_type 2 not found in identifier list |
| 89 | + | -- Executing [s@phptimeclock:35] MYSQL("SIP/703-00000002", "Clear 2") in new stack
|
| 90 | - | [2013-08-08 18:50:46] WARNING[24476][C-00000031]: app_mysql.c:520 aMYSQL_clear: Invalid result identifier 0 passed in aMYSQL_clear |
| 90 | + | [2013-08-08 21:47:42] WARNING[27331][C-00000002]: app_mysql.c:194 find_identifier: Identifier 2, identifier_type 2 not found in identifier list |
| 91 | - | -- Executing [s@phptimeclock:32] NoOp("SIP/703-0000001e", "") in new stack
|
| 91 | + | [2013-08-08 21:47:42] WARNING[27331][C-00000002]: app_mysql.c:520 aMYSQL_clear: Invalid result identifier 2 passed in aMYSQL_clear |
| 92 | - | -- Executing [s@phptimeclock:33] NoOp("SIP/703-0000001e", ""CallerID is "703") in new stack
|
| 92 | + | -- Executing [s@phptimeclock:36] MYSQL("SIP/703-00000002", "Query resultid 1 INSERT INTO info SET fullname='\1234\', info.inout='', timestamp='1376034462', ipaddress='703'") in new stack
|
| 93 | - | -- Executing [s@phptimeclock:34] MYSQL("SIP/703-0000001e", "Query resultid 1 UPDATE\ employees\ SET\ tstamp=\'\\'\ WHERE \empfullname=\1234") in new stack
|
| 93 | + | [2013-08-08 21:47:42] WARNING[27331][C-00000002]: app_mysql.c:405 aMYSQL_query: aMYSQL_query: mysql_query failed. Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '1376034462', ipaddress='703'' at line 1 |
| 94 | - | [2013-08-08 18:50:46] WARNING[24476][C-00000031]: app_mysql.c:405 aMYSQL_query: aMYSQL_query: mysql_query failed. Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\ employees\ SET\ tstamp=\'\\'\ WHERE \empfullname=\1234' at line 1 |
| 94 | + | -- Executing [s@phptimeclock:37] MYSQL("SIP/703-00000002", "Fetch fetchid 2") in new stack
|
| 95 | - | -- Executing [s@phptimeclock:35] MYSQL("SIP/703-0000001e", "Clear ") in new stack
|
| 95 | + | [2013-08-08 21:47:42] WARNING[27331][C-00000002]: app_mysql.c:194 find_identifier: Identifier 2, identifier_type 2 not found in identifier list |
| 96 | - | [2013-08-08 18:50:46] WARNING[24476][C-00000031]: app_mysql.c:194 find_identifier: Identifier 0, identifier_type 2 not found in identifier list |
| 96 | + | [2013-08-08 21:47:42] WARNING[27331][C-00000002]: app_mysql.c:503 aMYSQL_fetch: aMYSQL_fetch: Invalid result identifier 2 passed |
| 97 | - | [2013-08-08 18:50:46] WARNING[24476][C-00000031]: app_mysql.c:520 aMYSQL_clear: Invalid result identifier 0 passed in aMYSQL_clear |
| 97 | + | -- Executing [s@phptimeclock:38] MYSQL("SIP/703-00000002", "Clear 2") in new stack
|
| 98 | - | -- Executing [s@phptimeclock:36] MYSQL("SIP/703-0000001e", "Query resultid 1 INSERT\ INTO\ info\ SET\ fullname=\'\1234\'\, info.inout=\'\\'\, timestamp=\'\\'\, ipaddress=\'\703\'\") in new stack
|
| 98 | + | [2013-08-08 21:47:42] WARNING[27331][C-00000002]: app_mysql.c:194 find_identifier: Identifier 2, identifier_type 2 not found in identifier list |
| 99 | - | [2013-08-08 18:50:46] WARNING[24476][C-00000031]: app_mysql.c:405 aMYSQL_query: aMYSQL_query: mysql_query failed. Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\ INTO\ info\ SET\ fullname=\'\1234\'\, info.inout=\'\\'\, timestamp=\'\\'\, ipa' at line 1 |
| 99 | + | [2013-08-08 21:47:42] WARNING[27331][C-00000002]: app_mysql.c:520 aMYSQL_clear: Invalid result identifier 2 passed in aMYSQL_clear |
| 100 | - | -- Executing [s@phptimeclock:37] MYSQL("SIP/703-0000001e", "Fetch fetchid ") in new stack
|
| 100 | + | -- Executing [s@phptimeclock:39] GotoIf("SIP/703-00000002", "0?in:out") in new stack
|
| 101 | - | [2013-08-08 18:50:46] WARNING[24476][C-00000031]: app_mysql.c:506 aMYSQL_fetch: aMYSQL_fetch: missing some arguments |
| 101 | + | |
| 102 | - | -- Executing [s@phptimeclock:38] MYSQL("SIP/703-0000001e", "Clear ") in new stack
|
| 102 | + | -- Executing [s@phptimeclock:42] Playback("SIP/703-00000002", "tm_clocked_out") in new stack
|
| 103 | - | [2013-08-08 18:50:46] WARNING[24476][C-00000031]: app_mysql.c:194 find_identifier: Identifier 0, identifier_type 2 not found in identifier list |
| 103 | + | -- <SIP/703-00000002> Playing 'tm_clocked_out.gsm' (language 'en') |
| 104 | - | [2013-08-08 18:50:46] WARNING[24476][C-00000031]: app_mysql.c:520 aMYSQL_clear: Invalid result identifier 0 passed in aMYSQL_clear |
| 104 | + | -- Executing [s@phptimeclock:43] Goto("SIP/703-00000002", "done") in new stack
|
| 105 | - | -- Executing [s@phptimeclock:39] GotoIf("SIP/703-0000001e", "0?in:out") in new stack
|
| 105 | + | |
| 106 | -- Executing [s@phptimeclock:44] NoOp("SIP/703-00000002", ""Connection ID is "1") in new stack
| |
| 107 | - | -- Executing [s@phptimeclock:42] Playback("SIP/703-0000001e", "tm_clocked_out") in new stack
|
| 107 | + | -- Executing [s@phptimeclock:45] NoOp("SIP/703-00000002", ""Result ID is "2") in new stack
|
| 108 | - | -- <SIP/703-0000001e> Playing 'tm_clocked_out.gsm' (language 'en') |
| 108 | + | -- Executing [s@phptimeclock:46] Wait("SIP/703-00000002", "1") in new stack
|
| 109 | - | -- Executing [s@phptimeclock:43] Goto("SIP/703-0000001e", "done") in new stack
|
| 109 | + | -- Executing [s@phptimeclock:47] MYSQL("SIP/703-00000002", "Clear 2") in new stack
|
| 110 | [2013-08-08 21:47:46] WARNING[27331][C-00000002]: app_mysql.c:194 find_identifier: Identifier 2, identifier_type 2 not found in identifier list | |
| 111 | - | -- Executing [s@phptimeclock:44] NoOp("SIP/703-0000001e", ""Connection ID is "1") in new stack
|
| 111 | + | [2013-08-08 21:47:46] WARNING[27331][C-00000002]: app_mysql.c:520 aMYSQL_clear: Invalid result identifier 2 passed in aMYSQL_clear |
| 112 | - | -- Executing [s@phptimeclock:45] NoOp("SIP/703-0000001e", ""Result ID is "") in new stack
|
| 112 | + | -- Executing [s@phptimeclock:48] MYSQL("SIP/703-00000002", "Disconnect 1") in new stack
|
| 113 | - | -- Executing [s@phptimeclock:46] Wait("SIP/703-0000001e", "1") in new stack
|
| 113 | + | -- Auto fallthrough, channel 'SIP/703-00000002' status is 'UNKNOWN' |
| 114 | - | -- Executing [s@phptimeclock:47] MYSQL("SIP/703-0000001e", "Clear ") in new stack
|
| 114 | + | -- Executing [h@phptimeclock:1] MYSQL("SIP/703-00000002", "clear 2") in new stack
|
| 115 | - | [2013-08-08 18:50:50] WARNING[24476][C-00000031]: app_mysql.c:194 find_identifier: Identifier 0, identifier_type 2 not found in identifier list |
| 115 | + | [2013-08-08 21:47:46] WARNING[27331][C-00000002]: app_mysql.c:194 find_identifier: Identifier 2, identifier_type 2 not found in identifier list |
| 116 | - | [2013-08-08 18:50:50] WARNING[24476][C-00000031]: app_mysql.c:520 aMYSQL_clear: Invalid result identifier 0 passed in aMYSQL_clear |
| 116 | + | [2013-08-08 21:47:46] WARNING[27331][C-00000002]: app_mysql.c:520 aMYSQL_clear: Invalid result identifier 2 passed in aMYSQL_clear |
| 117 | - | -- Executing [s@phptimeclock:48] MYSQL("SIP/703-0000001e", "Disconnect 1") in new stack
|
| 117 | + | -- Executing [h@phptimeclock:2] MYSQL("SIP/703-00000002", "disconnect 1") in new stack
|
| 118 | - | -- Auto fallthrough, channel 'SIP/703-0000001e' status is 'UNKNOWN' |
| 118 | + | [2013-08-08 21:47:46] WARNING[27331][C-00000002]: app_mysql.c:194 find_identifier: Identifier 1, identifier_type 1 not found in identifier list |
| 119 | - | -- Executing [h@phptimeclock:1] MYSQL("SIP/703-0000001e", "clear ") in new stack
|
| 119 | + | [2013-08-08 21:47:46] WARNING[27331][C-00000002]: app_mysql.c:537 aMYSQL_disconnect: Invalid connection identifier 1 passed in aMYSQL_disconnect |