Remove all keywords from all items [resolved]

Discuss Search Engine Optimization in relation to Joomla!. This forum will also have discussions on SEF/SEO Joomla! extensions.

Moderator: General Support Moderators

User avatar
Azmandius
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 149
Joined: Fri Nov 27, 2009 3:25 pm
Location: Moldova, Chisinau
Contact:

Remove all keywords from all items [resolved]

Postby Azmandius » Thu May 11, 2017 12:18 pm

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!
Last edited by mandville on Fri Jun 23, 2017 10:58 am, edited 1 time in total.
Reason: Marked resolved as per OP
AzBlog.me | Content & links worth checking.

farhan258
Joomla! Apprentice
Joomla! Apprentice
Posts: 12
Joined: Tue May 30, 2017 6:30 am

Re: Remove all keywords from all items

Postby farhan258 » Fri Jun 23, 2017 6:14 am

Can i know from were you want to remove keywords

User avatar
Azmandius
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 149
Joined: Fri Nov 27, 2009 3:25 pm
Location: Moldova, Chisinau
Contact:

Re: Remove all keywords from all items

Postby Azmandius » Fri Jun 23, 2017 7:08 am

Yes you can, here:
Image
But i already did apply the proper SQL query, thanks.
AzBlog.me | Content & links worth checking.

User avatar
mandville
Joomla! Master
Joomla! Master
Posts: 14330
Joined: Mon Mar 20, 2006 1:56 am
Location: The Girly Side of Joomla in Sussex

Re: Remove all keywords from all items

Postby mandville » Fri Jun 23, 2017 7:38 am

personaly i think the fact you are using an out of date and vulnerable version of joomla is more concerning than removing your keywords
HU2HY- Poor questions = Poor answer
Un requested Help PM's will be reported, added to the foe list and possibly just deleted
{VEL Team Leader}{TM Auditor }{ Showcase & Security forums Moderator}

User avatar
Azmandius
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 149
Joined: Fri Nov 27, 2009 3:25 pm
Location: Moldova, Chisinau
Contact:

Re: Remove all keywords from all items

Postby Azmandius » Fri Jun 23, 2017 8:08 am

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 :)
AzBlog.me | Content & links worth checking.

User avatar
sozzled
Joomla! Virtuoso
Joomla! Virtuoso
Posts: 3498
Joined: Sun Jul 05, 2009 3:30 am
Location: Canberra, Australia
Contact:

Re: Remove all keywords from all items

Postby sozzled » Fri Jun 23, 2017 8:23 am

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

Azmandius wrote: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.
https://www.kuneze.com/blog
Former member of Kunena project team
If you think I’m wrong then say “I think you're wrong.” If you say “You’re wrong!”, how do you know?

User avatar
Azmandius
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 149
Joined: Fri Nov 27, 2009 3:25 pm
Location: Moldova, Chisinau
Contact:

Re: Remove all keywords from all items

Postby Azmandius » Fri Jun 23, 2017 8:31 am

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.
AzBlog.me | Content & links worth checking.

User avatar
sozzled
Joomla! Virtuoso
Joomla! Virtuoso
Posts: 3498
Joined: Sun Jul 05, 2009 3:30 am
Location: Canberra, Australia
Contact:

Re: Remove all keywords from all items

Postby sozzled » Fri Jun 23, 2017 8:48 am

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.
https://www.kuneze.com/blog
Former member of Kunena project team
If you think I’m wrong then say “I think you're wrong.” If you say “You’re wrong!”, how do you know?

User avatar
Azmandius
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 149
Joined: Fri Nov 27, 2009 3:25 pm
Location: Moldova, Chisinau
Contact:

Re: Remove all keywords from all items

Postby Azmandius » Fri Jun 23, 2017 10:29 am

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 :)
AzBlog.me | Content & links worth checking.

User avatar
mandville
Joomla! Master
Joomla! Master
Posts: 14330
Joined: Mon Mar 20, 2006 1:56 am
Location: The Girly Side of Joomla in Sussex

Re: Remove all keywords from all items

Postby mandville » Fri Jun 23, 2017 10:35 am

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
HU2HY- Poor questions = Poor answer
Un requested Help PM's will be reported, added to the foe list and possibly just deleted
{VEL Team Leader}{TM Auditor }{ Showcase & Security forums Moderator}

User avatar
Azmandius
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 149
Joined: Fri Nov 27, 2009 3:25 pm
Location: Moldova, Chisinau
Contact:

Re: Remove all keywords from all items

Postby Azmandius » Fri Jun 23, 2017 10:51 am

Yes, thanks everyone for contribution.
AzBlog.me | Content & links worth checking.


Return to “Search Engine Optimization (Joomla! SEO) in Joomla! 1.5”

Who is online

Users browsing this forum: No registered users and 9 guests