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

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...

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/

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.

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

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=