vRewrite - SEOed URLs for vBulletin

[DementedMindz]

that would be very very nice

[Immortal]

Yah, I believe he already has plans for something of that nature :)

[fabianv]

Ive checked over and over again man.. I cant find anything about memberlist problems exactly the same as mine...

what must I do?

[CrazyVLS]

Yes, i uploaded .htaccess and enable mod_rewrite, but it's still not working. Anyone can help me ?

[fabianv]

Ive checked over and over again man.. I cant find anything about memberlist problems exactly the same as mine...

what must I do?


Also, everything else on the right column on forumhome links to the wrong place :surprised:

[Immortal]

Yes, i uploaded .htaccess and enable mod_rewrite, but it's still not working. Anyone can help me ?

Make sure you changed the RewriteBase as described in the note :)

Also, everything else on the right column on forumhome links to the wrong place

The only fix is upgrading to 1.5, same with your other errors.

[DementedMindz]

wow this is nice i like it im starting to rewrite me arcade now im having a slight problem though ok this is what i did and it clean up most of it to .html at the end :) with the help of this post (https://vborg.vbsupport.ru/showpost.php?p=890580&postcount=368)

of i looked for this in my templates

<a href="arcade.php?do=play&gameid=$game[gameid]">

and i replaced it with this:

<a href="arcade/games/$game[gameid].html">

that worked very well it worked on the image part too where you can click the image to play the game... ok now for my part that im not to sure of or if it can be rewritten...



<a href="arcade.php?$session[sessionhash]do=play&gameid=$game[gameid]">

what could i rewrite that too? i only have a few more to rewrite and my arcade is flawless :)

[Immortal]

Sure.

<a href="arcade-session=$session[sessionhash]-do=play-gameid=$game[gameid].html">

And then add:

RewriteRule ^arcade-session=(.*)-do=(.*)-gameid=(.*).html arcade.php$1&do=$2&gameid=$3 [L]

[DementedMindz]

man your the man lol i have a few more i can show you if im not bothering you to much :) and maybe it will help others out too.. let me do them first im happy as h3ll

[Immortal]

Sure, not a problem. I don't mind helping people as long as I haven't repeated it more then a hundred times in the same thread :)

[Bhuwan]

RC2 will be delayed by tomorrow morning, as I want to fix a bug that Tyler (Immortal) mentioned to me and some various "cosmetic" errors Jlaine reported.
Fruthermore, I am going for ice cream so i wont get started on fixes until later tonight :)!

By the way, everyone should thank Jlaine , as Jlaine reported MANY bugs/fixes to Tyler and myself. Furthermore, Jlaine risked running this hack on their LIVE board (which is very big) which helped us dramatically!

Many people have helped throughout the development of this hack but I personally want to thank Jlaine for their time

[DementedMindz]

Jlaine thank you for helpin...

the one that im tryin to find right now im not to sure of :confused: i wanted to do it for the categorys this way they were rewritten here is the page it brings you too /arcade.php?categoryid=-1 also on the main arcade page i wanted to do it for when you click high score it would bring you to a page like this /arcade.php?do=scores&gameid=100

[Immortal]

I'll try and come up with somethin' shortly :)

* Immortal needs to finish this thing first

Sorry. :(

[DementedMindz]

hey thats no problem you helped me out alot thanks so much... this just keeps getting better and better

another one i found


<a href="$vboptions[bburl]/arcade.php?$session[sessionurl]do=lboard">[ $vbphrase[leader_board] ]</a>

[DementedMindz]

I run this great on vBgallery 1.01 (http://www.PlanetSRK.com/forums/gallery)

here is the headinclude code you need to use:

<if condition="THIS_SCRIPT != 'index' AND THIS_SCRIPT != 'gallery_index' AND THIS_SCRIPT != 'gallery_upload' AND THIS_SCRIPT != 'showimage' AND THIS_SCRIPT != 'gallery_search' AND THIS_SCRIPT != 'gallery_newreply' AND THIS_SCRIPT != 'gallery_moderate' AND THIS_SCRIPT != 'gallery_misc' AND THIS_SCRIPT != 'gallery_managecats' AND THIS_SCRIPT != 'editimage' AND THIS_SCRIPT != 'ecard' AND THIS_SCRIPT != 'displayimages' AND THIS_SCRIPT != 'browseimages'">
<base href="$vboptions[bburl]/" />
</if>



will this work with PhotoPost vBGallery v1.0.2 also where does this code excatly go?

[CrazyVLS]

Make sure you changed the RewriteBase as described in the note :)



This is my RewriteBase in .htaccess :
RewriteEngine On
RewriteBase /
RewriteRule ^(.*)/t-(.*)-(.*)/go=(.*) showthread.php?t=$3&goto=$4&is_vrewrite=yes[L]
RewriteRule ^(.*)/p-(.*)-(.*).html showthread.php?p=$3&is_vrewrite=yes[L]
RewriteRule ^f-(.*)-(.*)-page(.*).html forumdisplay.php?f=$2&page=$3&order=desc&is_vrewrite=yes [L]
RewriteRule ^f-(.*)-(.*).html/page(.*)daysprune(.*)-order(.*)-sort(.*) forumdisplay.php?f=$2&page=$3daysprune=$4&order=$5&sort=$6&is_vrewrite=yes [L]
RewriteRule ^f-(.*)-(.*).html/daysprune(.*)-order(.*)-sort(.*) forumdisplay.php?f=$2&daysprune=$3&order=$4&sort=$5&is_vrewrite=yes [L]
RewriteRule ^f-(.*)-(.*).html forumdisplay.php?f=$2&is_vrewrite=yes [L]
RewriteRule ^u-(.*)-(.*).html member.php?u=$2&is_vrewrite=yes [L]
RewriteRule ^(.*)-(.*)-newpost.html showthread.php?goto=newpost&t=$2 [L]
RewriteRule ^(.*)/t-(.*)-(.*)-page(.*).html showthread.php?t=$3&page=$4&is_vrewrite=yes [L]
RewriteRule ^(.*)/t-(.*)-(.*).html showthread.php?t=$3&is_vrewrite=yes [L]
RewriteRule ^markread.html forumdisplay.php?do=markread [L]
RewriteRule ^(.*)/p-(.*)-(.*).html#(.*) showthread.php?p=$3#post$4 [L]
RewriteRule ^print-(.*)-(.*).html printthread.php?t=$2 [L]
RewriteRule ^sendtofriend-(.*)-(.*).html sendmessage.php?do=sendtofriend&t=$2 [L]
RewriteRule ^search-(.*).html search.php?do=$1 [L]
RewriteRule ^(.*)-(.*)/newthread.php newthread.php?do=newthread&f=$2[L]
RewriteRule ^(.*)/newpostnoquote-(.*).php newreply.php?do=newreply&noquote=1&p=$2[L]
RewriteRule ^(.*)/newpost-(.*).php newreply.php?do=newreply&p=$2[L]
RewriteRule ^p-(.*).html showpost.php?p=$1&postcount=$1 [L]

Whats wrong ? Please help me to fix that :
http://www.angelsbabe.net/rewrite/asian-pictures/t-maiko-kazano-fmm-scan-pics-87.html
Not Found
The requested URL /rewrite/asian-pictures/t-maiko-kazano-fmm-scan-pics-87.html was not found on this server.

Apache/1.3.33 Server at www.angelsbabe.net Port 80

Still not working !

[Immortal]

will this work with PhotoPost vBGallery v1.0.2 also where does this code excatly go?

You would want to use that in headerinclude. I'll work on your v3 code tomorrow :)

This is my RewriteBase in .htaccess :

And did you read install.html or searched the thread as I told you to?

Note: If you run your vB on a directory from a subdomain or root ex: http:///www.yoursite.com/forum or http://subdomain.site.com/forum you will need to open up the .htacess file and change Rewrite Base / to Rewrite Base /yourdir

[jdingman]

It this problem related to vRewrite at all?

Database error in vBulletin 3.5.4:

Invalid SQL:
SELECT threadid, title FROM vb_thread WHERE visible = 1 AND lastpost <

I'm getting that error on my site sometimes now...

Additionally, when I go to a page that doesn't actually exist and it returns a 'no thread specified', how can I make that error page return a 404 so search engines know it doesn't exist anymore?

[DementedMindz]

Immortal thanks again im going to look in there in a min... im still doing other links basiclly that i can figure out :)

[Immortal]

It this problem related to vRewrite at all?



I'm getting that error on my site sometimes now...

Hm, first I heard of it. What happens if you disable it, do you still get the error?

Immortal thanks again im going to look in there in a min... im still doing other links basiclly that i can figure out

No problem. Just poke me tomorrow if I don't get it by then :)

[jdingman]

weird, I disabled it and now I get this:

No Thread specified. If you followed a valid link, please notify the administrator

That's really weird...did someone possibly create a thread, then delete it?

the lastpost stuff still gives random output threads instead of the actual lastpost (using 1.0)

[Immortal]

You shouldn't be getting that error, it may have been merged etc.

Yah, the only fix for that is to upgrade to 1.5.

[Danecookie]

i think we shall wait for the next version? with it all errors will be gone?

i am just waiting for it ..

[jdingman]

You shouldn't be getting that error, it may have been merged etc.

Yah, the only fix for that is to upgrade to 1.5.

It definitely wasn't merged because I didn't merge it and I'm the only one with access ;) When will 1.5 RC2 be out?

[Roms]

I'll try it out, Thanks! :)

[CrazyVLS]

You would want to use that in headerinclude. I'll work on your v3 code tomorrow :)



And did you read install.html or searched the thread as I told you to?
yes, i already chanche RewriteBase to /forum and /var/www/forum, but both still not working. Any more ideas to fix that ... Help me !

[VTXCafe.com]

I installed and have this problem, when the link is clicked I get this:

It has an F-and then the url. But nothing shows, I have edited the Rewrite Base but what do I put there? forum.php? Index.php?

Sorry, it was just not clear to me.

Here is what I have now:
.

[DementedMindz]

ok here is another arcade one :)


<phrase 1="arcade.php?$session[sessionurl]do=play&amp;gameid=$newgameid" 2="$newgame">$vbphrase[arcade_newgame]</phrase>


<a href="arcade.php?do=scores&amp;gameid=$game[gameid]">$game[highscore]</a>

[Immortal]

For those who are getting not found errors, and you are 100% sure mod_rewrite is enabled, post your full .htaccess with a forum link.

DementedMindz: Can you get a full list of everything you need, and I'll do it now, for me? :)

[Princeton]

I haven't installed this (I've only tested on sites that you have listed above) ... so I apologize if it can be done.

There have been a few SEO addons lately but most fail in this category:
I'll explain by giving you examples.

On one of the sites that I tested ...
domain.com/announcements-and-feedback/t-links-and-directory-669.html
the link above works great; but, if I was to shorten the link (copy/paste error) to
domain.com/announcements-and-feedback
it would fail.

If you could get these issues fixed this would be a great product. :up:

[Immortal]

I believe in 2.0 (the next major release), you will have the option to control how you wish for the URLs to look. But now, the title of forums/threads/usernames are useless, they are there only for SEO purpose, vRewrite still grabs the info using the id. :)

[DementedMindz]

i have to run out for a bit ill be back in a few hours...i have most of the arcade fully done im just missing a few... here are a couple now while i think of it.... one that im not sure of is the categories that would be a nice one i just have to see what the code is for it.. here are a few links i found really quick before i went out... these may hold to key to the categories hopefully and the scores...

this is for categories (i hope):

<a style="text-decoration:none" href="arcade.php?categoryid=$id">

<a href="arcade.php?barsize=1<if condition="$categoryid">


these are im hoping forthe other part of the high score:

<a href="member.php?$session[sessionurl]u=$game[highscorerid]" target="_blank">

<a href="arcade.php?do=scores&gameid=$game[gameid]">

<a href="arcade.php?do=play&gameid=$newgame[gameid]">



here is for the leader board: this would be a good one...

<a href="$vboptions[bburl]/arcade.php?$session[sessionurl]do=lboard">


this is for challenges:

<a href="arcade.php?do=play&gameid=$challenge[gameid]">

<a href="arcade.php?do=play&challengeid=$challenge[challengeid]">

<a href="arcade.php?do=declinechallenge&challengeid=$challenge[challengeid]">

<a href="arcade.php?do=play&challengeid=$challenge[challengeid]">

this is for awards:

<a href="arcade.php?do=scores&gameid=$award[gameid]">


thanks again for all your help... another one i would like to do if you get free time is the ecdownloads :cool: thanks again

[Bhuwan]

I haven't installed this (I've only tested on sites that you have listed above) ... so I apologize if it can be done.

There have been a few SEO addons lately but most fail in this category:
I'll explain by giving you examples.

On one of the sites that I tested ...
domain.com/announcements-and-feedback/t-links-and-directory-669.html
the link above works great; but, if I was to shorten the link (copy/paste error) to
domain.com/announcements-and-feedback
it would fail.

If you could get these issues fixed this would be a great product. :up:

I dont know how you'd grab the forum information without an id;
if you can suggest a method, maybe I will implement it for 2.0 :)

[Bhuwan]

For those waiting for RC2, be patient -- Tyler myself and Jlaine are trying to work out on the bugs -- I dont want to give any time frame but it is very very close :-).

[Immortal]

<a style="text-decoration:none" href="arcade.php?categoryid=$id">

Becomes:

<a style="text-decoration:none" href="arcade-categoryid=$id.html">

RewriteRule ^arcade-categoryid=(.*).html arcade.php?categoryid=$1 [L]

<a href="arcade.php?barsize=1<if condition="$categoryid">

I am not actually too sure on that one, hmm, sorry.

<a href="member.php?$session[sessionurl]u=$game[highscorerid]" target="_blank">

Becomes:

<a href="member-$session[sessionurl]-u=$game[highscorerid].html" target="_blank">

RewriteRule ^member-(.*)-u=(.*).html member.php?$1u=$game$2 [L]

<a href="arcade.php?do=scores&gameid=$game[gameid]">

Becomes:

<a href="arcade-do=scores-gameid=$game[gameid].html">

RewriteRule ^arcade-do=(.*)-gameid=(.*).html arcade.php?do=$1&gameid=$2 [L]

<a href="arcade.php?do=play&gameid=$newgame[gameid]">

Becomes:

<a href="arcade-do=play-gameid=$newgame[gameid].html">

RewriteRule ^arcade-do=(.*)-gameid=(.*).html arcade.php?do=$1&gameid=$2 [L]


That's all I have time for now, I'll try to finish shortly :)

[El_Muerte]

don't know if this has been reported already, but vRewrite doesn't work when the style sheets are written to files

[DementedMindz]

ok time to try these out and see lol ill let you know shortly :) thanks for all your help

[DementedMindz]

this is great i have like 3 or 4 more links to go and its set my v3 arcade will be fully rewritten... thanks so much for everything

[DementedMindz]

so far i see 3 left i didnt check on the challenges but other then that its done

ok this one is for the newest game one.. it has this in the install this is the code

<phrase 1="arcade.php?$session[sessionurl]do=play&amp;gameid=$newgameid" 2="$newgame">$vbphrase[arcade_newgame]</phrase>

and this is the phrase that fits to that just so it gives you a better idea...

<a href="{1}">{2}</a>


and i still needed this for the leader board

<a href="$vboptions[bburl]/arcade.php?$session[sessionurl]do=lboard">

and i think this one would fix the categories for the arcade

<a href="arcade.php?categoryid=$game[categoryid]">

[jdingman]

I believe in 2.0 (the next major release), you will have the option to control how you wish for the URLs to look. But now, the title of forums/threads/usernames are useless, they are there only for SEO purpose, vRewrite still grabs the info using the id. :)

So we should expect a 1.5 RCx or FINAL in the next week or so?

[DementedMindz]

i take it you dont read... they just posted about it...

For those waiting for RC2, be patient -- Tyler myself and Jlaine are trying to work out on the bugs -- I dont want to give any time frame but it is very very close :-).

[jdingman]

I did, I had just missed that part.

[Bhuwan]

So we should expect a 1.5 RCx or FINAL in the next week or so?Very soon :-).
Sit back, relax, grab a Coke (or Pepsi) or beer.
:banana: :banana: :banana: :banana:
HAND UP...THIS IS A HOLDUP:cool:

[jdingman]

awesome, that's what I like to hear. I'll keep an eye out for it :)

[Immortal]

DementedMindz: I haven't forgotten about you! Just takes some time, very sorry :(

But on a lighter note, vRewrite 1.5 RC2 is now released. DO NOT report vRewrite RC1 bugs, because, honestly we don't care. Make sure you are running the most up to date vRewrite, and then report the bugs you find :)

Same links as before:

http://www.techhelpforum.com/vrewrite/vRewrite_15_beta.zip

And the bug tracker:

http://www.techhelpforum.com/vrewrite/

Thanks to everyone, but especially Bhuwan and jlaine :)

[jdingman]

Looks like that fixed most or all of the problems I was having. Great release, thanks!!!!

One last question though, how easily would a sitemap plugin interact with these SEF links so that a proper sitemap could be created instead of giving the regular showthread.php? links?

EDIT: I seem to be getting an error on one of my 'lastpost' links too..

Database error in vBulletin 3.5.4:

Invalid SQL:

SELECT postid AS postid, post.dateline, t.title as threadtitle, f.title as forumtitle, f.forumid as forumid
FROM post AS vb_post JOIN vb_thread AS t ON(t.threadid=post.threadid) JOIN vb_forum as f ON(f.forumid=t.forumid)
WHERE post.threadid = 165 AND post.visible = 1 AND
postid = (
SELECT MAX(t2.postid) AS postid
FROM vb_post AS t2
WHERE t2.threadid = 165 AND t2.visible = 1
)
LIMIT 1;

MySQL Error : Table 'forums_vb.post' doesn't exist
Error Number : 1146
Date : Sunday, April 2nd 2006 @ 03:33:32 PM
Script : http://forums.site.net/page-###.html
Referrer : http://forums.site.net/
IP Address : X.X.X.X
Username : Jonathan
Classname : vB_Database

As I'm looking at my database, the table vb_posts most certainly DOES exist.

[xStylezx]

I searched the thread and didnt notice what im looking for.On the forumhome my link to a forum shows as

http://www.somesite.com/f-main-forum-2.html/

and a link to a thread shows as

http://www.somesite.com/main-forum/t-just-a-test-1.html

What would i have to modify to get rid of the .html and have it show as its doing in the link to a thread?Ive tried searching the xml for what i thought was the right code and then editing htaccess but no luck.Also,im curious as to why links are rewritten like this by default?Thanks for the help :)

[Immortal]

We will be playing with something shortly ;)

But, in the mean time it is safe as it redirects to the proper URL.

[Immortal]

.html means static URLs most of the time, so it makes sense to add .html. This will not be a feature, until 2.0. The only way is to do it manually through the XML and .htaccess. I posted a tutorial on custom links AWHILE ago, so you'll have to search for it.

Edit: I lied, in 1.5 it's a feature. In vB Options->vRewrite.

[Bhuwan]

I searched the thread and didnt notice what im looking for.On the forumhome my link to a forum shows as

http://www.somesite.com/f-main-forum-2.html/

and a link to a thread shows as

http://www.somesite.com/main-forum/t-just-a-test-1.html

What would i have to modify to get rid of the .html and have it show as its doing in the link to a thread?Ive tried searching the xml for what i thought was the right code and then editing htaccess but no luck.Also,im curious as to why links are rewritten like this by default?Thanks for the help :)

Silly me -- I forgot to mention, thi sis now possible --
go to admincp->vbulletin options->vRewrite
there you can change .html to be blank and it wont write HTML.

you still have to edit .htaccess manually.

[xStylezx]

Yes,but wouldnt that also disable .html for the links to the actual threads?I was looking for a way to keep the .html in the thread links but have the .html removed from the forum links,if i wasnt really confusing.haha

[xStylezx]

I just visited the http://www.techhelpforum.com/
and noticed that on forumhome all links to the forums are without a trailing slash,such as

http://www.techhelpforum.com/f-site-rules-17.html

but mine have a trailing slash on the end,such as

http://www.somesite.com/f-main-forum-2.html/

Why arent mine formatted like that?Ive updated to the RC2 and its the same behavior.I would either like to get rid of the trailing slash or get rid of the .html and leave the slash.Thanks for any help and also great mod

[Immortal]

Mine are:
http://www.techhelpforum.com/f-site-rules-17.html/

The trailing slash is needed and cannot be removed.

[hbalagh1]

i instaleld and thought everything was working good, till i had a user tell me the last post links were not going to the correct post :(

[Bhuwan]

i instaleld and thought everything was working good, till i had a user tell me the last post links were not going to the correct post :(

Pls provide more info :)

[hbalagh1]

well i have disabled it will reload it when traffic is slow on my forum so i can tell you

[xStylezx]

Mine are:
http://www.techhelpforum.com/f-site-rules-17.html/

The trailing slash is needed and cannot be removed.

Hmmm,and google has no problem with a .html and a slash following it?Just seems a bit messy looking and made me worry when i seen that.

[Immortal]

Why would they? .html is considered static content...the / is just a must, and will/cannot be changed.

[Bhuwan]

Hmmm,and google has no problem with a .html and a slash following it?Just seems a bit messy looking and made me worry when i seen that.
Here's teh logic behind the "/":
http://www.techhelpforum.com/f-windows-9598me-12.html/

Right below where it says: "Threads in Forum : Windows 95/98/ME"
you see several links... (thread, thread starter, Rating, Last Post, Replies, Views).......

In order for these links to work properly, the "/" must be located after the forum details..

Hope this helps...

[xStylezx]

Well when you check a link to a thread the .html isnt there,but its there when you check a link to an actual forum,ive just never seen it done like that i guess and i hope we can eventually customize it or hack around it somehow,such as getting rid of the .html and leaving the trailing slash,that i would be ok with,and is i believe default of vbseo rewriting.

[Bhuwan]

Well when you check a link to a thread the .html isnt there,but its there when you check a link to an actual forum,ive just never seen it done like that i guess and i hope we can eventually customize it or hack around it somehow,such as getting rid of the .html and leaving the trailing slash,that i would be ok with,and is i believe default of vbseo rewriting.
buddy, check out the options
vBulletin admincp -> vBulletin Options-> vRewrite options
you have the ability to remove the .html !!:)

[xStylezx]

Yes,but as i mentioned before that also removes it from the thread links.I just want it removed from the forum links themselves.I like the threads having the static links,but would prefer my forum links to have a directory look without an extension.Or the extension of .html would be fine without the trailing slash.Since we cant get rid of the slash though,id like to get rid of the .html without losing the one in the thread links.Hope ive been a bit clearer:)

[DementedMindz]

Yes,but as i mentioned before that also removes it from the thread links.I just want it removed from the forum links themselves.I like the threads having the static links,but would prefer my forum links to have a directory look without an extension.Or the extension of .html would be fine without the trailing slash.Since we cant get rid of the slash though,id like to get rid of the .html without losing the one in the thread links.Hope ive been a bit clearer:)

personally i think if thats what you want to do then this aint for you... why wouldnt you want your linked seoed? thas what gets me :surprised:

[phkk]

I need some advise for ISS server.I need some advise for ISS server.I need some advise for ISS server.I need some advise for ISS server.I need some advise for ISS server.I need some advise for ISS server.I need some advise for ISS server.I need some advise for ISS server.I need some advise for ISS server.I need some advise for ISS server.I need some advise for ISS server.I need some advise for ISS server.

THANKS

[jj]

I need some advise for ISS server.I need some advise for ISS server.I need some advise for ISS server.I need some advise for ISS server.I need some advise for ISS server.I need some advise for ISS server.I need some advise for ISS server.I need some advise for ISS server.I need some advise for ISS server.I need some advise for ISS server.I need some advise for ISS server.I need some advise for ISS server.


THANKS

You mean IIS Server? From M$? Forget it :) There's no .htaccess feature, which is needed by this one...

[jdingman]

So does anyone know why I'm getting this database error? I disable vRewrite and it works fine, enable it and my site breaks for 'lastpost' button.

Database error in vBulletin 3.5.4:

Invalid SQL:

SELECT postid AS postid, post.dateline, t.title as threadtitle, f.title as forumtitle, f.forumid as forumid
FROM post AS vb_post JOIN vb_thread AS t ON(t.threadid=post.threadid) JOIN vb_forum as f ON(f.forumid=t.forumid)
WHERE post.threadid = 166 AND post.visible = 1 AND
postid = (
SELECT MAX(t2.postid) AS postid
e FROM vb_post AS t2
WHERE t2.threadid = 166 AND t2.visible = 1
)
LIMIT 1;

MySQL Error : Table 'forums_vb.post' doesn't exist
Error Number : 1146
Date : Sunday, April 2nd 2006 @ 06:00:33 PM
Script : http://forums.site.net/introductions/t-test-166-last.html
Referrer : http://forums.site.net/
IP Address : X.X.X.X
Username : Jonathan
Classname : vB_Database

I'm getting the same error when using the "NEW" post link.

[Bhuwan]

So does anyone know why I'm getting this database error? I disable vRewrite and it works fine, enable it and my site breaks for 'lastpost' button.

Database error in vBulletin 3.5.4:

Invalid SQL:

SELECT postid AS postid, post.dateline, t.title as threadtitle, f.title as forumtitle, f.forumid as forumid
FROM post AS vb_post JOIN vb_thread AS t ON(t.threadid=post.threadid) JOIN vb_forum as f ON(f.forumid=t.forumid)
WHERE post.threadid = 166 AND post.visible = 1 AND
postid = (
SELECT MAX(t2.postid) AS postid
e FROM vb_post AS t2
WHERE t2.threadid = 166 AND t2.visible = 1
&nbsp;)
LIMIT 1;

MySQL Error : Table 'forums_vb.post' doesn't exist
Error Number : 1146
Date : Sunday, April 2nd 2006 @ 06:00:33 PM
Script : http://forums.site.net/introductions/t-test-166-last.html
Referrer : http://forums.site.net/
IP Address : X.X.X.X
Username : Jonathan
Classname : vB_Database

I'm getting the same error when using the "NEW" post link.



Are you naming your tables with a prefix?

[Bhuwan]

So does anyone know why I'm getting this database error? I disable vRewrite and it works fine, enable it and my site breaks for 'lastpost' button.

Database error in vBulletin 3.5.4:

Invalid SQL:

SELECT postid AS postid, post.dateline, t.title as threadtitle, f.title as forumtitle, f.forumid as forumid
FROM post AS vb_post JOIN vb_thread AS t ON(t.threadid=post.threadid) JOIN vb_forum as f ON(f.forumid=t.forumid)
WHERE post.threadid = 166 AND post.visible = 1 AND
postid = (
SELECT MAX(t2.postid) AS postid
e FROM vb_post AS t2
WHERE t2.threadid = 166 AND t2.visible = 1
&nbsp;)
LIMIT 1;

MySQL Error : Table 'forums_vb.post' doesn't exist
Error Number : 1146
Date : Sunday, April 2nd 2006 @ 06:00:33 PM
Script : http://forums.site.net/introductions/t-test-166-last.html
Referrer : http://forums.site.net/
IP Address : X.X.X.X
Username : Jonathan
Classname : vB_Database

I'm getting the same error when using the "NEW" post link.
I see the problem. ignore my last post.

[jdingman]

Is it a problem on my end or in the plugin?

[Bhuwan]

Is it a problem on my end or in the plugin?
Give me two minutes, i'm posting the fix as we speak
Error is on my part :)

[jdingman]

Awesome, thanks bhuwan!!!

[Bhuwan]

Until tyler can update the zip file ....

Here is how to fix the problem..
edit XML file DIRECTLY _OR_ edit the hook titled global_start

Search for:

FROM post AS " . TABLE_PREFIX . "post JOIN " . TABLE_PREFIX . "thread AS t ON(t.threadid=post.threadid) JOIN " . TABLE_PREFIX . "forum as f ON(f.forumid=t.forumid)


Replace it with

FROM " . TABLE_PREFIX . "post AS post JOIN " . TABLE_PREFIX . "thread AS t ON(t.threadid=post.threadid) JOIN " . TABLE_PREFIX . "forum as f ON(f.forumid=t.forumid)

[jdingman]

that worked like a charm, thanks again!!

[Bhuwan]

that worked like a charm, thanks again!!Glad it works! Let me know if everything else works good! :)

[xStylezx]

personally i think if thats what you want to do then this aint for you... why wouldnt you want your linked seoed? thas what gets me :surprised:

you must be completely misunderstanding me because i find the way im speaking of to be more efficient SEO wise as you eliminate those extra letters (.html)from the url.as to my understanding with that forward slash on the end of the .html wouldnt Spiders/Bots just treat the link more of a like a directory/hierarchy type url instead of an actual .html url such as the threads(because the threads dont have the trailing slash).I just think the .html is a waste in the url once you get rid of the "forumdisplay.phpf?f=" and add the forums name in the url,and throw the forward slash behind that,you got a clean perfectly spiderable url.With the trailing forward slash i just am failing to see the need to put .html prior to that.Im not trying to butt heads or anything,just explaining where im coming from.

Take a look at this url from a phpbb board of mine that is pretty SEO friendly.

http://seorecruit.com/archived-topics-vf16.htm

If you go to the seorecruit.com forum home you will see that all the links to my forums are in a .htm format with no trailing forward slash.Now,i understand if there is a need to have the forward slash,but if so then why not just omit the .html.I know its possible as the new RC2 has the option of getting rid of the .html,but this also eliminates it in the thread urls,where id prefer to have it.

[moftary]

I have to agree with xStylezx. From SEO and WWW standards points of view, links should be /forum_name/ and /forum_name/thread.htm

I would consider this as a "feature request" :)

[Bhuwan]

you must be completely misunderstanding me because i find the way im speaking of to be more efficient SEO wise as you eliminate those extra letters (.html)from the url.as to my understanding with that forward slash on the end of the .html wouldnt Spiders/Bots just treat the link more of a like a directory/hierarchy type url instead of an actual .html url such as the threads(because the threads dont have the trailing slash).I just think the .html is a waste in the url once you get rid of the "forumdisplay.phpf?f=" and add the forums name in the url,and throw the forward slash behind that,you got a clean perfectly spiderable url.With the trailing forward slash i just am failing to see the need to put .html prior to that.Im not trying to butt heads or anything,just explaining where im coming from.

Take a look at this url from a phpbb board of mine that is pretty SEO friendly.

http://seorecruit.com/archived-topics-vf16.htm

If you go to the seorecruit.com forum home you will see that all the links to my forums are in a .htm format with no trailing forward slash.Now,i understand if there is a need to have the forward slash,but if so then why not just omit the .html.I know its possible as the new RC2 has the option of getting rid of the .html,but this also eliminates it in the thread urls,where id prefer to have it.

So i n short, your looking for the option of having different extensions for each option (showthread, member, forumdispaly, printthread, showpost) as opposed to having a universal option that covers everything?

[xStylezx]

I have to agree with xStylezx. From SEO and WWW standards points of view, links should be /forum_name/ and /forum_name/thread.htm

I would consider this as a "feature request" :)

awesome,thats exactly what i was talking about :D

[xStylezx]

So i n short, your looking for the option of having different extensions for each option (showthread, member, forumdispaly, printthread, showpost) as opposed to having a universal option that covers everything?

Well that would work.Im really just looking to make the url like this

/forum-name/

instead of

/f-forum-name.html/

or this way would be acceptable too

/f-forum-name.html

As far as the thread urls,i think they are rewritten perfectly.I would just like to be able to configure how forum urls are rewritten,or in the least if i can figure out how to hack it for what im lookin for

[derekivey]

Thanks Tyler & Bhuwan! I think I'm going to install this on my live site now.

Derek

[moftary]

1) example on 302 (too lazy to google)
2) difference between 301 vs 302
3) why isnt what is iad duplicate
4) example of duplicate

thx for your help!( I am not a SEO expert )

1) too lazy to answer :p
2) 301 is "moved permanently" and 302 is "moved temporarily"
3) Duplication penalties occure when the very same page appears for more than one URL that is linked.
4) http://www.techhelpforum.com/windows-xp/t-problems-after-reformating-and-reinstalling-windows-3059.html and http://www.techhelpforum.com/windows-xp/t-bluhbluh-3059.html

[Bhuwan]

Well that would work.Im really just looking to make the url like this

/forum-name/

instead of

/f-forum-name.html/

or this way would be acceptable too

/f-forum-name.html

Here's the best I can do for 1.5

/f-FORUM-NAME-HERE-ID{EXTENSION HERE}

The end-user can choose {EXTENSION HERE} to be anything they want (.html, .htm, blank, etc.)

The 'id' and 'f' are req'd and can't be changed for 1.5 (too much work involved).

Furthermore, vRewrite displays data based on the ID - once I figure out how to omit the ID without any problems, I will certainly add this as a feature (2.0).

Hope this is a good enough comprimise...

[Bhuwan]

1) too lazy to answer :p
2) 301 is "moved permanently" and 302 is "moved temporarily"
3) Duplication penalties occure when the very same page appears for more than one URL that is linked.
4) http://www.techhelpforum.com/windows-xp/t-problems-after-reformating-and-reinstalling-windows-3059.html and http://www.techhelpforum.com/windows-xp/t-bluhbluh-3059.html
thx!

[xStylezx]

Here's the best I can do for 1.5

/f-FORUM-NAME-HERE-ID{EXTENSION HERE}

The end-user can choose {EXTENSION HERE} to be anything they want (.html, .htm, blank, etc.)

The 'id' and 'f' are req'd and can't be changed for 1.5 (too much work involved).

Furthermore, vRewrite displays data based on the ID - once I figure out how to omit the ID without any problems, I will certainly add this as a feature (2.0).

Hope this is a good enough comprimise...

Sounds good,as long as you can get rid of the trailing slash after the extension,and that is exactly what im looking for if that can be done

[Immortal]

Until tyler can update the zip file ....

Here is how to fix the problem..
edit XML file DIRECTLY _OR_ edit the hook titled global_start

Search for:

FROM post AS " . TABLE_PREFIX . "post JOIN " . TABLE_PREFIX . "thread AS t ON(t.threadid=post.threadid) JOIN " . TABLE_PREFIX . "forum as f ON(f.forumid=t.forumid)


Replace it with

FROM " . TABLE_PREFIX . "post AS post JOIN " . TABLE_PREFIX . "thread AS t ON(t.threadid=post.threadid) JOIN " . TABLE_PREFIX . "forum as f ON(f.forumid=t.forumid)



Updated ZIP to reflect those changes. :)

[Immortal]

Sounds good,as long as you can get rid of the trailing slash after the extension

Not possible ;)

[Bhuwan]

Not possible ;)Tyler is right, i forgot to add the trailing slash in my exammple...sorry...it has to stay, go back a few pots to see why ( I posted my reasoning)

[moftary]

So i n short, your looking for the option of having different extensions for each option (showthread, member, forumdispaly, printthread, showpost) as opposed to having a universal option that covers everything?

Exactly. I would also appreciate a .htaccess update from DC-SEO to vRewrite.
I have some ideas for the authors about adding more SEO power to the mod..

1) Generates structured archives based on date/forum; i.e, forum -> years 1,2,.. -> months 1,2,3,..,12 -> days 1,2,3,...,30-31.

2) Place a link on each forum pointing to its archive (automatical link from /forum_name/ to /archives/archived_forum.html)

3) Place a link back from each archive thread posting to the original thread (/forum_name/thread.html).

[xStylezx]

Hmmmm,ok.So if i use this hack now and then you rewrite this later on to where what i want is possible(more customization),will you also redirect any of the changed urls so there wont be any penalties?I still want to use the hack,but later when it became possible id like to change the urls to what im describing and wouldnt want to be penalized or anything.

[Bhuwan]

Thanks Tyler & Bhuwan! I think I'm going to install this on my live site now.

Derek
How is it working out?

[Bhuwan]

hello,

its perfect to merge vRewrite with vBSEO Google/Yahoo Sitemap Generator

its difficult?

its been done ;) :banana:

[jdingman]

how come that when I go to a page like this, http://forums.site.net/member.php?u=41, it doesn't redirect me to the rewritten page? It just stays normal at the u=41 page. The same happens with a thread, when going to t=###, it stays there and doesn't redirect. I thought it was supposed to 301 to the rewritten page automatically?

[MamboCube]

i seem to have a problem, whenever i click on a username to go to their profile, the url gets rewritten like this

u-username-2.html8

(username being a members username)

this is for member 28, but the 8 goes to the end taking me to member 2

i tried to take off the .html at the end but could not find it in the vboptions

anyone had this problem?

if so how do i fix it?

thnx great mod!

[xStylezx]

i seem to have a problem, whenever i click on a username to go to their profile, the url gets rewritten like this

u-username-2.html8

(username being a members username)

this is for member 28, but the 8 goes to the end taking me to member 2

i tried to take off the .html at the end but could not find it in the vboptions

anyone had this problem?

if so how do i fix it?

thnx great mod!


http://www.techhelpforum.com/vrewrite/

For bug reporting.Did you search the thread?I thought possibly i seen someone with a problem similar to yours when i was reading through it earlier

[forte]

I've tried both of the Sitemap generators for vBSEO but they won't seem to work with vRewrite so I was wondering if you guys are going to make one.

[Bhuwan]

i seem to have a problem, whenever i click on a username to go to their profile, the url gets rewritten like this

u-username-2.html8

(username being a members username)

this is for member 28, but the 8 goes to the end taking me to member 2

i tried to take off the .html at the end but could not find it in the vboptions

anyone had this problem?

if so how do i fix it?

thnx great mod!
you've downloaded and used the wrong zip file - the zip file is located on Tyler's website, go back a few posts to see the actual link.

[Bhuwan]

I've tried both of the Sitemap generators for vBSEO but they won't seem to work with vRewrite so I was wondering if you guys are going to make one.I ported vBSEO sitemap Generator to work with vRewrite, however, out of respect for Juan and his team, I won't release it unless they are okay with it... But it is working...

[Bhuwan]

how come that when I go to a page like this, http://forums.site.net/member.php?u=41, it doesn't redirect me to the rewritten page? It just stays normal at the u=41 page. The same happens with a thread, when going to t=###, it stays there and doesn't redirect. I thought it was supposed to 301 to the rewritten page automatically?
They are rewritten automatically -- please provide more details so we can debug.

Here are some likes that are automatically 301'd:
http://www.techhelpforum.com/forumdisplay.php?f=11
http://www.techhelpforum.com/member.php?u=1
http://www.techhelpforum.com/showthread.php?t=10

[DementedMindz]

ok question for vba gallery we add this to headerinclude:

but where do we add it?

<if condition="THIS_SCRIPT != 'index' AND THIS_SCRIPT != 'gallery_index' AND THIS_SCRIPT != 'gallery_upload' AND THIS_SCRIPT != 'showimage' AND THIS_SCRIPT != 'gallery_search' AND THIS_SCRIPT != 'gallery_newreply' AND THIS_SCRIPT != 'gallery_moderate' AND THIS_SCRIPT != 'gallery_misc' AND THIS_SCRIPT != 'gallery_managecats' AND THIS_SCRIPT != 'editimage' AND THIS_SCRIPT != 'ecard' AND THIS_SCRIPT != 'displayimages' AND THIS_SCRIPT != 'browseimages'">
<base href="$vboptions[bburl]/" />
</if>

[jdingman]

They are rewritten automatically -- please provide more details so we can debug.

Here are some likes that are automatically 301'd:
http://www.techhelpforum.com/forumdisplay.php?f=11
http://www.techhelpforum.com/member.php?u=1
http://www.techhelpforum.com/showthread.php?t=10


Yeah, that's how it should work, but it's not for me. I'm on PHP5.1.2 and MySQL4.x on a CentOS system. Not sure what else I can provide to help debug the problem =/

[DementedMindz]

im on basiclly the same setup and mine is working fine... im rewritten alot of things here lol

[AWS]

You mean IIS Server? From M$? Forget it :) There's no .htaccess feature, which is needed by this one...
Yes there is.
http://helicontech.com
You just have to replace ^ with / at the beginning of each rule after you install isapi rewrite.

[MamboCube]

you've downloaded and used the wrong zip file - the zip file is located on Tyler's website, go back a few posts to see the actual link.
ah right lol, yeh it works great now, thnx for your help xStylezx and Bhuwan

[Bhuwan]

Yeah, that's how it should work, but it's not for me. I'm on PHP5.1.2 and MySQL4.x on a CentOS system. Not sure what else I can provide to help debug the problem =/A couple things
First, PM or post a link to your site
Second, verify the system is ON (not vRewrite, but the 301 redirects!) - AdminCP -> vBulletin Options -> vRewrite.
Third - will say wen we get there.

[Bhuwan]

ok question for vba gallery we add this to headerinclude:

but where do we add it?

<if condition="THIS_SCRIPT != 'index' AND THIS_SCRIPT != 'gallery_index' AND THIS_SCRIPT != 'gallery_upload' AND THIS_SCRIPT != 'showimage' AND THIS_SCRIPT != 'gallery_search' AND THIS_SCRIPT != 'gallery_newreply' AND THIS_SCRIPT != 'gallery_moderate' AND THIS_SCRIPT != 'gallery_misc' AND THIS_SCRIPT != 'gallery_managecats' AND THIS_SCRIPT != 'editimage' AND THIS_SCRIPT != 'ecard' AND THIS_SCRIPT != 'displayimages' AND THIS_SCRIPT != 'browseimages'">
<base href="$vboptions[bburl]/" />
</if>
I added it right after

<meta http-equiv="Content-Type" content="text/html; charset=$stylevar[charset]" />

[Bhuwan]

Yes there is.
http://helicontech.com
You just have to replace ^ with / at the beginning of each rule after you install isapi rewrite.
Does 1.5 work based on only these cahnges? if so, then that's grood to know for when 1.5 is released (many people may ask about this!)

[Bhuwan]

ah right lol, yeh it works great now, thnx for your help xStylezx and Bhuwanno prob

[DementedMindz]

ok i think i got this down i think if you can confirm if this is correct... if so im on a mission lol im going to rewrite alot of stuff....


<a href="$vboptions[bburl]/arcade.php?$session[sessionurl]do=lboard">[ $vbphrase[leader_board] ]</a>

becomes:

<a href="$vboptions[bburl]/arcade-$session[sessionurl]do-lboard.html">[ $vbphrase[leader_board] ]</a>

and the rewrite rule would be :

RewriteEngine on
RewriteRule arcade-$session[sessionurl]do-(.*)\.html$ arcade.php?$session[sessionurl]do=$1

is this correct if you know?

[Alex_]

I am still not able to choose a timespan in a forum.

Threads from the X last days always directs to the standard timespan (of 30 days) no matter what I choose.
This was in 1.x and 1.5 RC1 too...

[jdingman]

A couple things
First, PM or post a link to your site
Second, verify the system is ON (not vRewrite, but the 301 redirects!) - AdminCP -> vBulletin Options -> vRewrite.
Third - will say wen we get there.

EDIT: It seems be working fine now....not sure what fixed it, thanks.

[Immortal]

ok i think i got this down i think if you can confirm if this is correct... if so im on a mission lol im going to rewrite alot of stuff....


<a href="$vboptions[bburl]/arcade.php?$session[sessionurl]do=lboard">[ $vbphrase[leader_board] ]</a>

becomes:

<a href="$vboptions[bburl]/arcade-$session[sessionurl]do-lboard.html">[ $vbphrase[leader_board] ]</a>

and the rewrite rule would be :

RewriteEngine on
RewriteRule arcade-$session[sessionurl]do-(.*)\.html$ arcade.php?$session[sessionurl]do=$1

is this correct if you know?

Everything is correct, but mod_rewrite doesn't understand vars. So try this:

RewriteRule ^arcade-(.*)do-(.*).html arcade.php?$1do=$2 [L]

[DementedMindz]

when i do that it brings me to a blank white page :(

[jdingman]

I did have one more thing to ask. When you goto member.php?u=1, it goes members/username-1.html? instead of just members/username-1.html .. any idea why it adds that ? to the end of it?

[Bhuwan]

I did have one more thing to ask. When you goto member.php?u=1, it goes members/username-1.html? instead of just members/username-1.html .. any idea why it adds that ? to the end of it?I am aware of this and have fixed it for RC3 ... :) Thanks

[jdingman]

awesome, thanks!!

[Bhuwan]

I am still not able to choose a timespan in a forum.

Threads from the X last days always directs to the standard timespan (of 30 days) no matter what I choose.
This was in 1.x and 1.5 RC1 too...WorkiNg on it...Please post bugs at http://www.TechHelpForum.com/vrewrite

This was already reported but missed because it was never reported!! :banana:

[Immortal]

when i do that it brings me to a blank white page :(

Hm, weird. Make sure no entry like that already exists.

[DementedMindz]

nope its just one link thats all lol and its been tricky... i got everything done except that..

[Bhuwan]

I am still not able to choose a timespan in a forum.

Threads from the X last days always directs to the standard timespan (of 30 days) no matter what I choose.
This was in 1.x and 1.5 RC1 too...
Officially fixed

[Immortal]

nope its just one link thats all lol and its been tricky... i got everything done except that..


Hm.. :(

* Immortal prods Bhuwan

[Bhuwan]

PM sent to DementedMindz

[Bhuwan]

I think you need the following htaccess :

RewriteRule ^arcade-(.*)do-(.*).html arcade.php?$1&do=$2 [L]


you were mising the &

[Immortal]

Doy!!!

[DementedMindz]

hmmm strange it just brings me back to my home page now... the link ends up like this

http://www.example.com/arcade-do-lboard.html

[Bhuwan]

hmmm strange it just brings me back to my home page now... the link ends up like this

http://www.example.com/arcade-do-lboard.html
IM ME

you should be redirecting sesssions through ?<session here>
not in the URL.

Let's resolve this VIA PM/IM/something else....
bhuwan

[VTXCafe.com]

Hum, http://www.techhelpforum.com/ is doing the same thing my site was, click a link and get the "page not found" page.

[Alex_]

WorkiNg on it...Please post bugs at http://www.TechHelpForum.com/vrewrite

This was already reported but missed because it was never reported!! :banana:

Sorry for that - don't have time now to register there and fill a bug report ;)
Just wanted to add (or remind) that it's not only the daysprune but also sort and order parameter...

[Immortal]

Hum, http://www.techhelpforum.com/ is doing the same thing my site was, click a link and get the "page not found" page.

What browser and browser version?

[Bhuwan]

Sorry for that - don't have time now to register there and fill a bug report ;)
Just wanted to add (or remind) that it's not only the daysprune but also sort and order parameter...coool...I've fixed it already

[Bhuwan]

Hum, http://www.techhelpforum.com/ is doing the same thing my site was, click a link and get the "page not found" page.more details please!

[Mike Blitz]

<a href="http://www.urbanforums.co.uk" target="_blank">www.urbanforums.co.uk</a>

why does the seo bring up a 404 not found error everytime trying to submit/query something

[Bhuwan]

www.urbanforums.co.uk (http://www.urbanforums.co.uk)

why does the seo bring up a 404 not found error everytime trying to submit/query something
problem #1) you arent running vrewrite 1.5

[Mike Blitz]

i installed whatever was on the main page :s

[Mike Blitz]

got it fixed, error on my part with the settings

[Mike Blitz]

one thing I need to know is where the "SEOed URLs completed by Tech Help Forum." is, its halfway up the screen in one of my templates and its not located in the footer

[Bhuwan]

one thing I need to know is where the "SEOed URLs completed by Tech Help Forum." is, its halfway up the screen in one of my templates and its not located in the footer
PM Me alink to your site.. I am pretty sure I know why this is happening but want to confirm.

[Bhuwan]

one thing I need to know is where the "SEOed URLs completed by Tech Help Forum." is, its halfway up the screen in one of my templates and its not located in the footer
please update to 1.5 first !

[Bhuwan]

Is there areal need from the public to support:

- External.php
-Correct email links

?

[treasureman]

Hi,

In looking at a couple of the forums from the posters to this thread that have installed this mod I see something that I do not understand and that could be a problem.

In viewing a forum with a list of threads when you hover your curser over the link it does not show the rewritten URL, it shows the old URL. When you click on the URL it goes to the rewritten URL. So won't a search engine first see the old URL and index and follow that one instead of the rewritten URL?

Go ahead and view the source and you will see what I mean, and you will see what the search engines will see, which are the old URL's.

Also I viewed another forum this is installed on and the links were rewritten properly when the cursor is hovered, but when the links were clicked on with the Mozilla browser each link went to a "page not found" which indicates that the pages were not being rewritten properly. This particular forum did work properly in IE however.

I didn't want to publically mention the forums if the Mod author wants me to PM him with the URL's let me know and I will.

[xStylezx]

I have not seen anything like that treasureman.

[Bhuwan]

Hi,

In looking at a couple of the forums from the posters to this thread that have installed this mod I see something that I do not understand and that could be a problem.

In viewing a forum with a list of threads when you hover your curser over the link it does not show the rewritten URL, it shows the old URL. When you click on the URL it goes to the rewritten URL. So won't a search engine first see the old URL and index and follow that one instead of the rewritten URL?

Go ahead and view the source and you will see what I mean, and you will see what the search engines will see, which are the old URL's.

Also I viewed another forum this is installed on and the links were rewritten properly when the cursor is hovered, but when the links were clicked on with the Mozilla browser each link went to a "page not found" which indicates that the pages were not being rewritten properly. This particular forum did work properly in IE however.

I didn't want to publically mention the forums if the Mod author wants me to PM him with the URL's let me know and I will.

Please PM me

[Mike Blitz]

there should be a image attatched with what I mean by having a copyright text at the top aswell as at the bottom


45198

[Mike Blitz]

fixed that myself by just editing the xml then adding the copyright statement to the footer

I wasnt thinking
lmao

[VTXCafe.com]

What browser and browser version?

IE 6.0.2

It's working fine today but last night no matter what link I clicked on that site I got the page not found.

[Bhuwan]

IE 6.0.2

It's working fine today but last night no matter what link I clicked on that site I got the page not found.maybe the person fixed their site ?

[LICryptkeeper]

hi, I have an error after installing. some users link back to my user account. for example...

http://www.montrealforums.com/u-cryptkeeper-1.html

but on my buddies list... SOME of them like "Jay" should be linking to

http://www.montrealforums.com/u-jay-X.html
but instead is linking to

http://www.montrealforums.com/u-cryptkeeper-1.html18 (back to me)

as a reult, nobody can view jay's profile! is there a fix for this?

[Immortal]

Yes, upgrade to 1.5. Searching the thread does a wonder of good.

[DementedMindz]

hmmm i was just searchin around and came across this page read this it has alot of nice info The quick 'n' dirty ultra simple vBulletin SEO hack (http://www.daniweb.com/techtalkforums/thread35147.html) seems pretty nice to me :surprised:

[Hornstar]

hmmm i was just searchin around and came across this page read this it has alot of nice info The quick 'n' dirty ultra simple vBulletin SEO hack (http://www.daniweb.com/techtalkforums/thread35147.html) seems pretty nice to me :surprised:


anyone wanna make this an offical port for 3.5 as a plugin or something so it will be really simple. Thanks

[LICryptkeeper]

Yes, upgrade to 1.5. Searching the thread does a wonder of good.

Hi Immortal, I did see the upgrade, but I thought the packaged version WAS 1.5, I searched this thread with the following querys: 1.5 and upgrade, and havent come across any links. I will try the forum now.

edit: :( mabey I'm blind. I searched the forums, searched by your releases, Bhuwan's Chroder's and Cole's too. and I still cant find it. your first post (info about upgrade can be found here) links to page 42.

[Immortal]

Searched beta ;)

https://vborg.vbsupport.ru/showthread.php?p=935077&highlight=beta#post935077

Anywho, the packaged is 1.0, which is the only stable release currently.

[Immortal]

hmmm i was just searchin around and came across this page read this it has alot of nice info The quick 'n' dirty ultra simple vBulletin SEO hack (http://www.daniweb.com/techtalkforums/thread35147.html) seems pretty nice to me :surprised:

Use it if you'd like, just don't hijack our thread.

anyone wanna make this an offical port for 3.5 as a plugin or something so it will be really simple. Thanks

No, now go away and ask elsewhere. This isn't their support thread, it's vRewite's.

* Immortal gets the broom out

[Bhuwan]

Use it if you'd like, just don't hijack our thread.



No, now go away and ask elsewhere. This isn't their support thread, it's vRewite's.

* Immortal gets the broom outLOL!:banana: :banana:

[LICryptkeeper]

Searched beta ;)

https://vborg.vbsupport.ru/showthread.php?p=935077&highlight=beta#post935077

Anywho, the packaged is 1.0, which is the only stable release currently.


oog.

* LICryptkeeper feels like an idiot.

thank you! :bunny:

[LICryptkeeper]

Ok, I uninstalled 1.0 and installed 1.5 and it dosent work, I searched again, before posting this, and tried a few things too (including keeping and removing the headerinclude modification and baseurl in .htaccess) If I messed up again, just let me know if the result is in this thread I will search till i find it ;)

also, a couple of pages back someone mentions that on your forums some links 404, I get the same thing too, if I click on recent posts or other locations. I'm using ie 6.02 as well.

my site is www.montrealforums.com, as you can see, the urls are not being rewritten (I made all nessisary mods) I will edit this post if I get it fixed.

[Bhuwan]

also, a couple of pages back someone mentions that on your forums some links 404, I get the same thing too, if I click on recent posts or other locations. I'm using ie 6.02 as well.

Please tell me more about this bug -- i.e. what site has the 404, what links, etc. SCreen shots also --


Version1.5 is OFF by default
you have to manually turn it on (this forces you to see the other options).

Admincp -> vBulletin Options -> vRewrite -> put first option to "yes"

[DementedMindz]

Use it if you'd like, just don't hijack our thread.

* Immortal gets the broom out

i didnt hijack your thread with one post i was simply showin others as they may also learn a few rules from it :)

[forte]

I ported vBSEO sitemap Generator to work with vRewrite, however, out of respect for Juan and his team, I won't release it unless they are okay with it... But it is working...

I don't know if I am correct but just in case the vBSEO team won't respond, I just wanted to tell you that it says this in the hack thread.

You are free to modify and/or re-distribute this script as along as the following copyright notice is maintained:

vBSEO(TM) ? 2005 Crawlability, Inc.

[Bhuwan]

I don't know if I am correct but just in case the vBSEO team won't respond, I just wanted to tell you that it says this in the hack thread.\
Thanks for the reply. We are very well aware of this but out of respect for his team, we'd like to wait for them to give an okay :)

[Immortal]

i didnt hijack your thread with one post i was simply showin others as they may also learn a few rules from it :)

Ah, sorry. And in fact...I did try that with vB 3.5, and for me it didn't work. But hey, each is to their own.

[jdingman]

I found a new bug.

When you click on a FORUM link in the 'view user profile' link, such as 'currently viewing XXXXFORUM', it gives a a f--##.html instead of the actual link. Is this a known bug already?

[Immortal]

Report it at the bug tracker, please :)

[LICryptkeeper]

I posted a new thread and got this: I ended up turning it off completly, mabey when i feel like I have enough time to work on it I'll do it, but I have a few more importat things to do till then :(

Database error in vBulletin 3.5.4:

Invalid SQL:

SELECT username, userid, threadid
FROM vb3_post
WHERE threadid IN (,2065,2042,2011,2028,2041,2058,2049,2059,2054,202 5,2057,982,1973,2002,997)
AND visible = 1
ORDER BY dateline DESC;

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 '2065,2042,2011,2028,2041,2058,2049,2059,2054,2025 ,2057,982,1973
Error Number : 1064
Date : Wednesday, April 5th 2006 @ 02:14:39 PM
Script : http://www.montrealforums.com/
Referrer :
IP Address : 24.37.XXXXXXX
Username : Cryptkeeper
Classname : vb_database

[Bhuwan]

I posted a new thread and got this: I ended up turning it off completly, mabey when i feel like I have enough time to work on it I'll do it, but I have a few more importat things to do till then :(

Database error in vBulletin 3.5.4:

Invalid SQL:

SELECT username, userid, threadid
FROM vb3_post
WHERE threadid IN (,2065,2042,2011,2028,2041,2058,2049,2059,2054,202 5,2057,982,1973,2002,997)
AND visible = 1
ORDER BY dateline DESC;

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 '2065,2042,2011,2028,2041,2058,2049,2059,2054,2025 ,2057,982,1973
Error Number : 1064
Date : Wednesday, April 5th 2006 @ 02:14:39 PM
Script : http://www.montrealforums.com/
Referrer :
IP Address : 24.37.XXXXXXX
Username : Cryptkeeper
Classname : vb_database

extra commas

[Bhuwan]

I posted a new thread and got this: I ended up turning it off completly, mabey when i feel like I have enough time to work on it I'll do it, but I have a few more importat things to do till then :(

Database error in vBulletin 3.5.4:

Invalid SQL:

SELECT username, userid, threadid
FROM vb3_post
WHERE threadid IN (,2065,2042,2011,2028,2041,2058,2049,2059,2054,202 5,2057,982,1973,2002,997)
AND visible = 1
ORDER BY dateline DESC;

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 '2065,2042,2011,2028,2041,2058,2049,2059,2054,2025 ,2057,982,1973
Error Number : 1064
Date : Wednesday, April 5th 2006 @ 02:14:39 PM
Script : http://www.montrealforums.com/
Referrer :
IP Address : 24.37.XXXXXXX
Username : Cryptkeeper
Classname : vb_database

I think i may have this resolved, but not sure.

[webwench]

Thank you! This works great! I installed the beta - should I still click install?

[VTXCafe.com]

Worked like a charm with v 1.5, thanks...waiting to see what happens now. ;)

[Bhuwan]

cool

[Bhuwan]

Thank you! This works great! I installed the beta - should I still click install?yes please

[Bhuwan]

Worked like a charm with v 1.5, thanks...waiting to see what happens now. ;)
On your site...
"Members Online In The Past "

Doesn't seem to work proeperly... I will take a loook...

[LICryptkeeper]

I think i may have this resolved, but not sure.

please let me know when you do, other then being indexed easier I love this hack because all my ads were relevant to the thread they were in when i installed it, and I loved that :p

[Bhuwan]

please let me know when you do, other then being indexed easier I love this hack because all my ads were relevant to the thread they were in when i installed it, and I loved that :pThat's good :)
Will release RC3 tonight

[Bhuwan]

RC3

If you don't post bugs then we assume there aren't any!

[xStylezx]

My page 2 link is still not rewriting correct.I have added other posts to the animation forum and its added a page 3 now,which also isnt rewriting correct

http://www.signyourmelonz.com/f-animated-gif-7/page2/?order=desc

http://www.signyourmelonz.com/f-animated-gif-7/page3/?order=desc

[Bhuwan]

My page 2 link is still not rewriting correct.I have added other posts to the animation forum and its added a page 3 now,which also isnt rewriting correct

http://www.signyourmelonz.com/f-animated-gif-7/page2/?order=desc

http://www.signyourmelonz.com/f-animated-gif-7/page3/?order=desc
htaccess issue?

[xStylezx]

I uploaded the new one you provided in the RC3 zip just a few ago.Made sure i did that,other than that i dont know

[Bhuwan]

My page 2 link is still not rewriting correct.I have added other posts to the animation forum and its added a page 3 now,which also isnt rewriting correct

http://www.signyourmelonz.com/f-animated-gif-7/page2/?order=desc

http://www.signyourmelonz.com/f-animated-gif-7/page3/?order=desc


if you see

http://www.signyourmelonz.com/f-animated-gif-7/page2.html/?order=desc

and


http://www.signyourmelonz.com/f-animated-gif-7/page3.html/?order=desc


they both work fine

This shows to me that it is a htaccess issue :)

[Bhuwan]

I uploaded the new one you provided in the RC3 zip just a few ago.Made sure i did that,other than that i dont know

If you decide not to use .html as part of the Rewrites, then you should also remove this from the htaccess file...The htaccess providers defaults which were used for vRewrite 1.0.

Hope this helps out...

[xStylezx]

You have to view the pages with the "?order=desc" off the end of the url and then yes,they function correctly.I dont have time to dig into the .htaccess myself right now.Am i the only one experiencing this problem?Seems like other users would be having the same issues,would everyone have to edit their .htaccess or something.Im just not understanding or something.haha

[xStylezx]

Oh and ive only eliminated .html from the forum names themselves,not the threads,so that shouldnt have anything to do with the page 2 and 3 not rewriting i wouldnt think...

[Bhuwan]

You have to view the pages with the "?order=desc" off the end of the url and then yes,they function correctly.I dont have time to dig into the .htaccess myself right now.Am i the only one experiencing this problem?Seems like other users would be having the same issues,would everyone have to edit their .htaccess or something.Im just not understanding or something.haha

I've created a mini-hack in which it will create the htaccess file FOR YOU based on settings you set. However, it makes no sense to release a fully working copy until 1.5 is stable & final :) -- check it out though if you want.

[Bhuwan]

here's what you need to edit in htaccess

remove
RewriteRule ^f-(.*)-(.*)/page(.*).html/(.*)$ forumdisplay.php?f=$2&&page=$3%{QUERY_STRING}&is_vrewrite=yes [L]


replace it with


RewriteRule ^f-(.*)-(.*)/page(.*)/(.*)$ forumdisplay.php?f=$2&&page=$3%{QUERY_STRING}&is_vrewrite=yes [L]

[xStylezx]

Ok,ill check that hack out in a few.Hope it works as im not up to hacking around with this much today.I just looked at the htaccess and right now im not seeing why it would append that extra ?order=desc

[Bhuwan]

Ok,ill check that hack out in a few.Hope it works as im not up to hacking around with this much today.I just looked at the htaccess and right now im not seeing why it would append that extra ?order=desc

The ?order=desc is from vBulletin.

Check out alll vB Sites, they all have that.

[xStylezx]

yeah,i understand that.it just seems like others or at least one person would be having the same issues i am.why is everyone elses page2 and 3 rewriting appropriately and mine not.Even with the default settings,its not rewritting on my board.hmmmmm

[Bhuwan]

yeah,i understand that.it just seems like others or at least one person would be having the same issues i am.why is everyone elses page2 and 3 rewriting appropriately and mine not.Even with the default settings,its not rewritting on my board.hmmmmmWhat do you mean not rewrting properly?

[jlaine]

RC2 will be delayed by tomorrow morning, as I want to fix a bug that Tyler (Immortal) mentioned to me and some various "cosmetic" errors Jlaine reported.
Fruthermore, I am going for ice cream so i wont get started on fixes until later tonight :)!

By the way, everyone should thank Jlaine , as Jlaine reported MANY bugs/fixes to Tyler and myself. Furthermore, Jlaine risked running this hack on their LIVE board (which is very big) which helped us dramatically!

Many people have helped throughout the development of this hack but I personally want to thank Jlaine for their time

No problem at all, glad I could help you guys out through this and get some of the bugs ironed out.

:)

[Bhuwan]

No problem at all, glad I could help you guys out through this and get some of the bugs ironed out.

:)thx!!! :):banana:

[xStylezx]

Not rewriting properly i guess is my way of saying that i cant get to the proper url from a default install.i havent had a chance to play with the htaccess yet,there probably is a small edit that would fix this,but i dont have the time this evening until possibly real late tonight to mess around with it.On top of that i dont know alot about mod rewriting so figuring this out might take me a few weeks.haha i was just hoping to find an easier way as i dont have the time to devote at this very second....

[Bhuwan]

Not rewriting properly i guess is my way of saying that i cant get to the proper url from a default install.i havent had a chance to play with the htaccess yet,there probably is a small edit that would fix this,but i dont have the time this evening until possibly real late tonight to mess around with it.On top of that i dont know alot about mod rewriting so figuring this out might take me a few weeks.haha i was just hoping to find an easier way as i dont have the time to devote at this very second....
Do one thing, post your configuraiton (vBulletin admincp -> vBulletin options -> vrerwite) line for line
i'll set it up on my DEV board and create a htaccess that works
ok?I need every single option, so screen shot may be easier.

[LICryptkeeper]

AGH! Installed it and was all happy. then I could not go to page 2 of any thread (or more) I applied the fix above, then started looking at the htaccess to see if I could patch it myself. last straw was when I clicked on "new posts" and was greeted by a "page cannot be found" the url had a / at the end (new-post.html/) when i deleted it, the page displayed but with extra content on the top. (and the tables were messed up.)

[Alex_]

Sorry if this was asked before... what do I have to do to enable rewriting in my vbadvanced portal? I want to rewrite links in the news and latest thread modules...


---
Cause of very long thread names the urls grow bigger and bigger... that might be good for SE but not for humans.
I think I will limit the name length to 5-10 chars or so... perhaps you want to make it a feature ;)

[Renada]

Hi,

I have AmyKhar's "Expanded Get New Posts (https://vborg.vbsupport.ru/showthread.php?t=82872&page=3&highlight=new+posts+in+last+hour)" hack installed and this seems to cause a problem with the vRewrite.

It appears to work for minutes and hours but if you click "4 days" it looks like this. (see attachment)

Any ideas?

Regards
Renada

[Bhuwan]

Hi,

I have AmyKhar's "Expanded Get New Posts (https://vborg.vbsupport.ru/showthread.php?t=82872&page=3&highlight=new+posts+in+last+hour)" hack installed and this seems to cause a problem with the vRewrite.

It appears to work for minutes and hours but if you click "4 days" it looks like this. (see attachment)

Any ideas?

Regards
Renada
oops.
Load up your global_complete hook OR load up the complete XML file and
search for


echo($fname . '<br>');

and delete it

[Bhuwan]

Sorry if this was asked before... what do I have to do to enable rewriting in my vbadvanced portal? I want to rewrite links in the news and latest thread modules...


---
Cause of very long thread names the urls grow bigger and bigger... that might be good for SE but not for humans.
I think I will limit the name length to 5-10 chars or so... perhaps you want to make it a feature ;)
Thread name limitation can be very easily applied, espeically since you could use vBulletin's build-in functionality.

[Bhuwan]

AGH! Installed it and was all happy. then I could not go to page 2 of any thread (or more) I applied the fix above, then started looking at the htaccess to see if I could patch it myself. last straw was when I clicked on "new posts" and was greeted by a "page cannot be found" the url had a / at the end (new-post.html/) when i deleted it, the page displayed but with extra content on the top. (and the tables were messed up.)

Can you post your setttings? (/admincp/options.php -> vRewrite) take a screen shot ...

[Bhuwan]

AGH! Installed it and was all happy. then I could not go to page 2 of any thread (or more) I applied the fix above, then started looking at the htaccess to see if I could patch it myself. last straw was when I clicked on "new posts" and was greeted by a "page cannot be found" the url had a / at the end (new-post.html/) when i deleted it, the page displayed but with extra content on the top. (and the tables were messed up.)

Trythe new htaccess generator (0.2) to create the correct htaccess file based on settings you've set.

[Renada]

oops.
Load up your global_complete hook OR load up the complete XML file and
search for


echo($fname . '<br>');

and delete it



Hi Bhuwan,

That cured the forums showing up in a list top left but now the only thing that works is "new posts today".

Also I have this hack installed: Super Display Suite (https://vborg.vbsupport.ru/showthread.php?t=108910&highlight=suite) but when clicking on a name that uses this hack the script displays in the URL

http://thinkstop.com/community2/forums/u--var-scolorff6699-var-a_speed120-var-shimmercountshimmercount1-evalvar-shimmerspeed-shimmercount-a_speed-evalvar-shimmercolor-shimmercount-scolor-documentwrite-freddie-35.html

This happens to all names except mine (me being user 1 (http://www.techhelpforum.com/vrewrite/view.php?id=1))

Regards,
Renada

[Bhuwan]

Hi Bhuwan,

That cured the forums showing up in a list top left but now the only thing that works is "new posts today".

Also I have this hack installed: Super Display Suite (https://vborg.vbsupport.ru/showthread.php?t=108910&highlight=suite) but when clicking on a name that uses this hack the script displays in the URL

http://thinkstop.com/community2/forums/u--var-scolorff6699-var-a_speed120-var-shimmercountshimmercount1-evalvar-shimmerspeed-shimmercount-a_speed-evalvar-shimmercolor-shimmercount-scolor-documentwrite-freddie-35.html

This happens to all names except mine (me being user 1 (http://www.techhelpforum.com/vrewrite/view.php?id=1))

Regards,
Renada

didn't you already report this as a bug? :-) ...nevertheless, I will ONLY make tvRewrite compatable with other HACKS once i am certain that 1.5 is stable....then we'll addcompatabilit :)

[LICryptkeeper]

I get this when i perform searches (new posts) this happens even when I turn OFF "rewrite searches" in admincp. I'll try the suggestion you gave renada

ALL my settings are default in admincp exept for "on" and "searches off"

also I noteced, inside forums, it's rewritten with a / at the end (t-forumname-01.html/)

[Bhuwan]

I get this when i perform searches (new posts) this happens even when I turn OFF "rewrite searches" in admincp. I'll try the suggestion you gave renada

ALL my settings are default in admincp exept for "on" and "searches off"

also I noteced, inside forums, it's rewritten with a / at the end (t-forumname-01.html/)
forums part you can disable (i.e. remove the "/")

i posted a fix for the additioanl text ons earches (i left an echo statement).

be careful when changing settings as u have toupdate the .htaccess file also.

[LICryptkeeper]

all fixed. hope thers no more errors ;)

[Alex_]

Thread name limitation can be very easily applied, espeically since you could use vBulletin's build-in functionality.
No no, I do not mean limiting the allowed thread title length but the length of the name in the url. Cause rewriting only depends on the id in the url I think I will strip an url from blar-blar-blar-blar-12.html down to blar-12.html (first X chars of the title)

[Bhuwan]

Nono, I do not mean limiting the allowed thread title length but the length of the name in the url. Cause rewriting only depends on the id in the url I think I will strip an url from blar-blar-blar-blar-12.html down to blar-12.html (first X chars of the title)Thats what i mean -- it can be done very easily.

[jdingman]

I found a new bug too. When a user creates a username with a space in it, it creates the html file -###.html instead of user name-###.html. Is there a way to sanitize that so it doesn't break and leave out the username?

[Bhuwan]

I found a new bug too. When a user creates a username with a space in it, it creates the html file -###.html instead of user name-###.html. Is there a way to sanitize that so it doesn't break and leave out the username?
This is NOT a bug and the code is WORKING as designed...


HOWEVER, if you really wanted to keep the space... you could do this
in the xml file search for (there should be two instances of it):

$txt = str_replace(' ', '-', $txt);



<b>And replace it with </b>

//$txt = str_replace(' ', '-', $txt);


But if a user enters a space in the thread name (or forum name for that matter), it won't be replaced with a "-"
SO a thread name with "this is my thread" (t = 82) would be replaced as
"this is my thread-82.html" as opposed to "this-is-my-thread-82.html"


From a SEO stand point, how does it make a difference whether you keep the space or replace it with a "-"?
I am no expert, but I think this is irrelevent.
Furthermore, if I am not mistaken, the browser would replace the space with a %20

[jdingman]

The problem actually happening, is that it shows /member/-###.html instead of showing the username at all. It's not displaying ANYTHING for the username. Is that how it's supposed to work?

[Bhuwan]

The problem actually happening, is that it shows /member/-###.html instead of showing the username at all. It's not displaying ANYTHING for the username. Is that how it's supposed to work?
Is that for every user name or just th eusername with a space? is it on forumhome or a thread?

[jdingman]

it's actually just happening with that ONE username, being displayed on the homepage. I'm using the 'all the latest visitors that were here in the last 24 hours'. the other usernames work just fine, if they don't have spaces, but this one breaks.

Also, do you have plans in rewriting the memberlist.php pages or somehow making it easier for search engines to find all the member profiles? I haven't been able to get a working sitemap with all the rewritten pages yet...

[Bhuwan]

it's actually just happening with that ONE username, being displayed on the homepage. I'm using the 'all the latest visitors that were here in the last 24 hours'. the other usernames work just fine, if they don't have spaces, but this one breaks.

Also, do you have plans in rewriting the memberlist.php pages or somehow making it easier for search engines to find all the member profiles? I haven't been able to get a working sitemap with all the rewritten pages yet...
This seems more like a noncompatability issue than a bug. I'll take a look at making it compatable once 1.5 is stable :)

I configured vBSEO sitemap to write urls for vrewrite.

[jdingman]

Ok, sweet. Yes, I read that you did, but you haven't released it yet out of respect for the vBSEO authors, so I'm still waiting for one. Are you going to release it soon?

[Bhuwan]

Ok, sweet. Yes, I read that you did, but you haven't released it yet out of respect for the vBSEO authors, so I'm still waiting for one. Are you going to release it soon?
I am waiting to see if we've gotten a response.
* Bhuwan pokes Tyler :D

[???`S?LV?R???`]

How is this working for 3.5.4? any issue? things users should know? things to look out for?

[jdingman]

Working fine for me under 3.5.4

[xStylezx]

I am waiting to see if we've gotten a response.
* Bhuwan pokes Tyler :D

im curious about this too :)

[Immortal]

I am waiting to see if we've gotten a response.
* Bhuwan pokes Tyler :D

No reply as of now :)

[jdingman]

Immortal: Bhuwan: have you guys considered rewriting the external.php pages to work too? such as /external/rss/ or /external/xml/ or /external/rss2/ or something? just to make it a little more SEF :)

[Immortal]

Good thinking! :)

[jdingman]

:) woot! I'll look for it in the next release then!!

[Bhuwan]

Immortal: Bhuwan: have you guys considered rewriting the external.php pages to work too? such as /external/rss/ or /external/xml/ or /external/rss2/ or something? just to make it a little more SEF :)
I actually asked that ques a few pages back -- do people want support for external & mail?

I'll try to add it this weekend :)

[newmomsforum]

great hack but my navigation is a little strange now.

Ie. My boards are located at http://sitename.com/forums

For my board navigation though everything works fine but

clicking on the first link takes me back to my site homepage and not my forums index.php

ie Boardname > Forum name > sub forum name

Clicking on the first Boardname link takes me to my sites home page at http://sitename.com and not my forum homepage at http://sitename.com/boards

Any ideas?

Thanks in advance

Claire

[Immortal]

Upgrade to 1.5 :)

[newmomsforum]

I thought this was the latest release? :)

[Immortal]

It's the latest stable version which is attached. You'll have to search the thread to find the link to the beta ;)

[VTXCafe.com]

Worked like a charm with v 1.5, thanks...waiting to see what happens now. ;)

Nevermind. :(

It worked great till yesterday and I started getting database errors, when the index page was being accessed we would get the following database errors:

Database error in vBulletin 3.5.4:

Invalid SQL:

SELECT username, userid, threadid
FROM post
WHERE threadid IN (672,765,,826,824,28,764,819,653,807)
AND visible = 1
ORDER BY dateline DESC;

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 '826,824,28,764,819,653,807)
AND visible = 1
ORDER BY dateline DESC' at line 3
Error Number : 1064
Date : Saturday, April 8th 2006 @ 03:42:30 PM
Script : http://www.vtxcafe.com/forum.php
Referrer : http://www.vtxcafe.com/arcade.php
IP Address :
Username :
Classname : vb_database

As soon as I disabled the script the forum worked fine again. I'll go submit this to the bug tracker.

[Immortal]

Hello Everyone,

I have been noticing a lot of forums that have removed links or made them inactive, in vRewrite. I would like to remind everyone that this is a violation of the license agreement and it will not go unnoticed. If you are one who has done this, I highly suggest you add it back how it originally was.

We will begin to start taking action momentarily if we see a forum that does not have the link(s).

Note: If you have donated $20 and took all the necessary steps to remove all copyrights, then you are allowed to remove the copyright(s). But not many have done this, and none of the forums which I was referring to.

[Immortal]

VTXCafe.com: I'll have him take a look at it for ya. :)

[Bhuwan]

Nevermind. :(

It worked great till yesterday and I started getting database errors, when the index page was being accessed we would get the following database errors:


<B>Database error in vBulletin 3.5.4:</B>

Invalid SQL:

SELECT username, userid, threadid
FROM post
WHERE threadid IN (672,765,,826,824,28,764,819,653,807)
AND visible = 1
ORDER BY dateline DESC;

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 '826,824,28,764,819,653,807)
AND visible = 1
ORDER BY dateline DESC' at line 3
Error Number : 1064
Date : Saturday, April 8th 2006 @ 03:42:30 PM
Script : http://www.vtxcafe.com/forum.php
Referrer : http://www.vtxcafe.com/arcade.php
IP Address :
Username :
Classname : vb_database


As soon as I disabled the script the forum worked fine again. I'll go submit this to the bug tracker.
I am looking @ the XML file and their is no such code that has "ORDER BY DATELINE" in it...my guess is you've got an old XML file....

This is the real file you want, latest and greatest RC3..

https://vborg.vbsupport.ru/showpost.php?p=943291&postcount=924

[Darkwolf]

Hmmm. I need some help. My "Go to Last post" doesn't seems to be working for me...

[Frapegliko]

there is a bug with /showthread.php?goto=lastpost&t=201 Urls they doesnt anymore exist..

Database error in vBulletin 3.5.4:

Invalid SQL:

SELECT postid AS postid, post.dateline, t.title as threadtitle, f.title as forumtitle, f.forumid as forumid
FROM vb_post AS post JOIN vb_thread AS t ON(t.threadid=post.threadid) JOIN vb_forum as f ON(f.forumid=t.forumid)
WHERE post.threadid = 201 AND post.visible = 1 AND
postid = (
SELECT MAX(t2.postid) AS postid
FROM vb_post AS t2
WHERE t2.threadid = 201 AND t2.visible = 1
)
LIMIT 1;

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 'SELECT MAX(t2.postid) AS postid
FROM vb_post AS t2

Error Number : 1064
Date : Sunday, April 9th 2006 @ 09:41:01 AM
Script : http://www.domain.com/showthread.php?goto=lastpost&t=201
Referrer :
IP Address : xx.xx.xx.xx
Username : unregistered
Classname : vb_database

[morrow]

WEll now... I've spent the past 6hrs or so reading just about each and every thread here... Uninstalled, re-installed, yada yada....

Anyhow, the latest release RC3... finally works. A few items I've noticed are here:

http://www.njflyfishing.com/vBulletin/search.php?searchid=18376
(this happens when you search for posts by a certain user)

and

http://www.njflyfishing.com/vBulletin/search.php?searchid=18381
(this happens when you click 'New Posts' then click 'here')

and
http://www.njflyfishing.com/vBulletin/rods-reels-lines-leaders-tippets/rods-reels-lines-leaders-tippets/t-loomis-glx-3249-post23097.html#post23097http://www.njflyfishing.com/vBulletin/rods-reels-lines-leaders-tippets/rods-reels-lines-leaders-tippets/t-loomis-glx-3249-post23097.html#post23097
(this is what happens when you click on the 'last post by user')

Thanks / Groan hacks no longer work.

Anyhow, I am using VBAdvanced as you can see, and these are the only few problems I was able to find so far.

If I disable the hack, all of the above starts working again. I'll leave the hack enabled for a few hours so you can see what I mean.

Other than that, it does seem to be working pretty good. Any suggestions?

Man, you guys did a helluva lot of work to get this thing going! I think when this is working 100%, the least I can do is find my wallet and make a donation.

[morrow]

Ok... Had to turn it off... Anything after page 1 was no longer working. Ohh well, I'll check back later.

[Immortal]

Hmmm. I need some help. My "Go to Last post" doesn't seems to be working for me...

You'll want to upgrade to 1.5 :)

morrow: Please report all the issues you come across at the bug tracker, it helps us tremendously.

[Bhuwan]

there is a bug with /showthread.php?goto=lastpost&t=201 Urls they doesnt anymore exist..

Database error in vBulletin 3.5.4:

Invalid SQL:

SELECT postid AS postid, post.dateline, t.title as threadtitle, f.title as forumtitle, f.forumid as forumid
FROM vb_post AS post JOIN vb_thread AS t ON(t.threadid=post.threadid) JOIN vb_forum as f ON(f.forumid=t.forumid)
WHERE post.threadid = 201 AND post.visible = 1 AND
postid = (
SELECT MAX(t2.postid) AS postid
FROM vb_post AS t2
WHERE t2.threadid = 201 AND t2.visible = 1
&nbsp;)
LIMIT 1;

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 'SELECT MAX(t2.postid) AS postid
FROM vb_post AS t2

Error Number : 1064
Date : Sunday, April 9th 2006 @ 09:41:01 AM
Script : http://www.domain.com/showthread.php?goto=lastpost&t=201
Referrer :
IP Address : xx.xx.xx.xx
Username : unregistered
Classname : vb_databasewat version of mysql

[Bhuwan]

Ok... Had to turn it off... Anything after page 1 was no longer working. Ohh well, I'll check back later.
your on an old version of vrewrite (sounds like)

[Darkwolf]

You'll want to upgrade to 1.5 :)

morrow: Please report all the issues you come across at the bug tracker, it helps us tremendously.

why do i get the file ?

[Bhuwan]

why do i get the file ?

here:
https://vborg.vbsupport.ru/showpost.php?p=943291&postcount=924

or click me (https://vborg.vbsupport.ru/showpost.php?p=943291&postcount=924)

[Darkwolf]

here:
https://vborg.vbsupport.ru/showpost.php?p=943291&postcount=924

or click me (https://vborg.vbsupport.ru/showpost.php?p=943291&postcount=924)

Ok Now I upgraded but it seems that when u click on the page 2 or 3 isn't working for me.

[Bhuwan]

Ok Now I upgraded but it seems that when u click on the page 2 or 3 isn't working for me.

htaccess problem:
use this to create a proper htaccess file
https://vborg.vbsupport.ru/showthread.php?t=112024

[Darkwolf]

thanks. you fix all the problem! you have been a great help!

[yayvb]

Ok guys.. I lost the URL to report the bugs but it seems like everyone's just been putting them back in here anyway.

I installed this on one site that is live but not popular, and then on my live but popular site. I noticed a bug on each of them. Should be easy I think.

I think this one here was previously reported. If someone clicks on the quick link Today's Posts the skin is broken on both sites (www.420boards.com and www.youradultworld.com) and see a list of words on the top left of the screen, thus pushing the site down a few inches.

Bug #2 - I think also reported. It seems that not all of the links on the bottom of my site www.420boards.com for the latest X threads/members, etc. seem to work. Some work just fine and then other don't.

Some examples:
Good Urls:
http://www.420boards.com/marijuana-smokers-lounge/t-jee-willakers-batman-912-new.html
http://www.420boards.com/soil-marijuana-grow-journals/t-lowryder-2-821-new.html

Bad Urls:
http://www.420boards.com/t--911-new.html
http://www.420boards.com/t--910-new.html

I'm leaving this going for now on both sites although I expect to hear some people complaining, they'll just have to suffer. You guys have been real good at getting these problems fixed. :)

*EDIT* Oh and yeah before I'm asked, I did use the new .htaccess program so I don't think that's the cause for any of this. :)

[Immortal]

It's in the readme. From now on, all bugs will be ignored, or will be posting the URL to the bug tracking. There are many reasons to use the bug tracker rather then this thread.

http://www.techhelpforum.com/vrewrite

Make sure you search the tracker, and running the latest version (RC3) before you post any bugs.

[Darkwolf]

Immortal I have post the issue on that.

[Immortal]

Thanks :)

[Chadi]

This is my original htaccess file. What should I do with the content?

# -FrontPage-

IndexIgnore .htaccess */.??* *~ *# */HEADER* */README* */_vti*

<Limit GET POST>
#The next line modified by DenyIP
order allow,deny
#The next line modified by DenyIP
#deny from all
allow from all
</Limit>
<Limit PUT DELETE>
order deny,allow
deny from all
</Limit>
AuthName www.domain.com
AuthUserFile /home/user/public_html/_vti_pvt/service.pwd
AuthGroupFile /home/user/public_html/_vti_pvt/service.grp

<Files 403.shtml>
order allow,deny
allow from all
</Files>

deny from 66.208.240.
deny from 213.185.106.206
deny from 213.122.222.
deny from 81.132.39.
deny from 81.86.140.
deny from 68.33.58.
deny from 81.86.140.213
deny from 81.129.
deny from 172.16.
deny from 86.132.174.
deny from 203.59.
deny from 83.70.178.
deny from 216.193.131.
deny from 216.193.131.102
deny from 65.65.222.
deny from 221.192.249.
deny from 66.14.198.
deny from 208.214.184.130
deny from 68.56.241.89
deny from 64.12.13.
deny from 206.172.212.



RedirectMatch permanent ^/private/$ http://www.domain.com/private/flashchat.php

[Immortal]

Just open up your old .htaccess, and then the new. Copy the content in the new, to the bottom of your old. If you get any 404's with the default settings, just post your full .htaccess here then. :)

[dizzy100]

Hi, did v3arcade ever get a full rewrite for this hack ? I know you did the main page and it worked perfectly, what about all the rest ? I saw fragments but in all honesty the thread is so big it started to get very confusing.

If anyone has fully SEO'd their v3arcade please let me know how you did it.

Great hack btw ...

[Immortal]

I would ask the person who was asking the help a bit ago if he can share all the changes he had etc. :)

[DementedMindz]

do a search in the thread for v3 arcade it will limit it down to i think 3 spots and there all the changes... i have fully rewritten alot of my site my arcade is fully done and im just finishing my gallery then im just about done... but search for v3 arcade and it will pull up all the changes...

[dizzy100]

do a search in the thread for v3 arcade it will limit it down to i think 3 spots and there all the changes... i have fully rewritten alot of my site my arcade is fully done and im just finishing my gallery then im just about done... but search for v3 arcade and it will pull up all the changes...

I did that and found fragments all over the place and got very confused in all honesty :(.

Would be good to release as an addon to this i think ...

I'll try again ..