Support Forum
Hi
My forum had been running fine for almost a month now when suddenly I noticed my Wordpress error_log file balloon to over 85MB (from a few hundred KB). I looked at the contents and I found that the errors were of the following nature (the red text below). I can't really tell what it is but the bulk of the error messages comes from a couple of thousand lines of the SQL statement involving the "update wp_sftrack SET notification" where it looks like something "recursive" is going on. This goes on for a couple of thousand entries with each succeeding error line getting longer and longer until it ends with the blue error log line below (I replaced the actual folder path with the orange ????? in this post for security reasons).
All I can say at this point is that it seems to start with something related to my theme (Catalyst Theme) then the bulk of the error messages come from the said SQL statement which includes the update on wp_sftrack.
Could you help point me in the right direction to try to figure out what's causing it? It's caused my forum to hang for a few times these past three days. Thanks in advance.
[27-Jun-2013 03:36:19] WordPress database error MySQL server has gone away for query SELECT ID FROM wp_posts WHERE post_parent = 19 AND post_type = 'page' AND post_status = 'publish' LIMIT 1 made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/catalyst/page.php'), catalyst_framework, get_header, locate_template, load_template, require_once('/themes/catalyst/problem-with-post-edit-buttoneader.php'), body_class, get_body_class
[27-Jun-2013 03:36:19] WordPress database error MySQL server has gone away for query SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE tt.taxonomy = 'nav_menu' AND t.term_id = 2 LIMIT 1 made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/catalyst/page.php'), catalyst_framework, get_header, locate_template, load_template, require_once('/themes/catalyst/problem-with-post-edit-buttoneader.php'), catalyst_hook_header, do_action('catalyst_hook_header'), call_user_func_array, catalyst_build_header, catalyst_hook_header_right, do_action('catalyst_hook_header_right'), call_user_func_array, catalyst_build_navbar1, wp_nav_menu, wp_get_nav_menu_object, get_term
[27-Jun-2013 03:36:19] WordPress database error MySQL server has gone away for query SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE tt.taxonomy = 'nav_menu' AND t.slug = '2' LIMIT 1 made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/catalyst/page.php'), catalyst_framework, get_header, locate_template, load_template, require_once('/themes/catalyst/problem-with-post-edit-buttoneader.php'), catalyst_hook_header, do_action('catalyst_hook_header'), call_user_func_array, catalyst_build_header, catalyst_hook_header_right, do_action('catalyst_hook_header_right'), call_user_func_array, catalyst_build_navbar1, wp_nav_menu, wp_get_nav_menu_object, get_term_by
[27-Jun-2013 03:36:19] WordPress database error MySQL server has gone away for query SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE tt.taxonomy = 'nav_menu' AND t.name = '2' LIMIT 1 made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/catalyst/page.php'), catalyst_framework, get_header, locate_template, load_template, require_once('/themes/catalyst/problem-with-post-edit-buttoneader.php'), catalyst_hook_header, do_action('catalyst_hook_header'), call_user_func_array, catalyst_build_header, catalyst_hook_header_right, do_action('catalyst_hook_header_right'), call_user_func_array, catalyst_build_navbar1, wp_nav_menu, wp_get_nav_menu_object, get_term_by
[27-Jun-2013 03:36:19] WordPress database error MySQL server has gone away for query SELECT * FROM wp_sflinks WHERE post_id=19 made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/catalyst/page.php'), catalyst_framework, catalyst_hook_post_loop, do_action('catalyst_hook_post_loop'), call_user_func_array, catalyst_build_loop, catalyst_standard_loop, catalyst_hook_post_content, do_action('catalyst_hook_post_content'), call_user_func_array, catalyst_build_the_content, the_content, apply_filters('the_content'), call_user_func_array, sp_render_forum, apply_filters('the_content'), call_user_func_array, sp_linking_show_blog_link, sp_show_blog_link, sp_blog_links_control, spdb_table, spdb_select
[27-Jun-2013 03:36:19] WordPress database error MySQL server has gone away for query UPDATE wp_sftrack
SET notification='a:2:{i:0;i:1;i:1;s:22:"Invalid database query";}'
WHERE id=3994 made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/catalyst/page.php'), catalyst_framework, catalyst_hook_post_loop, do_action('catalyst_hook_post_loop'), call_user_func_array, catalyst_build_loop, catalyst_standard_loop, catalyst_hook_post_content, do_action('catalyst_hook_post_content'), call_user_func_array, catalyst_build_the_content, the_content, apply_filters('the_content'), call_user_func_array, sp_render_forum, apply_filters('the_content'), call_user_func_array, sp_linking_show_blog_link, sp_show_blog_link, sp_blog_links_control, spdb_table, spdb_select, sp_construct_database_error, sp_notify, spdb_query
[27-Jun-2013 03:36:19] WordPress database error MySQL server has gone away for query UPDATE wp_sftrack
SET notification='a:2:{i:0;i:1;i:1;s:22:"Invalid database query";}'
WHERE id=3994 made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/catalyst/page.php'), catalyst_framework, catalyst_hook_post_loop, do_action('catalyst_hook_post_loop'), call_user_func_array, catalyst_build_loop, catalyst_standard_loop, catalyst_hook_post_content, do_action('catalyst_hook_post_content'), call_user_func_array, catalyst_build_the_content, the_content, apply_filters('the_content'), call_user_func_array, sp_render_forum, apply_filters('the_content'), call_user_func_array, sp_linking_show_blog_link, sp_show_blog_link, sp_blog_links_control, spdb_table, spdb_select, sp_construct_database_error, sp_notify, spdb_query, sp_construct_database_error, sp_notify, spdb_query
[27-Jun-2013 03:36:19] WordPress database error MySQL server has gone away for query UPDATE wp_sftrack
SET notification='a:2:{i:0;i:1;i:1;s:22:"Invalid database query";}'
WHERE id=3994 made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/catalyst/page.php'), catalyst_framework, catalyst_hook_post_loop, do_action('catalyst_hook_post_loop'), call_user_func_array, catalyst_build_loop, catalyst_standard_loop, catalyst_hook_post_content, do_action('catalyst_hook_post_content'), call_user_func_array, catalyst_build_the_content, the_content, apply_filters('the_content'), call_user_func_array, sp_render_forum, apply_filters('the_content'), call_user_func_array, sp_linking_show_blog_link, sp_show_blog_link, sp_blog_links_control, spdb_table, spdb_select, sp_construct_database_error, sp_notify, spdb_query, sp_construct_database_error, sp_notify, spdb_query, sp_construct_database_error, sp_notify, spdb_query
[27-Jun-2013 03:36:20] PHP Fatal error: Allowed memory size of 268435456 bytes exhausted (tried to allocate 71 bytes) in /?????/public_html/wp-includes/functions.php on line 3788
Actually - if you look at all of these entries you will see they all start with the term 'MySQL server has gone away'. This is a somewhat quaint expression MySQL uses to inform you that it can no longer make a connection to the database and is thus unable to run the query. WordPress and PHP will plough on regardless which often will then result in a long list of errors reported many of which came about on a single page load. In this case until it ran out of php memory at the end there.
I think you need to start diagnosing this by talking to your hosting support to see if they can explain why the connection to the DB is getting lost. We had a similar problem here a couple of years back and in our case it was just a matter of tweaking a few mySQL settings and values but each system is going to be different. And if you are using shared hosting you will not have access to change settings anyway.
YELLOW
SWORDFISH
|
Thanks! I'll look into that as well.
I was also looking at my recently updated plugins and learned about this only today:
http://yoast.com/mea-culpa-on-.....s-learned/
Apparently Yoast's WP SEO put out a bad plugin (incompatible with PHP 5.2). I know this is a shot in the dark and it may not be fair to ask, but would something like this possibly affect the forum? I've turned the Yoast SEO plugin for now and am monitoring if that'll fix it.
I'm also curious about the error log generated with the "sp_sftrack" database involved (and this may turn out to be a symptom rather than a cause). It seems a different SQL query starts having problems, but why are those succeeding error logs so numerous and apparently recursive (when they happen they generate over 2MB worth of ever growing text lines) before it stops with the PHP Fatal Error in the end telling me it's out of memory?
I would assume that the Yoast problem would have generated php errors not mytSQL errors.
I am not sure why you are focused on the sftrack entries as opposed to all of the others which are not even forum related. It has exactly the same error message (server gone away) as all of the others...
Or is it just because of that message 'Invalid Database Query'? If that is what concerns you then that is a part of the actual query - it is recording the fact that the previous query failed - which looks to be related to our blog linking plugin - although you will see that that too suffered from the missing mySQL server. Hence the writing of the error notification to sftrack.
YELLOW
SWORDFISH
|
Hi, I'm just trying to cover multiple paths at once, as well as gathering all the info I can on the software while I wait for my hosting provider to respond. Also arming myself with all the info I need in case they point to the software as the problem.
However my practical concern about the sftrack entries is that it's generating about 2-5MB worth at a time of error_log data while the other messages are just a few lines at a time. I only put some sample lines here of that sftrack error message but in the actual logs they number roughly 1,000 each time this occurs. My site is new and doesn't have a lot of users yet (<200) but I've been having to check in every few hours to delete the fast-growing error log.
I turned on WP_DEBUG in my install in an effort to use the Debug Bar plugin. When I go to my forum page I see this before the forum is displayed (again, I just hid the actual root path with /?????):
Notice: Undefined index: group in /?????/public_html/wp-content/plugins/simple-press/sp-startup/forum/sp-forum-framework.php on line 99
Notice: Undefined index: group in /?????/public_html/wp-content/plugins/simple-press/sp-startup/forum/sp-forum-framework.php on line 99
Notice: Undefined index: group in /?????/public_html/wp-content/plugins/simple-press/sp-startup/forum/sp-forum-framework.php on line 99
Notice: Undefined index: group in /?????/public_html/wp-content/plugins/simple-press/sp-startup/forum/sp-forum-framework.php on line 99
Notice: Undefined index: group in /?????/public_html/wp-content/plugins/simple-press/sp-startup/forum/sp-forum-framework.php on line 99
Notice: Undefined index: group in /?????/public_html/wp-content/plugins/simple-press/sp-startup/forum/sp-forum-framework.php on line 99
Notice: Undefined index: group in /?????/public_html/wp-content/plugins/simple-press/sp-startup/forum/sp-forum-framework.php on line 99
Notice: Undefined index: group in /?????/public_html/wp-content/plugins/simple-press/sp-startup/forum/sp-forum-framework.php on line 99
Notice: Undefined index: group in /?????/public_html/wp-content/plugins/simple-press/sp-startup/forum/sp-forum-framework.php on line 99
Notice: Undefined index: group in /?????/public_html/wp-content/plugins/simple-press/sp-startup/forum/sp-forum-framework.php on line 99
Notice: Undefined index: group in /?????/public_html/wp-content/plugins/simple-press/sp-startup/forum/sp-forum-framework.php on line 99
Notice: Undefined index: group in /?????/public_html/wp-content/plugins/simple-press/sp-startup/forum/sp-forum-framework.php on line 99
Notice: Undefined index: group in /?????/public_html/wp-content/plugins/simple-press/sp-startup/forum/sp-forum-framework.php on line 99
Notice: Undefined index: group in /?????/public_html/wp-content/plugins/simple-press/sp-startup/forum/sp-forum-framework.php on line 99
Notice: Undefined index: group in /?????/public_html/wp-content/plugins/simple-press/sp-startup/forum/sp-forum-framework.php on line 99
Notice: Undefined index: group in /?????/public_html/wp-content/plugins/simple-press/sp-startup/forum/sp-forum-framework.php on line 99
Notice: Undefined index: group in /?????/public_html/wp-content/plugins/simple-press/sp-startup/forum/sp-forum-framework.php on line 99
Notice: Undefined index: group in /?????/public_html/wp-content/plugins/simple-press/sp-startup/forum/sp-forum-framework.php on line 99
Notice: Undefined index: group in /?????/public_html/wp-content/plugins/simple-press/sp-startup/forum/sp-forum-framework.php on line 99
Notice: Undefined index: group in /?????/public_html/wp-content/plugins/simple-press/sp-startup/forum/sp-forum-framework.php on line 99
Notice: Undefined index: group in /?????/public_html/wp-content/plugins/simple-press/sp-startup/forum/sp-forum-framework.php on line 99
Notice: Undefined index: group in /?????/public_html/wp-content/plugins/simple-press/sp-startup/forum/sp-forum-framework.php on line 99
Notice: Undefined index: group in /?????/public_html/wp-content/plugins/simple-press/sp-startup/forum/sp-forum-framework.php on line 99
Notice: Undefined index: sfkeywords in /?????/public_html/wp-content/plugins/simple-press/sp-startup/forum/sp-forum-support-functions.php on line 534
Is this something I should be concerned about and should I do something to fix this?
not really.. those are harmless notices... still, we try to clean them up when we come across them... that one has already been corrected in next version...
Visit Cruise Talk Central and Mr Papa's World
Ok thanks.
I also have some repeating error logs (appearing in error_log as well as the S:P error log report) relating to the Polls, Subscriptions, and Watches plugins. I've pasted a sample below for your info. I hadn't reported them before since they didn't seem to be affecting the functionality of those plugins (as usual I replaced actual root paths with ?????):
June 29, 2013
3:28 am php file: ????/public_html/wp-content/sp-resources/forum-plugins/polls/library/sp-polls-components.php
line: 323
function: Unavailable
Notice | Trying to get property of non-object
June 29, 2013
3:28 am php file: ????/public_html/wp-content/sp-resources/forum-plugins/polls/library/sp-polls-components.php
line: 323
function: sp_polls_show_result
Notice | Trying to get property of non-object
June 28, 2013
11:51 pm database file: /?????/public_html/wp-content/sp-resources/forum-plugins/polls/sp-polls-plugin.php
line: 223
function: include_once
error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' '2013-06-28 23:51:48', 236, '99.6.132.189')' at line 1
INSERT INTO wp_sfpollsvoters VALUES (0, 4, , '2013-06-28 23:51:48', 236, '99.6.132.189')
June 28, 2013
11:51 pm database file: /?????/public_html/wp-content/sp-resources/forum-plugins/polls/sp-polls-plugin.php
line: 223
function: include_once
error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
UPDATE wp_sfpollsanswers SET answer_votes = (answer_votes + 1) WHERE poll_id = 4 AND answer_id =
June 28, 2013
10:55 pm php file: ????/public_html/wp-content/sp-resources/forum-plugins/ban/library/sp-ban-components.php
line: 24
function: gethostbyaddr
Warning | gethostbyaddr() [function.gethostbyaddr]: Address is not a valid IPv4 or IPv6 address
June 28, 2013
10:55 pm php file: ????/public_html/wp-content/sp-resources/forum-plugins/ban/library/sp-ban-components.php
line: 24
function: gethostbyaddr
Warning | gethostbyaddr() [function.gethostbyaddr]: Address is not a valid IPv4 or IPv6 address
June 28, 2013
2:22 pm php file: ????/public_html/wp-content/sp-resources/forum-plugins/ban/library/sp-ban-components.php
line: 24
function: gethostbyaddr
Warning | gethostbyaddr() [function.gethostbyaddr]: Address is not a valid IPv4 or IPv6 address
June 28, 2013
9:07 am php file: ????/public_html/wp-content/sp-resources/forum-plugins/watches/template-tags/sp-watches-watch-button-tag.php
line: 54
function: sp_WatchesWatchButtonTag
Notice | Trying to get property of non-object
June 28, 2013
9:07 am php file: ????/public_html/wp-content/sp-resources/forum-plugins/subscriptions/template-tags/sp-subscriptions-subscribe-button-tag.php
line: 56
function: sp_SubscriptionsSubscribeButtonTag
Notice | Trying to get property of non-object
Yes - 'Notices' and 'Warnings' are not errors. But they ARE a nuisance! We eradicate them when we encounter them and when users such as yourself find more. It can be difficult to trap all of them because there are so many variables involved - what plugins are active - what sort of data is being used etc.
So I will note these and correct if they have not been found already.
However - on a couple of those Polls queries you are getting actual SQL errors and they do need closer investigation. We have no current reports outstanding of data problems with the Polls plugin and it is possible you may have a corruption or some orphaned data - we will need to take a look at the code where these SQL statements are generated.
For starters - could you tell us which version of Simple:Press and version of the Polls plugin you are using there?
YELLOW
SWORDFISH
|