Author Topic: [SMF Converter] wowBB 1.7 (Read 17633 times)

TE · « **on:** September 21, 2008, 08:10:09 AM »

Software: wowBB
Version: 1.x

This is the official support topic for wowBB converter. Use this topic to ask for support for this converter.

Note: This was tested on wowBB 1.7 but should in theory work on other versions of wowBB if the database changes have not been to great.

Changelog

convert.php
Use this convert.php with the .sql file attached in this topic.

Geoffw · « **Reply #1 on:** October 03, 2008, 03:49:31 AM »

I am converting my forum to SMF from a leased version of WowBB hosted on their server.

For some reason the convert prog offered here will not work under these circumstances, as you sem to need to have both WowBB (a full stand alone version) and SMF on the same server. When I FTP'd the leased WowBB to my own server and tried to run the 'Covert' program nothing happened.

So, as my forum is a relatively small community and has only been in use for a year, I am trying to copy the messages across from one forum to the other. a long winded and tedious process, but manageable (I've created accounts for three of the twenty regular users, and copied about five of the 290 message thread so far)

The only problem is the posting are appearing under today's date, and not their original date. Obviously I can see why, but would like to be able to 'edit' the dates so that I can create virtually the same database as already exists on my current WowBB.

So I suppose had two/three questions that I hope someone can shed light on:

1: Has anyone been able to 'convert' a leased Wowbb that exists on another server?
2: Is it possible to 'import' a WowBB backup database into SMF?
3: or failing the above scenarios, can one 'edit 'the date stamp on individual messages?

Cheers Geoff

***Sorry I seem to have posed this twice to the same forum!

SleePy · « **Reply #2 on:** October 03, 2008, 02:22:43 PM »

If you can get a database backup.
You could import it into another database on the same server. The converter just needs the configuration scripts (Usually just something like config.php, configuration.php or settings.php.

As long as it has that and it has valid data in it for the database and file paths (If you are wanting to convert attachments/avatars if the converter supports it).

mike s · « **Reply #3 on:** March 01, 2009, 11:22:08 PM »

Hi all, I'm trying to give this converter a go on a test SMF 2.0RC1 forum.

1) I am currently running wowbb1.7 on a separate host (not leased from wowbb). I created a test SMF site in a separate subfolder, and have it working fine. I have not done any customization except for playing with some of the minor configuration options to get to know the software.

2) I downloaded the convert.php and the wowbb_to_smf.sql files into my main SMF subfolder.

3) I tried running the convert.php and received "The error MySQL gave was: SELECT command denied to user 'xxxx4326_smf'@'localhost' for table 'wowbb_users' ", so I added this user to my wowbb database with only SELECT priveleges.

4) I tried again, now getting this at the very top of screen (not in a window):

Notice: Undefined variable: HTTP_SERVER_VARS in /home/xxxx4326/public_html/xxxxx/wowbbforum/config.php on line 26

Notice: Undefined variable: HTTP_SERVER_VARS in /home/xxxx4326/public_html/xxxxx/wowbbforum/config.php on line 26

Notice: Undefined variable: HTTP_COOKIE_VARS in /home/xxxx4326/public_html/xxxxx/wowbbforum/config.php on line 33

Below that and in a box, i get:

Converting...
Converting Membergroups... Unsuccessful!
This query:
DELETE FROM `xxxx4326_smf`.smf_membergroups
WHERE ID_GROUP >3 AND minPosts = -1;
Caused the error:

Unknown column 'minPosts' in 'where clause'

And now I am stumped, lol. Any suggestions or help great appreicated. Is there a doc file for this yet, that I have perhaps missed?

regards. Mike.

TE · « **Reply #4 on:** March 02, 2009, 01:14:19 AM »

the converter currently is for SMF 1.1.x only. You can convert your wowBB to SMF 1.1.8, then run the large upgrade..
Upgrade SMF

mike s · « **Reply #5 on:** March 02, 2009, 04:40:41 PM »

ok thanks very much.. I thought I had read it was new for 2.0 but my brain is probably overloaded lol..

I will retry under 1.8 and check my results.

appreciate the reply!
regards, Mike.

RickJ · « **Reply #6 on:** March 13, 2009, 12:08:08 PM »

I am trying to give detailed instructions to our webmaster for converting our forum from WowBB 1.7 to SMF. I will, of course, point him to this thread where I see the files posted in the opening post...

But is there somewhere else where step-by-step instructions are given?

Thank you.

TE · « **Reply #7 on:** March 13, 2009, 02:04:08 PM »

our docs should help: Converting to SMF

RickJ · « **Reply #8 on:** March 13, 2009, 04:32:44 PM »

Thank you TE, but I did already review that link carefully. It does not quite, though, answer my question. If it were my own forum I'd just "wing" it, but I'm trying to get as much step-by-step info as I can for a large NPO who wishes to convert from WowBB 1.7 to SMF. I don't have server access so I'm trying to do the best I can to refer them to step by step instructions, and include any other info that they might need too.

Is there anything beyond the docs link that you can offer as far as tips and hints?

In my experience, something like this hardly ever goes without a hitch... Maybe I'm wrong.

I've got several SMF forums that I admit but I've never converted one from WowBB 1.7 so I just want to get as much info as I can before taking the plunge.

Thank you for anything further that you can provide.

Sincerely,

mike s · « **Reply #9 on:** March 17, 2009, 12:31:37 AM »

I'm going through a conversion from wowbb1.7 to smf as well. If you have specific questions, I'll be happy to answer. I Can show you before and after conversions as well before I take it live.

RickJ · « **Reply #10 on:** March 17, 2009, 05:29:47 AM »

Thanks gofi!

One thing we'll want to do is to do it in a new folder...and make sure it all worked right before changing links that point to it. Is that what you'll do too?

mike s · « **Reply #11 on:** March 17, 2009, 09:45:24 AM »

yes , just create a separate subfolder on your system and install it there, then run the convert. You can do lots of testing this way before going live.

RickJ · « **Reply #12 on:** March 17, 2009, 10:04:04 AM »

Great! I hope you don't mind that I'll be watching you as the "test subject"

I'll appreciate any tips or tricks that you might share based on what you've run into along the way.

Thanks again, gofi!

steve922 · « **Reply #13 on:** March 21, 2009, 02:59:03 PM »

This is what I am getting...

Sorry, the database connection information used in the specified installation of SMF cannot access the installation of wowBB 1.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 'xxxxxx_smf1'@'localhost' for table 'wowbb_users'

I am running wow 1.7 trying to convert to 1.1.8

Any suggestions?
Steve

SleePy · « **Reply #14 on:** March 25, 2009, 01:06:08 PM »

Please see this document:
http://www.simplemachines.org/community/index.php?topic=146192.0

steve922 · « **Reply #15 on:** March 28, 2009, 04:42:36 PM »

Quote from: SleePy on March 25, 2009, 01:06:08 PM

Please see this document:
http://www.simplemachines.org/community/index.php?topic=146192.0

Thank You SleePy.

The information in that thread did help me however now it is only converting 889 of my 36,000 posts. It is eveident that I will not be converting SMF unless I can get more help.

I am more than willing to spend some cash to get this done if anyone is willing to help.

TE · « **Reply #16 on:** March 28, 2009, 05:15:10 PM »

steve922, have you seen any errors during the conversion? the conversion should finish with "conversion successful".

steve922 · « **Reply #17 on:** March 28, 2009, 06:56:41 PM »

Quote from: TE on March 28, 2009, 05:15:10 PM

steve922, have you seen any errors during the conversion? the conversion should finish with "conversion successful".

It finished with "conversion unsuccessful" It gave a rather long list of errors, all of which appeared to be posts on my wow forum.

At the very end of the report it said something about "duplicate entries"

I will try it again to give more specifics.

mike s · « **Reply #18 on:** March 28, 2009, 09:47:13 PM »

steve922, are you running it against a live database???

if so, try closing the board for a litlte bit and rerunning.. I would get sporadic errors when running against the wowbb board while it was still up.

regards, Mike.

TE · « **Reply #19 on:** March 29, 2009, 02:39:44 AM »

steve922,
edit the wowbb_to_smf.sql and find:

Code: [Select]

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

replace it with

Code: [Select]

---* {$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.

steve922 · « **Reply #20 on:** March 29, 2009, 11:37:48 AM »

Quote from: TE on March 29, 2009, 02:39:44 AM

steve922,
edit the wowbb_to_smf.sql and find:
Code: [Select]
---* {$to_prefix}messages 200 ---{replace it with
Code: [Select]
---* {$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, p.post_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'

TE · « **Reply #21 on:** March 29, 2009, 01:00:29 PM »

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]

/******************************************************************************/
--- 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 · « **Reply #22 on:** April 19, 2009, 11:10:31 AM »

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?

TE · « **Reply #23 on:** April 19, 2009, 01:09:51 PM »

please check Common conversion errors.

RickJ · « **Reply #24 on:** April 20, 2009, 08:04:16 AM »

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" ?

TE · « **Reply #25 on:** April 20, 2009, 11:01:17 AM »

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 · « **Reply #26 on:** April 21, 2009, 07:48:55 AM »

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 · « **Reply #27 on:** April 23, 2009, 10:17:43 PM »

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 · « **Reply #28 on:** May 06, 2009, 09:16:54 AM »

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 · « **Reply #29 on:** May 06, 2009, 09:22:01 AM »

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

RickJ · « **Reply #30 on:** May 11, 2009, 07:42:16 AM »

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

mike s · « **Reply #31 on:** May 11, 2009, 11:20:32 PM »

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

RickJ · « **Reply #32 on:** May 12, 2009, 07:58:26 AM »

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!

News:

Author Topic: [SMF Converter] wowBB 1.7 (Read 17633 times)