質問編集履歴

7

セキュリティの関わる問題なので削除させていただきました。

2018/06/18 09:46

投稿

amaguri
amaguri

スコア227

test CHANGED
@@ -1 +1 @@
1
- cakephp ループ文返事が返っこな
1
+ セキュリティ関わる問題なので削除させていただきました。
test CHANGED
@@ -1,291 +1 @@
1
- 下記プログラムを動かすと全く返事が返ってきません、、
2
-
3
- 何が原因でしょうか??
4
-
5
- ```php
6
-
7
- ///////////////////////////////////////////////////////////////////
8
-
9
- //IP範囲チェック
10
-
11
- ///////////////////////////////////////////////////////////////////
12
-
13
- function IpCheck(){
14
-
15
-
16
-
17
- $access_ip = CommonComponent::getAccessIp();
18
-
19
-
20
-
21
- $sql = "SELECT start_ip, last_ip FROM allow_ips AS AllowIps WHERE INET_ATON(?) between INET_ATON(start_ip) and INET_ATON(last_ip)";
22
-
23
-
24
-
25
- $ips = $this->AllowIps->query($sql,array($this->$access_ip));
26
-
27
-
28
-
29
- return $ips;
30
-
31
- }
32
-
33
-
34
-
35
- ///////////////////////////////////////////////////////////////////
36
-
37
- //フラグIP範囲チェック
38
-
39
- ///////////////////////////////////////////////////////////////////
40
-
41
- function FigIpCheck(){
42
-
43
- $access_ip = CommonComponent::getAccessIp();
44
-
45
-
46
-
47
- $sql = "SELECT start_ip, last_ip, full_access_flg FROM allow_ips AS AllowIps WHERE INET_ATON(?) between INET_ATON(start_ip) and INET_ATON(last_ip)";
48
-
49
-
50
-
51
- $ips = $this->AllowIps->query($sql,array($this->$access_ip));
52
-
53
-
54
-
55
- return $ips;
56
-
57
- }
58
-
59
-
60
-
61
- ///////////////////////////////////////////////////////////////////
62
-
63
- //識別します
64
-
65
- ///////////////////////////////////////////////////////////////////
66
-
67
- function identification($results){
68
-
69
-
70
-
71
- foreach ($results as $result) {
72
-
73
- //$results[$cnt]->typeを抜き出す
74
-
75
- $u_type=$result->type;
76
-
77
- //更新系の場合
78
-
79
- if( eregi($u_type,"^insert|^create table|^create database|^drop database|^drop table")){
80
-
81
- //対象のDBを$results[$cnt]->dbを$resultsから抽出
82
-
83
- $u_db=$result->db;
84
-
85
- //対象のDBが個人情報DBか識別
86
-
87
- $dbcheck = $this->PrivateHiveDb->find('count', array(
88
-
89
- 'conditions' => array('PrivateHiveDb.hive_database' => $u_db))
90
-
91
- );
92
-
93
- //対象のDBが個人情報系の場合
94
-
95
- if($dbcheck){
96
-
97
- // 接続元IP情報
98
-
99
- $ips=CommonComponent::IpCheck();
100
-
101
-
102
-
103
- if (empty($ips)) {
104
-
105
- return 1;
106
-
107
- }
108
-
109
-
110
-
111
- }else{
112
-
113
- //対象のDBが非個人情報の場合
114
-
115
- // 接続元IP情報
116
-
117
- $ips=CommonComponent::FlgIpCheck();
118
-
119
-
120
-
121
- foreach ($ips as $row) {
122
-
123
- if ($row['full_access_flg'] == '0') {
124
-
125
- //0の場合(権限許可IPの場合)
126
-
127
- return 1;
128
-
129
- }
130
-
131
- }
132
-
133
- }
134
-
135
-
136
-
137
- }else{
138
-
139
- //参照系の場合
140
-
141
- //対象のDBを$results[$cnt]->dbを$resultsから抽出
142
-
143
- $u_db=$result->db;
144
-
145
- //対象のDBが個人情報DBか識別
146
-
147
- $dbcheck = $this->PrivateHiveDb->find('count',array(
148
-
149
- 'conditions' => array('PrivateHiveDb.hive_database' => $u_db))
150
-
151
- );
152
-
153
- //対象のDBが更新系の場合
154
-
155
- if($dbcheck){
156
-
157
- // 接続元IP情報
158
-
159
- $ips=CommonComponent::IpCheck();
160
-
161
-
162
-
163
- if (empty($ips)) {
164
-
165
- return 1;
166
-
167
- }
168
-
169
- }
170
-
171
- }
172
-
173
- }
174
-
175
- return 0;
176
-
177
- }
178
-
179
- ```
180
-
181
-
182
-
183
- エラー文です
184
-
185
- ```
186
-
187
-
188
-
189
- ext-all.js:15 Uncaught You're trying to decode an invalid JSON String: <pre class="cake-debug"><a href="javascript:void(0);" onclick="document.getElementById('cakeErr1-trace').style.display = (document.getElementById('cakeErr1-trace').style.display == 'none' ? '' : 'none');"><b>Notice</b> (8)</a>: Undefined variable: results [<b>APP/controllers/apis_controller.php</b>, line <b>987</b>]<div id="cakeErr1-trace" class="cake-stack-trace" style="display: none;"><a href="javascript:void(0);" onclick="document.getElementById('cakeErr1-code').style.display = (document.getElementById('cakeErr1-code').style.display == 'none' ? '' : 'none')">Code</a> | <a href="javascript:void(0);" onclick="document.getElementById('cakeErr1-context').style.display = (document.getElementById('cakeErr1-context').style.display == 'none' ? '' : 'none')">Context</a><div id="cakeErr1-code" class="cake-code-dump" style="display: none;"><pre><code><span style="color: #000000"></span></code>
190
-
191
- <code><span style="color: #000000">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//☆☆新規追加☆☆参照系更新系DB識別&nbsp;</span></code>
192
-
193
- <span class="code-highlight"><code><span style="color: #000000">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$judgment=CommonComponent::identification($results);</span></code></span></pre></div><pre id="cakeErr1-context" class="cake-context" style="display: none;">$u_userid = "admin"
194
-
195
- $u_database = "default"
196
-
197
- $u_query = "use default;
198
-
199
- use default;
200
-
201
- SHOW TABLES;
202
-
203
- "
204
-
205
- $u_id = "20160728175253_44583"
206
-
207
- $hql_file = "/var/www/html/WebHive/request/admin/20160728175253_44583.hql"
208
-
209
- $chk_file = "/var/www/html/WebHive/request/admin/20160728175253_44583.chk"
210
-
211
- $exp_file = "/var/www/html/WebHive/result/admin/20160728175253_44583.exp"
212
-
213
- $arr = array(
214
-
215
- "use default",
216
-
217
- "use default",
218
-
219
- "SHOW TABLES",
220
-
221
- ""
222
-
223
- )
224
-
225
- $u_query2 = "use default;
226
-
227
- use default;
228
-
229
- SHOW TABLES;
230
-
231
-
232
-
233
- "
234
-
235
- $i = 4
236
-
237
- $set_flg = 0
238
-
239
- $fp =
240
-
241
- $ret = 30
242
-
243
- $cmd = "/usr/bin/hive -v -f /var/www/html/WebHive/request/admin/20160728175253_44583.chk &gt; /var/www/html/WebHive/result/admin/20160728175253_44583.exp 2&gt;&amp;1"
244
-
245
- $result = array()
246
-
247
- $retval = 0
248
-
249
- $line_cnt = 40
250
-
251
- $mapreduce_cnt = 0
252
-
253
- $stage_cnt = 4
254
-
255
- $u_databases = "INVALID"
256
-
257
- $u_user = array(
258
-
259
- array(
260
-
261
- "Users" => array()
262
-
263
- )
264
-
265
- )
266
-
267
-
268
-
269
- $chk_result = 0</pre><pre class="stack-trace">ApisController::explain() - APP/controllers/apis_controller.php, line 987
270
-
271
- Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 204
272
-
273
- Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 171
274
-
275
- [main] - APP/webroot/index.php, line 87</pre></div></pre><pre class="cake-debug"><a href="javascript:void(0);" onclick="document.getElementById('cakeErr2-trace').style.display = (document.getElementById('cakeErr2-trace').style.display == 'none' ? '' : 'none');"><b>Warning</b> (2)</a>: Invalid argument supplied for foreach() [<b>APP/controllers/components/common.php</b>, line <b>645</b>]<div id="cakeErr2-trace" class="cake-stack-trace" style="display: none;"><a href="javascript:void(0);" onclick="document.getElementById('cakeErr2-code').style.display = (document.getElementById('cakeErr2-code').style.display == 'none' ? '' : 'none')">Code</a> | <a href="javascript:void(0);" onclick="document.getElementById('cakeErr2-context').style.display = (document.getElementById('cakeErr2-context').style.display == 'none' ? '' : 'none')">Context</a><div id="cakeErr2-code" class="cake-code-dump" style="display: none;"><pre><code><span style="color: #000000">&nbsp;&nbsp;&nbsp;&nbsp;function&nbsp;identification($results){</span></code>
276
-
277
- <code><span style="color: #000000">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></code>
278
-
279
- <span class="code-highlight"><code><span style="color: #000000">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;foreach&nbsp;($results&nbsp;as&nbsp;$result)&nbsp;{</span></code></span></pre></div><pre id="cakeErr2-context" class="cake-context" style="display: none;">$results = null</pre><pre class="stack-trace">CommonComponent::identification() - APP/controllers/components/common.php, line 645
280
-
281
- ApisController::explain() - APP/controllers/apis_controller.php, line 987
282
-
283
- Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 204
284
-
285
- Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 171
286
-
287
- [main] - APP/webroot/index.php, line 87</pre></div></pre>{"result":"check","id":"20160728175253_44583","msg":"\u51e6\u7406\u6570=4 MapReduce\u6570=0 \u30b3\u30b9\u30c8=40"}raise @ ext-all.js:15(anonymous function) @ ext-all.js:15HiveExecute_fin @ (index):1199callback @ ext-all.js:15onComplete @ ext-all.js:15onStateChange @ ext-all.js:15(anonymous function) @ ext-all.js:15
288
-
289
-
290
-
291
- ```
1
+ セキュリティの関わる問題なので削除させいただきました。

6

エラーが更新されました

2018/06/18 09:46

投稿

amaguri
amaguri

スコア227

test CHANGED
File without changes
test CHANGED
@@ -184,11 +184,99 @@
184
184
 
185
185
  ```
186
186
 
187
- (index):1199 Uncaught You're trying to decode an invalid JSON String: <pre class="cake-debug"><a href="javascript:void(0);" onclick="document.getElementById('cakeErr1-trace').style.display = (document.getElementById('cakeErr1-trace').style.display == 'none' ? '' : 'none');"><b>Notice</b> (8)</a>: Undefined variable: u_userid [<b>APP/controllers/components/common.php</b>, line <b>671</b>]<div id="cakeErr1-trace" class="cake-stack-trace" style="display: none;"><a href="javascript:void(0);" onclick="document.getElementById('cakeErr1-code').style.display = (document.getElementById('cakeErr1-code').style.display == 'none' ? '' : 'none')">Code</a><div id="cakeErr1-code" class="cake-code-dump" style="display: none;"><pre><code><span style="color: #000000">&nbsp;&nbsp;&nbsp;&nbsp;///////////////////////////////////////////////////////////////////</span></code>
188
-
189
- <code><span style="color: #000000">&nbsp;&nbsp;&nbsp;&nbsp;function&nbsp;identification(){</span></code>
190
-
191
- <span class="code-highlight"><code><span style="color: #000000">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$results=CommonComponent::CheckExplainParce($u_userid,$u_id);</span></code></span></pre></div><pre class="stack-trace">CommonComponent::identification() - APP/controllers/components/common.php, line 671
187
+
188
+
189
+ ext-all.js:15 Uncaught You're trying to decode an invalid JSON String: <pre class="cake-debug"><a href="javascript:void(0);" onclick="document.getElementById('cakeErr1-trace').style.display = (document.getElementById('cakeErr1-trace').style.display == 'none' ? '' : 'none');"><b>Notice</b> (8)</a>: Undefined variable: results [<b>APP/controllers/apis_controller.php</b>, line <b>987</b>]<div id="cakeErr1-trace" class="cake-stack-trace" style="display: none;"><a href="javascript:void(0);" onclick="document.getElementById('cakeErr1-code').style.display = (document.getElementById('cakeErr1-code').style.display == 'none' ? '' : 'none')">Code</a> | <a href="javascript:void(0);" onclick="document.getElementById('cakeErr1-context').style.display = (document.getElementById('cakeErr1-context').style.display == 'none' ? '' : 'none')">Context</a><div id="cakeErr1-code" class="cake-code-dump" style="display: none;"><pre><code><span style="color: #000000"></span></code>
190
+
191
+ <code><span style="color: #000000">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//☆☆新規追加☆☆参照系更新系DB識別&nbsp;</span></code>
192
+
193
+ <span class="code-highlight"><code><span style="color: #000000">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$judgment=CommonComponent::identification($results);</span></code></span></pre></div><pre id="cakeErr1-context" class="cake-context" style="display: none;">$u_userid = "admin"
194
+
195
+ $u_database = "default"
196
+
197
+ $u_query = "use default;
198
+
199
+ use default;
200
+
201
+ SHOW TABLES;
202
+
203
+ "
204
+
205
+ $u_id = "20160728175253_44583"
206
+
207
+ $hql_file = "/var/www/html/WebHive/request/admin/20160728175253_44583.hql"
208
+
209
+ $chk_file = "/var/www/html/WebHive/request/admin/20160728175253_44583.chk"
210
+
211
+ $exp_file = "/var/www/html/WebHive/result/admin/20160728175253_44583.exp"
212
+
213
+ $arr = array(
214
+
215
+ "use default",
216
+
217
+ "use default",
218
+
219
+ "SHOW TABLES",
220
+
221
+ ""
222
+
223
+ )
224
+
225
+ $u_query2 = "use default;
226
+
227
+ use default;
228
+
229
+ SHOW TABLES;
230
+
231
+
232
+
233
+ "
234
+
235
+ $i = 4
236
+
237
+ $set_flg = 0
238
+
239
+ $fp =
240
+
241
+ $ret = 30
242
+
243
+ $cmd = "/usr/bin/hive -v -f /var/www/html/WebHive/request/admin/20160728175253_44583.chk &gt; /var/www/html/WebHive/result/admin/20160728175253_44583.exp 2&gt;&amp;1"
244
+
245
+ $result = array()
246
+
247
+ $retval = 0
248
+
249
+ $line_cnt = 40
250
+
251
+ $mapreduce_cnt = 0
252
+
253
+ $stage_cnt = 4
254
+
255
+ $u_databases = "INVALID"
256
+
257
+ $u_user = array(
258
+
259
+ array(
260
+
261
+ "Users" => array()
262
+
263
+ )
264
+
265
+ )
266
+
267
+
268
+
269
+ $chk_result = 0</pre><pre class="stack-trace">ApisController::explain() - APP/controllers/apis_controller.php, line 987
270
+
271
+ Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 204
272
+
273
+ Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 171
274
+
275
+ [main] - APP/webroot/index.php, line 87</pre></div></pre><pre class="cake-debug"><a href="javascript:void(0);" onclick="document.getElementById('cakeErr2-trace').style.display = (document.getElementById('cakeErr2-trace').style.display == 'none' ? '' : 'none');"><b>Warning</b> (2)</a>: Invalid argument supplied for foreach() [<b>APP/controllers/components/common.php</b>, line <b>645</b>]<div id="cakeErr2-trace" class="cake-stack-trace" style="display: none;"><a href="javascript:void(0);" onclick="document.getElementById('cakeErr2-code').style.display = (document.getElementById('cakeErr2-code').style.display == 'none' ? '' : 'none')">Code</a> | <a href="javascript:void(0);" onclick="document.getElementById('cakeErr2-context').style.display = (document.getElementById('cakeErr2-context').style.display == 'none' ? '' : 'none')">Context</a><div id="cakeErr2-code" class="cake-code-dump" style="display: none;"><pre><code><span style="color: #000000">&nbsp;&nbsp;&nbsp;&nbsp;function&nbsp;identification($results){</span></code>
276
+
277
+ <code><span style="color: #000000">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></code>
278
+
279
+ <span class="code-highlight"><code><span style="color: #000000">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;foreach&nbsp;($results&nbsp;as&nbsp;$result)&nbsp;{</span></code></span></pre></div><pre id="cakeErr2-context" class="cake-context" style="display: none;">$results = null</pre><pre class="stack-trace">CommonComponent::identification() - APP/controllers/components/common.php, line 645
192
280
 
193
281
  ApisController::explain() - APP/controllers/apis_controller.php, line 987
194
282
 
@@ -196,45 +284,7 @@
196
284
 
197
285
  Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 171
198
286
 
199
- [main] - APP/webroot/index.php, line 87</pre></div></pre><pre class="cake-debug"><a href="javascript:void(0);" onclick="document.getElementById('cakeErr2-trace').style.display = (document.getElementById('cakeErr2-trace').style.display == 'none' ? '' : 'none');"><b>Notice</b> (8)</a>: Undefined variable: u_id [<b>APP/controllers/components/common.php</b>, line <b>671</b>]<div id="cakeErr2-trace" class="cake-stack-trace" style="display: none;"><a href="javascript:void(0);" onclick="document.getElementById('cakeErr2-code').style.display = (document.getElementById('cakeErr2-code').style.display == 'none' ? '' : 'none')">Code</a><div id="cakeErr2-code" class="cake-code-dump" style="display: none;"><pre><code><span style="color: #000000">&nbsp;&nbsp;&nbsp;&nbsp;///////////////////////////////////////////////////////////////////</span></code>
200
-
201
- <code><span style="color: #000000">&nbsp;&nbsp;&nbsp;&nbsp;function&nbsp;identification(){</span></code>
202
-
203
- <span class="code-highlight"><code><span style="color: #000000">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$results=CommonComponent::CheckExplainParce($u_userid,$u_id);</span></code></span></pre></div><pre class="stack-trace">CommonComponent::identification() - APP/controllers/components/common.php, line 671
204
-
205
- ApisController::explain() - APP/controllers/apis_controller.php, line 987
206
-
207
- Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 204
208
-
209
- Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 171
210
-
211
- [main] - APP/webroot/index.php, line 87</pre></div></pre><pre class="cake-debug"><a href="javascript:void(0);" onclick="document.getElementById('cakeErr3-trace').style.display = (document.getElementById('cakeErr3-trace').style.display == 'none' ? '' : 'none');"><b>Warning</b> (2)</a>: fopen(/var/www/html/WebHive/result//.exp) [http://php.net/function.fopen]: failed to open stream: No such file or directory [<b>APP/controllers/components/common.php</b>, line <b>288</b>]<div id="cakeErr3-trace" class="cake-stack-trace" style="display: none;"><a href="javascript:void(0);" onclick="document.getElementById('cakeErr3-code').style.display = (document.getElementById('cakeErr3-code').style.display == 'none' ? '' : 'none')">Code</a> | <a href="javascript:void(0);" onclick="document.getElementById('cakeErr3-context').style.display = (document.getElementById('cakeErr3-context').style.display == 'none' ? '' : 'none')">Context</a><pre id="cakeErr3-context" class="cake-context" style="display: none;">$u_userid = null
212
-
213
- $u_id = null
214
-
215
- $cnt = 0
216
-
217
- $results = array()
218
-
219
- $cur_db = "default"
220
-
221
- $sql_query = ""
222
-
223
- $sql_query_no = 0
224
-
225
- $exp_file = "/var/www/html/WebHive/result//.exp"</pre><pre class="stack-trace">fopen - [internal], line ??
226
-
227
- CommonComponent::CheckExplainParce() - APP/controllers/components/common.php, line 288
228
-
229
- CommonComponent::identification() - APP/controllers/components/common.php, line 671
230
-
231
- ApisController::explain() - APP/controllers/apis_controller.php, line 987
232
-
233
- Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 204
234
-
235
- Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 171
236
-
237
- [main] - APP/webroot/index.php, line 87</pre></div></pre>{"result":"check","id":"20160728160050_44583","msg":"\u51e6\u7406\u6570=3 MapReduce\u6570=0 \u30b3\u30b9\u30c8=36"}raise @ ext-all.js:15(anonymous function) @ ext-all.js:15HiveExecute_fin @ (index):1199callback @ ext-all.js:15onComplete @ ext-all.js:15onStateChange @ ext-all.js:15(anonymous function) @ ext-all.js:15
287
+ [main] - APP/webroot/index.php, line 87</pre></div></pre>{"result":"check","id":"20160728175253_44583","msg":"\u51e6\u7406\u6570=4 MapReduce\u6570=0 \u30b3\u30b9\u30c8=40"}raise @ ext-all.js:15(anonymous function) @ ext-all.js:15HiveExecute_fin @ (index):1199callback @ ext-all.js:15onComplete @ ext-all.js:15onStateChange @ ext-all.js:15(anonymous function) @ ext-all.js:15
238
288
 
239
289
 
240
290
 

5

修正

2016/07/28 09:18

投稿

amaguri
amaguri

スコア227

test CHANGED
@@ -1 +1 @@
1
- つうcakephp ループ文の返事が返ってこない
1
+ cakephp ループ文の返事が返ってこない
test CHANGED
File without changes

4

エラー文の修正

2016/07/28 07:27

投稿

amaguri
amaguri

スコア227

test CHANGED
File without changes
test CHANGED
File without changes

3

修正

2016/07/28 07:10

投稿

amaguri
amaguri

スコア227

test CHANGED
File without changes
test CHANGED
@@ -64,9 +64,7 @@
64
64
 
65
65
  ///////////////////////////////////////////////////////////////////
66
66
 
67
- function identification(){
67
+ function identification($results){
68
-
69
- $results=CommonComponent::CheckExplainParce($u_userid,$u_id);
70
68
 
71
69
 
72
70
 
@@ -184,9 +182,9 @@
184
182
 
185
183
  エラー文です
186
184
 
187
- ```ここに言語を入力
188
-
189
- ext-all.js:15 Uncaught You're trying to decode an invalid JSON String: <pre class="cake-debug"><a href="javascript:void(0);" onclick="document.getElementById('cakeErr1-trace').style.display = (document.getElementById('cakeErr1-trace').style.display == 'none' ? '' : 'none');"><b>Notice</b> (8)</a>: Undefined variable: u_userid [<b>APP/controllers/components/common.php</b>, line <b>671</b>]<div id="cakeErr1-trace" class="cake-stack-trace" style="display: none;"><a href="javascript:void(0);" onclick="document.getElementById('cakeErr1-code').style.display = (document.getElementById('cakeErr1-code').style.display == 'none' ? '' : 'none')">Code</a><div id="cakeErr1-code" class="cake-code-dump" style="display: none;"><pre><code><span style="color: #000000">&nbsp;&nbsp;&nbsp;&nbsp;///////////////////////////////////////////////////////////////////</span></code>
185
+ ```
186
+
187
+ (index):1199 Uncaught You're trying to decode an invalid JSON String: <pre class="cake-debug"><a href="javascript:void(0);" onclick="document.getElementById('cakeErr1-trace').style.display = (document.getElementById('cakeErr1-trace').style.display == 'none' ? '' : 'none');"><b>Notice</b> (8)</a>: Undefined variable: u_userid [<b>APP/controllers/components/common.php</b>, line <b>671</b>]<div id="cakeErr1-trace" class="cake-stack-trace" style="display: none;"><a href="javascript:void(0);" onclick="document.getElementById('cakeErr1-code').style.display = (document.getElementById('cakeErr1-code').style.display == 'none' ? '' : 'none')">Code</a><div id="cakeErr1-code" class="cake-code-dump" style="display: none;"><pre><code><span style="color: #000000">&nbsp;&nbsp;&nbsp;&nbsp;///////////////////////////////////////////////////////////////////</span></code>
190
188
 
191
189
  <code><span style="color: #000000">&nbsp;&nbsp;&nbsp;&nbsp;function&nbsp;identification(){</span></code>
192
190
 
@@ -236,18 +234,8 @@
236
234
 
237
235
  Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 171
238
236
 
239
- [main] - APP/webroot/index.php, line 87</pre></div></pre>{"result":"check","id":"20160728133524_44581","msg":"\u51e6\u7406\u6570=3 MapReduce\u6570=0 \u30b3\u30b9\u30c8=36"}raise @ ext-all.js:15(anonymous function) @ ext-all.js:15HiveExecute_fin @ (index):1199callback @ ext-all.js:15onComplete @ ext-all.js:15onStateChange @ ext-all.js:15(anonymous function) @ ext-all.js:15
237
+ [main] - APP/webroot/index.php, line 87</pre></div></pre>{"result":"check","id":"20160728160050_44583","msg":"\u51e6\u7406\u6570=3 MapReduce\u6570=0 \u30b3\u30b9\u30c8=36"}raise @ ext-all.js:15(anonymous function) @ ext-all.js:15HiveExecute_fin @ (index):1199callback @ ext-all.js:15onComplete @ ext-all.js:15onStateChange @ ext-all.js:15(anonymous function) @ ext-all.js:15
238
+
239
+
240
240
 
241
241
  ```
242
-
243
-
244
-
245
- 追記
246
-
247
- $results=CommonComponent::CheckExplainParce($u_userid,$u_id);
248
-
249
-
250
-
251
- $results=CommonComponent::CheckExplainParce();
252
-
253
- にしてもエラー文は同じでした。

2

追記

2016/07/28 07:04

投稿

amaguri
amaguri

スコア227

test CHANGED
@@ -1 +1 @@
1
- cakephp ループ文の返事が返ってこない
1
+ つうcakephp ループ文の返事が返ってこない
test CHANGED
@@ -239,3 +239,15 @@
239
239
  [main] - APP/webroot/index.php, line 87</pre></div></pre>{"result":"check","id":"20160728133524_44581","msg":"\u51e6\u7406\u6570=3 MapReduce\u6570=0 \u30b3\u30b9\u30c8=36"}raise @ ext-all.js:15(anonymous function) @ ext-all.js:15HiveExecute_fin @ (index):1199callback @ ext-all.js:15onComplete @ ext-all.js:15onStateChange @ ext-all.js:15(anonymous function) @ ext-all.js:15
240
240
 
241
241
  ```
242
+
243
+
244
+
245
+ 追記
246
+
247
+ $results=CommonComponent::CheckExplainParce($u_userid,$u_id);
248
+
249
+
250
+
251
+ $results=CommonComponent::CheckExplainParce();
252
+
253
+ にしてもエラー文は同じでした。

1

エラー文の追記

2016/07/28 05:24

投稿

amaguri
amaguri

スコア227

test CHANGED
File without changes
test CHANGED
@@ -2,10 +2,6 @@
2
2
 
3
3
  何が原因でしょうか??
4
4
 
5
- エラーは出てきません
6
-
7
-
8
-
9
5
  ```php
10
6
 
11
7
  ///////////////////////////////////////////////////////////////////
@@ -183,3 +179,63 @@
183
179
  }
184
180
 
185
181
  ```
182
+
183
+
184
+
185
+ エラー文です
186
+
187
+ ```ここに言語を入力
188
+
189
+ ext-all.js:15 Uncaught You're trying to decode an invalid JSON String: <pre class="cake-debug"><a href="javascript:void(0);" onclick="document.getElementById('cakeErr1-trace').style.display = (document.getElementById('cakeErr1-trace').style.display == 'none' ? '' : 'none');"><b>Notice</b> (8)</a>: Undefined variable: u_userid [<b>APP/controllers/components/common.php</b>, line <b>671</b>]<div id="cakeErr1-trace" class="cake-stack-trace" style="display: none;"><a href="javascript:void(0);" onclick="document.getElementById('cakeErr1-code').style.display = (document.getElementById('cakeErr1-code').style.display == 'none' ? '' : 'none')">Code</a><div id="cakeErr1-code" class="cake-code-dump" style="display: none;"><pre><code><span style="color: #000000">&nbsp;&nbsp;&nbsp;&nbsp;///////////////////////////////////////////////////////////////////</span></code>
190
+
191
+ <code><span style="color: #000000">&nbsp;&nbsp;&nbsp;&nbsp;function&nbsp;identification(){</span></code>
192
+
193
+ <span class="code-highlight"><code><span style="color: #000000">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$results=CommonComponent::CheckExplainParce($u_userid,$u_id);</span></code></span></pre></div><pre class="stack-trace">CommonComponent::identification() - APP/controllers/components/common.php, line 671
194
+
195
+ ApisController::explain() - APP/controllers/apis_controller.php, line 987
196
+
197
+ Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 204
198
+
199
+ Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 171
200
+
201
+ [main] - APP/webroot/index.php, line 87</pre></div></pre><pre class="cake-debug"><a href="javascript:void(0);" onclick="document.getElementById('cakeErr2-trace').style.display = (document.getElementById('cakeErr2-trace').style.display == 'none' ? '' : 'none');"><b>Notice</b> (8)</a>: Undefined variable: u_id [<b>APP/controllers/components/common.php</b>, line <b>671</b>]<div id="cakeErr2-trace" class="cake-stack-trace" style="display: none;"><a href="javascript:void(0);" onclick="document.getElementById('cakeErr2-code').style.display = (document.getElementById('cakeErr2-code').style.display == 'none' ? '' : 'none')">Code</a><div id="cakeErr2-code" class="cake-code-dump" style="display: none;"><pre><code><span style="color: #000000">&nbsp;&nbsp;&nbsp;&nbsp;///////////////////////////////////////////////////////////////////</span></code>
202
+
203
+ <code><span style="color: #000000">&nbsp;&nbsp;&nbsp;&nbsp;function&nbsp;identification(){</span></code>
204
+
205
+ <span class="code-highlight"><code><span style="color: #000000">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$results=CommonComponent::CheckExplainParce($u_userid,$u_id);</span></code></span></pre></div><pre class="stack-trace">CommonComponent::identification() - APP/controllers/components/common.php, line 671
206
+
207
+ ApisController::explain() - APP/controllers/apis_controller.php, line 987
208
+
209
+ Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 204
210
+
211
+ Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 171
212
+
213
+ [main] - APP/webroot/index.php, line 87</pre></div></pre><pre class="cake-debug"><a href="javascript:void(0);" onclick="document.getElementById('cakeErr3-trace').style.display = (document.getElementById('cakeErr3-trace').style.display == 'none' ? '' : 'none');"><b>Warning</b> (2)</a>: fopen(/var/www/html/WebHive/result//.exp) [http://php.net/function.fopen]: failed to open stream: No such file or directory [<b>APP/controllers/components/common.php</b>, line <b>288</b>]<div id="cakeErr3-trace" class="cake-stack-trace" style="display: none;"><a href="javascript:void(0);" onclick="document.getElementById('cakeErr3-code').style.display = (document.getElementById('cakeErr3-code').style.display == 'none' ? '' : 'none')">Code</a> | <a href="javascript:void(0);" onclick="document.getElementById('cakeErr3-context').style.display = (document.getElementById('cakeErr3-context').style.display == 'none' ? '' : 'none')">Context</a><pre id="cakeErr3-context" class="cake-context" style="display: none;">$u_userid = null
214
+
215
+ $u_id = null
216
+
217
+ $cnt = 0
218
+
219
+ $results = array()
220
+
221
+ $cur_db = "default"
222
+
223
+ $sql_query = ""
224
+
225
+ $sql_query_no = 0
226
+
227
+ $exp_file = "/var/www/html/WebHive/result//.exp"</pre><pre class="stack-trace">fopen - [internal], line ??
228
+
229
+ CommonComponent::CheckExplainParce() - APP/controllers/components/common.php, line 288
230
+
231
+ CommonComponent::identification() - APP/controllers/components/common.php, line 671
232
+
233
+ ApisController::explain() - APP/controllers/apis_controller.php, line 987
234
+
235
+ Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 204
236
+
237
+ Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 171
238
+
239
+ [main] - APP/webroot/index.php, line 87</pre></div></pre>{"result":"check","id":"20160728133524_44581","msg":"\u51e6\u7406\u6570=3 MapReduce\u6570=0 \u30b3\u30b9\u30c8=36"}raise @ ext-all.js:15(anonymous function) @ ext-all.js:15HiveExecute_fin @ (index):1199callback @ ext-all.js:15onComplete @ ext-all.js:15onStateChange @ ext-all.js:15(anonymous function) @ ext-all.js:15
240
+
241
+ ```