[SMF Converter] wowBB 1.7

[steve922]

steve922,
edit the wowbb_to_smf.sql and find:

Code Select Expand

---* {$to_prefix}messages 200
---{

replace it with

Code Select Expand

---* {$to_prefix}messages 200
---{
$ignore = true;

this will ignore all duplicates from the messages table.

Just a note: the converter stops sometimes to avoid a server overload. Do not Click "continue".. the converter restarts after 3 seconds automatically.

Thanks to everyone we are getting closer! I closed the board and edited the wowbb_to_smf.sql. Now the converter has given me the following error after the posts were converted...

Converting attachments ... Unsuccessful!
This query:
SELECT
a.attachment_id, a.file_contents, hxxp:p.post [nonactive]_id AS ID_MSG, a.file_name AS filename,
'' AS size, a.downloads AS downloads
FROM `vendiscu_wowbb`. wowbb_attachments AS a
INNER JOIN `vendiscu_wowbb`. wowbb_posts AS p ON (a.attachment_id = p.attachment_id)
LIMIT 0, 500;
Caused the error:

Unknown column 'p.attachment_id' in 'on clause'

[ThorstenE]

can you check your wowBB tables with phpMyAdmin? the table wowbb_attachments should have a column "attachment_id".. also the wowbb_posts. is there anything related in the posts table?

If you don't use attachments in wowBB you can also remove the complete attachments block from our converter:

Code Select Expand


/******************************************************************************/
--- Converting attachments ...
/******************************************************************************/
---* {$to_prefix}attachments
---{
$no_add = true;
$keys = array('ID_ATTACH', 'size', 'filename', 'ID_MSG', 'downloads');
$newfilename = getAttachmentFilename(basename($row['filename']), $ID_ATTACH);

$file=fopen($attachmentUploadDir . '/' . $newfilename,'wb');
fwrite($file,$row['file_contents']);
fclose($file);

@touch($attachmentUploadDir . '/' . $newfilename, filemtime($row['filename']));
$rows[] = "$ID_ATTACH, " . filesize($attachmentUploadDir . '/' . $newfilename) . ", '" . addslashes(basename($row['filename'])) . "', $row[ID_MSG], $row[downloads]";
$ID_ATTACH++;
---}
SELECT
a.attachment_id, a.file_contents, p.post_id AS ID_MSG, a.file_name AS filename,
'' AS size, a.downloads AS downloads
FROM {$from_prefix}attachments AS a
INNER JOIN {$from_prefix}posts AS p ON (a.attachment_id = p.attachment_id);
---*


[RickJ]

I got the "conversion complete" message...but nothing converted

Converting...
Successful.
Recalculating forum statistics... Successful.
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.
Please check this box to delete the converter right now for security reasons. (doesn't work on all servers.)

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!

Any suggestions on what I need to look for?

[ThorstenE]

please check Common conversion errors.

[RickJ]

I see now...maybe:

The path to my root is: /home/users/web/b2497/ipw.chnetwor/public_html

In my php.ini file, I see this line:

session.save_path = /home/users/web/b2497/ipw.chnetwor/phpsessions

...so do I just need to change "phpsessions" to "public_html" ?

[ThorstenE]

the path /home/users/web/b2497/ipw.chnetwor/phpsessions must exist on your server and also must be writeable. It's a path inside your homedir, you should be able to create it via FTP and also change the permissions to writeable.
How do I use FTP? / What is FTP?

[RickJ]

TE please pardon my dumbness...but from the php.ini file quoted above, does that not indicate that the path
/home/users/web/b2497/ipw.chnetwor/phpsessions
already does exist on the server?

...so I only need to change the permissions on it?

[SleePy]

The path may or may not exist. Since its not a default path, you most likely need to create this yourself.
You can verify this anyways by checking FTP to make sure the path actually exists.

You could even possibly remove this from your settings and let the default path for sessions in PHP take over.

[RickJ]

Thanks, Sleepy.

I'm learning as I go ...

phpsessions is there and it is writeable by User.  ...and that did not work...so do I also need to make it writeable by also "Group" and/or "Other" ?

[RickJ]

PS. Here is an image of my directory.  Should phpsessions be UNDER public_html?

[RickJ]

Resolved:  I added Write permissions to GROUP and all is good now

[mike s]

Hi RickJ, glad you are making progress..  let me know if I can help you at all.

[RickJ]

Thanks gofi!

We are up and running now!

Once I figured it out, I was very happy...with a couple exceptions that I wish I would have known about in advance:

1. Notifications are gone.  Any boards or threads that members had on their watch list do not convert to the Notifications list in SMF.

2. Some usergroups that have special names do not convert properly.

Overall, I'd have to give the conversion tool 8.5 out of 10!