vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 4.x Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=245)
-   -   Board Optimization - FUZZY SEO Booster - increase long tail search traffic AUTOMATICALLY! (https://vborg.vbsupport.ru/showthread.php?t=234192)

MOGmartin 02-23-2010 05:23 PM

Quote:

Originally Posted by WxP (Post 1989618)
Database error in vBulletin 4.0.2:

Invalid SQL:

SELECT
MAX(st.date_clicked) max_d, sd.founded, t.term_value, st.position

FROM seoqueries_terms_stats st

LEFT JOIN seoqueries_data sd
ON st.stid = sd.stid
AND st.page_type = sd.page_type

LEFT JOIN seoqueries_terms t
ON sd.stid = t.stid

WHERE
st.page_type = 'index'
AND
t.ban = 0

GROUP BY
st.stid

ORDER BY
#max_d DESC,
#sd.founded DESC,
sd.founded DESC,
t.term_value ASC;

MySQL Error : Unknown column 't.ban' in 'where clause'
Error Number : 1054
Request Date : Tuesday, February 23rd 2010 @ 09:48:41 AM
Error Date : Tuesday, February 23rd 2010 @ 09:48:41 AM
Script : http://www.forumivirtual.com/***/seo...statistic_home
Referrer : http://www.forumivirtual.com/*/index.php?do=nav
Classname : vB_Database
MySQL Version : 5.1.30


thanks for letting me know, Ive not upgraded to 4.0.2 yet, I will check it out this weekend

KissOfDeath 02-23-2010 05:32 PM

Quote:

Originally Posted by MOGmartin (Post 1989778)
sorry mate, IBP is a heap of sh1t - as are any "seo programs" that cost a hundred or so dollars.

Ive been doing this professionally for 5 years, and have worked in online gaming for a few years, specialising in organic search.

but if you dont like it, then dont use it. simple...

I'm not saying any solution is 100% the right one, I like to play around with different ideas and different theories, the fact is that the majority of my urls are not even indexed now and they were before, the only think that changed was the installation of this mod and the upgrade to 4.0.2,

you asked for feedback, maybe you wanted positive feedback only?
i'm just posting my findings positive of negative

oddmud 02-23-2010 05:37 PM

No answer to my problem?

kall 02-23-2010 05:51 PM

Quote:

Originally Posted by MOGmartin (Post 1989775)
which is a school of thought that I dont subscribe to sorry!

I do know a little about seo, check my bio:
http://seoforums.org/seo-blog/about-...seoforums-org/

Fairly obvious, given you made, shared, and use this mod. :)

These guys also know a little about SEO.

http://www.vbseo.com/f30/websiteowne...y-index-30707/ is a case study of someone who had a similar mod installed. Who knows if it was the absolute cause of his rankings tanking, but they did.

KissOfDeath 02-23-2010 06:00 PM

Quote:

Originally Posted by kall (Post 1989808)
Fairly obvious, given you made, shared, and use this mod. :)

These guys also know a little about SEO.

http://www.vbseo.com/f30/websiteowne...y-index-30707/ is a case study of someone who had a similar mod installed. Who knows if it was the absolute cause of his rankings tanking, but they did.

that article seems to explain the exact issue i'm having, it will spike the traffic which is quickly noticed by google, who then punish you for cheating, he posted his before and after stats, i'll see if the same thing happens to me and post my findings,

i'll mark this down to experience, something new i've learnt

KissOfDeath 02-23-2010 06:05 PM

lol,

i disabled the mod about 5 hours ago, my indexed url's have already gone up to 18,101

kall 02-23-2010 06:05 PM

Quote:

Originally Posted by KissOfDeath (Post 1989816)
that article seems to explain the exact issue i'm having, it will spike the traffic which is quickly noticed by google, who then punish you for cheating, he posted his before and after stats, i'll see if the same thing happens to me and post my findings,

i'll mark this down to experience, something new i've learnt

Yeah, that's why I grabbed it.. hadn't seen anyone else saying the same had happened to them with THIS mod until your post, so I shared. :)

*edit* The other mod, if I recall correctly, actually hyperlinked all the SE entries, to the page they were from. This mod doesn't do that, but it's similar.

KissOfDeath 02-23-2010 06:19 PM

1 Attachment(s)
Here are my stats from when the mod was installed till now, i'll post again in a few days when my missing pages are reindexed , you can see it builds up then starts on a rapid decline as google realise whats going on, you can see it builds up then starts on a rapid decline as google realise whats going on, i'm not trying to belittle the creatore work or anything, just saying i tried it and it didn't work for me, i would have actually made a donation to the creator if it did work for me but it just give me a short term gain then worked against me, i check my indexed urls every 3 - 4 days and google have only recently taken action, the fact that my pages are being immediately reindexed as soon as i dissable this mod tells me that it was the cause

final kaoss 02-23-2010 06:34 PM

I see all this "pages removed" "pages reindexed" stuff but do you have any screenshots to prove it? Hint

http://www.google.com/search?hl=en&c...g-sx9&aql=&oq=

KissOfDeath 02-23-2010 06:38 PM

Quote:

Originally Posted by extreme-gaming (Post 1989834)
I see all this "pages removed" "pages reindexed" stuff but do you have any screenshots to prove it? Hint

http://www.google.com/search?hl=en&c...g-sx9&aql=&oq=

don't use the "site:"

I got my stats from google analytics's>traffic sources>search engines

https://vborg.vbsupport.ru/attachmen...0&d=1266958011

TimberFloorAu 02-23-2010 06:46 PM

I am a bit amazed VBSEO and this MOD have been .. mentioned in the same thread, with accusation of this mod being a culprit for page index sandboxing, of sorts.

When clearly if you look at VBSEO relevant replacement tag options, it offers something somewhat identical.

Not sure how the damage of page rank, and index assasination by search engines, can be attributed to one without the other.

Perhaps some smart arse can explain, as it seems to me all this mod does is display the referral keywords used to get to the page, which I cannot see harms the page.

hilfe-forum 02-23-2010 07:01 PM

Quote:

Originally Posted by ahmedbehiry (Post 1972819)
is the encoding issue solved yet?

With new Version i have this Problem:
Quote:

bluetooth am laptop findet keine geräte

final kaoss 02-23-2010 07:01 PM

Well maybe if you worked at google you would be assessing this situation much differently if you noticed a site displaying the exact search terms used to reach the site in question, noticing that the terms weren't there before a user searched google to get there and then suddenly after a search was made voila, there they are (which they probably have a system to detect this with). What would you think about this?

*oh it's just a coincidence that this is happening to every thread
OR
*it seems this site is using blackhat seo software to stuff keywords

Quote:

Originally Posted by TimberFloorAu (Post 1989843)
I am a bit amazed VBSEO and this MOD have been .. mentioned in the same thread, with accusation of this mod being a culprit for page index sandboxing, of sorts.

When clearly if you look at VBSEO relevant replacement tag options, it offers something somewhat identical.

Not sure how the damage of page rank, and index assasination by search engines, can be attributed to one without the other.

Perhaps some smart arse can explain, as it seems to me all this mod does is display the referral keywords used to get to the page, which I cannot see harms the page.


jsnape 02-23-2010 11:33 PM

1 Attachment(s)
Last traffic update. Hopefully the site doesn't get banned at google. The past two years the site averaged a steady 500/visits day but right after installing this it almost doubled. I also updated to 4.0 about the same time so, there's that possible influence.

oddmud 02-24-2010 12:13 AM

I'm also seeing no Homepage Statistics, Forum Display Statistics. I only have 4 Show thread terms statistic.

TimberFloorAu 02-24-2010 02:01 AM

Quote:

Originally Posted by extreme-gaming (Post 1989855)
Well maybe if you worked at google you would be assessing this situation much differently if you noticed a site displaying the exact search terms used to reach the site in question, noticing that the terms weren't there before a user searched google to get there and then suddenly after a search was made voila, there they are (which they probably have a system to detect this with). What would you think about this?

*oh it's just a coincidence that this is happening to every thread
OR
*it seems this site is using blackhat seo software to stuff keywords

I hear what you are saying.

But you are missing the VBSEO point, and that being I can replicate the title tags of the page, and first 20 words of any given thread board wide. Surely this is just as harmful.

Maxima 02-24-2010 02:53 AM

Error on 4.0.2 PL1

Parse error: syntax error, unexpected T_STRING in /public_html/includes/class_core.php(4010) : eval()'d code on line 435

This happens when going to ForumDisplay only (not when viewing thread).

CiyaEzIM 02-24-2010 11:15 AM

Turkish charakter problem?

capy 02-24-2010 06:38 PM

I think I have a problem. If you google fpv.no you'll find my page. you can click on "fpv.no/vbulletin/forumdisplay.php?1-Main-Category" and get straight to the forum. the search word "fpv.no" will now stand under "Visitors found this page by searching for:" but when clicking "home" and "forum" again the search word is gone. What have I done wrong?

oddmud 02-25-2010 05:02 AM

does it remove the tags every day to refresh or something? they keep changing.

oddmud 02-25-2010 05:04 AM

I'm also not a fan of this.. when using the search terms in google.

"Goalie Crease Network
Twitter RSS Feeds. Posting of all the Goalie Crease Network Twitter Feeds .... warrior woodrow goalie. SEO Forum. Buy a Goaliecrease.net T-Shirt! ...
www.goaliecrease.net/forum.php - Cached"

Why would that now come up in the description? not very happy that's there.

Skyrider 02-25-2010 06:40 AM

As I see with the aboev replies, should I install this or wait?

CiyaEzIM 02-25-2010 07:34 AM

Turkish characters
There are also problems.

daveaite 02-25-2010 06:10 PM

The funny thing is, I keep installing this mod, only to uninstall it a few days later. Its a great mod and everything, except it has that SEO Forums on every page next to the landing keywords. Wouldn't it be better to put that outgoing link at the bottom?

It's just like in the middle of my site and probably sends more outgoing traffic than I would like/ is a link way to visible in the middle of my forums of every page.

Good idea, but it still benefits your site way more than it would benefit our sites with that link location and keywords for your site. Waiting to see other options

ps2wiz 02-26-2010 02:02 AM

Quote:

Originally Posted by daveaite (Post 1991416)
The funny thing is, I keep installing this mod, only to uninstall it a few days later. Its a great mod and everything, except it has that SEO Forums on every page next to the landing keywords. Wouldn't it be better to put that outgoing link at the bottom?

It's just like in the middle of my site and probably sends more outgoing traffic than I would like/ is a link way to visible in the middle of my forums of every page.

Good idea, but it still benefits your site way more than it would benefit our sites with that link location and keywords for your site. Waiting to see other options

I just installed, and uninstalled it for the same reason.

oddmud 02-26-2010 03:19 PM

Yeah I don't think I'm going to use this until there is no link added. It's purely just a way for the developer to get more traffic to his site. It's not really working all that well on my site either. I saw a boost for one day in search engine traffic then it tailed off right away. So that might or might not have been a coincidence.

Sorry developer, just don't like the fact your link it showing up in my descriptions on google. It seems you're just trying to gain your PR through this modification.

capy 02-26-2010 06:20 PM

I'm uninstalling as well.

hilfe-forum 02-28-2010 11:27 AM

no support here?

MOGmartin 03-01-2010 11:00 AM

Not been around for a couple of days, hence reduced support.

TO THE PEOPLE COMPLAINING ABOUT ATTRIBUTION LINKS:

This plugin is provided for free, to help increase your long tail SEO traffic, and it does what it says on the tin.

Now that Ive been testing it on my board for a month (and change) its increased my long tail quite significantly - my only condition for you guys to use it for your own benefit is the link back to my site, which is either in your footer, or in the tag cloud itself.

If you are NOT happy with that condition (and lots of plugins do this) then dont use it! its quite simple!

If someone really wants to use it without the attribution link, Im open to taking a donation for removal, if thats the case, then please contact me by PM at my board, http://seoforums.org (user: MOGmartin)

emdee 03-01-2010 11:50 PM

please make this for 3.8.x

ChopSuey 03-02-2010 01:00 AM

Certainly not real results that it tells me. Says position in Google "2" then i search that keyword, it doesn't show up.

MOGmartin 03-02-2010 09:41 AM

Quote:

Originally Posted by ChopSuey (Post 1994892)
Certainly not real results that it tells me. Says position in Google "2" then i search that keyword, it doesn't show up.

ok so that functionality works when google have the position string in the referral URL, thats normally when a user is searching using firefox, and on a version of google that passes the information. (not all countries do).

if its saying #2 then at some point, somewhere - your site was in P2 in google for that search term. the serps vary a lot by country, for instance, my site is #2 in the UK for the search term "seo forum" and in the US its #4, in canada its #3, in india its #1, and in russia its #14.

you can check international serps using a few tools online, like this one:

http://link.ezer.com/tools/google_se...nk_checker.asp

thanks

MOGmartin

MOGmartin 03-04-2010 10:05 AM

4th of March, new version released, please download and UPGRADE your existing plugins to maintain database of keywords.

thanks!

MOGmartin

(ps. fully vb4.0.2 tested now as well)

Marv 03-04-2010 12:33 PM

Just a short note.

As mentioned in a few posts here and over at vbseo.com I had some doubts about this mod and the risk of being banned from major SE for generating keywords. I installed this mod 3 weeks ago and had no significant visitor boosts by now. Quite a bit, but nothing really important. ´til Monday my site was listed in big G with over 200.000 pages. Since tuesday I´m at 13.000.

I can´t tell wether Google has identified my site as a keyword landing page cause of this mod or if there are other reasons for this. But I would recommend that you all keep that in mind. You never know.

I´ll keep the mod until end of the week to see if Google is just doing nasty things or kicking me for a looong time into the second cache. I´ll update this info as soon as I have some news to tell.

Anyone else experiencing something like that ?

MOGmartin 03-04-2010 01:25 PM

as mentioned over at vbseo.com as well, this plugin is in use in over 5,000 websites - I personally run it on about 60 websites and have never had a problem.

The stats on my board are that long tail queries have increased by around 75% since I installed it.


All SEO strategies should be thought out, and a great example is the discussion about this plugin that I link to in my main MOD description area over at seoMoz, where there are nearly 100 comments about it, and its effectiveness.

Basically, I trust it, and I am a full time SEO (check my bio).

Marv 03-04-2010 02:22 PM

Quote:

Originally Posted by MOGmartin (Post 1996921)
as mentioned over at vbseo.com as well, this plugin is in use in over 5,000 websites - I personally run it on about 60 websites and have never had a problem.

The stats on my board are that long tail queries have increased by around 75% since I installed it.


All SEO strategies should be thought out, and a great example is the discussion about this plugin that I link to in my main MOD description area over at seoMoz, where there are nearly 100 comments about it, and its effectiveness.

Basically, I trust it, and I am a full time SEO (check my bio).

Ain?t say a word of distrust in your person and I don?t have to do a backgroundcheck on you. There?s no need to get curious. I only stated that something unusual happend to me and may be could have sthg to do with this mod. I never experienced before that Google has dropped my sites so dramaticly and surely I?m looking for some answers cause my site is generating a needed part of my monthly income. So please dont take this personnel. It?s not meant to be.

AliMadkour 03-04-2010 02:22 PM

Database error in vBulletin 4.0.2:

Invalid SQL:
SELECT * FROM seoqueries_terms WHERE term_value='اكواد الكول تون لمصطفى كامل فودافون\';

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''اكواد الكول تون لمصطفى كامل فودافون\'' at line 1
Error Number : 1064
Request Date : Thursday, March 4th 2010 @ 10:20:20 AM
Error Date : Thursday, March 4th 2010 @ 10:20:20 AM
Classname : vB_Database
MySQL Version : 5.1.30

!!!!
Got DB Error !!! when visitor from google !

MOGmartin 03-04-2010 02:28 PM

Quote:

Originally Posted by Marv (Post 1996983)
Ain?t say a word of distrust in your person and I don?t have to do a backgroundcheck on you. There?s no need to get curious. I only stated that something unusual happend to me and may be could have sthg to do with this mod. I never experienced before that Google has dropped my sites so dramaticly and surely I?m looking for some answers cause my site is generating a needed part of my monthly income. So please dont take this personnel. It?s not meant to be.


not a problem mate, Im not taking it personally - but this strategy has had its detractors, I personally have seen great things on all my sites where this type of thing is installed (wordpress and vbulletin).

there is no reason though for google to drop a large amount of pages because this plugin is installed, thats my only point!

if you want any help with specific diagnosis, post a thread over at http://seoforums.org ;)

cheers!

MOGmartin

MOGmartin 03-04-2010 02:29 PM

Quote:

Originally Posted by AliMadkour (Post 1996984)
Database error in vBulletin 4.0.2:

Invalid SQL:
SELECT * FROM seoqueries_terms WHERE term_value='اكواد الكول تون لمصطفى كامل فودافون\';

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''اكواد الكول تون لمصطفى كامل فودافون\'' at line 1
Error Number : 1064
Request Date : Thursday, March 4th 2010 @ 10:20:20 AM
Error Date : Thursday, March 4th 2010 @ 10:20:20 AM
Classname : vB_Database
MySQL Version : 5.1.30




!!!!
Got DB Error !!! when visitor from google !

please send me by PM the URL to your board, and a search term that I can find it with, and on which google site you are searching from.

thanks!

MOGmartin

Gnoll 03-04-2010 05:35 PM

new updates looks cool :) i installed , if possible can ( or making ? )

* add as tag ( to topic )
* add as keyword ( to topic )
* do both


All times are GMT. The time now is 07:43 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01818 seconds
  • Memory Usage 1,860KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (15)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete