Invalid JSON response - It's not invalid..

SoNiice

Hi there,

I got an error about invalid json.. I checked it like 100 times, it's definitly not invalid. I found a character right before my json starts, but it makes no sense, there's no whitespace or anything in the code.

If this will help: http://debug.datatables.net/iyevus

There is all you need about the json response and so on..

Thanks in advance.

allan

It definitely is invalid :-). Run it through JSONLint or similar to confirm.

The issue is the multi-line string:

        ["1", "Sonic", "2", "40", "223246", "test
"],

That is not valid JSON. You need to check how that JSON is being generated and update it to handle the multi-lines correctly.

Allan

SoNiice

Hi Alan,

thank you for answering. But I cannot figure out how this new-line gets inserted.

Here you can see the JSON Response directly: http://www.metin2reloaded.net/SoNiice/request.php?module=main&action=highscore&datatables=true&draw=1&columns[0][data]=0&columns[0][name]=&columns[0][searchable]=true&columns[0][orderable]=true&columns[0][search][value]=&columns[0][search][regex]=false&columns[1][data]=1&columns[1][name]=&columns[1][searchable]=true&columns[1][orderable]=false&columns[1][search][value]=&columns[1][search][regex]=false&columns[2][data]=2&columns[2][name]=&columns[2][searchable]=true&columns[2][orderable]=false&columns[2][search][value]=&columns[2][search][regex]=false&columns[3][data]=3&columns[3][name]=&columns[3][searchable]=true&columns[3][orderable]=false&columns[3][search][value]=&columns[3][search][regex]=false&columns[4][data]=4&columns[4][name]=&columns[4][searchable]=true&columns[4][orderable]=false&columns[4][search][value]=&columns[4][search][regex]=false&columns[5][data]=5&columns[5][name]=&columns[5][searchable]=true&columns[5][orderable]=false&columns[5][search][value]=&columns[5][search][regex]=false&order[0][column]=0&order[0][dir]=asc&start=0&length=10&search[value]=&search[regex]=false&_=1439216393466

There is no new-line, but when I debug, I'll see the new lines. There is no code inside tho.

```$aPlayers = explode('~', file_get_contents('cache/player_ranking.txt', FILE_USE_INCLUDE_PATH));
$lCount = count($aPlayers);
$aOut = array();

    foreach ($aPlayers as $lKey => $sPlayer) {
        $aPlayers[$lKey] = explode('|', $sPlayer);

        if (!empty($_REQUEST['search']['value'])) {
            if (strpos(strtolower($aPlayers[$lKey][1]), strtolower($_REQUEST['search']['value'])) === false) {
                unset($aPlayers[$lKey]);
                continue;
            }
        }
    }

    if (count($aPlayers) !== 0) {
        $aSort = array();
        $lSortColumn = $_REQUEST['order'][0]['column'];

        foreach ($aPlayers as $k => $v) {
            $aSort[$lSortColumn][$k] = $v[$lSortColumn];
        }

        array_multisort($aSort[$lSortColumn], $_REQUEST['order'][0]['dir'] === 'asc' ? SORT_ASC : SORT_DESC, $aPlayers);
    }

    for ($i = Request::GetInteger('start'); $i < (Request::GetInteger('start') + Request::GetInteger('length')); $i++) {
        if (!isset($aPlayers[$i])) {
            continue;
        }

        $aRow = array();
        $aRow[0] = $aPlayers[$i][0];
        $aRow[1] = $aPlayers[$i][1];
        $aRow[2] = $aPlayers[$i][2];
        $aRow[3] = $aPlayers[$i][3];
        $aRow[4] = $aPlayers[$i][4];
        $aRow[5] = $aPlayers[$i][5];

        $aOut[] = $aRow;
    }

    $aDataTables = array(
        'draw' => Request::GetInteger('draw'),
        'recordsTotal' => $lCount,
        'recordsFiltered' => count($aPlayers),
        'data' => $aOut
    );

    echo json_encode($aDataTables);```

SoNiice

I just tried to write down the json by my own, so I didn't use json_encode now. There is still atleast one line-break.

tangerine

Just a guess: byte order mark in your text file?

https://duckduckgo.com/?q=bom+byte+json

allan

Ooo - if I open the debug trace direct from the database I can see the following:

\ufeff\ufeff\ufeff\ufeff{\"draw\":1,\"recordsTotal\":4,\"recordsFiltered\":4,\"data\":[[\"1\",\"Sonic\",\"2\",\"40\",\"223246\",\"test\\n\"],[\"2\",\"Knuckles\",\"2\",\"12\",\"21632\",\"test\\n\"],[\"3\",\"Kelb\",\"3\",\"1\",\"9\",\"test\\n\"],[\"4\",\"SoNiice\",\"2\",\"1\",\"0\",\"test\"]]}","status":200,"statusText":"OK"}

I think tangerine is absolutely spot on. The BOM is causing the issue.

Nice one!

Allan

SoNiice

Thank you very much, I don't know how that happened.. But somehow all my files changed to UTF8...

Have a nice day!