manfromnapa

I thought “latest posts” was a core WP function. sorry.

As an update… we had another plugin “break” the site during an update. I did a full restore of the site and the issue seems to have disappeared. Not sure why that would be, but it is.

Thanks for your response. To help us narrow down the performance issue, we would need a full WP Query Monitor report.

Let me look into how I can export a report. Can you point me somewhere I can see how to do this?

Moreover, one of my colleagues also recommends looking at:?https://www.ads-software.com/plugins/advanced-database-cleaner/?– this has helped optimize some things since The Events Calendar plugin does a lot of post meta queries and sometimes this can help.

I had been using WP-Optimize for DB clean up. I deactivated it and installed Advanced Database Cleaner. It cleaned some stuff out, but no noticeable improvement.

Just curious, were you able to replicate this issue on a staging version of your live site? If you haven’t created one yet, could you create one and check if the performance improves where WP Query Monitor is activated and deactivated?

I was able to replicate on a staging site. I’ve tried disabling plugins. The issue always comes back to TEC. That is, disabling TEC makes the site faster.

I ran it. It didn’t seem to change anything.

Any updates on when 1.23.1 is coming out?

Thank you.

PHP Version: 8.0.28 / 64Bit OS / Max execution time: 600sec
Memory limits: WordPress 256MB / PHP 256MB
Current Memory usage: 115MB

I am experiencing this slowness and this slow query on all of the WP-Admin pages. Not just TEC related ones.

8.0 resolved the deprecated results. I still get a slow query. This could be multiple things though. I’ll keep testing.

Query
SELECT?*
FROM?INFORMATION_SCHEMA.key_column_usage
WHERE?referenced_table_schema =?DATABASE()
AND?referenced_table_name?IS?NOT?NULL
AND?COLUMN_NAME= ‘event_id’
AND?TABLE_NAME = ‘wp_tec_occurrences’

Caller:
TEC\E\C\V\S\Abstract_Custom_Table->get_schema_constraint()wp-content/plugins/the-events-calendar/src/Events/Custom_Tables/V1/Schema_Builder/Abstract_Custom_Table.php:182TEC\E\C\V\S\Abstract_Custom_Table->has_constraint()wp-content/plugins/the-events-calendar/src/Events/Custom_Tables/V1/Schema_Builder/Abstract_Custom_Table.php:155TEC\E\C\V\T\Occurrences->after_update()wp-content/plugins/the-events-calendar/src/Events/Custom_Tables/V1/Tables/Occurrences.php:97TEC\E\C\V\S\Abstract_Custom_Table->update()wp-content/plugins/the-events-calendar/src/Events/Custom_Tables/V1/Schema_Builder/Abstract_Custom_Table.php:60TEC\E\C\V\S\Schema_Builder->up()wp-content/plugins/the-events-calendar/src/Events/Custom_Tables/V1/Schema_Builder/Schema_Builder.php:259TEC\E\C\V\Activation::init()wp-content/plugins/the-events-calendar/src/Events/Custom_Tables/V1/Activation.php:106do_action(‘init’)wp-includes/plugin.php:517

Component:
Plugin: the-events-calendar

Rows
0

Time
2.3864

Sorry… 2.5.6. is the version of TEC Shortcode. We were already on version 6.X, and I just upgraded to 6.0.11.

I’ve optimized our DB tables. I’m using MySQL InnoDB for all TEC tables.

We have 107 events.

As I investigate furthur I’m seeing 3 PHP Errors (All 3 are Deprecated):

Optional parameter $download_url declared before required parameter $js_action is implicitly treated as a required parameter 1
wp-content/plugins/the-events-calendar/common/vendor/vendor-prefixed/stellarwp/installer/src/Installer/Handler/Plugin.php:123
Plugin: the-events-calendar

Deprecated Optional parameter $did_action declared before required parameter $js_action is implicitly treated as a required parameter 1
wp-content/plugins/the-events-calendar/common/vendor/vendor-prefixed/stellarwp/installer/src/Installer/Handler/Plugin.php:0
Plugin: the-events-calendar

Constant FILTER_SANITIZE_STRING is deprecated 3
wp-content/plugins/the-events-calendar/common/src/functions/utils.php:1130
Plugin: the-events-calendar

I have a follow up to this. I created the form using the recommended format. When someone places an order, the email has all of the items on it, even ones that have a number/qty of 0. I tried using the {all_non_empty_fields} in the email. Is there a way to limit the email notification to just items ordered?

https://pastebin.com/yUsMYuTi

I was going to update this. We used the following line of custom CSS to resolve this.

html, body { height: auto !important; }

However, is there a more elegant way to resolve this?

I think this will work. Thank you so much for all the help.

Is there a limit to only 4 fields per row?

I could make it work if the “html” field was able to be used in calculations.

I tried that. It doesn’t quite look right. It also created a very complex calculation field that I’ll need to manually manage. I’ll keep trying.