Title: Lane's Replies | WordPress.org --- # Lane [ ](https://wordpress.org/support/users/laned69/) * [Profile](https://wordpress.org/support/users/laned69/) * [Topics Started](https://wordpress.org/support/users/laned69/topics/) * [Replies Created](https://wordpress.org/support/users/laned69/replies/) * [Reviews Written](https://wordpress.org/support/users/laned69/reviews/) * [Topics Replied To](https://wordpress.org/support/users/laned69/replied-to/) * [Engagements](https://wordpress.org/support/users/laned69/engagements/) * [Favorites](https://wordpress.org/support/users/laned69/favorites/) Search replies: ## Forum Replies Created Viewing 6 replies - 1 through 6 (of 6 total) * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Burst Statistics – Simple WordPress Analytics (Google Analytics Alternative)] wp_burst_statistics table not being created](https://wordpress.org/support/topic/wp_burst_statistics-table-not-being-created/) * Thread Starter [Lane](https://wordpress.org/support/users/laned69/) * (@laned69) * [1 year, 5 months ago](https://wordpress.org/support/topic/wp_burst_statistics-table-not-being-created/#post-18352576) * Follow up. This issue was resolved via email support. A version with a fix was emailed to me and will be incorporated into a new public update. * Thank you Hessel * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Burst Statistics – Simple WordPress Analytics (Google Analytics Alternative)] wp_burst_statistics table not being created](https://wordpress.org/support/topic/wp_burst_statistics-table-not-being-created/) * Thread Starter [Lane](https://wordpress.org/support/users/laned69/) * (@laned69) * [1 year, 5 months ago](https://wordpress.org/support/topic/wp_burst_statistics-table-not-being-created/#post-18328087) * Thanks for getting back with me. * I converted the engine from MyISAM to InnoDB for all the existing wp_burst tables. I could not convert the wp_burst_statistics table because it doesn’t exist. * I used the Collation Fix plugin and got all the wp_burst tables in utf8mb4_unicode_ci format. Previously they were in utf8mb4_unicode_520_ci format. * I deactivated and reactivated the Burst plugin. * Still was not working. I was still getting the “table does not exist” errors in debug.log. * I uninstalled and reinstalled the Burst plugin. When it got reinstalled, the tables were in MyISAM and old collation. So I ran the SQL and got them to InnoDB again, but I don’t know how to make the collation plugin do it’s thing again. Plugin notes say it runs once a day. * Even though the collation is currently utf8mb4_unicode_520_ci, I don’t think changing the engine and collation solved the problem. * What should I do next? * Here’s a link to my debug.log: * [https://www.dropbox.com/scl/fi/xbhaux4m4hwp73zjoxna7/debug.log?rlkey=zunxpbtiy8ki5tg5tufhicslc&dl=0](https://www.dropbox.com/scl/fi/xbhaux4m4hwp73zjoxna7/debug.log?rlkey=zunxpbtiy8ki5tg5tufhicslc&dl=0) * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Advanced Query Loop] Multiple meta queries on same page](https://wordpress.org/support/topic/multiple-meta-queries-on-same-page/) * Thread Starter [Lane](https://wordpress.org/support/users/laned69/) * (@laned69) * [1 year, 7 months ago](https://wordpress.org/support/topic/multiple-meta-queries-on-same-page/#post-18254413) * Thanks for your reply. * I am on the latest version, 4.0.1. * I am trying to make a “calendar” page where each month’s block shows posts from 3 custom post types that start within that month. Posts have meta field that stores the start date. I have multiple AQL blocks on the page that are all the same except the dates within the meta value. * Here is the code view of the AQL block for January. * ```wp-block-code ``` * Here is what the March query looks like on the front end (from Query Monitor plugin). You can see that one of the post_type is empty. This is what happens for all queries except January * ```wp-block-code SELECT wp_xxx_posts.IDFROM wp_xxx_postsINNER JOIN wp_xxx_postmetaON ( wp_xxx_posts.ID = wp_xxx_postmeta.post_id )WHERE 1=1AND ( ( wp_xxx_postmeta.meta_key = 'lws_exhibition-start-date'AND wp_xxx_postmeta.meta_value BETWEEN '2025-03-01'AND '2025-03-31' )OR ( wp_xxx_postmeta.meta_key = 'lws_workshop-start-date'AND wp_xxx_postmeta.meta_value BETWEEN '2025-03-01'AND '2025-03-31' )OR ( wp_xxx_postmeta.meta_key = 'lws_event-start-date'AND wp_xxx_postmeta.meta_value BETWEEN '2025-03-01'AND '2025-03-31T23:59:59' )OR ( wp_xxx_postmeta.meta_key = 'lws_exhibition-end-date'AND wp_xxx_postmeta.meta_value BETWEEN '2025-03-01'AND '2025-03-31' ) )AND ((wp_xxx_posts.post_type = ''AND (wp_xxx_posts.post_status = 'publish'))OR (wp_xxx_posts.post_type = 'lws_event'AND (wp_xxx_posts.post_status = 'publish'OR wp_xxx_posts.post_status = 'private'))OR (wp_xxx_posts.post_type = 'lws_workshop'AND (wp_xxx_posts.post_status = 'publish'OR wp_xxx_posts.post_status = 'private')))GROUP BY wp_xxx_posts.IDORDER BY wp_xxx_postmeta.meta_value ASCLIMIT 0, 10 ``` * Let me know if you need anything else. * Thank you so much for looking into this. * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Meow Lightbox] Getting this error](https://wordpress.org/support/topic/getting-this-error-14/) * [Lane](https://wordpress.org/support/users/laned69/) * (@laned69) * [2 years, 2 months ago](https://wordpress.org/support/topic/getting-this-error-14/#post-17784397) * I’ll second this. * I am also getting the same error on two different websites. Debug log shows it started with the last plugin update to 5.1.7. * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Advanced Query Loop] Meta Query > Meta Value date()](https://wordpress.org/support/topic/meta-query-meta-value-date/) * [Lane](https://wordpress.org/support/users/laned69/) * (@laned69) * [2 years, 9 months ago](https://wordpress.org/support/topic/meta-query-meta-value-date/#post-17153840) * Here is my workaround. * I typed the word “todays_date” in the Meta Value field in the Post Meta Query section of the AQL block settings. Then I added the following code in my theme’s functions.php file. It basically looks at what has been typed in, and if it is“ todays_date”, then it changes it to the numerical date by using the date() function. * ```wp-block-code function change_query_date_value( $query_args, $block_query, $inherited ) { if ( isset( $query_args['meta_query'] ) && ! empty( $query_args['meta_query'] ) ) { if ( $query_args['meta_query'][0]['value'] == 'todays_date' ) { $query_args['meta_query'][0]['value'] = date('Ymd'); } } return $query_args; } add_filter( 'aql_query_vars', 'change_query_date_value', 10, 3 ); ``` * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Advanced Query Loop] Current date as meta value](https://wordpress.org/support/topic/current-date-as-meta-value/) * Thread Starter [Lane](https://wordpress.org/support/users/laned69/) * (@laned69) * [3 years ago](https://wordpress.org/support/topic/current-date-as-meta-value/#post-16922390) * I discovered two problems for me: neither the ACF meta_key nor the meta_value were being inserted into the query. * It appears that ACF is not registering the custom fields as post meta. I had to write a simple function to do that. Perhaps you might not have this problem. * I am fine with that but the next part is kinda ugly. I added one line of code to the AQL plugin file query-loop.php. This is not ideal or recommended as any updates to the plugin may overwrite, requiring the line of code to be re-added or no longer work. Inside the foreach loop on line 23 I added: * ```wp-block-code if ( $query['meta_value'] == "todays_date" ) { $query['meta_value'] = date( 'Ymd' ); }; ``` * Then, in the query loop block settings I put “todays_date” as the meta_value. * This works, but is not “proper”. And I’m sure the plugin author will have a much better way to do it. * UPDATE: After updating to 1.4.1, I re-added same line of code and it still works. Viewing 6 replies - 1 through 6 (of 6 total)