Remove all keywords from all items [resolved]

[Azmandius]

Hello,
I've been using an automatic Add Keywords plugin, and i see there is a serious mess in articles keywords, and i kind of think it rather bad for SEO, considering the fact that Google isn't so much after keywords these days.

Is there a plugin or an SQL command that i could run to simply empty the keywords field for all article items?

Thanks a lot!

[farhan258]

Can i know from were you want to remove keywords

[Azmandius]

Yes you can, here:

But i already did apply the proper SQL query, thanks.

[mandville]

personaly i think the fact you are using an out of date and vulnerable version of joomla is more concerning than removing your keywords

[Azmandius]

Well, that being said, now i guess I'll happily get into few weeks of migration headache from 1.5xx to 3.xx, because i have nothing else better to do

Don't get me harsh, i understand you are an extremely advanced Joomla user, and your advice good, but also banal at same time.

I'm using Joomla since 2009, I'm no pro, but good enough to clearly realize what I'm doing

Peace

[sozzled]

I'm not defending the forum moderators but ...

I've been using an automatic Add Keywords plugin, and i see there is a serious mess in articles keywords, and i kind of think it rather bad for SEO, considering the fact that Google isn't so much after keywords these days.

Perhaps it's time to wake up and smell the roses (and I'm not trying to be cute or "banal".

You are aware, of course, that J! 1.5 is vulnerable? You are aware, of course, that J! 1.5 is not supported? You are aware, of course, that continuing to use J! 1.5 (and third-party extensions that happen to be lying around the internet) is the risk that you take. You've discovered what a disaster it was to use an old, outdated and unsupported plugin. I understand that. If, however, you're seeking sympathy I can't give you that kind of reassurance that you'll find it.

In any event, it's not "weeks" of headaches you'll be facing. Consider the time you spend planning and executing your migration to J! 3.7 as time productively spent.

It shouldn't be too difficult to write an SQL query that selects all records from the J! 1.5 articles table and sets the keywords column to NULL.

[Azmandius]

I'm actually seriously considering a suitable to my mind - responsive template with latest Joomla, to migrate to, I'm looking for long time, just did not fine one yet, i keep looking.

[sozzled]

Although this is off-topic, are you aware that the Joomla Protostar template is responsive? Returning to your question, yes, you could write your own SQL query—execute it with phpMyAdmin—to clear the contents of the keywords in your articles.

[Azmandius]

Actually i wasn't aware that Protostar is responsive, regardless, i don't really like it.

By the way i have successfully run and cleaned all keywords from articles, some time ago, this is a relatively old thread

[mandville]

Ok. So should we mark it as resolved (possibly why farhan258 responded because it wasnt ) and then you can concentrate on upgrading to j1.5.26 at least before you move to j3? For security reasons

[Azmandius]

Yes, thanks everyone for contribution.