Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Ticket List Search "Import Id" Fatal Error: ambiguous column import_key #31171

Open
cbeasley-sbb opened this issue Sep 27, 2024 · 0 comments
Open

Ticket List Search "Import Id" Fatal Error: ambiguous column import_key #31171

cbeasley-sbb opened this issue Sep 27, 2024 · 0 comments
Labels
Bug This is a bug (something does not work as expected)

Comments

@cbeasley-sbb
Copy link
Contributor

Bug

Searching on "Import Id" fails for ticket list searches. The search condition does not prefix the search conditions with the table alias "t.".

Dolibarr Version

18.0

Environment PHP

PHP 7.x

Environment Database

10.11.3-MariaDB-1 - Debian 12

Steps to reproduce the behavior and expected behavior

  1. Visit the Ticket list page
  2. Add "Import Id" to the columns displayed and searchable.
  3. Input a value into the search field for "Import Id"
  4. Execute the search.

Attached files

Screenshot_2024_09_27_at_2 03 41_PM
@cbeasley-sbb cbeasley-sbb added the Bug This is a bug (something does not work as expected) label Sep 27, 2024
@cbeasley-sbb cbeasley-sbb changed the title Ticket List Search "Import Id(import_key)" column ambiguous column SQL Fatal error. Ticket List Search "Import Id" Fatal Error: ambiguous column import_key Sep 27, 2024
This was referenced Nov 23, 2024
Merged
Merged
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
Bug This is a bug (something does not work as expected)
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@cbeasley-sbb