Database cleanup tool? #38
Labels
Comments
MitchellMcKenna
added a commit
that referenced
this issue
Oct 28, 2012
- Fix /items/tag pages using count_items_by_search() instead of count_item_by_tag() for figuring out pagination. - Fix item_model count_items_by_tag() using depreciated getwhere() function. Refs #38
MitchellMcKenna
added a commit
that referenced
this issue
Oct 29, 2012
- When requesting tags, only those of a published posts will be returned. - tag_model get_all_tags() will calculate the number of items tagged dynatmically. - The column count of the tags table is unnecessary, the column and related code will be removed when the database migration tool is built. Refs #38
This was referenced Oct 29, 2012
|
@therourke There was a bug in displaying the correct number of results when you click on a tag, there is a fix for this in the develop branch which will merge into master with the next release. I've also opened a pull request which will soon move into develop branch to change the way popular_tags is calculated, it will no longer be based on the count column in the tags table, it will be calculated dynamically based on how many published posts are tagged with a given tag. Also a ticket has been opened to create a new section of the admin specifically for maintaining tags. |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
I have a really cluttered Lifepress MySQL database. This is due to lots of things: feeds being pulled multiple times over time; tags relationships not being updated properly; links being deleted, etc.
The result is that a lot of editing I have to do to make the frontend of Lifepress look nice has to be done at the level of the database. Stuff like tags is a nightmare, because of the way Sweetcron/Lifepress relates an entry to its tags, the information is well out of sync. It might be something to do with feeds being pulled mutiple times, I'm not sure, but some tags that I know exist only 5 or 6 times through the database are listed as existing 40 or 50 times. this screws up the $popular_tags as $tag feature and feels messy.
Is there any debugging tool that could be latched on to the backend of Lifepress? I'm thinking, some bit of code that would run through the MySQL database and recount all the tags etc. and tidy stuff up?
Otherwise, do you have a better way to call up $popular_tags as $tag? At least a new way to choose how many tags show up etc? This old bit of code doesn't work anymore, an updated version would be great.
The text was updated successfully, but these errors were encountered: