JezF

Just in case it helps anyone else, I fixed it, albeit by accident.

I had no colours or borders showing on any style, but I created a new custom style and suddenly everything is working properly again – the standard styles and my custom style.

So my confidence in the plugin (and my chances of getting help if it goes wrong again in the future) is a little dented but for now, it’s working.

Problem solved thanks to the marvellous Plugin Organizer which allowed me to disable the plugin except on the dozen or so pages that are actually using it.

Hi Tobias,

Actually, it’s even odder than I thought. Try this table:

Turkey Flotilla Prices

If you sort on the column headed “With Flights”, the first click doesn’t actually get the sort right at all, though it does shuffle the rows a bit.

Click to sort again and the descending order seems right, albeit with the “ask”s appearing part way down in a group with just one numeric value in the middle of them.

Click again and now the ascending order is correct but with the “ask”s again grouped part way down the list, again with a single value in the middle of them.

Strange!

Hi Tobias,

I’ve amended my tables accordingly. The prices now sort fine though there’s one thing that surprised me.

I have a number of holidays that have to be priced on request, denoted in the price column by the text “ask”. I assumed these would sort to the top or the bottom of the prices but they seem to just spread throughout when sorted.

The prices around them sort in order so it’s not a big issue but do you know if there’s any way to get the “ask”s to go to the top or bottom of the sort?

regards
Jeremy

Hi Tobias,

What a great chap you are. Thanks so much.

I’ve now moved everything over to Tablepress so I’m only left with one problem – the currency sort.

Here’s an example of the code I’m using:

"aoColumnDefs": [ { "bSortable": true, "aTargets": [ 3,4,8,9,10] }, { "bSortable": false, "aTargets": [ "_all" ] }, { "sType": "numeric-comma", "aTargets": [ 9,10 ] }]

The first part turns off the sorting on all except columns 3, 4, 8, 9 & 10. The last bit should enable currency sorting on columns 9 & 10. These contain prices in ￡ (an example here) or in € (an example here).

After going over and over the code searching for a syntax error, I noticed a table where I’d forgotten to put the currency sign in and this one seems to sort ok.

So I’m guessing it’s the currency symbol that’s causing the problem but I really need to show it in each cell or it’s too easy to get mixed up. I know the euro and ￡ will probably soon reach parity but we’re not quite there yet ??

Is there a way to get my prices sorting properly like they did in Reloaded?

REgards
Jeremy

A contribution for your good work this afternoon just sent. More once the business gets going!

Hi,

No, I’m not multisite – one is quite enough! I have got 40 tables on my site though (told you I like your plugin)!!

Anyway, I will have a go in the next few days – sounds like I might need some help with the currency sorting.

Question is, will Tablepress be fast enough to enable me to rejoin some of the tables I had to split – I found a limit of around 2000 rows a bit restricting!!

I’ll let you know how it goes. Thanks again.

Hi Tobias,

Oh deep joy, another all night WordPress session by the sounds of it!!

I’ve no other caching plugins in use but sounds like moving to Tablepress is the best route anyway.

For info, the tables are called using hide_column and column-widths parameters in the short code. There’s a bit of Custom CSS in the plugin options page box (to centre some of the data in the columns) and then in the Custom Commands box at the foot of each table there is something like this:

"sDom": 'W<"clear">lfrtip', "oColumnFilterWidgets": { "sSeparator": "\\s*,+\\s*", "aiExclude": [ 6,9,10,11]},"aoColumnDefs": [ { "bSortable": true, "aTargets": [ 3,4,8,9,10] }, { "bSortable": false, "aTargets": [ "_all" ] }, { "sType": "currency_sorting", "aTargets": [ 9,10 ] } ]

I appreciate your new extensions may be quicker once I have understood how to use them, but is there still a Custom Commands box for each table? (because nothing is as fast to an idiot like me as a copy and paste)!!

Hi Tobias,

Wow, thanks for the super rapid response (and a great plugin too – no apologies needed)!

I think the refresh may not be working quite that frequently – at least one of the tables affected was last updated over a week ago.

I had been looking at updating to Tablepress as I guess this may also help the response times?

My nervousness about Tablepress is my tables use a number of extensions from Datatables.net, for filtering, selective column sorting etc. I was pretty pleased I managed to get these working as I’m not very technical. Are these easy to migrate? Your migration notes seem to suggest some care is needed and with it being the height of the holiday booking season I’m very short of time.

Also can I carry on using the existing tables until I have the Tablepress versions ready?

Thanks again – funds are a bit tight whilst I get my new business up and running but a donation will be with you as soon as I can. Great to have such superb support – I’ve only paid for one plugin for my site and the authors of that one haven’t bothered to respond to my support request in 2 weeks. You’re a star.

I have the PRO version but I think this should work to change the tab width on the free version too:

Post this CSS in to the box on the plugin’s settings page:

.wordpress-post-tabs-skin-pepper_grinder .ui-tabs .ui-tabs-nav li {width:23%;}

You will need to change the skin name from pepper_grinder to whichever skin you are using. The width can be specified as a set number of pixels rather than a % if you prefer.

Thanks Mike. Apart from the 3 standard fields, I’m only passing 3 extra fields that are all text, and this one.

I could change the checkbox multiple field to be a select multiple, or at a stretch even radio buttons. Am I likely to have the same problem with these?

Thanks Mike. I’ve had a go at changing the captcha div width, making it smaller and larger (so small you couldn’t read it, and so large the table border fell off the sidebar). I also tried changing it back to the standard rather than the small Captcha.

But no joy – the refresh button didn’t move a jot. However, I did notice when I made the width very wide that though the table border moved out, the width of the Captcha itself seemed to stay at about half the sidebar width. I’m guessing whatever is limiting the width is also causing the refresh to be misplaced. Maybe something in my theme?