phpmyadmin / error-reporting-server

         * for how to use Sql functions with cake

         */

        switch ($fieldName) {

            case 'browser':

                // SUBSTRING(browser, 1, LOCATE(' ', Incidents.browser)-1))

                $field = $groupedCount->func()->substring([

                    $fieldName => 'literal',

                    '1' => 'literal',

                    "Locate(' ', Incidents.browser)-1" => 'literal',

                ]);

                break;

            case 'server_software':

                // SUBSTRING(server_software, 1, LOCATE('/', Incidents.server_software)-1))

                $field = $groupedCount->func()->substring([

                    "Locate(' ', Incidents.browser)-1" => 'literal',

                ]);

                break;

            case 'server_software':

                // SUBSTRING(server_software, 1, LOCATE('/', Incidents.server_software)-1))

                $field = $groupedCount->func()->substring([

                    $fieldName => 'literal',

                    '1' => 'literal',

                    "Locate('/', Incidents.server_software)-1" => 'literal',

                ]);

                break;

            default:

                $field = $fieldName;