Posted 2 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
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.
Posted 2 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
Posted 2 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
Posted 2 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."
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.
Posted 2 years ago #
No...i haven't reach any space limitation!!
Have you tried Esmi's suggestions?
Posted 2 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
Have you tried deactivating all of your plugins yet?
Posted 2 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".
Posted 2 years ago #
MACMANX... SHOULD REALLY DEACTIVATE ALL MY PLUGINS?????
Posted 2 years ago #
OK....ALL IS DEACTIVATED!!!!! LET'S SEE WHATS HAPPENS!!
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.
Posted 2 years ago #
Also deactivate your caps lock key. That all-caps stuff is hard to read.
Posted 2 years ago #
aahaaaha...sorry!!!! caps lock key removed from keaboard!!!! aahaah
let' s see what will happens now!
Posted 2 years ago #
after 2 days it crashes again!!!!! Is it possible that disinstalling e reinstalling it could solve the problem???
Have you tried the rest of Esmi's suggestions?
Posted 1 year 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;
That looks like a basic search query to me. What version of WordPress are you running?
This topic has been closed to new replies.
