FUDforum: How To » Import msgs from vBulletin 3.5.x

Home » FUDforum » How To » Import msgs from vBulletin 3.5.x

Show: Today's Messages :: Polls :: Message Navigator

Import msgs from vBulletin 3.5.x [message #35094]

Wed, 06 December 2006 23:14

Rolfla

Messages: 3
Registered: December 2006
Location: Sweden

Karma: 0

Junior Member

Hi all,

Anyone tried to import messages from vBulletin 3.5.x into FUDforum?

If not, are there any hints about what tables to dump (vB) and how to import? I can still start from a "clean" FUD installation.

// Rolf

[Updated on: Wed, 06 December 2006 23:16]

Report message to a moderator

Re: Import msgs from vBulletin 3.5.x [message #35098 is a reply to message #35094]

Thu, 07 December 2006 18:12

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

You can try using the existing conversion script which you can find on the download page. It was designed for earlier versions, but I'd imagine with little tweaking it can be made to work with version 3.5 as well.

FUDforum Core Developer

Report message to a moderator

Re: Import msgs from vBulletin 3.5.x [message #35103 is a reply to message #35098]

Thu, 07 December 2006 20:15

Rolfla

Messages: 3
Registered: December 2006
Location: Sweden

Karma: 0

Junior Member

Ilia:

... existing conversion script ... designed for earlier versions, ... little tweaking .. work with version 3.5 as well.

Thank you for the hint. I'll let you know if I succeed.

Regards,

// Rolf Lampa

Report message to a moderator

Re: Import msgs from vBulletin 3.5.x [message #35104 is a reply to message #35098]

Fri, 08 December 2006 00:30

Rolfla

Messages: 3
Registered: December 2006
Location: Sweden

Karma: 0

Junior Member

Ilia:

... with little tweaking it can be made to work with version 3.5 as well.

It seems like the script is abit confused as to which database it operates on. If I understood the idea this code (line 128 in vb2.php) is supposed to delete any avatar's in the FUD forum:

/* Import Avatar Gallery */
  q("DELETE FROM ".$GLOBALS['DBHOST_TBL_PREFIX']."avatar");

But the code fails. It seems to me that the script is trying to access the vb-databse instead (error message):

E:\xampplite\htdocs\forum_fud\VB2.php:161
) 1146: Table 'forum_bulletin.fud26_users' doesn't exist
Query: DELETE FROM fud26_users

(Surprise... I would have expected 'forum_fud.fud26_users'... unless this is only due to a bug in the error msg).

I noticed that $GLOBALS is not set correctly. I had set the following config path to vBulletin on line 23 (which is a valid windows path):

// $VB2_CONFIG_PATH = "/home/forum/F/vb/admin/config.php";
   $VB2_CONFIG_PATH = "e:/xampplite/htdocs/forum_bulletin/includes/config.php4";

...but on line 72 I still had to "enforce" the value since it was missing:

   $GLOBALS['dbname'] = 'forum_bulletin'; // <-- fix /RIL:
   $r= mysql_db_query($GLOBALS['dbname'], $str, $GLOBALS['vb2db']);

A check if I got anything right; in the following code (~125) I understood q() to access the fud db, and Q2() to access the vB-db, right?:

/* Import Avatar Gallery */
   q("DELETE FROM ".$GLOBALS['DBHOST_TBL_PREFIX']."avatar");
   $r = Q2("SELECT * FROM avatar");

Could this info altogether give any ideas about why the config-variables for vB gets messed up? (or not set correctly).

Although I'm a newbie on PHP I use PhpED with debugger and I was pretty sure of that I would figure this out but, well.

Regards,

// Rolf Lampa

XAMPP,
PHP Version 5.1.4
Windows NT M70 5.1 build 2600
Apache 2.0 Handler
MySQL 5.0.21

Report message to a moderator

Re: Import msgs from vBulletin 3.5.x [message #35107 is a reply to message #35104]

Fri, 08 December 2006 15:14

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

It sounds like the database name was moved from the vb config file or is now stored under a different parameter name. Which is why you had to specify it manually.

As far as query execution, Q2() is intended for execution of queries based on VB database and q() is the native fudforum query execution function. The issue with connection is a bug. The following patch will fix it.

http://cvs.prohost.org/c/index.cgi/FUDforum/chngview?cn=11666

FUDforum Core Developer

Report message to a moderator

Previous Topic:	Need help with debugging
Next Topic:	paths and stuff me thinks

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Nov 21 21:42:04 GMT 2024

Total time taken to generate the page: 0.02718 seconds