Skip to content

[Bug]: "msg":"SQLSTATE[42000]: Syntax error or access violation: 1064 #810

@thecicco

Description

@thecicco

Describe the problem

When i click edit zone and i'll try to filter some record i got this error:

Steps to reproduce

  1. go to list forward zone
  2. Edit some zone
  3. Filter something in this zone

Poweradmin version

ghcr.io/poweradmin/poweradmin tag: "4.0.3"

Database

MariaDB

Additional information (optional)

{"level":"info","ts":1760616216.7648144,"msg":"SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ''100' OFFSET '0'' at line 2","syslog_level":"notice"}
{"level":"info","ts":1760616216.7648437,"msg":"#0 /app/lib/Domain/Repository/RecordRepository.php(474): PDOStatement->execute(Array)\n#1 /app/lib/Application/Controller/EditController.php(379): Poweradmin\Domain\Repository\RecordRepository->getFilteredRecords(9, 0, 100, 'name', 'ASC', false, '%cdn%', '', '')\n#2 /app/lib/Application/Routing/BasicRouter.php(190): Poweradmin\Application\Controller\EditController->run()\n#3 /app/index.php(68): Poweradmin\Application\Routing\BasicRouter->process()\n#4 {main}","syslog_level":"notice"}

Poweradmin DB is a separate DB, so we got pdns DB and Poweradmin DB via Docker container.

MariaDB 11.7.2

Metadata

Metadata

Assignees

Labels

coreCore Features

Type

Projects

No projects

Milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions