What is the cron doing?
What is the cron doing?
mysql
Get multisite count without php?
The information about the multisite option blog_count is stored in the table wp_sitemeta. Taking a look at the source is in such cases beneficial, if not invaluable.
How do I change the user via SQL?
You probably haven’t changed the display name, which is probably what is being displayed. “nicename” is used for the author’s posts page url and not for display. UPDATE wp_users SET display_name = replace(display_name, @old_user, @new_user);
Copy from wordpress for dev gives different output in browser
NOTE: as my reputation is non-existent I can’t post more than 2 links. So if I say “include http part” I mean for example domain.com should be http://domain.com Hi cybmeta. What you are saying is indeed part of the problem I was having. I found out about this before you posted but was too tired … Read more
Ordering topics by most replies in X days using MYSQL statement
Ordering topics by most replies in X days using MYSQL statement
Custom post order when using OR relation
This is a little hard to tinker with, without data to try it on. What strikes me as strange in your architecture that you describe it as type with three possible values, but what you have it three (I guess) different keys for it. It would make more sense to me if you had single … Read more
Geographical proximity query using post_meta
Oh dear, that was extremely obvious – there was a missing closing bracket! Here is the working query. SELECT ID, ( 6371 * acos ( cos ( radians( 35.665833 ) ) * cos( radians( latitude.meta_value ) ) * cos( radians( longitude.meta_value ) – radians( 139.731111 ) ) + sin ( radians(35.665833 ) ) * sin( … Read more
Re-writing MySQl query for execute faster
Try to cut the query in smaller parts, using temporary tables. Having sub queries is always time, memory and cpu consuming. That should do the trick.
How to properly send many mysql queries via php and what happens with ajax requests after they are sent?
There is typically a hosting limit to how long PHP can run, on shared this can be as low as 60-90 seconds. Since WP’s Ajax is just another instance of PHP load it will likely be subject to that restriction. Even if it’s disabled any error risks knocking such a long running process out. Unfortunately … Read more
get_results() query not working only when entering strings
You do not need to use quotes around some data types in SQL, integers being one of those types. That is why the first block of code works. It is a perfectly valid SQL statement. You do need to quote strings in SQL. That is why your second block of code does not work. The … Read more