External incoming links

[eJM]

How can I tell if the import IDs exist?

Thanks,

Jim

[Jerry]

As long as you haven't deleted them, they will be there.

[eJM]

Well, uh, I don't remember deleting them, but it was hectic then and I want to be sure. What do I look for?

Jim

[Jerry]

These SQL commands will tell you how many there are for each :

SELECT count(*) FROM user WHERE importuserid <> 0;
SELECT count(*) FROM forum WHERE importforumid <> 0;
SELECT count(*) FROM thread WHERE importthreadid <> 0;
SELECT count(*) FROM post WHERE importpostid <> 0;

[eJM]

And those can be done via the database query finction in the vB admin CP? Okay, I did that. I do get an error on the first command though:

error number: 1146
error desc: Table 'lbackus_vbulletin.users' doesn't exist

But I got results for the other 3 commands.

Thanks Jerry,

Jim

[esck]

I think you have to append your database prefix

example:

vb_users

[eJM]

There is no database prefix.

[Jerry]

There is no database prefix.

SELECT count(*) FROM [B]user[/B] WHERE importuserid <> 0;

I do know what the user table in vBulletin is called, honest

[tintin74]

I'm trying to convert from PNphpBB2 and my forums are not in subfolders.

The old forum looks like http://domain.com/PNphpBB2-viewtopic-t-9940.html and the new vBulletin forum is http://forum.domain.com/showthread.php?t=456.

Has anyone already done the script modifications to get this to work?

Hi everybody and many thanks to Jerry for his work. I've the same problem of echamberlain. I've on Google 9000 urls of my phpbb board like:

http://forum.mydomain.com/thread-name-vt12345.html

Actually, apache rewrite the popular viewtopic.php, viewforum.php in this way:

RewriteEngine On

RewriteBase /

RewriteRule [.]*-vf([0-9]*) viewforum.php?%{QUERY_STRING}&f=$1
RewriteRule [.]*-vp([0-9]*) viewtopic.php?%{QUERY_STRING}&p=$1
RewriteRule [.]*-vt([0-9]*) viewtopic.php?%{QUERY_STRING}&t=$1
RewriteRule [.]*-vc([0-9]*) index.php?%{QUERY_STRING}&c=$1 

I've test the 404.php script and it works well without url rewriting, but with "url rewrite" don't work.

I need a help,please.Anyone could help to find a solution for this?

Thank you in advance.

Tintin

[echamberlain]

I ended up using apache rewrites on domain.com to do a redirect to a 301.php file (modified version of 404.php) on forum.domain.com.

The 301.php file is responsible for the lookup matching and then running the new url through vBSEO functions to return the correct SEO friendly url to the browser.

[tintin74]

Hello echamberlain,

I'm interested about your solution, could you give me more details about "how to do it" ? I'm using Vbseo on my new VB board too.

Thank you

[tintin74]

Does anyone could help me to make some modification to 404.php to get a solution. I think it could be useful also for other people.

Thank you
Tintin

[Cars2007]

I've just imported a rather large vB 3.5 board to 3.6.8. ImpEx does not preserve thread or post IDs. It would be helpful if there were plugins for showthread.php and showpost.php that would translate old thread IDs into new ones. However, I think it would involve somehow forcing the auto_increment on thread and post IDs to be above the maximums for the previous board (to avoid collisions where old threads were deleted), and I'm not sure how to do that.

[Jerry]

ImpEx does not preserve thread or post IDs.

And it never will.

Userid mapping :

http://www.vbulletin.com/docs/html/impex_terminology

(or any id's)

ImpEx will not force id's and break the database, that will never be supported.

The 404/301 script can be used to redirect internal/external vBulletin links that have changed, it's one more step for the look up, though the 301 will update search engines and the older data will fade and the newer will have the new links and be fine.

[Cars2007]

OK, I found out you can do this:

[edit: damaging]

I think at that point, you could add plugins for showthread_start and showpost_start that would do a 301 redirect to showthread.php or showpost.php with the right thread or post ID in the URL.