ItemsPerPage select All

[NanaAmadou]

Selecting All items per page show error: SQLSTATE[42000]: Syntax error or access violation: 1064 Erreur de syntaxe près de '0' à la ligne 1
SELECT
*
FROM
people OFFSET 0

[akfaiz]

Hi @NanaAmadou , what's your current database and how many total data in people table

[NanaAmadou]

Hi @ahmadfaizk i have 500 total data in people table. When i try to select 10 or 50 items per page it show them correctly but if i select All it is showing error

[akfaiz]

Hi @NanaAmadou , This code base is working on my local and my server, i'm use postgresql, i think some database not support paginate with -1 value, you can adjust pagination on your controller like this.
Before
$data = $query->paginate($request->get('limit', 10));
After

$pageSize = $request->get('limit', 10);
if ($pageSize == -1) {
    $data = $query->paginate($query->count());
} else {
    $data = $query->paginate($pageSize);
}