Advertisement:

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

ThorstenE

  • Guest
[SMF Converter] wowBB 1.7
« 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.
« Last Edit: July 18, 2009, 03:00:47 PM by TE »

Offline Geoffw

  • Semi-Newbie
  • *
  • Posts: 14
Re: [SMF Converter] wowBB 1.x
« 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!

« Last Edit: October 03, 2008, 03:51:16 AM by Geoffw »

Offline SleePy

  • Site Team Lead
  • SMF Master
  • *
  • Posts: 29,941
  • Gender: Male
  • Thats his happy face.
    • jdarwood007 on GitHub
    • @jdarwood on Twitter
    • SleePy Code - My personal site
Re: [SMF Converter] wowBB 1.x
« 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).
Jeremy D — Site Team / SMF Developer
Support the SMF Support team!
Profiles:
GitHub

Offline mike s

  • Semi-Newbie
  • *
  • Posts: 63
Re: [SMF Converter] wowBB 1.7
« 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.

ThorstenE

  • Guest
Re: [SMF Converter] wowBB 1.7
« 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

Offline mike s

  • Semi-Newbie
  • *
  • Posts: 63
Re: [SMF Converter] wowBB 1.7
« 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.

Offline RickJ

  • Jr. Member
  • **
  • Posts: 273
  • Gender: Male
    • Affordable Websites
Re: [SMF Converter] wowBB 1.7
« 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.
Rick.

(I do search before asking, so please pardon me if I missed something :) )

ThorstenE

  • Guest
Re: [SMF Converter] wowBB 1.7
« Reply #7 on: March 13, 2009, 02:04:08 PM »
our docs should help: Converting to SMF

Offline RickJ

  • Jr. Member
  • **
  • Posts: 273
  • Gender: Male
    • Affordable Websites
Re: [SMF Converter] wowBB 1.7
« 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,
« Last Edit: March 13, 2009, 04:35:28 PM by RickJ »
Rick.

(I do search before asking, so please pardon me if I missed something :) )

Offline mike s

  • Semi-Newbie
  • *
  • Posts: 63
Re: [SMF Converter] wowBB 1.7
« 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.

Offline RickJ

  • Jr. Member
  • **
  • Posts: 273
  • Gender: Male
    • Affordable Websites
Re: [SMF Converter] wowBB 1.7
« 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?
Rick.

(I do search before asking, so please pardon me if I missed something :) )

Offline mike s

  • Semi-Newbie
  • *
  • Posts: 63
Re: [SMF Converter] wowBB 1.7
« 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.

Offline RickJ

  • Jr. Member
  • **
  • Posts: 273
  • Gender: Male
    • Affordable Websites
Re: [SMF Converter] wowBB 1.7
« 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!
Rick.

(I do search before asking, so please pardon me if I missed something :) )

Offline steve922

  • Newbie
  • *
  • Posts: 9
Re: [SMF Converter] wowBB 1.7
« 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

Offline SleePy

  • Site Team Lead
  • SMF Master
  • *
  • Posts: 29,941
  • Gender: Male
  • Thats his happy face.
    • jdarwood007 on GitHub
    • @jdarwood on Twitter
    • SleePy Code - My personal site
Re: [SMF Converter] wowBB 1.7
« Reply #14 on: March 25, 2009, 01:06:08 PM »
Jeremy D — Site Team / SMF Developer
Support the SMF Support team!
Profiles:
GitHub

Offline steve922

  • Newbie
  • *
  • Posts: 9
Re: [SMF Converter] wowBB 1.7
« Reply #15 on: March 28, 2009, 04:42:36 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.

ThorstenE

  • Guest
Re: [SMF Converter] wowBB 1.7
« 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".

Offline steve922

  • Newbie
  • *
  • Posts: 9
Re: [SMF Converter] wowBB 1.7
« Reply #17 on: March 28, 2009, 06:56:41 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.

Offline mike s

  • Semi-Newbie
  • *
  • Posts: 63
Re: [SMF Converter] wowBB 1.7
« 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.

ThorstenE

  • Guest
Re: [SMF Converter] wowBB 1.7
« 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.