WordPress.org

Forums

A query crash my site!!!! (20 posts)

  1. Diablo010473
    Member
    Posted 5 years ago #

    My blog crashes several times a day for this query!!! Anyone knows hot to fix it???? I use wordepress 2.9.2 with Mistique theme and w3 total cache plugin...

    Please help me!

    Query SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts LEFT JOIN (select distinct tr.object_id, t.name from wp_term_relationships tr inner join wp_term_taxonomy tt on tt.term_taxonomy_id = tr.term_taxonomy_id inner join wp_terms t on t.term_id = tt.term_id) tr on wp_posts.ID = tr.object_id WHERE 1=1 A

  2. esmi
    Forum Moderator
    Posted 5 years ago #

    Have you tried:

    - deactivating all plugins to see if this resolves the problem? If this works, re-activate the plugins one by one until you find the problematic plugin(s).

    - switching to the default theme to rule out any theme-specific problems?

    - resetting the plugins folder by FTP or phpMyAdmin? Sometimes, an apparently inactive plugin can still cause problems.

  3. Diablo010473
    Member
    Posted 5 years ago #

    Thank you for the answer....
    Before all i want to tell you that my host privider told me that the problem IS my huge database....
    It's 2650 post. Could it really be the PROBLEM ITSELF???

    i couldn't belive it couse i HAVE NOT GOT ANY PROBELM UNTIL 5 DAYS Ago!!!!!
    Please answer me!! COULD IT BE THAT 26500 POST ARE TOO MUCH FOR A BLOG?!?!?
    COULD IT REALLY BE THAT I NEED TO LOWER THAT NUMBER (AS MU HOST PROVIDER SAY) AND I "NEED" TO RENT THIS MACHINE THAT SHOULD COST ME 300 EUROS EACH MONTH???

    2 X quad core xeon E5420
    8GB RAM
    4 X HDD SAS 15.000rpm 146GB l'uno in raid 10
    Banda: 2000 Gb su 100Mb
    Pannello Hosting cPanel

  4. Diablo010473
    Member
    Posted 5 years ago #

    tHE NUMBER OF THE POST OF MY DATABASE IS 2650 (2THOUSEND 6 HUNDREND AND 50 POST) NOT 26500 AS WRITTEN THE SECOND TIME!!!!

    SORRY

  5. Diablo010473
    Member
    Posted 5 years ago #

    This are the axact words used by my host provider (NETSONS)

    "Must stop following query:

    SQL_CALC_FOUND_ROWS SELECT DISTINCT wp_posts .* FROM wp_posts LEFT JOIN (SELECT DISTINCT tr.object_id, t.name from wp_term_relationships tr tt inner join wp_term_taxonomy on tt.term_taxonomy_id = tr.term_taxonomy_id inner join t on wp_terms t.term_id = tt.term_id) on tr tr.object_id = wp_posts.ID WHERE 1 = 1 AND (((((wp_posts.post_title LIKE '% KiteGen%') OR
    (Wp_posts.post_content LIKE '% KiteGen %'))) AND (wp_posts.post_password ='') AND wp_posts.post_type =' post 'AND (wp_posts.post_status =' publish ')) AND post_type! =' Revision ') AND post_status! = 'future' OR (tr.name LIKE '%% KiteGen' AND post_status = 'publish' AND post_type = 'Post') GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 13;

    and streamline its database."

  6. James Huff
    Volunteer Moderator
    Posted 5 years ago #

    No, there are WordPress blogs with far more posts than that. Perhaps you have reached your hosting provider's space limitation? If not, try Esmi's suggestions.

  7. Diablo010473
    Member
    Posted 5 years ago #

    No...i haven't reach any space limitation!!

  8. James Huff
    Volunteer Moderator
    Posted 5 years ago #

    Have you tried Esmi's suggestions?

  9. Diablo010473
    Member
    Posted 5 years ago #

    I removed quite all.... now i have wordpress 2.9.2 with
    2,691 Posts
    442 Comments
    32 Categories
    541 Tags
    i use Mistique theme and this plugins:

    Advanced Export for WordPress & WordPress MU
    Adds an Advanced Export to the Tools menu which allows selective exporting of pages, posts, specific categories and/or post statuses by date.

    Deactivate | Edit
    Version 2.8.3 | By Ron Rennick | Visit plugin site

    Akismet
    Akismet checks your comments against the Akismet web service to see if they look like spam or not. You need a WordPress.com API key to use it. You can review the spam it catches under "Comments." To show off your Akismet stats just put <?php akismet_counter(); ?> in your template. See also: WP Stats plugin.

    Deactivate | Edit
    Version 2.2.7 | By Matt Mullenweg | Visit plugin site

    All in One SEO Pack
    Out-of-the-box SEO for your WordPress blog. Options configuration panel | Upgrade to Pro Version | Donate | Support | Amazon Wishlist

    Deactivate | Edit
    Version 1.6.10.2 | By Michael Torbert | Visit plugin site

    Auto AdSense Sections
    Automatically implement AdSense section targeting to improve the relevancy of your AdSense ads.

    Deactivate | Edit
    Version 1.0 | By Mathias Amnell | Visit plugin site

    Blog Protector
    Protects Your Valuable Blog Content As Well As Images From Being Copied.

    Deactivate | Edit
    Version 2.3 | By Anurag Choudhari | Visit plugin site
    There is a new version of Blog Protector available. View version 2.4 Details or upgrade automatically.

    Clean Options
    finds orphaned options and allows for their removal from the wp_options table

    Tools | Deactivate | Edit
    Version 1.3.1 | By Mittineague | Visit plugin site

    Delete-Revision
    Delete revision post from Database,let us now to drop Redundancy, lose weight !

    Deactivate | Edit
    Version 1.3.1 | By gohsy | Visit plugin site

    Frame Buster
    Thwarts any attempt to load your site in a frame.

    Deactivate | Edit
    Version 5.0 | By Denis de Bernardy | Visit plugin site

    Google AJAX Translation
    Add Google AJAX Translation to your blog. This plugin allows your blog readers to translate your blog posts or comments into other languages. [Settings]

    Deactivate | Edit
    Version 0.6.0 | By Libin Pan, Michael Klein, and Nick Marshall | Visit plugin site

    Google XML Sitemaps
    This plugin will generate a special XML sitemap which will help search engines like Google, Yahoo, Bing and Ask.com to better index your blog.

    Deactivate | Edit
    Version 3.2.3 | By Arne Brachhold | Visit plugin site | Settings | FAQ | Support | Donate

    JavaScript to Footer
    This plugin automatically moves JavaScript code to page footer, speeding up page loading time.

    Deactivate | Edit
    Version 0.4 | By Vladimir Prelovac | Visit plugin site

    Manageable
    Inline editing of the date, title, author, categories, tags, status and more on both posts and pages without leaving the "Manage" admin sections. No need to load each post or page individually. Simply double-click anywhere in the post or page row and when you're done, press enter. Requires WordPress 2.5 or above. This plugin doesn't work in 2.7 since it's been integrated into the core.

    Deactivate | Edit
    Version 1.1.1 | By Aaron Harp | Visit plugin site

    Optimize DB
    Let's you optimize your WordPress database tables with one click. Click optimize on the right to start optimizing!

    Optimize | Deactivate | Edit
    Version 1.3 | By Joost de Valk | Visit plugin site

    Quick Adsense
    Quick Adsense offers a quicker & flexible way to insert Google Adsense or any Ads code into a blog post.

    Setting | Deactivate | Edit
    Version 1.6 | By Philip Ze | Visit plugin site

    Revision Control
    Allows finer control over the number of Revisions stored on a global & per-type/page basis.

    Deactivate | Edit
    Version 2.0 | By Dion Hulse | Visit plugin site

    Simple Tags
    Extended Tagging for WordPress 2.8 and 2.9 ! Suggested Tags, Mass edit tags, Autocompletion, Tag Cloud Widgets, Related Posts, Related Tags, etc!

    Deactivate | Edit
    Version 1.7.4.4 | By Amaury BALMER | Visit plugin site

    W3 Total Cache
    The fastest and most complete WordPress performance plugin. Dramatically improve the speed and user experience of your blog by adding: page caching, database caching, minify, content delivery network (CDN) functionality and more...

    Settings | Deactivate | Edit
    Version 0.8.5.2 | By Frederick Townes | Visit plugin site

    WordPress Database Backup
    On-demand backup of your WordPress database. Navigate to Tools → Backup to get started.

    Deactivate | Edit
    Version 2.2.2 | By Austin Matzko | Visit plugin site

  10. James Huff
    Volunteer Moderator
    Posted 5 years ago #

    Have you tried deactivating all of your plugins yet?

  11. Diablo010473
    Member
    Posted 5 years ago #

    A FRIEND OF MINE SAy:

    "I saw the query that you posted. And 'of course "IT" IS the problem. There are a join between a table and a table generated by an additional join. And then on almost like a post-3000 ... implants "by definition".

  12. Diablo010473
    Member
    Posted 5 years ago #

    MACMANX... SHOULD REALLY DEACTIVATE ALL MY PLUGINS?????

  13. Diablo010473
    Member
    Posted 5 years ago #

    OK....ALL IS DEACTIVATED!!!!! LET'S SEE WHATS HAPPENS!!

  14. James Huff
    Volunteer Moderator
    Posted 5 years ago #

    Yes, deactivating your plugins is an essential troubleshooting step, as plugins can sometimes cause problems like this. If the problem is resolved by deactivating all of your plugins, reactivate each one individually until you find the cause. When you find the plugin causing the issue, get rid of it.

  15. manntis
    Member
    Posted 5 years ago #

    Also deactivate your caps lock key. That all-caps stuff is hard to read.

  16. Diablo010473
    Member
    Posted 5 years ago #

    aahaaaha...sorry!!!! caps lock key removed from keaboard!!!! aahaah

    let' s see what will happens now!

  17. Diablo010473
    Member
    Posted 5 years ago #

    after 2 days it crashes again!!!!! Is it possible that disinstalling e reinstalling it could solve the problem???

  18. James Huff
    Volunteer Moderator
    Posted 5 years ago #

    Have you tried the rest of Esmi's suggestions?

  19. Diablo010473
    Member
    Posted 5 years ago #

    mcmanix.....i try all suggestions!! the problem is THAT query!

    SQL_CALC_FOUND_ROWS SELECT DISTINCT wp_posts .* FROM wp_posts LEFT JOIN (SELECT DISTINCT tr.object_id, t.name from wp_term_relationships tr tt inner join wp_term_taxonomy on tt.term_taxonomy_id = tr.term_taxonomy_id inner join t on wp_terms t.term_id = tt.term_id) on tr tr.object_id = wp_posts.ID WHERE 1 = 1 AND (((((wp_posts.post_title LIKE '% KiteGen%') OR
    (Wp_posts.post_content LIKE '% KiteGen %'))) AND (wp_posts.post_password ='') AND wp_posts.post_type =' post 'AND (wp_posts.post_status =' publish ')) AND post_type! =' Revision ') AND post_status! = 'future' OR (tr.name LIKE '%% KiteGen' AND post_status = 'publish' AND post_type = 'Post') GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 13;

  20. esmi
    Forum Moderator
    Posted 5 years ago #

    That looks like a basic search query to me. What version of WordPress are you running?

Topic Closed

This topic has been closed to new replies.

About this Topic