Advertisement:

Author Topic: [SMF Converter] vBulletin 3.7  (Read 207786 times)

ThorstenE

  • Guest
Re: [Beta] [SMF Converter] vBulletin 3.7
« Reply #20 on: November 15, 2008, 01:38:54 PM »
the error is not a real problem, one of the attachments was not converted..maybe the file (MemberDownloads/6/3.attach) doesn't exist anymore?

Offline assam_siddibapa

  • Full Member
  • ***
  • Posts: 429
Re: [Beta] [SMF Converter] vBulletin 3.7
« Reply #21 on: November 15, 2008, 03:00:55 PM »
So i think so its not a big problem right ....
any ways thanks

Offline SleePy

  • Site Team Lead
  • SMF Master
  • *
  • Posts: 29,933
  • Gender: Male
  • Thats his happy face.
    • jdarwood007 on GitHub
    • @jdarwood on Twitter
    • SleePy Code - My personal site
Re: [Beta] [SMF Converter] vBulletin 3.7
« Reply #22 on: November 16, 2008, 08:37:00 AM »
The setting in the vBulletin database called "attachpath" seems to be empty.

Can you make sure in the vBulletin settings table has that varname and has a value that is correct :)
Jeremy D — Site Team / SMF Developer
Support the SMF Support team!
Profiles:
GitHub

Offline Suarez

  • Newbie
  • *
  • Posts: 3
Re: [Beta] [SMF Converter] vBulletin 3.7
« Reply #23 on: November 18, 2008, 11:06:25 PM »
I Have this error


Converting personal messages (step 2)... Successful.
Converting topic notifications... Unsuccessful!
This query:

    `urbanscr_foro`.smf_10log_notify
    SELECT userid AS ID_MEMBER, threadid AS ID_TOPIC
    FROM urbanscr_foro.12subscribethread
    LIMIT 0, 500;

Caused the 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 '`urbanscr_foro`.smf_10log_notify
    SELECT userid AS ID_MEMBER, threadid AS ID_TOPI' at line 1

ThorstenE

  • Guest
Re: [Beta] [SMF Converter] vBulletin 3.7
« Reply #24 on: November 19, 2008, 03:01:34 AM »
which version from the vbulletin37_to_smf.sql are you using? try the file attached on the first post of this topic.

Offline Suarez

  • Newbie
  • *
  • Posts: 3
Re: [Beta] [SMF Converter] vBulletin 3.7
« Reply #25 on: November 19, 2008, 08:51:17 PM »
which version from the vbulletin37_to_smf.sql are you using? try the file attached on the first post of this topic.

I use you file 4 vbulletin 3.7 and have this bug

ThorstenE

  • Guest
Re: [SMF Converter] vBulletin 3.7
« Reply #26 on: November 20, 2008, 01:40:33 AM »
have you tried the version attached here?
http://www.simplemachines.org/community/index.php?topic=262571.msg1712521#msg1712521

I noticed from the other topic that your vBulletin is 3.8
Maybe there was a database change between vBulletin 3.7 and 3.8

You can edit the vbulletin37_to_smf.sql and remove this block. this part is for the topic notifications, so you won't loose any important content.
Code: [Select]
/******************************************************************************/
--- Converting topic notifications...
/******************************************************************************/

TRUNCATE {$to_prefix}log_notify;

---* {$to_prefix}log_notify
SELECT userid AS ID_MEMBER, threadid AS ID_TOPIC
FROM {$from_prefix}subscribethread;
---*

Offline Ploot

  • Semi-Newbie
  • *
  • Posts: 13
Re: [SMF Converter] vBulletin 3.7
« Reply #27 on: November 21, 2008, 11:16:06 PM »
I get the same error

Code: [Select]
Sorry, the database connection information used in the specified installation of SMF cannot access the installation of vBulletin 3.7. This may either mean that the installation doesn't exist, or that the MySQL account used does not have permissions to access it.

The error MySQL gave was: Incorrect database name ''


ThorstenE

  • Guest
Re: [SMF Converter] vBulletin 3.7
« Reply #28 on: November 22, 2008, 01:35:38 AM »
Is SMF installed into the same database or a different database? Common conversion errors.

Offline NesTT

  • Newbie
  • *
  • Posts: 4
Re: [SMF Converter] vBulletin 3.7
« Reply #29 on: January 03, 2009, 08:13:50 PM »
Where's the link to the vBulletin 3.7.x converter? I need to convert my vBulletin 3.7.2 to SMF, thanks!
« Last Edit: January 03, 2009, 08:19:25 PM by NesTT »

ThorstenE

  • Guest
Re: [SMF Converter] vBulletin 3.7
« Reply #30 on: January 04, 2009, 02:38:46 AM »
you need two files (vbulletin37_to_smf.sql and convert.php)

the vbulletin37_to_smf.sql is attached here (first post):
http://www.simplemachines.org/community/index.php?topic=262571.0

convert.php is attached here (scroll down):
http://www.simplemachines.org/community/index.php?topic=140741.0

Converting to SMF

Offline NesTT

  • Newbie
  • *
  • Posts: 4
Re: [SMF Converter] vBulletin 3.7
« Reply #31 on: January 04, 2009, 03:06:02 PM »
Thanks man, I'll try that now  ;)

+10

Offline Ploot

  • Semi-Newbie
  • *
  • Posts: 13
Re: [SMF Converter] vBulletin 3.7
« Reply #32 on: January 07, 2009, 08:53:50 AM »
Is SMF installed into the same database or a different database? Common conversion errors.

It is using the same database. But still I get the same error. I have tried converting from IPB to SMF. The other converter seems to work..its just vbulletin 3.7 to Smf that is not working

Offline assam_siddibapa

  • Full Member
  • ***
  • Posts: 429
Re: [SMF Converter] vBulletin 3.7
« Reply #33 on: January 07, 2009, 12:03:06 PM »
Hi got this error ... i am unable to contiue


Sorry, the database connection information used in the specified installation of SMF cannot access the installation of vBulletin 3.7. This may either mean that the installation doesn't exist, or that the MySQL account used does not have permissions to access it.

The error MySQL gave was: SELECT command denied to user 'legenda1_dl'@'localhost' for table 'user'

ThorstenE

  • Guest
Re: [SMF Converter] vBulletin 3.7
« Reply #34 on: January 07, 2009, 02:21:14 PM »

Offline Ploot

  • Semi-Newbie
  • *
  • Posts: 13
Re: [SMF Converter] vBulletin 3.7
« Reply #35 on: January 08, 2009, 12:26:29 AM »
Anyone else able to convert their vb 3.7 to smf?

ThorstenE

  • Guest
Re: [SMF Converter] vBulletin 3.7
« Reply #36 on: January 08, 2009, 02:44:15 AM »
Ploot, please check your vBulletin installation.. is there a file named /admin/config.php or  includes/config.php?

these variables are in that file(s):

Code: [Select]
$config['Database']['dbname']
$config['Database']['tableprefix']

maybe the dbname or the tableprefix is missing / wrong?



Offline Ploot

  • Semi-Newbie
  • *
  • Posts: 13
Re: [SMF Converter] vBulletin 3.7
« Reply #37 on: January 12, 2009, 10:41:16 PM »
Ploot, please check your vBulletin installation.. is there a file named /admin/config.php or  includes/config.php?

these variables are in that file(s):

Code: [Select]
$config['Database']['dbname']
$config['Database']['tableprefix']

maybe the dbname or the tableprefix is missing / wrong?




I have both of them in the config.php file. Tableprefix is just blank because I installed it without any tableprefix like vb3_

Edit : These are the two errors I get at the top

Code: [Select]
Notice: Undefined variable: config in /home/public_html/smf/convert.php(407) : eval()'d code on line 1

Notice: Undefined variable: config in /home/public_html/smf/convert.php(407) : eval()'d code on line 1
« Last Edit: January 12, 2009, 10:48:20 PM by Ploot »

ThorstenE

  • Guest
Re: [SMF Converter] vBulletin 3.7
« Reply #38 on: January 13, 2009, 01:05:57 AM »
ah ok, the missing prefix is the cause .. that's not a problem I think.. is there a line
Code: [Select]
$config['Database']['tableprefix']  = '';
in config.php?
If not please at this line to the config.php, then re-start the conversion.

Offline Ploot

  • Semi-Newbie
  • *
  • Posts: 13
Re: [SMF Converter] vBulletin 3.7
« Reply #39 on: January 13, 2009, 01:57:08 PM »
yes I do

$config['Database']['tableprefix'] = ' ';

I even tried it with a space in between the quotes $config['Database']['tableprefix'] = ' ';