[GH-ISSUE #9] Issue with Tickets Plugin #9

Closed
opened 2026-05-07 00:16:58 +02:00 by BreizhHardware · 1 comment

Originally created by @Nik0-0 on GitHub (Dec 20, 2025).
Original GitHub issue: https://github.com/pelican-dev/plugins/issues/9

When trying to Answer to any ticket it errors out with:

SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'id' in WHERE is ambiguous (Connection: mariadb, SQL: select exists(select distinct `servers`.* from `servers` left join `subusers` on `subusers`.`server_id` = `servers`.`id` where (`servers`.`owner_id` = 1 or `subusers`.`user_id` = 1) and `id` = 12) as `exists`) {"userId":1,"exception":"[object] (Illuminate\\Database\\QueryException(code: 23000): SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'id' in WHERE is ambiguous (Connection: mariadb, SQL: select exists(select distinct `servers`.* from `servers` left join `subusers` on `subusers`.`server_id` = `servers`.`id` where (`servers`.`owner_id` = 1 or `subusers`.`user_id` = 1) and `id` = 12) as `exists`) at /var/www/pelican/vendor/laravel/framework/src/Illuminate/Database/Connection.php:826)

Originally created by @Nik0-0 on GitHub (Dec 20, 2025). Original GitHub issue: https://github.com/pelican-dev/plugins/issues/9 When trying to Answer to any ticket it errors out with: ```SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'id' in WHERE is ambiguous (Connection: mariadb, SQL: select exists(select distinct `servers`.* from `servers` left join `subusers` on `subusers`.`server_id` = `servers`.`id` where (`servers`.`owner_id` = 1 or `subusers`.`user_id` = 1) and `id` = 12) as `exists`) {"userId":1,"exception":"[object] (Illuminate\\Database\\QueryException(code: 23000): SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'id' in WHERE is ambiguous (Connection: mariadb, SQL: select exists(select distinct `servers`.* from `servers` left join `subusers` on `subusers`.`server_id` = `servers`.`id` where (`servers`.`owner_id` = 1 or `subusers`.`user_id` = 1) and `id` = 12) as `exists`) at /var/www/pelican/vendor/laravel/framework/src/Illuminate/Database/Connection.php:826)```
Author
Owner

@coderabbitai[bot] commented on GitHub (Dec 20, 2025):

📝 CodeRabbit Plan Mode

Generate an implementation plan and prompts that you can use with your favorite coding agent.

  • Create Plan
Examples


🧪 Issue enrichment is currently in open beta.

You can configure auto-planning by selecting labels in the issue_enrichment configuration.

To disable automatic issue enrichment, add the following to your .coderabbit.yaml:

issue_enrichment:
  auto_enrich:
    enabled: false

💬 Have feedback or questions? Drop into our discord or schedule a call!

<!-- gh-comment-id:3677302921 --> @coderabbitai[bot] commented on GitHub (Dec 20, 2025): <!-- This is an auto-generated issue plan by CodeRabbit --> ### 📝 CodeRabbit Plan Mode Generate an implementation plan and prompts that you can use with your favorite coding agent. - [ ] <!-- {"checkboxId": "8d4f2b9c-3e1a-4f7c-a9b2-d5e8f1c4a7b9"} --> Create Plan <details> <summary>Examples</summary> - [Example 1](https://github.com/coderabbitai/git-worktree-runner/issues/29#issuecomment-3589134556) - [Example 2](https://github.com/coderabbitai/git-worktree-runner/issues/12#issuecomment-3606665167) </details> --- --- <details> <summary> 🧪 Issue enrichment is currently in open beta.</summary> You can configure auto-planning by selecting labels in the issue_enrichment configuration. To disable automatic issue enrichment, add the following to your `.coderabbit.yaml`: ```yaml issue_enrichment: auto_enrich: enabled: false ``` </details> 💬 Have feedback or questions? Drop into our [discord](https://discord.gg/coderabbit) or [schedule a call](https://calendly.com/parth-coderabbit/issues-feedback)!
Sign in to join this conversation.
No labels
pull-request
No milestone
No project
No assignees
1 participant
Notifications
Due date
The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set.

Reference
starred/plugins#9
No description provided.