max_questions database error

  • Ive looked everywhere and cant really find an anwser to this. For the last week (but not until then) I keep getting an error that my database has been screwed up.

    It says that I have reached my max_questions limit of 50000. I havent really added anything to my site or gotten a substantial jump in readers either. So Im not sure what is causing the problem.

    I have heard that calling a lot of things like <font=> and other code can put a strain on your database. Anyone know if this is true? I was also wondering if the amount of posts showing and/or RSS feeds being sent could have something to do with it?

    I dont think this is specifically a wordpress error, but its really starting to shake my nerves. Any help would be MUCH appreciated.

Viewing 9 replies - 1 through 9 (of 9 total)

  • Use phpmyadmin to repair or optimise your database – that may help to a point.

    Where exactly do you see this error ?

    Ahh…….
    Grab this:
    https://vapourtrails.ca/downloads/jeromes-query-diagnostics.zip
    Install that, make the change in the site root ‘index.php’ then post back here ?

    I think you have the paginate plugin going ?

    Thread Starter nluckett

    (@nluckett)

    Usually I will get this error when I go to edit a post. All of a sudden the Loop is gone and this error appears above my header image.

    And yes, I am using the paginate plugin…is that a problem? It sounds like it might be…according the ouput from that plugin.

    Thanks for the help. Any other ideas of what might be causing this? Paginate might be the culprit, but I want to cover my bases.

    Do you guys think having the runPHP plugin could be an issue? I was using it to run smart_archives on a perma page.

    I’d leave the plugin active for a while – it won’t harm and hopefully your thread title will attract someone with better knowledge ??

    (Or activate the plugin, grab the results as a text file ?)

    Thread Starter nluckett

    (@nluckett)

    Just wanted to let people know that the plugin is running. Just view my page source and its at the very bottom under array.

    Here is the output with Page naviagation turned on and off:

    https://www.4colorrebellion.com/output.htm

    Looking at that though, it doesnt seem like the paginate function is causing any problems…only one more query. Hmmm

    It’s causing 3 – huge ones.
    Paste the .htm output into notepad, and be sure to have line wrapping on. Now look ??

    Thread Starter nluckett

    (@nluckett)

    Wow. Youre right, thats a lot of stuff. Thanks podz.

    So, I guess that looks like the main culprit, huh? Anything else I should check?

    Here is the output from the smart archives page also. Holy…might want to disable this also.

    https://www.4colorrebellion.com/output2.htm

    And finally, this is the lesterchan pagenavi plugin. Seems cleaner than the wp_paginate one:

    https://www.4colorrebellion.com/output3.htm

    Thread Starter nluckett

    (@nluckett)

    Ok, one more. This one shows the output for the WP standard page navigation

    <?php posts_nav_link(‘ · ‘, ‘previous page’, ‘next page’); ?>

    https://www.4colorrebellion.com/output4.htm

    More queries, but not as bad as the original wp_paginate I was using.

    Thread Starter nluckett

    (@nluckett)

    Just checking back to see if anyone had any other ideas about this problem. I tried using a more efficient pagination method and took the intensive smart archives off, but Im still getting the problem.

Viewing 9 replies - 1 through 9 (of 9 total)
  • The topic ‘max_questions database error’ is closed to new replies.