Skip to content

[Bug]: Searching a RR in a zone throw error #919

@stanjeptha

Description

@stanjeptha

Describe the problem

Searching for a RR in a zone edit will throw an error

Steps to reproduce

  1. Go to a zone and press edit button
  2. Search for a record, e.g. "mail"
  3. The URL will be:
    Example search:
    https://myserver.local/poweradmin/index.php?page=edit&id=62&search=mail&record_type=&content=

The message: An error occurred while processing the request.

And PHP-FPM:
tail -f /var/opt/remi/php83/log/php-fpm/www-error.log

[22-Dec-2025 09:51:46 EET] 2025-12-22T09:51:46+02:00 [INFO]: [SessionAuthenticator] User admin uses SQL for authentication [{"username":"admin"}]
[22-Dec-2025 09:51:46 EET] 2025-12-22T09:51:46+02:00 [INFO]: [SqlAuthenticator] Starting authentication process.
[22-Dec-2025 09:51:46 EET] 2025-12-22T09:51:46+02:00 [INFO]: [SqlAuthenticator] Session ID regenerated for user admin [{"username":"admin"}]
[22-Dec-2025 09:51:46 EET] 2025-12-22T09:51:46+02:00 [INFO]: [SqlAuthenticator] Authentication process completed successfully for user admin [{"username":"admin"}]
[22-Dec-2025 09:51:46 EET] SQLSTATE[HY000]: General error: 1 ambiguous column name: name
[22-Dec-2025 09:51:46 EET] #0 /opt/poweradmin/lib/Infrastructure/Database/PDOCommon.php(139): PDO->prepare()
#1 /opt/poweradmin/lib/Domain/Repository/RecordRepository.php(471): Poweradmin\Infrastructure\Database\PDOCommon->prepare()
#2 /opt/poweradmin/lib/Application/Controller/EditController.php(379): Poweradmin\Domain\Repository\RecordRepository->getFilteredRecords()
#3 /opt/poweradmin/lib/Application/Routing/BasicRouter.php(190): Poweradmin\Application\Controller\EditController->run()
#4 /opt/poweradmin/index.php(68): Poweradmin\Application\Routing\BasicRouter->process()

Poweradmin version

4.0.4

Database

SQLite

Additional information (optional)

No response

Metadata

Metadata

Assignees

Labels

dnsDNS ManagementuiUser Interface

Type

Projects

No projects

Milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions