CakePHP: the rapid development php framework: Errors

Warning (2): foreach() argument must be of type array|object, null given [/home/karin/vhost/pckeiba.karin-p.com/app/Controller/DefaultsController.php, line 217]

Code Context


            // 合計を作る
            foreach ($predict["senko"] as $k => $v) {

DefaultsController::detail() - /home/karin/vhost/pckeiba.karin-p.com/app/Controller/DefaultsController.php, line 217
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 499
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167
[main] - /home/karin/vhost/pckeiba.karin-p.com/public_html/index.php, line 112

Warning (2): Undefined array key "gokei" [/home/karin/vhost/pckeiba.karin-p.com/app/Controller/DefaultsController.php, line 223]

Code Context


            // 合計の順位を作る
            $tmp = $predict["gokei"];

DefaultsController::detail() - /home/karin/vhost/pckeiba.karin-p.com/app/Controller/DefaultsController.php, line 223
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 499
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167
[main] - /home/karin/vhost/pckeiba.karin-p.com/public_html/index.php, line 112

arsort(): Argument #1 ($array) must be of type array, null given

Error: An Internal Error Has Occurred.

Stack Trace

/home/karin/vhost/pckeiba.karin-p.com/app/Controller/DefaultsController.php line 224 → arsort()


            // 合計の順位を作る
            $tmp = $predict["gokei"];
            arsort($tmp);

[internal function] → DefaultsController->detail()

CORE/Cake/Controller/Controller.php line 499 → ReflectionMethod->invokeArgs()

                    'action' => $request->params['action']
                ));
            }
            return $method->invokeArgs($this, $request->params['pass']);

CORE/Cake/Routing/Dispatcher.php line 193 → Controller->invokeAction()


        $response = $controller->response;
        $render = true;
        $result = $controller->invokeAction($request);
        if ($result instanceof CakeResponse) {

CORE/Cake/Routing/Dispatcher.php line 167 → Dispatcher->_invoke()

            ));
        }

        $response = $this->_invoke($controller, $request);
        if (isset($request->params['return'])) {

/home/karin/vhost/pckeiba.karin-p.com/public_html/index.php line 112 → Dispatcher->dispatch()

$Dispatcher = new Dispatcher();
$Dispatcher->dispatch(
    new CakeRequest(),
    new CakeResponse()
);

(default) 26 queries took 17 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	SELECT CODE, CONTENT FROM `JVD_KEIBAJO_CODE`	112	112	0
2	SELECT CODE, CONTENT FROM `JVD_KYOSO_SHUBETSU_CODE`	11	11	0
3	SELECT CODE, CONTENT FROM `JVD_KYOSO_JOKEN_CODE`	105	105	0
4	SELECT CODE, CONTENT FROM `JVD_KYOSO_KIGO_CODE`	86	86	0
5	SELECT CODE, CONTENT FROM `JVD_GRADE_CODE`	10	10	0
6	SELECT CODE, CONTENT FROM `JVD_TRACK_CODE`	30	30	0
7	SELECT CODE, CONTENT FROM `JVD_UMAKIGO_CODE`	29	29	0
8	SELECT CODE, CONTENT FROM `JVD_IJO_KUBUN_CODE`	8	8	0
9	SELECT CODE, CONTENT FROM `JVD_CHAKUSA_CODE`	23	23	0
10	SELECT * FROM `JVD_RACE_SHOSAI` WHERE RACE_CODE = ? , params[ 2019012705010207 ]	1	1	1
11	SELECT * FROM `JVD_RACE_SHOSAI` WHERE KAISAI_NENGAPPI = ? AND KEIBAJO_CODE = ? ORDER BY RACE_CODE ASC , params[ 2019-01-27 00:00:00, 05 ]	12	12	0
12	SELECT RACE_CODE, KAISAI_NENGAPPI, DIRT_BABAJOTAI_CODE, SHIBA_BABAJOTAI_CODE FROM `JVD_RACE_SHOSAI` WHERE ((TOKUBETSU_KYOSO_BANGO <> '0000' AND TOKUBETSU_KYOSO_BANGO = ?) OR (KYOSOMEI_HONDAI <> '' AND KYOSOMEI_HONDAI = ?)) AND KEIBAJO_CODE = ? AND KYORI = ? AND TRACK_CODE = ? AND KYOSO_SHUBETSU_CODE = ? AND KYOSO_JOKEN_CODE_SAIJAKUNEN IN ('004','005','006') AND GRADE_CODE = ? AND KAISAI_NENGAPPI >= '1986-01-01 00:00:00' AND DATA_KUBUN <> '9' ORDER BY KAISAI_NENGAPPI DESC , params[ 0000, , 05, 2100, 23, 14 ]	0	0	0
13	SELECT * FROM `JVD_UMAGOTO_RACE_JOHO` WHERE RACE_CODE = ? AND DATA_KUBUN >= 2 ORDER BY UMABAN ASC, REPLACE(BAMEI, 'ヴ', 'ウヴ') ASC , params[ 2019012705010207 ]	11	11	1
14	SELECT * FROM `JVD_UMAGOTO_RACE_JOHO` LEFT JOIN `JVD_RACE_SHOSAI` ON `JVD_UMAGOTO_RACE_JOHO`.RACE_CODE = `JVD_RACE_SHOSAI`.RACE_CODE WHERE `JVD_UMAGOTO_RACE_JOHO`.KETTO_TOROKU_BANGO = ? AND `JVD_UMAGOTO_RACE_JOHO`.KAISAI_NENGAPPI < ? AND `JVD_UMAGOTO_RACE_JOHO`.DATA_KUBUN IN ('3', '4', '5', '6', '7', 'A', 'B') ORDER BY `JVD_UMAGOTO_RACE_JOHO`.KAISAI_NENGAPPI DESC LIMIT 0,5 , params[ 2015104426, 2019-01-27 00:00:00 ]	5	5	2
15	SELECT * FROM `JVD_UMAGOTO_RACE_JOHO` LEFT JOIN `JVD_RACE_SHOSAI` ON `JVD_UMAGOTO_RACE_JOHO`.RACE_CODE = `JVD_RACE_SHOSAI`.RACE_CODE WHERE `JVD_UMAGOTO_RACE_JOHO`.KETTO_TOROKU_BANGO = ? AND `JVD_UMAGOTO_RACE_JOHO`.KAISAI_NENGAPPI < ? AND `JVD_UMAGOTO_RACE_JOHO`.DATA_KUBUN IN ('3', '4', '5', '6', '7', 'A', 'B') ORDER BY `JVD_UMAGOTO_RACE_JOHO`.KAISAI_NENGAPPI DESC LIMIT 0,5 , params[ 2015106260, 2019-01-27 00:00:00 ]	5	5	2
16	SELECT * FROM `JVD_UMAGOTO_RACE_JOHO` LEFT JOIN `JVD_RACE_SHOSAI` ON `JVD_UMAGOTO_RACE_JOHO`.RACE_CODE = `JVD_RACE_SHOSAI`.RACE_CODE WHERE `JVD_UMAGOTO_RACE_JOHO`.KETTO_TOROKU_BANGO = ? AND `JVD_UMAGOTO_RACE_JOHO`.KAISAI_NENGAPPI < ? AND `JVD_UMAGOTO_RACE_JOHO`.DATA_KUBUN IN ('3', '4', '5', '6', '7', 'A', 'B') ORDER BY `JVD_UMAGOTO_RACE_JOHO`.KAISAI_NENGAPPI DESC LIMIT 0,5 , params[ 2012100309, 2019-01-27 00:00:00 ]	5	5	1
17	SELECT * FROM `JVD_UMAGOTO_RACE_JOHO` LEFT JOIN `JVD_RACE_SHOSAI` ON `JVD_UMAGOTO_RACE_JOHO`.RACE_CODE = `JVD_RACE_SHOSAI`.RACE_CODE WHERE `JVD_UMAGOTO_RACE_JOHO`.KETTO_TOROKU_BANGO = ? AND `JVD_UMAGOTO_RACE_JOHO`.KAISAI_NENGAPPI < ? AND `JVD_UMAGOTO_RACE_JOHO`.DATA_KUBUN IN ('3', '4', '5', '6', '7', 'A', 'B') ORDER BY `JVD_UMAGOTO_RACE_JOHO`.KAISAI_NENGAPPI DESC LIMIT 0,5 , params[ 2015103112, 2019-01-27 00:00:00 ]	5	5	1
18	SELECT * FROM `JVD_UMAGOTO_RACE_JOHO` LEFT JOIN `JVD_RACE_SHOSAI` ON `JVD_UMAGOTO_RACE_JOHO`.RACE_CODE = `JVD_RACE_SHOSAI`.RACE_CODE WHERE `JVD_UMAGOTO_RACE_JOHO`.KETTO_TOROKU_BANGO = ? AND `JVD_UMAGOTO_RACE_JOHO`.KAISAI_NENGAPPI < ? AND `JVD_UMAGOTO_RACE_JOHO`.DATA_KUBUN IN ('3', '4', '5', '6', '7', 'A', 'B') ORDER BY `JVD_UMAGOTO_RACE_JOHO`.KAISAI_NENGAPPI DESC LIMIT 0,5 , params[ 2014106028, 2019-01-27 00:00:00 ]	5	5	1
19	SELECT * FROM `JVD_UMAGOTO_RACE_JOHO` LEFT JOIN `JVD_RACE_SHOSAI` ON `JVD_UMAGOTO_RACE_JOHO`.RACE_CODE = `JVD_RACE_SHOSAI`.RACE_CODE WHERE `JVD_UMAGOTO_RACE_JOHO`.KETTO_TOROKU_BANGO = ? AND `JVD_UMAGOTO_RACE_JOHO`.KAISAI_NENGAPPI < ? AND `JVD_UMAGOTO_RACE_JOHO`.DATA_KUBUN IN ('3', '4', '5', '6', '7', 'A', 'B') ORDER BY `JVD_UMAGOTO_RACE_JOHO`.KAISAI_NENGAPPI DESC LIMIT 0,5 , params[ 2015100559, 2019-01-27 00:00:00 ]	5	5	1
20	SELECT * FROM `JVD_UMAGOTO_RACE_JOHO` LEFT JOIN `JVD_RACE_SHOSAI` ON `JVD_UMAGOTO_RACE_JOHO`.RACE_CODE = `JVD_RACE_SHOSAI`.RACE_CODE WHERE `JVD_UMAGOTO_RACE_JOHO`.KETTO_TOROKU_BANGO = ? AND `JVD_UMAGOTO_RACE_JOHO`.KAISAI_NENGAPPI < ? AND `JVD_UMAGOTO_RACE_JOHO`.DATA_KUBUN IN ('3', '4', '5', '6', '7', 'A', 'B') ORDER BY `JVD_UMAGOTO_RACE_JOHO`.KAISAI_NENGAPPI DESC LIMIT 0,5 , params[ 2015101686, 2019-01-27 00:00:00 ]	5	5	1
21	SELECT * FROM `JVD_UMAGOTO_RACE_JOHO` LEFT JOIN `JVD_RACE_SHOSAI` ON `JVD_UMAGOTO_RACE_JOHO`.RACE_CODE = `JVD_RACE_SHOSAI`.RACE_CODE WHERE `JVD_UMAGOTO_RACE_JOHO`.KETTO_TOROKU_BANGO = ? AND `JVD_UMAGOTO_RACE_JOHO`.KAISAI_NENGAPPI < ? AND `JVD_UMAGOTO_RACE_JOHO`.DATA_KUBUN IN ('3', '4', '5', '6', '7', 'A', 'B') ORDER BY `JVD_UMAGOTO_RACE_JOHO`.KAISAI_NENGAPPI DESC LIMIT 0,5 , params[ 2014110023, 2019-01-27 00:00:00 ]	5	5	1
22	SELECT * FROM `JVD_UMAGOTO_RACE_JOHO` LEFT JOIN `JVD_RACE_SHOSAI` ON `JVD_UMAGOTO_RACE_JOHO`.RACE_CODE = `JVD_RACE_SHOSAI`.RACE_CODE WHERE `JVD_UMAGOTO_RACE_JOHO`.KETTO_TOROKU_BANGO = ? AND `JVD_UMAGOTO_RACE_JOHO`.KAISAI_NENGAPPI < ? AND `JVD_UMAGOTO_RACE_JOHO`.DATA_KUBUN IN ('3', '4', '5', '6', '7', 'A', 'B') ORDER BY `JVD_UMAGOTO_RACE_JOHO`.KAISAI_NENGAPPI DESC LIMIT 0,5 , params[ 2015100548, 2019-01-27 00:00:00 ]	5	5	1
23	SELECT * FROM `JVD_UMAGOTO_RACE_JOHO` LEFT JOIN `JVD_RACE_SHOSAI` ON `JVD_UMAGOTO_RACE_JOHO`.RACE_CODE = `JVD_RACE_SHOSAI`.RACE_CODE WHERE `JVD_UMAGOTO_RACE_JOHO`.KETTO_TOROKU_BANGO = ? AND `JVD_UMAGOTO_RACE_JOHO`.KAISAI_NENGAPPI < ? AND `JVD_UMAGOTO_RACE_JOHO`.DATA_KUBUN IN ('3', '4', '5', '6', '7', 'A', 'B') ORDER BY `JVD_UMAGOTO_RACE_JOHO`.KAISAI_NENGAPPI DESC LIMIT 0,5 , params[ 2014103669, 2019-01-27 00:00:00 ]	5	5	2
24	SELECT * FROM `JVD_UMAGOTO_RACE_JOHO` LEFT JOIN `JVD_RACE_SHOSAI` ON `JVD_UMAGOTO_RACE_JOHO`.RACE_CODE = `JVD_RACE_SHOSAI`.RACE_CODE WHERE `JVD_UMAGOTO_RACE_JOHO`.KETTO_TOROKU_BANGO = ? AND `JVD_UMAGOTO_RACE_JOHO`.KAISAI_NENGAPPI < ? AND `JVD_UMAGOTO_RACE_JOHO`.DATA_KUBUN IN ('3', '4', '5', '6', '7', 'A', 'B') ORDER BY `JVD_UMAGOTO_RACE_JOHO`.KAISAI_NENGAPPI DESC LIMIT 0,5 , params[ 2015104349, 2019-01-27 00:00:00 ]	5	5	1
25	SELECT * FROM `JVD_HARAIMODOSHI` WHERE RACE_CODE = ? LIMIT 0,1 , params[ 2019012705010207 ]	1	1	1
26	SELECT `Predict`.`id`, `Predict`.`logic_no`, `Predict`.`race_code`, `Predict`.`data`, `Predict`.`created`, `Predict`.`modified` FROM `pckeiba`.`predicts` AS `Predict` WHERE `race_code` = '2019012705010207' AND `logic_no` = 3 LIMIT 1	1	1	0

(default) 26 queries took 17 ms

Query

Error

Affected

Num. rows

Took (ms)

SELECT CODE, CONTENT FROM `JVD_KEIBAJO_CODE`

112

SELECT CODE, CONTENT FROM `JVD_KYOSO_SHUBETSU_CODE`

SELECT CODE, CONTENT FROM `JVD_KYOSO_JOKEN_CODE`

105

SELECT CODE, CONTENT FROM `JVD_KYOSO_KIGO_CODE`

SELECT CODE, CONTENT FROM `JVD_GRADE_CODE`

SELECT CODE, CONTENT FROM `JVD_TRACK_CODE`

SELECT CODE, CONTENT FROM `JVD_UMAKIGO_CODE`

SELECT CODE, CONTENT FROM `JVD_IJO_KUBUN_CODE`

SELECT CODE, CONTENT FROM `JVD_CHAKUSA_CODE`

SELECT * FROM `JVD_RACE_SHOSAI` WHERE RACE_CODE = ? , params[ 2019012705010207 ]

SELECT * FROM `JVD_RACE_SHOSAI` WHERE KAISAI_NENGAPPI = ? AND KEIBAJO_CODE = ? ORDER BY RACE_CODE ASC , params[ 2019-01-27 00:00:00, 05 ]

SELECT RACE_CODE, KAISAI_NENGAPPI, DIRT_BABAJOTAI_CODE, SHIBA_BABAJOTAI_CODE FROM `JVD_RACE_SHOSAI` WHERE ((TOKUBETSU_KYOSO_BANGO <> '0000' AND TOKUBETSU_KYOSO_BANGO = ?) OR (KYOSOMEI_HONDAI <> '' AND KYOSOMEI_HONDAI = ?)) AND KEIBAJO_CODE = ? AND KYORI = ? AND TRACK_CODE = ? AND KYOSO_SHUBETSU_CODE = ? AND KYOSO_JOKEN_CODE_SAIJAKUNEN IN ('004','005','006') AND GRADE_CODE = ? AND KAISAI_NENGAPPI >= '1986-01-01 00:00:00' AND DATA_KUBUN <> '9' ORDER BY KAISAI_NENGAPPI DESC , params[ 0000, , 05, 2100, 23, 14 ]

SELECT * FROM `JVD_UMAGOTO_RACE_JOHO` WHERE RACE_CODE = ? AND DATA_KUBUN >= 2 ORDER BY UMABAN ASC, REPLACE(BAMEI, 'ヴ', 'ウヴ') ASC , params[ 2019012705010207 ]

SELECT * FROM `JVD_UMAGOTO_RACE_JOHO` LEFT JOIN `JVD_RACE_SHOSAI` ON `JVD_UMAGOTO_RACE_JOHO`.RACE_CODE = `JVD_RACE_SHOSAI`.RACE_CODE WHERE `JVD_UMAGOTO_RACE_JOHO`.KETTO_TOROKU_BANGO = ? AND `JVD_UMAGOTO_RACE_JOHO`.KAISAI_NENGAPPI < ? AND `JVD_UMAGOTO_RACE_JOHO`.DATA_KUBUN IN ('3', '4', '5', '6', '7', 'A', 'B') ORDER BY `JVD_UMAGOTO_RACE_JOHO`.KAISAI_NENGAPPI DESC LIMIT 0,5 , params[ 2015104426, 2019-01-27 00:00:00 ]

SELECT * FROM `JVD_HARAIMODOSHI` WHERE RACE_CODE = ? LIMIT 0,1 , params[ 2019012705010207 ]

SELECT `Predict`.`id`, `Predict`.`logic_no`, `Predict`.`race_code`, `Predict`.`data`, `Predict`.`created`, `Predict`.`modified` FROM `pckeiba`.`predicts` AS `Predict` WHERE `race_code` = '2019012705010207' AND `logic_no` = 3 LIMIT 1