Error reading database

  • Resolved Er_Maqui

    (@er_maqui)


    10 years, 11 months ago

    It’s the plugin still developed?

    I doesn’t require great changes, or new features for them. The plugin works great now, but i have one problem:

    The plugin are getting an error reading database on each blog who it’s active:

    “SELECT blog_id, registered, last_updated from wp_blogs where public = 1\tAND spam = 0 AND archived = ‘0’ AND deleted = 0 AND blog_id NOT IN (3) ORDER BY path asc”

    It’s a bit molest, because this error it’s triggered several times a minute and they are filling my error logs.

    I think, if investigate a bit, i can resolve by myself at code. But, it can be interesting if some developer can upload a fix for all another users.

    https://www.ads-software.com/plugins/diamond-multisite-widgets/

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Author Daniel J. Lewis

    (@djosephdesign)

    Hi! I’m helping with this plugin now. Did you already figure out a fix for this that I can incorporate into the main plugin?

    Thread Starter Er_Maqui

    (@er_maqui)

    The query appears to be valid, but, i can’t understand why they are showing the \t on the debug.

    If you see at lines 147, 170, this tab are hardcoded at the query.

    I cannot understand why wordpress are registering this error, they show them also without the tab, but i think who when i’ve deleted the tab the error appears on less cases. The complete line are:

    [Mon Jun 30 18:35:31 2014] [error] [client *] Error de la base de datos de WordPress para la consulta SELECT blog_id, registered, last_updated from wp_blogs where public = 1 AND spam = 0 AND archived = ‘0’ AND deleted = 0 AND blog_id NOT IN (10) ORDER BY path asc realizada por require(‘wp-blog-header.php’), require_once(‘wp-includes/template-loader.php’), include(‘/themes/weaver-ii-pro/tag.php’), weaverii_get_footer, get_footer, locate_template, load_template, require_once(‘/themes/weaver-ii-pro/footer.php’), get_sidebar, locate_template, load_template, require_once(‘/themes/weaver-ii-pro/sidebar-footer.php’), dynamic_sidebar, call_user_func_array, DiamondBL->widget_endView, DiamondBL->render_output

    I’ve searched the text and they only are at the file diamond-multisite-widgets/diamond-bloglist.php.
    Also these file needs a great cleanup, they have a lot of unused spaces (Read the file with linux nano for example).

    I also have another error, but i doesn’t know what plugin produces them. They are: [Mon Jun 30 18:37:41 2014] [error] [client *] Request exceeded the limit of 10 internal redirects due to probable configuration error. Use ‘LimitInternalRecursion’ to increase the limit if necessary. Use ‘LogLevel debug’ to get a backtrace., referer:

    The two errors appears on https://www.tabletpractico.com/ or https://www.iphonepractico.com/, for example.
    Thanks,

    Plugin Author Daniel J. Lewis

    (@djosephdesign)

    I removed the tabs and double-spacing in the query and I’m testing it.

    Plugin Author Daniel J. Lewis

    (@djosephdesign)

    I pushed this fix out in a minor update to 1.8.1.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Error reading database’ is closed to new replies.

Tags