vBulletin Search Engine Optimization
This is a discussion on Does vBseo also work with vBadvanced and vBadvanced links directory? within the General Discussion forums, part of the vBSEO SEO Plugin category; Do you have any idea why I got a database error when I first tried it though? It made some ...
| |||||||
Enhancing 80 million pages. | Register | FAQ | Members List | Social Groups | Calendar | Search | Today's Posts | Mark Forums Read |
|
#16
| |||
| |||
|
Do you have any idea why I got a database error when I first tried it though? It made some mention of "duplicate entry" or something like that. I guess I can try and do it manually, but that just seems like it'll be a big pain. |
|
#17
| ||||
| ||||
|
What exactly did the error say?
__________________ Oleg Ignatiuk / Crawlability Inc. vBSEO 3.2.0 Launched - Maximum Overdrive for Your Web Traffic! Over 100 Instant SEO Optimizations vBSEO Google Sitemap Generator - Version 2.2 Released Mandatory Upgrade for vBSEO 3.2.0 GOLD 6X Traffic - $1400 in One Day with vBSEO! Imagine What the vBSEO Patent Pending Technology Can Do For You. |
|
#18
| |||
| |||
|
It gets to the first template where it should replace something and then gives me this error: Code: Database error in vBulletin 3.5.2:
Invalid SQL:
INSERT INTO template
(styleid, title, template, template_un, dateline, username, version)
VALUES
(23,
'adv_links_directorybit_level1',
'</tbody>\n<tbody>\n<tr>\n <td colspan=\\\"2\\\" class=\\\"alt1\\\">\n\n <table border=\\\"0\\\" cellpadding=\\\"0\\\" cellspacing=\\\"0\\\">\n <tr>\n <td><img alt=\\\"\\\" border=\\\"0\\\" src=\\\"$stylevar[imgdir_statusicon]/forum_$onoff.gif\\\" /></td>\n <td><img alt=\\\"\\\" src=\\\"\" . $GLOBALS[\'vbulletin\']->options[\'bburl\'] . \"/\" . $GLOBALS[\'vbulletin\']->options[\'cleargifurl\'] . \"\\\" width=\\\"9\\\" /></td>\n <td><b><a href=\\\"browselinks.php?\" . $GLOBALS[\'vbulletin\']->session->vars[\'sessionurl\'] . \"c=$cats[catid]\\\">$cats[title]</a></b>\n <div class=\\\"smallfont\\\">$cats[description]</div>\n \".(($show[\'subscribe_options\']) ? (\"\n <div class=\\\"smallfont\\\">\n [<a href=\\\"misc.php?\" . $GLOBALS[\'vbulletin\']->session->vars[\'sessionurl\'] . \"do=unsubscribe&type=dir&c=$cats[catid]&return=subscriptions\\\">$vbphrase[unsubscribe_from_this_directory]</a>]\n </div>\n \") : (\"\")).\"\n </td>\n </tr>\n </table>\n </td>\n\n\n <td class=\\\"alt2\\\" nowrap=\\\"nowrap\\\">\n \".(($cats[\'lastlinkid\']) ? (\"\n <span class=\\\"smallfont\\\"><b><a href=\\\"showlink.php?\" . $GLOBALS[\'vbulletin\']->session->vars[\'sessionurl\'] . \"ltitle=$link_seo_title&do=showdetails&l=$cats[lastlinkid]\\\">$cats[lastlinktitle]</a></b><br />\n $vbphrase[by]\n \".(($cats[\'lastuserid\']) ? (\"\n <a href=\\\"\" . $GLOBALS[\'vbulletin\']->options[\'bburl\'] . \"/member.php?\" . $GLOBALS[\'vbulletin\']->session->vars[\'sessionurl\'] . \"u=$cats[lastuserid]\\\">$cats[lastposter]</a>\n \") : (\"\n $vbphrase[guest]\n \")).\"\n </span><div class=\\\"smallfont\\\" align=\\\"right\\\">$cats[lastupdateddate] <span class=\\\"time\\\">$cats[lastupdatedtime]</span> <a href=\\\"showlink.php?\" . $GLOBALS[\'vbulletin\']->session->vars[\'sessionurl\'] . \"ltitle=$link_seo_title&do=showdetails&l=$cats[lastlinkid]\\\"><img alt=\\\"\\\" border=\\\"0\\\" src=\\\"$stylevar[imgdir_button]/lastpost.gif\\\" /></a></div>\n \") : (\"\n <div align=\\\"center\\\">$vbphrase[never]</div>\n \")).\"\n </td>\n\n <td align=\\\"center\\\" class=\\\"alt1\\\"><span class=\\\"smallfont\\\">$cats[linkcount]</span></td>\n\n \".(($vba_options[\'links_allowreplies\']) ? (\"\n <td align=\\\"center\\\" class=\\\"alt2\\\"><span class=\\\"smallfont\\\">$cats[postcount]</span></td>\n \") : (\"\")).\"\n\n \".(($show[\'modcolumn\']) ? (\"\n <td align=\\\"center\\\" class=\\\"\".(($vba_options[\'links_allowreplies\']) ? (\"alt1\") : (\"alt2\")).\"\\\">$cats[moderator]</td>\n \") : (\"\")).\"\n\n</tr>\n',
'</tbody>\n<tbody>\n<tr>\n <td colspan=\"2\" class=\"alt1\">\n\n <table border=\"0\" cellpadding=\"0\" cellspacing=\"0\">\n <tr>\n <td><img alt=\"\" border=\"0\" src=\"$stylevar[imgdir_statusicon]/forum_$onoff.gif\" /></td>\n <td><img alt=\"\" src=\"$vboptions[bburl]/$vboptions[cleargifurl]\" width=\"9\" /></td>\n <td><b><a href=\"browselinks.php?$session[sessionurl]c=$cats[catid]\">$cats[title]</a></b>\n <div class=\"smallfont\">$cats[description]</div>\n <if condition=\"$show[\'subscribe_options\']\">\n <div class=\"smallfont\">\n [<a href=\"misc.php?$session[sessionurl]do=unsubscribe&type=dir&c=$cats[catid]&return=subscriptions\">$vbphrase[unsubscribe_from_this_directory]</a>]\n </div>\n </if>\n </td>\n </tr>\n </table>\n </td>\n\n\n <td class=\"alt2\" nowrap=\"nowrap\">\n <if condition=\"$cats[\'lastlinkid\']\">\n <span class=\"smallfont\"><b><a href=\"showlink.php?$session[sessionurl]ltitle=$link_seo_title&do=showdetails&l=$cats[lastlinkid]\">$cats[lastlinktitle]</a></b><br />\n $vbphrase[by]\n <if condition=\"$cats[\'lastuserid\']\">\n <a href=\"$vboptions[bburl]/member.php?$session[sessionurl]u=$cats[lastuserid]\">$cats[lastposter]</a>\n <else />\n $vbphrase[guest]\n </if>\n </span><div class=\"smallfont\" align=\"right\">$cats[lastupdateddate] <span class=\"time\">$cats[lastupdatedtime]</span> <a href=\"showlink.php?$session[sessionurl]ltitle=$link_seo_title&do=showdetails&l=$cats[lastlinkid]\"><img alt=\"\" border=\"0\" src=\"$stylevar[imgdir_button]/lastpost.gif\" /></a></div>\n <else />\n <div align=\"center\">$vbphrase[never]</div>\n </if>\n </td>\n\n <td align=\"center\" class=\"alt1\"><span class=\"smallfont\">$cats[linkcount]</span></td>\n\n <if condition=\"$vba_options[\'links_allowreplies\']\">\n <td align=\"center\" class=\"alt2\"><span class=\"smallfont\">$cats[postcount]</span></td>\n </if>\n\n <if condition=\"$show[\'modcolumn\']\">\n <td align=\"center\" class=\"<if condition=\"$vba_options[\'links_allowreplies\']\">alt1<else />alt2</if>\">$cats[moderator]</td>\n </if>\n\n</tr>\n',
1176682565,
'thehalogod',
'3.5.2');
MySQL Error : Duplicate entry 'adv_links_directorybit_level1-23' for key 2
Error Number : 1062
Date : Sunday, April 15th 2007 @ 08:16:05 PM
Script : http://www.gamingvidz.com/forum/xxxxxx/template.php
Referrer : http://www.gamingvidz.com/forum/xxxx....php?do=search
IP Address : xx.xx.xx.xx
Username : thehalogod
Classname : vb_database
Edit: Should I just try the syles and templates / replacement variable manager? |
|
#19
| ||||
| ||||
|
I'm not sure why does it happen, you should try to do it manually then. You can also copy template into your text editor, perform search and replace operation and copy it back to vB admincp.
__________________ Oleg Ignatiuk / Crawlability Inc. vBSEO 3.2.0 Launched - Maximum Overdrive for Your Web Traffic! Over 100 Instant SEO Optimizations vBSEO Google Sitemap Generator - Version 2.2 Released Mandatory Upgrade for vBSEO 3.2.0 GOLD 6X Traffic - $1400 in One Day with vBSEO! Imagine What the vBSEO Patent Pending Technology Can Do For You. |
|
#20
| |||
| |||
|
Ok, I'll go grab the appropriate templates and put them in notepad and try it. Will post back once I've done it.
|
|
#21
| |||
| |||
|
When I try and reinput the text that I've changed in my text editor it gives me this message when I try and save the template: "A template named adv_links_directorybit_level1 already exists. If you click 'Save' the existing template will be overwritten." But if I click save and look at the template my changes are not saved. Now what do I do to fix that? :( |
|
#22
| |||
| |||
|
Update: I reuploaded one of my old styles before I did all these changes and after reuploading it for some crazy unknown reason the stuff was fixed. In other words, my search and replace thing worked but only after I uploaded a new style. So now my links look like this (hover over them to see what I'm talking about): Gaming Videos - Video Database- Shadz Hayz & The Crack's Halo 2 Dualtage Is there a way to get rid of the "displaylink" part of it? My category url's look like this (hover over them to see what I'm talking about): Gaming Videos - Video Database - Montages Is there a way to make it look like forum categories do? Because rather than having /linkcat-2.html it'd probably be much better for it to be: http://www.gamingvidz.com/vidz/montages.html Any ideas on how to get these fixs? Thanks so far Oleg, we're getting close Here is my .htaccess for the "vidz" folder: Code: RewriteEngine On
RewriteCond %{QUERY_STRING} !vbseourl=
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule ^(.*)$ /forum/vbseo.php?vbseourl=$1&vbseorelpath=../vidz/&%{QUERY_STRING} [L]
RewriteCond %{REQUEST_FILENAME} !forum/
RewriteRule ^(.*\.php)$ /forum/vbseo.php?vbseourl=$1&vbseorelpath=../vidz/&%{QUERY_STRING} [L]
Code: //vidz Rewrites 'browselinks\.php\?do=newlinks$' => 'newlinks.html' 'browselinks\.php\?do=poplinks$' => 'top.html' 'browselinks\.php\?do=poplinks&orderby=rating$' => 'toprating.html' 'browselinks\.php\?do=poplinks&orderby=posts$' => 'topposts.html' 'browselinks\.php\?c=(\d+).*$' => 'linkcat-$1.html' 'vidz/search\.php' => 'search.html' 'vidz/search\.php\?do=searchresults&string=(\w+)&catid= 0&quicksearch=1' => 'search-$1.html' 'browselinks\.php\?do=browselinks&catid=(\d+)<r=(\w+)&linkuserid=(\d+)' => 'linkcat-$1-$2.html' 'browselinks\.php\?do=poplinks&orderby=views' => 'topviews.html' 'misc\.php\?do=linktous' => 'linktous.html' 'addlink\.php\?c=(\d*)' => 'addlink$1.html' 'misc\.php\?do=report&linkid=(\d+)&catid=(\d+)' => 'reportlink-$1-$2.html' 'showlink\.php\?ltitle=(.+)&do=showdetails&l=(\d+)&catid=(\d+)' => 'displaylink-$1-$2-c$3.html' 'showlink\.php\?ltitle=(.+)&do=showdetails&l=(\d+)' => 'displaylink-$1-$2.html' |
|
#23
| ||||
| ||||
| Quote:
Quote:
__________________ Oleg Ignatiuk / Crawlability Inc. vBSEO 3.2.0 Launched - Maximum Overdrive for Your Web Traffic! Over 100 Instant SEO Optimizations vBSEO Google Sitemap Generator - Version 2.2 Released Mandatory Upgrade for vBSEO 3.2.0 GOLD 6X Traffic - $1400 in One Day with vBSEO! Imagine What the vBSEO Patent Pending Technology Can Do For You. |
|
#24
| |||
| |||
|
Can I just remove "displaylink" entirely? Or do I still get the SEO advantage? Also, do you have an idea of what changes I'd have to make (i.e. experience with doing them) for the categories that is? Or would it require so much work that it's probably not even worth doing? And lastly, I have this module on the front page of my vbadvanced that displays the latest links put into the the links directory, but it still shows those links as dynamic urls and not the changes that have affected the links in the link directory? I did find a template for that particular module and did the find and replace for "do=showdetails" but that didn't seem to fix the problem. Again, thank you for all your help thus far. The other site I purchased vbseo for uses vbadvanced links directory as well, so I'll be able to use what you've taught me from this one and apply it to that site. Last edited by ChrisGuthrie.net; 04-16-2007 at 02:22 AM. |
|
#25
| ||||
| ||||
| Quote:
Quote:
Quote:
Code: http://www.gamingvidz.com/vidz/showlink.php?l=1071
__________________ Oleg Ignatiuk / Crawlability Inc. vBSEO 3.2.0 Launched - Maximum Overdrive for Your Web Traffic! Over 100 Instant SEO Optimizations vBSEO Google Sitemap Generator - Version 2.2 Released Mandatory Upgrade for vBSEO 3.2.0 GOLD 6X Traffic - $1400 in One Day with vBSEO! Imagine What the vBSEO Patent Pending Technology Can Do For You. |
|
#26
| |||
| |||
| Quote:
But I think you're right. I did have to upload a seperate php file called "hotlinks.php" to help get that module to work on the front page (It takes the newest 5 links in the video directory and displays them there). So does that mean I need to go into the php code and add that little string of code that I had to place in the links directory php files to get it to show up? |
|
#27
| ||||
| ||||
|
Yes, that is correct.
__________________ Oleg Ignatiuk / Crawlability Inc. vBSEO 3.2.0 Launched - Maximum Overdrive for Your Web Traffic! Over 100 Instant SEO Optimizations vBSEO Google Sitemap Generator - Version 2.2 Released Mandatory Upgrade for vBSEO 3.2.0 GOLD 6X Traffic - $1400 in One Day with vBSEO! Imagine What the vBSEO Patent Pending Technology Can Do For You. |
|
#28
| |||
| |||
|
Ok, if I can't find the right spot to place the code perhaps I could post it here?
|
|
#29
| ||||
| ||||
|
Yes.
__________________ Oleg Ignatiuk / Crawlability Inc. vBSEO 3.2.0 Launched - Maximum Overdrive for Your Web Traffic! Over 100 Instant SEO Optimizations vBSEO Google Sitemap Generator - Version 2.2 Released Mandatory Upgrade for vBSEO 3.2.0 GOLD 6X Traffic - $1400 in One Day with vBSEO! Imagine What the vBSEO Patent Pending Technology Can Do For You. |
|
#30
| |||
| |||
|
Ok, I had upgraded GamingVidz to the newest version of vBulletin and upgraded links directory at the same time... unfortunately now that means links directory is not vBSEO'd anymore. Do you think the steps I followed before will work the same for vB links directory 2.01? |