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 |