sqlite -> mysql filtering broken
sqlite -> mysql filtering broken
Hi,
We use jsonrpc to provide data to datatables in a web2py installation. Recently, we switched from a development sqlite database to a full fledged mysql server and all of a sudden filtering in DataTables is broken. The curious thing is this: I copied the json being provided DataTables for the first 10 elements (paginated) unfiltered to a file, then I filtered on a string that would preserve the order (the first 10 elements all share the same filter strings) and copied the resulting json for that and there is -no difference-. DataTables continues to show the table full of the correct 10 entries, but the info box now displays 0 of 0 entries, and the pagination is disabled. Is there a way to print debugging information for what DataTables clearly thinks is an error? Can you point me at what I should be looking at in the fnSettings() object associated with the table?
Thanks,
Matt
We use jsonrpc to provide data to datatables in a web2py installation. Recently, we switched from a development sqlite database to a full fledged mysql server and all of a sudden filtering in DataTables is broken. The curious thing is this: I copied the json being provided DataTables for the first 10 elements (paginated) unfiltered to a file, then I filtered on a string that would preserve the order (the first 10 elements all share the same filter strings) and copied the resulting json for that and there is -no difference-. DataTables continues to show the table full of the correct 10 entries, but the info box now displays 0 of 0 entries, and the pagination is disabled. Is there a way to print debugging information for what DataTables clearly thinks is an error? Can you point me at what I should be looking at in the fnSettings() object associated with the table?
Thanks,
Matt
This discussion has been closed.
Replies
Please disregard this message, the issue has been resolved and obviously was not a DataTables problem :)