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.

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

Alliance tracking - AJAX error when trying to sort by valid token #838

Open
wiblaa opened this issue Nov 17, 2021 · 0 comments
Open

Alliance tracking - AJAX error when trying to sort by valid token #838

wiblaa opened this issue Nov 17, 2021 · 0 comments
Assignees
Labels
bug complexity/low This task has a low complexity level good first issue Good for newcomers modules/alliances Stuff related to alliances to-check
Milestone

Comments

@wiblaa
Copy link

wiblaa commented Nov 17, 2021

  • Problem: I click to sort alliance membercorps by valid tokens, it gives an ajax error

  • Expected: The list gets sorted by valid tokens

  • Logs / Screenshots / Proof:
    [2021-11-17 10:25:16] local.ERROR: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'tracking' in 'order clause' (SQL: select corporation_infos.* from corporation_infoswherecorporation_idnot between 1000000 and 1999999 andcorporation_infos.alliance_idin (131511956) order bytrackingdesc limit 100 offset 0) {"userId":693,"exception":"[object] (Yajra\\DataTables\\Exceptions\\Exception(code: 0): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'tracking' in 'order clause' (SQL: selectcorporation_infos.* from corporation_infoswherecorporation_idnot between 1000000 and 1999999 andcorporation_infos.alliance_idin (131511956) order bytrackingdesc limit 100 offset 0) at /var/www/seat/vendor/yajra/laravel-datatables-oracle/src/DataTableAbstract.php:879)

  • Version Info: PHP 7.3

| Vendor  | Package Name   | Installed Version        |
| ------- | -------------- | ------------------------ |
| eveseat | api            | 4.7.0                    |
| eveseat | console        | 4.8.0                    |
| eveseat | eveapi         | 4.14.0                   |
| eveseat | notifications  | 4.3.1                    |
| eveseat | services       | 4.2.0                    |
| eveseat | web            | 4.15.0                   |
| ccp     | eve_online_sde | sde-20211104-TRANQUILITY |
@Crypta-Eve Crypta-Eve added bug complexity/low This task has a low complexity level good first issue Good for newcomers modules/alliances Stuff related to alliances labels Nov 17, 2021
@Crypta-Eve Crypta-Eve assigned Crypta-Eve and unassigned Crypta-Eve Feb 20, 2022
@Crypta-Eve Crypta-Eve self-assigned this Mar 2, 2022
@Crypta-Eve Crypta-Eve added this to the 5.1 milestone Jan 9, 2025
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug complexity/low This task has a low complexity level good first issue Good for newcomers modules/alliances Stuff related to alliances to-check
Projects
None yet
Development

No branches or pull requests

2 participants