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

[wiblaa]

• 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 |

[Raikia]

This bug is old and is no longer relevant, as commit b2e6520 removed this functionality. However, ever since that functionality was removed, the search was still broken on that page. eveseat/web#717 resolves that issue now.

This bug should be closed now