Database Query Builder cannot do paged query on MySQL v2

[jellederijke]

Refering to this earlier post:

Database Query Builder cannot do paged query on MySQL

Hi there Wappler support, I recently found an issue with the simple query builder. When I want to do a paged record it creates this query: SELECT * FROM aansluitingen FETCH NEXT 5 ROWS ONLY But I get this error: [errorsyntax] If I do custom query and change the FETCH NEXT 5 ROWS ONLY to LIMIT 5 I get no error and it just works. This is using the latest Wappler version and connected to a DO managed db. MySQL, using a legacy user account for the db. Happy to provide with more details, but …

For me in version 5.4.3 this issue is not fixed. I get this error:

// 20230307154921
// http://localhost:8100/dmxConnect/api/pdf_creation/create_pdf_aansluitbewijs_2023.php

{
  "code": "42S21",
  "file": "/var/www/html/dmxConnectLib/lib/db/Connection.php",
  "line": 112,
  "message": "SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'id'",
  "trace": "#0 /var/www/html/dmxConnectLib/lib/db/Connection.php(112): PDO->prepare('SELECT COUNT(*)...')\n#1 /var/www/html/dmxConnectLib/modules/dbconnector.php(240): lib\\db\\Connection->execute('SELECT COUNT(*)...', Array)\n#2 /var/www/html/dmxConnectLib/lib/App.php(204): modules\\dbconnector->paged(Object(stdClass), 'query', Array)\n#3 /var/www/html/dmxConnectLib/lib/App.php(176): lib\\App->execSteps(Object(stdClass))\n#4 /var/www/html/dmxConnectLib/lib/App.php(144): lib\\App->execSteps(Array)\n#5 /var/www/html/dmxConnectLib/lib/App.php(133): lib\\App->exec(Object(stdClass), false)\n#6 /var/www/html/dmxConnectLib/lib/App.php(111): lib\\App->exec(Object(stdClass))\n#7 /var/www/html/dmxConnect/api/pdf_creation/create_pdf_aansluitbewijs_2023.php(8): lib\\App->define(Object(stdClass))\n#8 {main}"
}

I don’t really understand why ‘column already exists’ comes up, since it is a query to get records, but anyway it still seems to be broken for me.

Thanks again for the support!