Advertisement:

Author Topic: [SMF Converter] vBulletin 3.5  (Read 83332 times)

Offline Norv

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 18,314
  • Blue Wolf
Re: [SMF Converter] vBulletin 3.5
« Reply #20 on: October 07, 2009, 03:30:29 PM »
What if you make sure you set the path to smf as
/home/newhostusername/public_html/smf
and to vb
/home/newhostusername/public_html/smf
when the convert.php first page asks about them?
To-do lists are for deferral. The more things you write down the later they're done… until you have 100s of lists of things you don't do.
File a security report | Developers' Blog | Bug Tracker

Also known as Norv on D* | Norv N. on G+ | Norv on Github

Offline Red G. Brown

  • Jr. Member
  • **
  • Posts: 225
Re: [SMF Converter] vBulletin 3.5
« Reply #21 on: October 07, 2009, 08:55:57 PM »
That's exactly what I did. A picture is worth a thousand words. Here's some screenshots:

http://img14.imageshack.us/img14/38/smfconvertfailure120091.png
http://img44.imageshack.us/img44/3166/smfconvertfailure220091.png
http://img200.imageshack.us/img200/6293/smfconvertfailure320091.png

Maybe it will be easier for you to figure out what's wrong if you can see what I see. The blanked out stuff is newhostusername. The two lines I have in config.php are:

$config['Database']['dbname'] = 'newhostusername_bulletin';
$config['Database']['tableprefix'] = 'vb_';

Here's screenshots of my FTP webhost dirs with config.php

http://img15.imageshack.us/img15/7200/smfconvertfailure420091.png
http://img43.imageshack.us/img43/2503/smfconvertfailure520091.png

Let me know if there's anything else you'd like to see.

Offline Norv

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 18,314
  • Blue Wolf
Re: [SMF Converter] vBulletin 3.5
« Reply #22 on: October 08, 2009, 07:06:51 AM »
Please, make sure the config.php file begins with <?php and ends with ?>, that is, its contents are actually
Code: [Select]
<?php
$config
['Database']['dbname'] = 'newhostusername_bulletin';
$config['Database']['tableprefix'] = 'vb_';
?>

To-do lists are for deferral. The more things you write down the later they're done… until you have 100s of lists of things you don't do.
File a security report | Developers' Blog | Bug Tracker

Also known as Norv on D* | Norv N. on G+ | Norv on Github

Offline Red G. Brown

  • Jr. Member
  • **
  • Posts: 225
Re: [SMF Converter] vBulletin 3.5
« Reply #23 on: October 08, 2009, 12:17:29 PM »
Got a new error:

Sorry, the database connection information used in the specified installation of SMF cannot access the installation of vBulletin 3.5. 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: Table 'newhostusername_bulletin.vb_user' doesn't exist

Offline Norv

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 18,314
  • Blue Wolf
Re: [SMF Converter] vBulletin 3.5
« Reply #24 on: October 08, 2009, 01:30:31 PM »
Oh! Okay, thank you.
So it seems that the database was not imported, or it has a different prefix. You could perhaps check in phpMyAdmin, to see if the table "user" in vbulletin's database on the new site (with some prefix) exists or not?
If it does not exist, then perhaps you didn't export it completely, or didn't restore the database into newhostusername_bulletin? The database can be restored with phpMyAdmin's "import" feature, please see the tab "import" for it.
If it exists, then what prefix do the tables have, please check the database name and the prefix of the tables.
To-do lists are for deferral. The more things you write down the later they're done… until you have 100s of lists of things you don't do.
File a security report | Developers' Blog | Bug Tracker

Also known as Norv on D* | Norv N. on G+ | Norv on Github

Offline Red G. Brown

  • Jr. Member
  • **
  • Posts: 225
Re: [SMF Converter] vBulletin 3.5
« Reply #25 on: October 08, 2009, 01:44:05 PM »
It appears to have been imported OK, as far as I can tell. I see "user", but should it be "vb_user" instead? The original database is still hosted at the old host, and it also has merely "user", and not "vb_user".

UPDATE:

I changed the config.php to not have a prefix, as follows:

<?php
$config['Database']['dbname'] = 'newhostusername_bulletin';
$config['Database']['tableprefix'] = '';
?>

Then, the convert seemed to be working, but gave me a new error:

Converting...
Converting members... Successful.
Converting categories... Successful.
Converting boards... Successful.
Converting topics... Successful.
Converting posts (this may take some time)... Successful.
Converting polls... Successful.
Converting poll options... Successful.
Converting poll votes... Successful.
Converting personal messages (step 1)... Successful.
Converting personal messages (step 2)... Unsuccessful!

This query:

SELECT
pm.pmid AS ID_PM, pm.touserid AS ID_MEMBER, pm.readtime != 0 AS is_read,
'-1' AS labels
FROM `newhostusername_bulletin`.pm AS pm
WHERE pm.folderid != '-1'
LIMIT 0, 500;

Caused the error:

Unknown column 'pm.touserid' in 'field list'
« Last Edit: October 08, 2009, 02:05:52 PM by qwasty »

Offline Norv

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 18,314
  • Blue Wolf
Re: [SMF Converter] vBulletin 3.5
« Reply #26 on: October 08, 2009, 06:02:13 PM »
In the file vbulletin35_to_smf.sql, please find:
Code: (find) [Select]
---* {$to_prefix}pm_recipients
SELECT
pm.pmid AS ID_PM, pm.touserid AS ID_MEMBER, pm.readtime != 0 AS is_read,
'-1' AS labels
FROM {$from_prefix}pm AS pm
WHERE pm.folderid != '-1';
---*

Code: (replace) [Select]
---* {$to_prefix}pm_recipients
SELECT
pm.pmid AS ID_PM, pm.userid AS ID_MEMBER, pm.readtime != 0 AS is_read,
'-1' AS labels
FROM {$from_prefix}pm AS pm
WHERE pm.folderid != '-1';
---*
To-do lists are for deferral. The more things you write down the later they're done… until you have 100s of lists of things you don't do.
File a security report | Developers' Blog | Bug Tracker

Also known as Norv on D* | Norv N. on G+ | Norv on Github

Offline Red G. Brown

  • Jr. Member
  • **
  • Posts: 225
Re: [SMF Converter] vBulletin 3.5
« Reply #27 on: October 08, 2009, 06:15:14 PM »
None of the posts, boards, and or members are showing up. Here's the results:

SMF Converter
Converting...

Notice: Undefined index: convert_script in /home/newhostusername/public_html/smf/convert.php on line 822

Warning: Invalid argument supplied for foreach() in /home/newhostusername/public_html/smf/convert.php on line 825

Notice: Undefined index: convert_script in /home/newhostusername/public_html/smf/convert.php on line 837

Notice: Undefined index: convert_script in /home/newhostusername/public_html/smf/convert.php on line 733
Successful.
Recalculating forum statistics...
Notice: Undefined variable: result in /home/newhostusername/public_html/smf/convert.php on line 2257

Notice: Undefined variable: result in /home/newhostusername/public_html/smf/convert.php on line 2258

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/newhostusername/public_html/smf/convert.php on line 1223

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/newhostusername/public_html/smf/convert.php on line 1233

Notice: Undefined variable: result in /home/newhostusername/public_html/smf/convert.php on line 2257

Notice: Undefined variable: result in /home/newhostusername/public_html/smf/convert.php on line 2258

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/newhostusername/public_html/smf/convert.php on line 1241

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/newhostusername/public_html/smf/convert.php on line 1251

Notice: Undefined variable: result in /home/newhostusername/public_html/smf/convert.php on line 2257

Notice: Undefined variable: result in /home/newhostusername/public_html/smf/convert.php on line 2258

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/newhostusername/public_html/smf/convert.php on line 1264

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/newhostusername/public_html/smf/convert.php on line 1277

Notice: Undefined variable: result in /home/newhostusername/public_html/smf/convert.php on line 2257

Notice: Undefined variable: result in /home/newhostusername/public_html/smf/convert.php on line 2258

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/newhostusername/public_html/smf/convert.php on line 1323

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/newhostusername/public_html/smf/convert.php on line 1325

Notice: Undefined variable: result in /home/newhostusername/public_html/smf/convert.php on line 2257

Notice: Undefined variable: result in /home/newhostusername/public_html/smf/convert.php on line 2258

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/newhostusername/public_html/smf/convert.php on line 1331

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/newhostusername/public_html/smf/convert.php on line 1337

Notice: Undefined variable: result in /home/newhostusername/public_html/smf/convert.php on line 2257

Notice: Undefined variable: result in /home/newhostusername/public_html/smf/convert.php on line 2258

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/newhostusername/public_html/smf/convert.php on line 1348

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/newhostusername/public_html/smf/convert.php on line 1349

Notice: Undefined variable: result in /home/newhostusername/public_html/smf/convert.php on line 2257

Notice: Undefined variable: result in /home/newhostusername/public_html/smf/convert.php on line 2258

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/newhostusername/public_html/smf/convert.php on line 1357

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/newhostusername/public_html/smf/convert.php on line 1359

Notice: Undefined variable: result in /home/newhostusername/public_html/smf/convert.php on line 2257

Notice: Undefined variable: result in /home/newhostusername/public_html/smf/convert.php on line 2258

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/newhostusername/public_html/smf/convert.php on line 1365

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/newhostusername/public_html/smf/convert.php on line 1366

Notice: Undefined variable: result in /home/newhostusername/public_html/smf/convert.php on line 2257

Notice: Undefined variable: result in /home/newhostusername/public_html/smf/convert.php on line 2258

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/newhostusername/public_html/smf/convert.php on line 1372

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/newhostusername/public_html/smf/convert.php on line 1373

Notice: Undefined variable: result in /home/newhostusername/public_html/smf/convert.php on line 2257

Notice: Undefined variable: result in /home/newhostusername/public_html/smf/convert.php on line 2258

Notice: Undefined variable: result in /home/newhostusername/public_html/smf/convert.php on line 2257

Notice: Undefined variable: result in /home/newhostusername/public_html/smf/convert.php on line 2258

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/newhostusername/public_html/smf/convert.php on line 1397

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/newhostusername/public_html/smf/convert.php on line 1399

Notice: Undefined variable: result in /home/newhostusername/public_html/smf/convert.php on line 2257

Notice: Undefined variable: result in /home/newhostusername/public_html/smf/convert.php on line 2258

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/newhostusername/public_html/smf/convert.php on line 1405

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/newhostusername/public_html/smf/convert.php on line 1417

Notice: Undefined variable: result in /home/newhostusername/public_html/smf/convert.php on line 2257

Notice: Undefined variable: result in /home/newhostusername/public_html/smf/convert.php on line 2258

Notice: Undefined variable: result in /home/newhostusername/public_html/smf/convert.php on line 2257

Notice: Undefined variable: result in /home/newhostusername/public_html/smf/convert.php on line 2258

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/newhostusername/public_html/smf/convert.php on line 1442

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/newhostusername/public_html/smf/convert.php on line 1444

Notice: Undefined variable: result in /home/newhostusername/public_html/smf/convert.php on line 2257

Notice: Undefined variable: result in /home/newhostusername/public_html/smf/convert.php on line 2258

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/newhostusername/public_html/smf/convert.php on line 1488

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/newhostusername/public_html/smf/convert.php on line 1503

Notice: Undefined variable: result in /home/newhostusername/public_html/smf/convert.php on line 2257

Notice: Undefined variable: result in /home/newhostusername/public_html/smf/convert.php on line 2258

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/newhostusername/public_html/smf/convert.php on line 1532

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/newhostusername/public_html/smf/convert.php on line 1534

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/newhostusername/public_html/smf/convert.php on line 1547

Notice: Undefined variable: result in /home/newhostusername/public_html/smf/convert.php on line 2257

Notice: Undefined variable: result in /home/newhostusername/public_html/smf/convert.php on line 2258

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/newhostusername/public_html/smf/convert.php on line 1569

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/newhostusername/public_html/smf/convert.php on line 1574

Notice: Undefined variable: result in /home/newhostusername/public_html/smf/convert.php on line 2257

Notice: Undefined variable: result in /home/newhostusername/public_html/smf/convert.php on line 2258

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/newhostusername/public_html/smf/convert.php on line 1635

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/newhostusername/public_html/smf/convert.php on line 1637

Notice: Undefined variable: result in /home/newhostusername/public_html/smf/convert.php on line 2257

Notice: Undefined variable: result in /home/newhostusername/public_html/smf/convert.php on line 2258

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/newhostusername/public_html/smf/convert.php on line 1673

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/newhostusername/public_html/smf/convert.php on line 1692

Notice: Undefined variable: result in /home/newhostusername/public_html/smf/convert.php on line 2257

Notice: Undefined variable: result in /home/newhostusername/public_html/smf/convert.php on line 2258

Notice: Undefined variable: result in /home/newhostusername/public_html/smf/convert.php on line 2257

Notice: Undefined variable: result in /home/newhostusername/public_html/smf/convert.php on line 2258

Notice: Undefined variable: result in /home/newhostusername/public_html/smf/convert.php on line 2257

Notice: Undefined variable: result in /home/newhostusername/public_html/smf/convert.php on line 2258

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/newhostusername/public_html/smf/convert.php on line 1715

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/newhostusername/public_html/smf/convert.php on line 1716

Notice: Undefined variable: result in /home/newhostusername/public_html/smf/convert.php on line 2257

Notice: Undefined variable: result in /home/newhostusername/public_html/smf/convert.php on line 2258

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/newhostusername/public_html/smf/convert.php on line 2429

Notice: Undefined variable: result in /home/newhostusername/public_html/smf/convert.php on line 2257

Notice: Undefined variable: result in /home/newhostusername/public_html/smf/convert.php on line 2258

Notice: Undefined variable: result in /home/newhostusername/public_html/smf/convert.php on line 2257

Notice: Undefined variable: result in /home/newhostusername/public_html/smf/convert.php on line 2258

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/newhostusername/public_html/smf/convert.php on line 2429

Notice: Undefined variable: result in /home/newhostusername/public_html/smf/convert.php on line 2257

Notice: Undefined variable: result in /home/newhostusername/public_html/smf/convert.php on line 2258
Successful.

Notice: Undefined index: convert_script in /home/newhostusername/public_html/smf/convert.php on line 1823

Notice: Undefined variable: result in /home/newhostusername/public_html/smf/convert.php on line 2257

Notice: Undefined variable: result in /home/newhostusername/public_html/smf/convert.php on line 2258
Conversion Complete
Congratulations, the conversion has completed successfully. If you have or had any problems with this converter, or need help using SMF, please feel free to look to us for support.
Now that everything is converted over, your SMF installation should have all the posts, boards, and members from the installation.

We hope you had a smooth transition!
« Last Edit: October 08, 2009, 06:31:51 PM by qwasty »

Offline Norv

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 18,314
  • Blue Wolf
Re: [SMF Converter] vBulletin 3.5
« Reply #28 on: October 08, 2009, 06:30:46 PM »
Errm, I'd say that didn't work ...
How did you edit the .sql file? Some editors may insert characters that break code. On windows a decent editor is Notepad++.
Perhaps you can try with the attached file instead.

On another note, is your database still online and accessible?
To-do lists are for deferral. The more things you write down the later they're done… until you have 100s of lists of things you don't do.
File a security report | Developers' Blog | Bug Tracker

Also known as Norv on D* | Norv N. on G+ | Norv on Github

Offline Red G. Brown

  • Jr. Member
  • **
  • Posts: 225
Re: [SMF Converter] vBulletin 3.5
« Reply #29 on: October 08, 2009, 06:40:44 PM »
I used textpad, which is an excellent windows text editor. All of the databases are still there. I'm not sure which one you want me to check. I get a different MD5 sum for the one you attached to your post, and the one I edited. Should I try it again with the one you attached to your post?

UPDATE:

I just tried it with yours, and it appears I got the same errors.

SMF Converter
Converting...

Notice: Undefined index: convert_script in /home/newhostusername/public_html/smf/convert.php on line 822

Warning: Invalid argument supplied for foreach() in /home/newhostusername/public_html/smf/convert.php on line 825

Notice: Undefined index: convert_script in /home/newhostusername/public_html/smf/convert.php on line 837

Notice: Undefined index: convert_script in /home/newhostusername/public_html/smf/convert.php on line 733
Successful.
Recalculating forum statistics...
Notice: Undefined variable: result in /home/newhostusername/public_html/smf/convert.php on line 2257

Notice: Undefined variable: result in /home/newhostusername/public_html/smf/convert.php on line 2258

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/newhostusername/public_html/smf/convert.php on line 1223

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/newhostusername/public_html/smf/convert.php on line 1233

Notice: Undefined variable: result in /home/newhostusername/public_html/smf/convert.php on line 2257

Notice: Undefined variable: result in /home/newhostusername/public_html/smf/convert.php on line 2258

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/newhostusername/public_html/smf/convert.php on line 1241

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/newhostusername/public_html/smf/convert.php on line 1251

Notice: Undefined variable: result in /home/newhostusername/public_html/smf/convert.php on line 2257

Notice: Undefined variable: result in /home/newhostusername/public_html/smf/convert.php on line 2258

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/newhostusername/public_html/smf/convert.php on line 1264

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/newhostusername/public_html/smf/convert.php on line 1277

Notice: Undefined variable: result in /home/newhostusername/public_html/smf/convert.php on line 2257

Notice: Undefined variable: result in /home/newhostusername/public_html/smf/convert.php on line 2258

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/newhostusername/public_html/smf/convert.php on line 1323

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/newhostusername/public_html/smf/convert.php on line 1325

Notice: Undefined variable: result in /home/newhostusername/public_html/smf/convert.php on line 2257

Notice: Undefined variable: result in /home/newhostusername/public_html/smf/convert.php on line 2258

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/newhostusername/public_html/smf/convert.php on line 1331

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/newhostusername/public_html/smf/convert.php on line 1337

Notice: Undefined variable: result in /home/newhostusername/public_html/smf/convert.php on line 2257

Notice: Undefined variable: result in /home/newhostusername/public_html/smf/convert.php on line 2258

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/newhostusername/public_html/smf/convert.php on line 1348

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/newhostusername/public_html/smf/convert.php on line 1349

Notice: Undefined variable: result in /home/newhostusername/public_html/smf/convert.php on line 2257

Notice: Undefined variable: result in /home/newhostusername/public_html/smf/convert.php on line 2258

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/newhostusername/public_html/smf/convert.php on line 1357

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/newhostusername/public_html/smf/convert.php on line 1359

Notice: Undefined variable: result in /home/newhostusername/public_html/smf/convert.php on line 2257

Notice: Undefined variable: result in /home/newhostusername/public_html/smf/convert.php on line 2258

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/newhostusername/public_html/smf/convert.php on line 1365

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/newhostusername/public_html/smf/convert.php on line 1366

Notice: Undefined variable: result in /home/newhostusername/public_html/smf/convert.php on line 2257

Notice: Undefined variable: result in /home/newhostusername/public_html/smf/convert.php on line 2258

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/newhostusername/public_html/smf/convert.php on line 1372

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/newhostusername/public_html/smf/convert.php on line 1373

Notice: Undefined variable: result in /home/newhostusername/public_html/smf/convert.php on line 2257

Notice: Undefined variable: result in /home/newhostusername/public_html/smf/convert.php on line 2258

Notice: Undefined variable: result in /home/newhostusername/public_html/smf/convert.php on line 2257

Notice: Undefined variable: result in /home/newhostusername/public_html/smf/convert.php on line 2258

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/newhostusername/public_html/smf/convert.php on line 1397

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/newhostusername/public_html/smf/convert.php on line 1399

Notice: Undefined variable: result in /home/newhostusername/public_html/smf/convert.php on line 2257

Notice: Undefined variable: result in /home/newhostusername/public_html/smf/convert.php on line 2258

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/newhostusername/public_html/smf/convert.php on line 1405

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/newhostusername/public_html/smf/convert.php on line 1417

Notice: Undefined variable: result in /home/newhostusername/public_html/smf/convert.php on line 2257

Notice: Undefined variable: result in /home/newhostusername/public_html/smf/convert.php on line 2258

Notice: Undefined variable: result in /home/newhostusername/public_html/smf/convert.php on line 2257

Notice: Undefined variable: result in /home/newhostusername/public_html/smf/convert.php on line 2258

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/newhostusername/public_html/smf/convert.php on line 1442

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/newhostusername/public_html/smf/convert.php on line 1444

Notice: Undefined variable: result in /home/newhostusername/public_html/smf/convert.php on line 2257

Notice: Undefined variable: result in /home/newhostusername/public_html/smf/convert.php on line 2258

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/newhostusername/public_html/smf/convert.php on line 1488

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/newhostusername/public_html/smf/convert.php on line 1503

Notice: Undefined variable: result in /home/newhostusername/public_html/smf/convert.php on line 2257

Notice: Undefined variable: result in /home/newhostusername/public_html/smf/convert.php on line 2258

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/newhostusername/public_html/smf/convert.php on line 1532

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/newhostusername/public_html/smf/convert.php on line 1534

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/newhostusername/public_html/smf/convert.php on line 1547

Notice: Undefined variable: result in /home/newhostusername/public_html/smf/convert.php on line 2257

Notice: Undefined variable: result in /home/newhostusername/public_html/smf/convert.php on line 2258

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/newhostusername/public_html/smf/convert.php on line 1569

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/newhostusername/public_html/smf/convert.php on line 1574

Notice: Undefined variable: result in /home/newhostusername/public_html/smf/convert.php on line 2257

Notice: Undefined variable: result in /home/newhostusername/public_html/smf/convert.php on line 2258

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/newhostusername/public_html/smf/convert.php on line 1635

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/newhostusername/public_html/smf/convert.php on line 1637

Notice: Undefined variable: result in /home/newhostusername/public_html/smf/convert.php on line 2257

Notice: Undefined variable: result in /home/newhostusername/public_html/smf/convert.php on line 2258

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/newhostusername/public_html/smf/convert.php on line 1673

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/newhostusername/public_html/smf/convert.php on line 1692

Notice: Undefined variable: result in /home/newhostusername/public_html/smf/convert.php on line 2257

Notice: Undefined variable: result in /home/newhostusername/public_html/smf/convert.php on line 2258

Notice: Undefined variable: result in /home/newhostusername/public_html/smf/convert.php on line 2257

Notice: Undefined variable: result in /home/newhostusername/public_html/smf/convert.php on line 2258

Notice: Undefined variable: result in /home/newhostusername/public_html/smf/convert.php on line 2257

Notice: Undefined variable: result in /home/newhostusername/public_html/smf/convert.php on line 2258

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/newhostusername/public_html/smf/convert.php on line 1715

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/newhostusername/public_html/smf/convert.php on line 1716

Notice: Undefined variable: result in /home/newhostusername/public_html/smf/convert.php on line 2257

Notice: Undefined variable: result in /home/newhostusername/public_html/smf/convert.php on line 2258

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/newhostusername/public_html/smf/convert.php on line 2429

Notice: Undefined variable: result in /home/newhostusername/public_html/smf/convert.php on line 2257

Notice: Undefined variable: result in /home/newhostusername/public_html/smf/convert.php on line 2258

Notice: Undefined variable: result in /home/newhostusername/public_html/smf/convert.php on line 2257

Notice: Undefined variable: result in /home/newhostusername/public_html/smf/convert.php on line 2258

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/newhostusername/public_html/smf/convert.php on line 2429

Notice: Undefined variable: result in /home/newhostusername/public_html/smf/convert.php on line 2257

Notice: Undefined variable: result in /home/newhostusername/public_html/smf/convert.php on line 2258
Successful.

Notice: Undefined index: convert_script in /home/newhostusername/public_html/smf/convert.php on line 1823

Notice: Undefined variable: result in /home/newhostusername/public_html/smf/convert.php on line 2257

Notice: Undefined variable: result in /home/newhostusername/public_html/smf/convert.php on line 2258
Conversion Complete
Congratulations, the conversion has completed successfully. If you have or had any problems with this converter, or need help using SMF, please feel free to look to us for support.
Now that everything is converted over, your SMF installation should have all the posts, boards, and members from the installation.

We hope you had a smooth transition!

UPDATE:

I just tried transferring your file with the FTP client, and then downloading it again. Hashcalc says the file has been altered, so the FTP client is doing something to the file. I'm using Filezilla, and this is super depressing that you can't trust your FTP program to not do stuff to your files! Any ideas how to fix this?

UPDATE:

I changed Filezilla's transfer mode from "Auto" to "Binary", and now I get the same file back that I put on the server. My MD5 checksum is 625fb3f61caad592cacedd079f6a5bc0

However, I still get the same errors. I'm going to fiddle some more to see if I can figure out what's wrong. Maybe I uploaded the wrong file or something.

UPDATE:

The file I edited has the following MD5 sum 632cfc0961a3cbfdf2f532876f4b4f6e and all versions I've tried give me a similar long list of errors. I haven't compared them to be sure they're the same though. Should I try starting over by re uploading everything from scratch to eliminate the possibility that filezilla screwed up everything from the beginning?
« Last Edit: October 08, 2009, 07:03:32 PM by qwasty »

Offline Norv

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 18,314
  • Blue Wolf
Re: [SMF Converter] vBulletin 3.5
« Reply #30 on: October 08, 2009, 07:09:14 PM »
Please run the following SQL on the SMF database
Code: [Select]
select * from smf_settings where variable = 'conversion_from';

Could you please tell also if you are using the converter from
http://www.simplemachines.org/community/index.php?topic=140741.0

Also, it seems the converter doesn't access the SMF database. That could happen if something is wrong with its settings in the file Settings.php. Please upload the tool attached here: What is repair_settings.php? on your SMF directory, and run it from the browser. You will see a number of settings. Please make sure your database information is correct, then save the settings.
In case nothing appears or there's a problem with Settings.php, please note there's also a Settings.bak.php, a backup file, that might help to restore the settings if necessary.
To-do lists are for deferral. The more things you write down the later they're done… until you have 100s of lists of things you don't do.
File a security report | Developers' Blog | Bug Tracker

Also known as Norv on D* | Norv N. on G+ | Norv on Github

Offline Red G. Brown

  • Jr. Member
  • **
  • Posts: 225
Re: [SMF Converter] vBulletin 3.5
« Reply #31 on: October 08, 2009, 07:27:29 PM »
repair_settings.php actually downloads as repair_settings.htm. I have to rename the file manually to .php extension. That's a simple but serious problem to add on top of whatever problems people are trying to troubleshoot.

Also, yes, I am using the converter from this thread, which is where the link you gave me eventually leads to. I can see SOME of the data from the database in the admin section of the forums, but none of it shows up anywhere else. Presumably the only place it could get that information is from the SMF database, so it appears it's able to access it just fine. I don't see anything misconfigured in the repair_settings.htm / repair_settings.php tool.

UPDATE:

I didn't see the first part of your reply. Here's what I got from the query from PHPmyadmin (I have no idea what I'm doing):

MySQL returned an empty result set (i.e. zero rows). (Query took 0.0003 sec)
SQL query:
SELECT *
FROM smf_settings
WHERE variable = 'conversion_from';

LIMIT 0 , 30
« Last Edit: October 08, 2009, 09:07:51 PM by qwasty »

Offline Norv

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 18,314
  • Blue Wolf
Re: [SMF Converter] vBulletin 3.5
« Reply #32 on: October 09, 2009, 10:40:36 AM »
repair_settings.php actually downloads as repair_settings.htm. I have to rename the file manually to .php extension. That's a simple but serious problem to add on top of whatever problems people are trying to troubleshoot.
You're right and I can fully appreciate that, however please note that it's something in your browser / downloads / file types settings controlling this little thing.

As for the problem, were there any other changes happening between reply #25 ? Can you please make sure to fully restart the converter? That is, run it with youraddress.com/convert.php. Also, perhaps you renamed the .sql file as well? The converter sql file name has a simple convention to help the convert script recognize multiple conversion sql files if there are from different software: like name_of_software_to_convert_from_to_smf.sql.
To-do lists are for deferral. The more things you write down the later they're done… until you have 100s of lists of things you don't do.
File a security report | Developers' Blog | Bug Tracker

Also known as Norv on D* | Norv N. on G+ | Norv on Github

Offline Red G. Brown

  • Jr. Member
  • **
  • Posts: 225
Re: [SMF Converter] vBulletin 3.5
« Reply #33 on: October 09, 2009, 02:27:24 PM »
I just ran the converter again from the beginning, here's the errors:

vBulletin 3.5 to SMF Converter
Converting...
Converting members... Successful.
Converting categories... Successful.
Converting boards... Successful.
Converting topics... Successful.
Converting posts (this may take some time)... Successful.
Converting polls... Successful.
Converting poll options... Successful.
Converting poll votes... Successful.
Converting personal messages (step 1)... Successful.
Converting personal messages (step 2)... Unsuccessful!
This query:
SELECT
pm.pmid AS ID_PM, pm.userid AS ID_MEMBER, pm.readtime != 0 AS is_read,
'-1' AS labels
FROM `newhostusername_bulletin`.pm AS pm
WHERE pm.folderid != '-1'
LIMIT 0, 500;
Caused the error:
Unknown column 'pm.readtime' in 'field list'

Offline Norv

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 18,314
  • Blue Wolf
Re: [SMF Converter] vBulletin 3.5
« Reply #34 on: October 09, 2009, 02:40:56 PM »
Please, try using the attached file.

On a side note, are you sure the database dump you had was from vbulletin 3.5? I'm not sure, but I wonder if it's higher, like 3.7 or 3.8, seeing these errors.
To-do lists are for deferral. The more things you write down the later they're done… until you have 100s of lists of things you don't do.
File a security report | Developers' Blog | Bug Tracker

Also known as Norv on D* | Norv N. on G+ | Norv on Github

Offline Red G. Brown

  • Jr. Member
  • **
  • Posts: 225
Re: [SMF Converter] vBulletin 3.5
« Reply #35 on: October 09, 2009, 02:52:33 PM »
Database was from VB 3.5.4, if I remember correctly. I searched for the version in the database, and as best I can tell, it was upgraded at least once, from version 3.5.3, to version 3.5.4. I could find no reference to version 3.6, 3.7, or 3.8.

I used your sql file, which has an MD5 checksum of 2f00e44f64d25199c7e3eabe50e5b7ee. I also downloaded it from the server, and checked its MD5, and got the same thing. It gave me the following errors:

Converting...
Converting members... Successful.
Converting categories... Successful.
Converting boards... Successful.
Converting topics... Successful.
Converting posts (this may take some time)... Successful.
Converting polls... Successful.
Converting poll options... Successful.
Converting poll votes... Successful.
Converting personal messages (step 1)... Successful.
Converting personal messages (step 2)... Successful.
Converting topic notifications... Successful.
Converting board notifications... Successful.
Converting smileys... Successful.
Converting attachments... Successful.
Converting avatars... Successful.
Recalculating forum statistics... Successful.
Unsuccessful!
This query:
REPLACE INTO {$to_prefix}settings (variable, value)
VALUES ("conversion_time", 1255113953),
("conversion_from", "vbulletin35_to_smf.sql");
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 '{$to_prefix}settings (variable, value)
VALUES ("conversion_time", 1255113953)' at line 1

UPDATE:

My forums are showing up now. I'm not sure what the error above screwed up.

Offline Norv

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 18,314
  • Blue Wolf
Re: [SMF Converter] vBulletin 3.5
« Reply #36 on: October 09, 2009, 02:57:20 PM »
It didn't, please ignore this one. The last error is a a little bug in the converter itself, which will probably be  fixed next time the converters will be updated on site.
The step about "Recalculating forum statistics... Successful." was the last that matter. Your conversion has succeeded. :)
To-do lists are for deferral. The more things you write down the later they're done… until you have 100s of lists of things you don't do.
File a security report | Developers' Blog | Bug Tracker

Also known as Norv on D* | Norv N. on G+ | Norv on Github

Offline Red G. Brown

  • Jr. Member
  • **
  • Posts: 225
Re: [SMF Converter] vBulletin 3.5
« Reply #37 on: October 09, 2009, 02:59:05 PM »
Great! Thank you so much for all your help in fixing this! You have been so fast and attentive, it surprised me quite a lot. Thanks!

Offline Red G. Brown

  • Jr. Member
  • **
  • Posts: 225
Re: [SMF Converter] vBulletin 3.5
« Reply #38 on: October 09, 2009, 07:43:24 PM »
I just noticed that the text of some of the posts has been altered. There are IRC logs in the forum that begin each line with a user's nickname. The nickname is in the form <nickname>. All of them have been stripped out, except ones of the form <@nickname>, which are the usernames of users with an "@" sign to signify a different status. Can this be corrected?

Offline Norv

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 18,314
  • Blue Wolf
Re: [SMF Converter] vBulletin 3.5
« Reply #39 on: October 10, 2009, 12:52:19 PM »
I'm sure it can, and I will take a look to see where did that come from, though I'm not fully sure I'll have time for it this weekend.

Eventually, meanwhile it might help if you can paste here an example - an entire  line of text or two before conversion, and the exact line(s) after.
To-do lists are for deferral. The more things you write down the later they're done… until you have 100s of lists of things you don't do.
File a security report | Developers' Blog | Bug Tracker

Also known as Norv on D* | Norv N. on G+ | Norv on Github