rickmiddleton

THANK YOU @rtd2 !

I was totally tearing my hair out.

The instructions for User Sync REALLY ought to tell you that you need to set first_name and last_name as additional fields before they will sync back from Mailchimp into WordPress.

IF YOU HAVE THE POWER PLEASE DO IT NOW – UPDATE THAT WEBHOOKS SECTION GUIDE…

That way the next poor soul will not have to suffer hours of wasted time.

Also I have a list of PHP extensions that I can enable / disable – I have not touched the settings that were there already…

Are there any particular PHP extensions that need to be turned on for this plug in to function correctly?

Also whilst i have used PHP Selector to choose v7.2, when I inspect the “server settings” elsewhere – which I cannot alter – it says:
Apache Version 2.4.35
PHP Version 5.6.38

Is this cause for concern?

Thanks for the reply!

I’ve had a look at the error_log that’s currently on my wordpress (I think it’s a php error log as that was it was showing – it had certain php code lines specified – where I’d made the odd syntax error whilst developing and testing pages.)

There don’t seem to be any obvious errors now – what would I be looking for?

I can’t seem to see apache errors.

Our site is using cPanel hosting and the control panel doesn’t seem to mention anything about apache at all.

I set post_max_size to 32 Mb to allow for upload of my theme – so that’s no problem – and the only suhosin controls I have are:
suhosin.get.max_name_length
suhosin.post.max_name_length
suhosin.request.max_varname_length

which I have set to the maximum allowed of 512

I have no idea about ModSecurity – no details are showing on my cPanel.

Any other help you may be able to give is much appreciated ??

Hmm took me a while to figure…

use:
meta_type => ‘NUMERIC’

that sorts the issue ??

Right…

Using meta_value_num for the sort order is of course the thing to do when displaying dates on one page – but it does not help with on the 1000000000 UNIX time query issue.

Is there some way of getting BETWEEN to work in number sort instead of text?

Hmmm – So this is to do with String sorting versus numerical?? So perhaps I just need to change the sort by for the query as noted in the WP codex?

‘meta_value’ – Note that a ‘meta_key=keyname’ must also be present in the query. Note also that the sorting will be alphabetical which is fine for strings (i.e. words), but can be unexpected for numbers (e.g. 1, 3, 34, 4, 56, 6, etc, rather than 1, 3, 4, 6, 34, 56 as you might naturally expect). Use ‘meta_value_num’ instead for numeric values. You may also specify ‘meta_type’ if you want to cast the meta value as a specific type. Possible values are ‘NUMERIC’, ‘BINARY’, ‘CHAR’, ‘DATE’, ‘DATETIME’, ‘DECIMAL’, ‘SIGNED’, ‘TIME’, ‘UNSIGNED’, same as in ‘$meta_query’. When using ‘meta_type’ you can also use ‘meta_value_*’ accordingly. For example, when using DATETIME as ‘meta_type’ you can use ‘meta_value_datetime’ to define order structure.