smconner
Forum Replies Created
-
Forum: Fixing WordPress
In reply to: WordPress Bug ? Problems with large number of posts@vyperlook that was my conclusion as well. That said I located some stop-gap resources.
In my situation I discovered that the plugin “FeedWordPress” (which aggregates other RSS feeds and whatnot) was aggregating from a “poisoned well“, meaning that someone in the RSS pool was pulling an RSS feed from someone else in the pool, thus creating an infinite loop. Bad news indeed. In the matter of a couple months it turned 684 real articles into over 300,000+ copies of these articles.
It appears that the FeedWordPress plugin has no logic to identify duplicates/copy posts. I think this would be a nice feature to add.
Removing Duplicate Posts
So for me the task became turning off the plugin and clearing out the duplicates posts, as well as the unused wp_postmeta and wp_term_relationships.Helpful Plugins
WP-Cleanup (will delete unused postmeta but CAN take many hours)
WP-DBManager (helps examine the database and quickly repair/optimize)Remove duplicate entries / rows a mySQL database table
http://www.justin-cook.com/wp/2006/12/12/remove-duplicate-entries-rows-a-mysql-database-table/CREATE TABLE new_table as
SELECT * FROM old_table WHERE 1 GROUP BY [column to remove duplicates by];
DROP TABLE old_table;
RENAME TABLE new_table TO old_table;How To Clean WordPress Database
http://www.allguru.net/web/how-to-clean-wordpress-databaseDELETE FROM wp_term_relationships
WHERE NOT EXISTS (
SELECT * FROM wp_posts
WHERE wp_term_relationships.object_id = wp_posts.ID
);Remove duplicate / unused postmeta through mysql command line
DELETE pm
FROM wp_postmeta pm
LEFT JOIN wp_posts wp ON wp.ID = pm.post_id
WHERE wp.ID IS NULL;I’m still cranking on one of the three databases, cleaning up duplicates, and it’s taking forever, so much so that I have to stop apache2 at night run the command line mysql commands and then kill it in the morning, restart apache2, repair the tables and then do it all over the next night… I’ve been doing that for two nights in a row and it is only about half way done by my estimation.
Forum: Fixing WordPress
In reply to: WordPress Bug ? Problems with large number of postsIndeed. I’m running into a very similar issue. The mysql database seems to be taking an incredibly long time to return results, and eventually times out. I’m not sure it’s the same number limit at above (which might be related to the default configuration that apt-get installs) but one blog with over 300k posts is totally useless at this point, while another with just over 30k is painfully slow.
The physical size of the 300k post database is over 800MB, which seems pretty big in one sense, but small when compared to other database projects (non-wordpress) I’ve worked on.
I did locate this wordpress bug report which seems to describe the issue I’m having at least.
http://core.trac.ww.wp.xz.cn/ticket/16706
If anyone finds a clean solution please post it here.
Forum: Themes and Templates
In reply to: "Cheatin' Uh?" – Editor Accessible Settings PageYep, that was it! SWEET!
Forum: Themes and Templates
In reply to: "Cheatin' Uh?" – Editor Accessible Settings PageI think I may have figured out my own issue… I think I was using kind of a bastardized way of getting input from the menu in to the options database, i.e. by posting to options.php:
?> <form action="options.php" method="post"> <?php settings_fields($report_user_input); ?> <?php do_settings_sections(__FILE__); ?> <p class="submit"> <input name="Submit" type="submit" class="button-primary" value="<?php esc_attr_e('Save Changes'); ?>" /> </p> </form> <?phpBut I think this is the way to do it (i.e. the examples: Sample Menu Page) http://codex.ww.wp.xz.cn/Administration_Menus
Hope this works for me!
Forum: Themes and Templates
In reply to: "Cheatin' Uh?" – Editor Accessible Settings PageHey mywebgrocer,
I’ve recently run into the exact same issue with an options page for my users, and it’s causing considerable frustration… I used the same example and I’ve spent the last two days thoroughly vetting my code with lots of little “echo hey I’m here” type statements, and as near as I can tell it should be working for users with non-administrator privileges, but it ain’t.
So I figure either my understand is flawed (probable), the code is flawed (possible) or there’s a hole in the universe that’s sucking non-administrative permissions into it.
…I notice you haven’t posted for a couple weeks. Does this mean you found a solution? (Please oh please fulfill my daylight-savings day wish!)