0

I've got a strange issue with DataTables and destroy. I am using version 1.10.3 (but also tried 1.10.7) and fixedColumns Plugin (3.0). When I want to destroy the table I get an error in the plugin:

Uncaught TypeError: $(...).fn is not a function

My init looks like this:

fulltable = $('#auditplan_table_fs').dataTable();

and the destroy

fulltable.fnDestroy();

but I've also tried to initalize via .DataTable() and destroy via .api().destroy() or .destroy() which leads to the same result. Any possible solution would be appreciated.

UPDATE: As it seems it isn't a problem with FixedColumns, here is some more information. I'm calling the dataTable in an ajax success like this:

$('#auditplan_table_fs').append(responseData.findinglist.html);
          fulltable = $('#auditplan_table_fs').dataTable({
            scrollY: newheight,
            scrollX: true,
            scrollCollapse: true,
            "bSort": false,
            paging: false
});
new $.fn.dataTable.FixedColumns(fulltable);

In a document change function (when I select some values from a dropdown) I try to destroy the table like I posted before and then call the ajax function again.

The fulltable variable is defined in my document ready, the assignment happens, as already told, in my success function. When I print out the variable right before the destroy, everything seems to be fine.

UPDATE: It seems to be a bug in fixedColumns itself. I found out I am using 3.0.0 and the newest version is 3.0.4. With this one, I passed the first error and come up with a new one. I now get stuck in Line 1107:

Uncaught TypeError: Cannot read property 'anCells' of undefined

I suppose it has to do something with my init in an ajax call.

LAST UPDATE: Ok, I was to fast. It was only a caching problem. With the new version, everything is working fine.

Andi
  • 909
  • 1
  • 11
  • 26
  • Both methods should work right away, `dataTable()` -> `fnDestroy()` and `DataTable()` -> `destroy()` http://jsfiddle.net/4toLj9yn/412 and here http://jsfiddle.net/4toLj9yn/413 (both with 1.10.7 and FixedColumns) – davidkonrad Jun 18 '15 at 09:38
  • funny thing. Then I have to look for the problem elsewhere – Andi Jun 18 '15 at 09:43
  • Try post your code. The problem is as you said most certainly elsewhere around your use of dataTables. – davidkonrad Jun 18 '15 at 09:46

1 Answers1

0

If you do:

  1. jQuery
  2. DataTables
  3. jQuery

The second jQuery will overwrite the first one (which has DataTables attached to it). Thus, you would end up with a jQuery object that doesn't have DataTables available.

Bit frustrating that jQuery doesn't give an error about being loaded twice as it bites a lot of people

Reference

Khamill
  • 51
  • 7
ANR Upgraded Version
  • 857
  • 16
  • 39