trying to upgrade to newest version about datatables HOT 12 CLOSED

nice. glad to hear that.

from datatables.

hey thank you for using the library.

the error is related to sql query.

SELECT list contains nonaggregated column 't.account_action_seq'

Can you provide your full query?

from datatables.

sure but it did work with a previous version of your code.
SELECT account_action_seq, _from, _to, _quantity, _symbol, _memo, txid, block_num, block_time FROM transfers ORDER BY account_action_seq DESC

from datatables.

personally I think there is something wrong with my query parameters. I'm parsing/constructing them myself. so there must be something in your new version changed that broke it. probably something in the columnCollections...

from datatables.

I think I have found the issue and made a quick fix. can you update your library to 2.0.2 ?

let me know if it is fixed.

from datatables.

hey the update fixed something but still got the ColumnColections error

https://github.com/n1crack/datatables/blob/master/src/ColumnCollection.php#L153

from datatables.

can you share the header part of your ajax request ?
There is something wrong, couldn't figure it out yet.

from datatables.

btw if I disable errors it seems to work so the errors are not critical.
notice that I only have 7 columns in my parameters and my Mysql query selects 9.

from datatables.

as i thought, your table has only 6 column right? but it seems your sql has 8 columns.

from datatables.

yes but that did work in your previous version.

from datatables.

ok fixed. you can try it with 2.0.3 in a couple minutes

from datatables.

fix confirmed! thank you very much, you saved me a lot of work! In fact we're not using jquery datatables at all. I wrote an adapter for vue quasar datatables to work with your lib. peace!

from datatables.