HTML Logo by World Wide Web Consortium (www.w3.org). Click to learn more about our commitment to accessibility and standards.

Moving forward with Composr

ocPortal has been relaunched as Composr CMS, which is now in beta. ocPortal 9 will be superseded by Composr 10.

Head over to compo.sr for our new site, and to our migration roadmap. Existing ocPortal member accounts have been mirrored.


Tag-cloud issue

Login / Search

 [ Join | More ]
 Add topic 
Posted
Rating:
#103322 (In Topic #20231)
Avatar

Well-settled

Cannot trace sources of unwanted tags

Greetings!

I've been experiencing a gradual build-up of unwanted metakeywords in my Tag-cloud block, some of which I can clearly recall deleting from the SEO section of pages that initially auto-generated them.

I've inspected every single manually-created page on my site, both by opening via the CMS interfaces and via the Search function (by clicking a tag in the Tag-cloud). Either way, none of the unwanted tags appears in any of those pages' current versions. (Perhaps they're still extant in earlier saved versions - though they aren't in any I've checked via their editing page).

Would anyone be able to tell me of any other way of tracing tags back to their origin, please? Or, better still (under the circumstances) a way to selectively edit out tags from the Tag-cloud?

Thanks for reading!

(running v9.0.9, with the static Tag-cloud, btw)
Back to the top
 
Posted
Rating:
#103337
Avatar

Hi,

It sounds like some rows in the seo_meta table might have got orphaned. ocPortal is supposed to clean up when content is deleted, but maybe something went wrong there.

I'm going to add an "orphaned tags" cleanup tool…


Become a fan of ocPortal on Facebook or add me as a friend. Add me on on Twitter.
Was I helpful?
  • If not, please let us know how we can do better (please try and propose any bigger ideas in such a way that they are fundable and scalable).
  • If so, please let others know about ocPortal whenever you see the opportunity.
  • If my reply is too Vulcan or expressed too much in business-strategy terms, and not particularly personal, I apologise. As a company & project maintainer, time is very limited to me, so usually when I write a reply I try and make it generic advice to all readers. I'm also naturally a joined-up thinker, so I always express my thoughts in combined business and technical terms. I recognise not everyone likes that, don't let my Vulcan-thinking stop you enjoying ocPortal on fun personal projects.
  • If my response can inspire a community tutorial, that's a great way of giving back to the project as a user.
Back to the top
 
Posted
Rating:
#103338
Avatar



Become a fan of ocPortal on Facebook or add me as a friend. Add me on on Twitter.
Was I helpful?
  • If not, please let us know how we can do better (please try and propose any bigger ideas in such a way that they are fundable and scalable).
  • If so, please let others know about ocPortal whenever you see the opportunity.
  • If my reply is too Vulcan or expressed too much in business-strategy terms, and not particularly personal, I apologise. As a company & project maintainer, time is very limited to me, so usually when I write a reply I try and make it generic advice to all readers. I'm also naturally a joined-up thinker, so I always express my thoughts in combined business and technical terms. I recognise not everyone likes that, don't let my Vulcan-thinking stop you enjoying ocPortal on fun personal projects.
  • If my response can inspire a community tutorial, that's a great way of giving back to the project as a user.
Back to the top
 
Posted
Rating:
#103357
Avatar

It occurred to me that the tags could be from data from uninstalled addons, which my cleanup script can't catch.

This query would give you an idea where all 'example' tags are coming from:

Code

SELECT m.* FROM ocp_seo_meta m JOIN ocp_translate t ON t.id=m.meta_keywords WHERE text_original LIKE '%example%';
It is safe to delete rows from the seo_meta table.


Become a fan of ocPortal on Facebook or add me as a friend. Add me on on Twitter.
Was I helpful?
  • If not, please let us know how we can do better (please try and propose any bigger ideas in such a way that they are fundable and scalable).
  • If so, please let others know about ocPortal whenever you see the opportunity.
  • If my reply is too Vulcan or expressed too much in business-strategy terms, and not particularly personal, I apologise. As a company & project maintainer, time is very limited to me, so usually when I write a reply I try and make it generic advice to all readers. I'm also naturally a joined-up thinker, so I always express my thoughts in combined business and technical terms. I recognise not everyone likes that, don't let my Vulcan-thinking stop you enjoying ocPortal on fun personal projects.
  • If my response can inspire a community tutorial, that's a great way of giving back to the project as a user.
Back to the top
 
Posted
Rating:
#103377
Avatar

Well-settled

Many thanks for that, Chris!

Unfortunately I haven't applied your fix yet, as the two files in the .tar are fused together; the .ini code ends at line 50 and the .php `starts at line 51

I'm guessing it would be okay to split this into two separate files, but I thought I'd better consult you in case, before going ahead.

Kind regards

Richard.

btw, purely info: the table names in my installation are all prefixed with oc_ , not ocp_ 
Back to the top
 
Posted
Rating:
#103378
Avatar

I'm not sure what happened for you there, but the file looks fine to me. I opened it up and tested extracting each file, and the integrity of each file.

I also looked at the raw tar in an editor, and the files aren't directly consecutive (which I thought could be possible by a coincidence, leading to some bug), there's padding between them.



Become a fan of ocPortal on Facebook or add me as a friend. Add me on on Twitter.
Was I helpful?
  • If not, please let us know how we can do better (please try and propose any bigger ideas in such a way that they are fundable and scalable).
  • If so, please let others know about ocPortal whenever you see the opportunity.
  • If my reply is too Vulcan or expressed too much in business-strategy terms, and not particularly personal, I apologise. As a company & project maintainer, time is very limited to me, so usually when I write a reply I try and make it generic advice to all readers. I'm also naturally a joined-up thinker, so I always express my thoughts in combined business and technical terms. I recognise not everyone likes that, don't let my Vulcan-thinking stop you enjoying ocPortal on fun personal projects.
  • If my response can inspire a community tutorial, that's a great way of giving back to the project as a user.
Back to the top
 
Posted
Rating:
#103414
Avatar

Well-settled

Hi Chris!

I've at last had a free moment permitting me to re-try your tar. The earlier strange result was evidently due to some kind of Windows glitch affecting 7-Zip, and after re-booting, the tar unpacked without a hitch. Apologies for taking up your time investigating the matter, and sincere thanks for your care.

Your addon appears to have installed fine, though it hasn't actually removed the offending tags. The mySQL query you kindly appended, however, has done the job of tracing their source to a seedy page that I'd deleted after having saved its content to a new page (in order to regain original Comcode ownership), which explains why the replacement page appeared to be tag-free, (i.e., as initially saved).

Many thanks for all your attention, and good wishes,

Richard.
Back to the top
 
Posted
Rating:
#103424
Avatar

Ah, cool. So it turns out Wiki+ page deletion isn't cleaning up tags, and doesn't fully have tagging defined such as to allow my tool to work. Both issues will be resolved.


Become a fan of ocPortal on Facebook or add me as a friend. Add me on on Twitter.
Was I helpful?
  • If not, please let us know how we can do better (please try and propose any bigger ideas in such a way that they are fundable and scalable).
  • If so, please let others know about ocPortal whenever you see the opportunity.
  • If my reply is too Vulcan or expressed too much in business-strategy terms, and not particularly personal, I apologise. As a company & project maintainer, time is very limited to me, so usually when I write a reply I try and make it generic advice to all readers. I'm also naturally a joined-up thinker, so I always express my thoughts in combined business and technical terms. I recognise not everyone likes that, don't let my Vulcan-thinking stop you enjoying ocPortal on fun personal projects.
  • If my response can inspire a community tutorial, that's a great way of giving back to the project as a user.
Back to the top
 
Posted
Rating:
#103458
Avatar

Well-settled

Hi Chris,
Perhaps it might be pertinent to this  issue to mention I've found that if a seedy page is renamed,  its earlier name is retained in the "Edit Wiki Page" cms interface list of pages, and not updated - although the updated name displays on the user's page and on the Wiki Tree.

That too would seem to be a database-table issue, so I wonder if the two issues are connected?



Back to the top
 
Important!
Posted
Rating:
#103470
Avatar

Automated fix message

RichT said

Hi Chris,
Perhaps it might be pertinent to this  issue to mention I've found that if a seedy page is renamed,  its earlier name is retained in the "Edit Wiki Page" cms interface list of pages, and not updated - although the updated name displays on the user's page and on the Wiki Tree.

That too would seem to be a database-table issue, so I wonder if the two issues are connected?



This issue has been filed on the tracker as issue #1641, with a fix.


Become a fan of ocPortal on Facebook or add me as a friend. Add me on on Twitter.
Was I helpful?
  • If not, please let us know how we can do better (please try and propose any bigger ideas in such a way that they are fundable and scalable).
  • If so, please let others know about ocPortal whenever you see the opportunity.
  • If my reply is too Vulcan or expressed too much in business-strategy terms, and not particularly personal, I apologise. As a company & project maintainer, time is very limited to me, so usually when I write a reply I try and make it generic advice to all readers. I'm also naturally a joined-up thinker, so I always express my thoughts in combined business and technical terms. I recognise not everyone likes that, don't let my Vulcan-thinking stop you enjoying ocPortal on fun personal projects.
  • If my response can inspire a community tutorial, that's a great way of giving back to the project as a user.
Important!
 
Posted
Rating:
#103484
Avatar

Well-settled

Many thanks for the hotfix, Chris!

Unfortunately, as my set of seedy db tables are currently set, the fix is still not actually updating the page-title in the child list, so the issue still stands. However, I notice that my Primary index for oc_seedy_children is set to "--ignore--" with respect to the "title" column, rather than "title" - would that account for your fix not getting implemented, and should I reset the column to "title" in the Primary index?

Anyway, manually editing the page-name in the "title" field does the trick.

Regarding the orphaned tags still not getting removed after performing your cleanup, could that be for the same reason - ie my ocp_seo_meta primary index has only one column set ("id[int(10) unsigned]" and one other set as "--ignore--" Please can you advise?

Thanks again for all your time on this so far, and good wishes,

Richard
Back to the top
 
Posted
Rating:
#103486
Avatar

As explained in the hotfix, titles are meant to be able to be unique in different points in the tree. This is because there are many situations where you might need that. For example if you have a page called 'Boats' and a child page of it called 'Engine Mechanics' – and you might actually have another page called 'Engines' that has the same child as 'Boat Engines'. Not a great example really, but that was off the top of my head.

The hotfix prevents unnecessary divergence, it will not resync things.

That stuff about database indexes is inconsequential. Database indexes are related to performance only.


Become a fan of ocPortal on Facebook or add me as a friend. Add me on on Twitter.
Was I helpful?
  • If not, please let us know how we can do better (please try and propose any bigger ideas in such a way that they are fundable and scalable).
  • If so, please let others know about ocPortal whenever you see the opportunity.
  • If my reply is too Vulcan or expressed too much in business-strategy terms, and not particularly personal, I apologise. As a company & project maintainer, time is very limited to me, so usually when I write a reply I try and make it generic advice to all readers. I'm also naturally a joined-up thinker, so I always express my thoughts in combined business and technical terms. I recognise not everyone likes that, don't let my Vulcan-thinking stop you enjoying ocPortal on fun personal projects.
  • If my response can inspire a community tutorial, that's a great way of giving back to the project as a user.
Back to the top
 
Posted
Rating:
#103487
Avatar

Well-settled

Many thanks, Chris, for your explanation - I hadn't grasped the underlying rationale, and hence wasn't correctly inferring from the hotfix's description what to expect from it. I'm with you now!

Kind regards,

Richard
Back to the top
 
There are too many online users to list.
Control functions:

Quick reply   Contract

Your name:
Your message: