vb.org Archive - Board Optimization - FUZZY SEO Booster - increase long tail search traffic AUTOMATICALLY!

Page 29 of 80

Show 40 post(s) from this thread on one page

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

03-04-2010 05:37 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 !

FYI: Ive located the bug with this, the user is searching for a query that ends in a trailing slash (weird, and very unusual)

this is a circumstance I never considered, but a release tomorrow will cover that bug.

MOGmartin

03-05-2010 04:44 AM

Quote:

Originally Posted by Gnoll (Post 1997138)

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

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

as the keywords are specific to a single thread in a lot of cases this wouldnt really work to be honest.

you would have to build a lot of logic to determine what tag it was meant to link to, then that tag page would get the SEO benefit.

I dont know about you, but Ive never seen tag pages pop up in the SERPs much.

fogjuice

03-05-2010 03:29 PM

I have the same problem and I just installed the update.

Quote:

Database error in vBulletin 4.0.1:

Invalid SQL:
SELECT * FROM vB_seoqueries_terms WHERE term_value='innumerable stars science said 1 100\';

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 ''innumerable stars science said 1 100\'' at line 1
Error Number : 1064
Request Date : Friday, March 5th 2010 @ 12:29:11 PM
Error Date : Friday, March 5th 2010 @ 12:29:11 PM
Script : http://atheistdiscussion.com/showthread.php?t=381
Referrer : http://www.google.ca/search?hl=en&sa...100%5C&spell=1
IP Address : ***
Username : ***
Classname : vB_Database
MySQL Version : 5.0.89-community

MOGmartin

03-05-2010 03:54 PM

Quote:

Originally Posted by fogjuice (Post 1997838)

I have the same problem and I just installed the update.

does the search term you are clicking through from contain a slash?

fogjuice

03-05-2010 03:54 PM

Quote:

Originally Posted by MOGmartin (Post 1997853)

does the search term you are clicking through from contain a slash?

yes. It seems you have not escaped the slashes properly.

Here is the search, http://www.google.ca/search?hl=en&sa...1,100\&spell=1

MOGmartin

03-05-2010 03:56 PM

yep, its a bug I was made aware of for the first time yesterday, I will release a patch upgrade by Monday mate.

thanks for flagging it though, I genuinely hadn't ever used a search term with a slash in it ;)

fogjuice

03-05-2010 03:58 PM

Quote:

Originally Posted by MOGmartin (Post 1997857)

Ok thanks, the sooner the better because its effecting any pages ppl search with a slash and I don't want to lose page position and have google replace them with db error pages. :\

MOGmartin

03-05-2010 05:45 PM

Quote:

Originally Posted by fogjuice (Post 1997859)

Ok thanks, the sooner the better because its effecting any pages ppl search with a slash and I don't want to lose page position and have google replace them with db error pages. :\

there is no need to worry about that, because the page still exists fine, its just when it has a slash in the refferer url...

ie, googlebot will still load the page correctly, but I am re-releasing a fix on this ASAP!

thanks

MOGMartin

Yellow Slider

03-06-2010 12:22 PM

can you please give an example of this? is it the tag cloud over SEOFORUMS.ORG or what?
I don't see any "long tail phrases" in that tag cloud..

MOGmartin

03-06-2010 05:20 PM

Quote:

Originally Posted by Yellow Slider (Post 1998431)

can you please give an example of this? is it the tag cloud over SEOFORUMS.ORG or what?
I don't see any "long tail phrases" in that tag cloud..

sure, check out the first link in the description to my blog post about it, there are examples, and snapshots of my organic traffic as well.

All times are GMT. The time now is 11:20 PM.

Page 29 of 80

« First

Last »

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01815 seconds Memory Usage 1,750KB 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 (8)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (3)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (10)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
Messages: