WP-Table Reloaded 1.9.1: "DataTables TableTools" Options Broken in WP 3.1.1

Hi,

this seems to be coming from your theme, which is loading an old version of the jQuery JavaScript library (namely 1.2.6), while WordPress already loads version 1.4.4. Due to that, there’s a JavaScript conflict, as the old version is messing things up.

To confirm this, can you temporarily switch to the WordPress Default Theme (Twenty Ten) and test if the sorting works there?

Regards,
Tobias

Hi Tobias,

That fixed it! I upgraded to jQuery 1.4.4 and it works now.

Thanks for the help,
Clark

Hi Clark,

thanks for the confirmation! Great to hear that it works now!

You should actually not need to manually load version 1.4.4 of the jQuery library, as it is already being loaded – there’s no need to have it twice.

Best wishes,
Tobias

You’re right. I apparently don’t need to load it. Thanks for the heads-up.

Clark

p.s. 1 suggestion that would be nice for whenever you release a new update – it’d be really great if columns disregarded html when sorting themselves alphabetically.

As you can see in the table on my site – I’ve hyperlinked all of the names of the organizations, and if someone sorts by the organization column, the result is not alphabetical. Thanks!

Hi Clark,

you can achieve the disregarding of HTML in the sorting by setting a manual option for the DataTables JavaScript library (see https://datatables.net/usage/columns).

Just add

"aoColumnDefs": [ { "sType": "html", "aTargets": [ 0 ] } ]

to the “Custom Commands” textfield in the “DataTables JavaScript Features” section on the “Edit” screen of your table.
(The 0 refers to the first column of your table, so if you change the table structure, you’ll need to change that.)

Regards,
Tobias

That’s fantastic! Thanks Tobias. That was the only part of the plugin that really annoyed me, so now it’s perfect. It’s a great plugin.

Best,
Clark

Hi Clark,

awesome! Nice to hear that ??

Best wishes,
Tobias

Hi Tobias,

I’m having the same problem: my tabletools are not working anymore, but how can I set WordPress so, that the latest (required) jquery version loads?

Thanks!

Mike

Hi Mike,

WordPress usually loads the required version automatically, it’s usually other plugins that ship with their own (older) version of jQuery that break this.
Can you provide the URL to the page with your table? Then I’ll take a look if this really is the case for your table.

Regards,
Tobias

The table on this page:

https://bit.ly/eaHxg2

Hi Mike,

oh, that table ??
But wasn’t this workind nicely yesterday?

I can’t find any additional jQuery libs being loaded, so that is definitely not the issue.
There’s however no script issue as well, so my assumption is that this is caused by some invalid HTML.
If you check your site with https://validator.w3.org, you will see that there are a few mistakes, which you should fix.

If the script is then still not working, I suggest that you ask in the DataTables forums at https://www.datatables.net, as I don’t really see why this is not working ??

Regards,
Tobias

Tobias,

I’ve tried almost everything but nothing will work… I don’t understand, I’ve resetted al my tweaks but still no result!

Maybe you can take a look for me in de admin?

Thanks!

Mike

Hi Mike,

taking a look in the admin area won’t help, because this is entirely a JavaScript problem on the frontend.
I really suggest that you try to get help from the DataTables developer in their forums.

Regards,
Tobias

The problem was with the cufon option in the theme!

When this is turned off, the tabletools not worked.

Hi Mike,

awesome! Great that you found the setting that is responsible for this!

Best wishes,
Tobias