Not Responding

I would like to help but you did not leave me your email. Can you check your error_log file to see if there are any hints as to what might be causing that 500 error?

Aloha, Eli

P.S. My email address is in the readme.txt file of my plugin or you can also contact me directly on my blog.

Email is…. [email protected]

Error msg (couldn’t access dashboard until I disabled Eli plugin.) one of your reports resides on dashboard.

“WordPress database error MySQL server has gone away for query SELECT autoload FROM wp_options WHERE option_name = ‘_transient_4oaxu386S2’ made by require_once(‘wp-admin/admin.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘init’), call_user_func_array, ninja_forms_session_class_setup, get_transient, delete_option
“

Any ideas?

I would like to help but you did not leave me your email.

And if he did it would get redacted in short order. Posted email addresses on these forums give me a painful spasm. ??

P.S. My email address is in the readme.txt file of my plugin or you can also contact me directly on my blog.

Now THAT’S a great P.S. but I missed where the contact info is in the readme.txt file. Do you have a contact URL that you would not mind posting?

Edit: But I did find it in the index.php file. ??

Is it possibly a conflict with the ninja_forms plugin have you tried disabling that plugin to see if my works then.

I send you an email that you can reply to with WP Admin login info if you want me to troubleshoot first hand.

I have tried disabling the ninja form plugin. Still not working. I am now having issues just getting access to back end at all now and the frontend is very slow

Jason,
perhaps there is something wrong with your server. The error you got “WordPress database error MySQL server has gone away” likely indicates that your database server is not staying online consistently enough to run all the queries requested by PHP scripts on your webserver.

Who is your hosting provider?

Also, I sent you an email to the address you provided so that you could write me back directly, did you get that?

I’m happy to help any way I can.

Aloha, Eli

I have disabled the SQL Admin Reports plugin and able to navigate backend and frontend much better.

Here is the latest error log:

“WordPress database error MySQL server has gone away for query SELECT option_value FROM wp_options WHERE option_name = ‘woocommerce_sharedaddy’ LIMIT 1 made by require_once(‘wp-admin/admin.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘init’), call_user_func_array, Woocommerce->init, WC_Integrations->__construct, WC_ShareDaddy->__construct, WC_ShareDaddy->init_form_fields, get_option”

Right, so you have disabled my plugin and you are still getting the same error in your logs (“WordPress database error MySQL server has gone away”). This confirms my theory that your database server is not staying online consistently enough to run all the queries requested by PHP scripts on your webserver.

So far the errors you have posted are from plugins like ShareDaddy and NinjaForms but I suspect this error could be generated by any script that tries to run a query when your DB server has crapped out.

I don’t see that this issue is directly related to my plugin but I am still willing to help you troubleshoot. Did you get my email sent directly to the address you posted?

Eli,

Please try this email address… [email protected]

I haven’t gotten any errors since disabling your plugin. I just wanted to show you the last one because it was different from before.

J

Ok Jason, I just sent you a reply directly to your gmail.

After a lot of troubleshooting and testing I determined that it was really just one report that didn’t work because it took so long to execute the query that the connection to the server was timing out. It seemed to also consume most of the server’s resources while it is trying to execute that query so it was causing slow response times for the rest of your site. I made a slightly modified report that will work most of the time, it still takes 40 to 50 seconds to execute, but at least that falls under the timeout cut-off. The problem with this query is all the joins and conditions seem to be too much to process efficiently. I copied a backup of the database to my servers and it still took 20 -25 seconds to execute the same query.

I recommend testing your large queries in PhpMyAdmin first to see how well they execute before making them into reports.

Aloha, Eli