Open wiblaa opened 2 years ago
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: selectcorporation_infos.* fromcorporation_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.* fromcorporation_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)
[2021-11-17 10:25:16] local.ERROR: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'tracking' in 'order clause' (SQL: select
.* from
where
not between 1000000 and 1999999 and
.
in (131511956) order by
desc 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: select
desc 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 |
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_infoswhere
corporation_idnot between 1000000 and 1999999 and
corporation_infos.
alliance_idin (131511956) order by
trackingdesc 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: select
corporation_infos.* from
corporation_infoswhere
corporation_idnot between 1000000 and 1999999 and
corporation_infos.
alliance_idin (131511956) order by
trackingdesc limit 100 offset 0) at /var/www/seat/vendor/yajra/laravel-datatables-oracle/src/DataTableAbstract.php:879)
Version Info: PHP 7.3