Support Forum
Support Forum
Offline
Hi
I'm on the latest release of simple:press and I get between 80 and 100 calls to sferrorlog on each page - even non forum pages! This is bringing my site down.
Here's an example:
Time: 0.00099396705627441
Query: SHOW TABLES LIKE 'wp_xxx_sferrorlog'
Call from: require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/bazar/page.php'), do_action('yit_loop_page'), call_user_func_array, yit_loop_page, yit_get_template, include('/themes/bazar/theme/templates/loop/page/content.php'), the_content, apply_filters('the_content'), call_user_func_array, yit_clean_text, yit_addp, do_shortcode, preg_replace_callback, do_shortcode_tag, call_user_func, WC_Shortcodes->products, woocommerce_get_template_part, load_template, require('/themes/bazar/woocommerce/content-product.php'), do_action('woocommerce_after_shop_loop_item'), call_user_func_array, woocommerce_template_loop_add_to_cart, woocommerce_get_template, include('/themes/bazar/woocommerce/loop/add-to-cart.php'), sp_construct_php_error
1. How can I turn off debugging
2. Why?
The only simple press element I have on non forum pages is the private message.
thanks!
Blaise
Offline
why would be a good question... your query example format 'wp_xxx_sferrorlog' seems to show wp multisite... is that what you are running? and if so, how many network sites do you have? and roughly how many db tables?
If you want to disable error logging:
in file sp-site-support-functions.php, around line 160 find and comment out this code:
$wpdb->hide_errors();
set_error_handler('sp_construct_php_error');
comment out both lines…
we have one other multisite install that is experiencing something similar...
Visit Cruise Talk Central and Mr Papa's World
Offline
Hi Mr Papa,
No, it's not WP Multisite - it's a plain WP with woocommerce installed.
On the site's homepage (not even the forum section) we have 69 calls to sferrorlog. I am copying here the first 3 and the last 3 as an example:
-
- Time: 0.0052900314331055
- Query: SHOW TABLES LIKE 'wp_xxx_sferrorlog'
- Call from: require('wp-blog-header.php'), require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), include_once('/plugins/tab-section/tab-section-loader.php'), define, sp_construct_php_error
-
- Time: 0.00089597702026367
- Query: SHOW TABLES LIKE 'wp_xxx_sferrorlog'
- Call from: require('wp-blog-header.php'), require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), include_once('/plugins/tab-section/tab-section-loader.php'), define, sp_construct_php_error
-
- Time: 0.00078296661376953
- Query: SHOW TABLES LIKE 'wp_xxx_sferrorlog'
- Call from: require('wp-blog-header.php'), require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), include_once('/plugins/theme-my-login/theme-my-login.php'), require_once('/plugins/theme-my-login/includes/class-theme-my-login.php'), sp_construct_php_error
-
- Time: 0.00090503692626953
- Query: SHOW TABLES LIKE 'wp_xxx_sferrorlog'
- Call from: require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/bazar/problem-with-post-edit-buttonome.php'), get_template_part, locate_template, load_template, require('/themes/bazar/blog.php'), get_footer, locate_template, load_template, require_once('/themes/bazar/footer.php'), wp_footer, do_action('wp_footer'), call_user_func_array, Debug_Queries->the_queries, Debug_Queries->get_queries, mysql_fetch_object, sp_construct_php_error
-
-
- Time: 0.00071001052856445
- Query: SHOW TABLES LIKE 'wp_xxx_sferrorlog'
- Call from: require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/bazar/problem-with-post-edit-buttonome.php'), get_template_part, locate_template, load_template, require('/themes/bazar/blog.php'), sp_construct_php_error
-
- Time: 0.00071001052856445
- Query: SHOW TABLES LIKE 'wp_xxx_sferrorlog'
- Call from: require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/bazar/problem-with-post-edit-buttonome.php'), get_template_part, locate_template, load_template, require('/themes/bazar/blog.php'), sp_construct_php_error
-
Offline
On the /forum/ section of my site I get a very similar number of calls to sferrorlog. Here is a copy of the 1st one. Always SHOW TABLES LIKE
- Time: 0.00085997581481934
- Query: SHOW TABLES LIKE 'wp_xxx_sferrorlog'
- Call from: require('wp-blog-header.php'), require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), include_once('/plugins/tab-section/tab-section-loader.php'), define, sp_construct_php_error
Offline
As Steve said above - we have two such reports so you are not alone!
I would strongly suggest you implement the temporary code change we gave you in post 2 above. Rest assured that this change should not have any detrimental side-effect.
We are currently looking into this although it is always difficult when we are unable to replicate things.
I do have one question however as I am most curious. The first set of log entries you set were all being generated from the WooCommerce plugin. This should not really be subject to the forum error trapping code unless the Woo components appear ion the same page as the forum - like in a sidebar for example. Can you tell me if this is the case please?
 |
YELLOW
SWORDFISH
|
Offline
The site is fotoloco.fr
The forum and woocommerce are completely seperate. Neither should be called from the homepage.
Offline
so that would make it weird that woo commerce stuff was erroring on the forum page, no?
did you turn off the error logging to see if it helped??
Visit Cruise Talk Central and Mr Papa's World
Offline
This is weird indeed.
It's clearly the same issue we were experiencing after the last update. I presumed it was related to the number of tables in our multisite db. For the record, we do not run woocommerce.
Blaise, FYI: Issue was resolved by disabling error logging as suggested in post 2 above.
Simple:Press powers the Tripawds Discussion Forums.
It's better to hop on three legs than to limp on four.
The Tripawds Blogs Community is made possible by The Tripawds Foundation.
Offline
yeah, two sites who had better operation when disabling error logging... dont get it, but hey, if it works... one had many tables, one did not...
next version will include an option to disable error logging as we try to dig into this further... but kind of a needle in a haystack...
Visit Cruise Talk Central and Mr Papa's World
Offline
Mr Papa said
next version will include an option to disable error logging...
That's great, any chance the default state could be off? Or perhaps we could get a hack for making it so. Activating the plugin (at least in our case) allows very little time to do anything before loads spiral out of control.
Thanks!
PS: I don't get it either, figured this certainly had to do with the size of our multisite db.
Simple:Press powers the Tripawds Discussion Forums.
It's better to hop on three legs than to limp on four.
The Tripawds Blogs Community is made possible by The Tripawds Foundation.
All RSS1 Guest(s)