Fatal Error on loading table

Huh. Only that one table?

Would you mind sharing the key and, if you’re using one, the query you’re using in that specific shortcode so I can have a look at the table contents, too?

Thanks. ??

Here is the shortcode (no query) :

[gdoc key=”https://docs.google.com/spreadsheets/d/1tatc0EBIpXgBzEFwakzqYCcbO7d6v0r7K9Cua2KVYek/edit” gid=”2099403487″ title=”Comptages de l’année en cours” class=”FixedColumns-left-1 no-datatables” header_rows=”1″]

Thanks !

Oh, interesting. I’m not sure why, but it seems Google is returning an HTTP response with a filename that breaks WordPress’s built-in serialization routines. This means the cache can not finish writing the complete serialized data value, and so when you go to load it from the cache there’s an unserialization error.

I’ve worked around this problem, and fixed a few other bugs, in the latest version 0.8.1, released a few seconds ago.

Let me know if this doesn’t solve the problem for you. ??

Also, the reason you’re not seeing the left column frozen is because you’ve included no-datatables in your class attribute. That will override FixedColumns-left-1 because fixed columns needs DataTables JavaScript to work, and the no-datatables class disables DataTables’s JavaScript.

Finally, header_rows="1" is the default, so you can omit that attribute altogether and you’ll still end up seeing a table with 1 header row. ??

It does work now whith the update, great !

Thanks a lot !

I did figure out that “no-datatables” removed the possibility to fix columns, but I forgot then, and the code stayed in a copy/paste done too quickly.

But in other pages it’s the FixedColumns that doesn’t work, I think it’s because they are included in a spoiler shortcode from Shortcode Ultimate plugin. Example in the sandbox here : https://www.logrami.fr/sandbox/

It may be a jquery bug from the SU plugin, but in case you understand what’s going on…

[gdoc key="https://docs.google.com/spreadsheets/d/1tatc0EBIpXgBzEFwakzqYCcbO7d6v0r7K9Cua2KVYek/edit" query="Select B,C,F,G,H,I,J,K,L,M,P,R,T,U,V,W,AC,AF,AG,AH,AI WHERE A ='Chatellerault' ORDER BY B?asc" class="FixedColumns-left-2"]

Thanks again for your work !

Hey Tim, it does seem to be a JavaScript incompatibility, because without the SU plugin you mentioned, the freeze works fine. I took a brief look at the SU plugin, too, but honestly it looked kinda messy and it seems to be packaging a bunch of shortcodes available elsewhere (along with some nag and adware?!?!) into one plugin, which seems kind of unscrupulous to me. So, I didn’t do any further digging into the incompatibility.