Advertisement:

Author Topic: vBulletin 4.2.0 to SMF  (Read 11721 times)

Offline Divx

  • Semi-Newbie
  • *
  • Posts: 39
  • Gender: Male
vBulletin 4.2.0 to SMF
« on: April 02, 2015, 02:39:52 PM »
Hi! I have the database of my vB forum. I install smf. Can someone help me to convert my database of vB to SMF? Because I upload convert.php but I don't know how I do next.

Offline margarett

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,761
  • Gender: Male
Re: vBulletin 4.2.0 to SMF
« Reply #1 on: April 02, 2015, 07:16:41 PM »
First step is to check our wiki ;)
Converting to SMF

Do you have vB running or you just have the database?
Se forem conduzir, não bebam. Se forem beber... CHAMEM-ME!!!! :D

Quote
Over 90% of all computer problems can be traced back to the interface between the keyboard and the chair

Offline Divx

  • Semi-Newbie
  • *
  • Posts: 39
  • Gender: Male
Re: vBulletin 4.2.0 to SMF
« Reply #2 on: April 02, 2015, 07:32:35 PM »
I only have the database

Offline margarett

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,761
  • Gender: Male
Re: vBulletin 4.2.0 to SMF
« Reply #3 on: April 02, 2015, 07:36:52 PM »
Yeah, that's a bigger problem... (One that can be fixed, though ;) )

The converter expects to find a working instance of the "origin" software, which will allow it, amongst others:
- get the database details from the configuration file
- know where the attachments are in order to copy them.
(And 2 or 3 other minor stuff)

Not having it requires a "fake" configuration file to be created. I can assist you with that but I won't have a computer for the next few days... :(
Se forem conduzir, não bebam. Se forem beber... CHAMEM-ME!!!! :D

Quote
Over 90% of all computer problems can be traced back to the interface between the keyboard and the chair

Offline Divx

  • Semi-Newbie
  • *
  • Posts: 39
  • Gender: Male
Re: vBulletin 4.2.0 to SMF
« Reply #4 on: April 02, 2015, 07:49:53 PM »
Yes, I need assist because I don't have a license of vBulletin.

Offline margarett

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,761
  • Gender: Male
Re: vBulletin 4.2.0 to SMF
« Reply #5 on: April 02, 2015, 07:58:11 PM »
As I said, I can help you. But not until Monday evening...
Se forem conduzir, não bebam. Se forem beber... CHAMEM-ME!!!! :D

Quote
Over 90% of all computer problems can be traced back to the interface between the keyboard and the chair

Offline Divx

  • Semi-Newbie
  • *
  • Posts: 39
  • Gender: Male
Re: vBulletin 4.2.0 to SMF
« Reply #6 on: April 02, 2015, 08:41:33 PM »
No problem, is not urgent.

Offline Divx

  • Semi-Newbie
  • *
  • Posts: 39
  • Gender: Male
Re: vBulletin 4.2.0 to SMF
« Reply #7 on: April 06, 2015, 10:47:36 AM »
Hi margarett, yu can help me now?

Offline margarett

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,761
  • Gender: Male
Re: vBulletin 4.2.0 to SMF
« Reply #8 on: April 07, 2015, 10:17:03 AM »
Hi.

I'll try to check it today evening.
Se forem conduzir, não bebam. Se forem beber... CHAMEM-ME!!!! :D

Quote
Over 90% of all computer problems can be traced back to the interface between the keyboard and the chair

Offline Divx

  • Semi-Newbie
  • *
  • Posts: 39
  • Gender: Male
Re: vBulletin 4.2.0 to SMF
« Reply #9 on: April 08, 2015, 11:58:19 AM »
Thank you :)

Offline margarett

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,761
  • Gender: Male
Re: vBulletin 4.2.0 to SMF
« Reply #10 on: April 08, 2015, 02:20:52 PM »
Nop, yesterday wasn't the day. Today is :)

Edit: dang, not yet, sorry. Why is the day only 24h long?
« Last Edit: April 08, 2015, 07:22:50 PM by margarett »
Se forem conduzir, não bebam. Se forem beber... CHAMEM-ME!!!! :D

Quote
Over 90% of all computer problems can be traced back to the interface between the keyboard and the chair

Offline Divx

  • Semi-Newbie
  • *
  • Posts: 39
  • Gender: Male
Re: vBulletin 4.2.0 to SMF
« Reply #11 on: April 08, 2015, 11:07:51 PM »
No problem men  ;D

If you can solved my problem, take your time :D

Offline margarett

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,761
  • Gender: Male
Re: vBulletin 4.2.0 to SMF
« Reply #12 on: April 09, 2015, 08:09:31 PM »
OK, here goes nothing :P

This is untested because I have no vB setup to test.

So you need to:
* Import your database backup (probably a .sql file?) to MySQL. Make note of the database name and make sure that the user that SMF has configured to access its database can also access this newly imported database.
* create a file called config.php, and put the following content in it:
Code: [Select]
<?php
    $config
['Database']['dbname'] = 'your_newly_imported_database';
    
$config['Database']['tableprefix'] = 'vb_table_prefix_';
?>

(about table prefix: after you import your database, you'll notice that all tables start with a certain pattern, SMF uses "smf_" by default, your tables will have something different)

Now, you need to put this file in a certain place. If your forum is, eg, under:
/home/user123/public_html/forum
You need to create a folder, eg:
/home/user123/public_html/temp_vb/admin
And put the file you just created inside.

Now launch the converter. In the path to vB, put this
/home/user123/public_html/temp_vb

And if we're lucky, it works :P
Se forem conduzir, não bebam. Se forem beber... CHAMEM-ME!!!! :D

Quote
Over 90% of all computer problems can be traced back to the interface between the keyboard and the chair

Offline Divx

  • Semi-Newbie
  • *
  • Posts: 39
  • Gender: Male
Re: vBulletin 4.2.0 to SMF
« Reply #13 on: April 10, 2015, 10:19:40 AM »
Hi, thank you for the reply.

I do all that you told me. I have the forum in localhost, so I can enter to my forum at: http://localhost

When I try run the converter (localhost/convert.php), this give me an error:

Quote
The converter did not find any conversion data files. Please check to see if the one you want is available for download at www.simplemachines.org. If it isn't, we may be able to write one for you - just ask us!

After you download it, simply upload it into the same folder as this convert.php file. If you're having any other problems with this converter, don't hesitate to look for help on our forum.

Try again

Offline margarett

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,761
  • Gender: Male
Re: vBulletin 4.2.0 to SMF
« Reply #14 on: April 10, 2015, 10:51:59 AM »
You need to upload both convert.php and the corresponding converter file, in your case vbulletin4_to_smf.sql
Pick them from here --> http://www.simplemachines.org/community/index.php?topic=527924.msg3745016#msg3745016
Se forem conduzir, não bebam. Se forem beber... CHAMEM-ME!!!! :D

Quote
Over 90% of all computer problems can be traced back to the interface between the keyboard and the chair

Offline Divx

  • Semi-Newbie
  • *
  • Posts: 39
  • Gender: Male
Re: vBulletin 4.2.0 to SMF
« Reply #15 on: April 10, 2015, 11:08:42 AM »
Quote
Sorry, the database connection information used in the specified installation of SMF cannot access the installation of vBulletin 4.0. This may either mean that the installation doesn't exist, or that the Database account used does not have permissions to access it.

The error that was received from the Database was: Table 'etk999_etk1.etk1_user' doesn't exist

The name of my .sql file: etk999_ETK1
Table prefix: etk1_

So, in my config.php I put this:

Code: [Select]
<?php
    $config
['Database']['dbname'] = 'etk999_ETK1';
    
$config['Database']['tableprefix'] = 'etk1_';
?>

Offline Illori

  • Project Manager
  • SMF Master
  • *
  • Posts: 48,058
Re: vBulletin 4.2.0 to SMF
« Reply #16 on: April 10, 2015, 11:13:18 AM »
did you import the databse into your database server? a .sql file will not work directly.

Offline Divx

  • Semi-Newbie
  • *
  • Posts: 39
  • Gender: Male
Re: vBulletin 4.2.0 to SMF
« Reply #17 on: April 10, 2015, 11:29:25 AM »
Yes. So, in:

Code: [Select]
$config['Database']['dbname'] = 'etk999_ETK1';
I put the name of my smf database?

Offline Illori

  • Project Manager
  • SMF Master
  • *
  • Posts: 48,058
Re: vBulletin 4.2.0 to SMF
« Reply #18 on: April 10, 2015, 11:38:29 AM »
i mean actually to import the database backup to your server, not just list a name in a config file.

Offline Divx

  • Semi-Newbie
  • *
  • Posts: 39
  • Gender: Male
Re: vBulletin 4.2.0 to SMF
« Reply #19 on: April 10, 2015, 11:45:22 AM »
Ok, I put the name of my database (no .sql) in the config file, and when I try to convert, the converter gime me this error:

Unknown system variable 'SQL_MAX_JOIN_SIZE'