Advertisement:

Author Topic: Web Wiz to SMF  (Read 10087 times)

Offline H

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 21,662
  • Gender: Male
Web Wiz to SMF
« on: August 30, 2005, 11:46:12 AM »
Has anyone got a converter from Web Wiz to SMF?

Thanks

/edit: I found a way to go from webwiz >> phpbb >> smf. However this is still a bit long and direct conversion would be appreciated!
« Last Edit: August 30, 2005, 11:54:14 AM by huwnet »
-H
Former Support Team Lead
                              I recommend:
Namecheap (domains)
Fastmail (e-mail)
Linode (VPS)
                             

Offline creatures

  • Semi-Newbie
  • *
  • Posts: 68
Re: Web Wiz to SMF
« Reply #1 on: November 15, 2005, 01:33:19 PM »
I am using web wiz and want to change it to SMF.

I like this forum and looks like better and faster  :D

However i need to convert db to SMF's one.

Any helps?

Offline H

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 21,662
  • Gender: Male
Re: Web Wiz to SMF
« Reply #2 on: November 15, 2005, 03:36:21 PM »
Well I did find a way to do it.

It is a bit long winded but you will have to converter WWF >> phpbb >> smf.

Search the phpbb forums for the conversion thread as it also links to a good MS access to mysql converter.
-H
Former Support Team Lead
                              I recommend:
Namecheap (domains)
Fastmail (e-mail)
Linode (VPS)
                             

Offline creatures

  • Semi-Newbie
  • *
  • Posts: 68
Re: Web Wiz to SMF
« Reply #3 on: November 15, 2005, 04:09:44 PM »
Yeah, I am trying to go with your way. I hope i can do it :D, my wwf forum espicially it is soop portal.
I got error Warning: odbc_exec(): SQL error: [Microsoft][ODBC SQL Server Driver][SQL Server]There is already an index on table 'phpbb_sessions_keys' named 'IX_phpbb_sessions_keys'., SQL state S0011 in SQLExecDirect in D:\Websites\forum.alternatifim.com\wwwroot\phpbb2\db\mssql-odbc.php on line 171
when trying to convert to phpbb
I hope i will convert to phpbb and then SMF :)

Offline Oldiesmann

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 24,817
  • Gender: Male
  • Ask me about the function DB :)
    • oldiesmann on Facebook
    • Oldiesmann on GitHub
    • http://www.linkedin.com/in/michaeleshom on LinkedIn
    • @oldiesmann on Twitter
    • Archie Comics Fan Forum
Re: Web Wiz to SMF
« Reply #4 on: November 16, 2005, 09:41:04 AM »
You should be using MySQL for phpBB, not SQLServer. Otherwise you'll have problems trying to convert to SMF.
Michael Eshom
Webmaster / SMF Lead Developer
oldiesmann@simplemachines.org

Offline H

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 21,662
  • Gender: Male
Re: Web Wiz to SMF
« Reply #5 on: November 16, 2005, 11:44:23 AM »
Indeed, there are however many MSSQL to MYSQL converters available, in fact I think there is a free beta one available from mysql itself
-H
Former Support Team Lead
                              I recommend:
Namecheap (domains)
Fastmail (e-mail)
Linode (VPS)
                             

Offline creatures

  • Semi-Newbie
  • *
  • Posts: 68
Re: Web Wiz to SMF
« Reply #6 on: November 16, 2005, 11:47:02 AM »
Of course my phpbb one is mysql.  However my webwiz forum mssql :(

Offline Oldiesmann

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 24,817
  • Gender: Male
  • Ask me about the function DB :)
    • oldiesmann on Facebook
    • Oldiesmann on GitHub
    • http://www.linkedin.com/in/michaeleshom on LinkedIn
    • @oldiesmann on Twitter
    • Archie Comics Fan Forum
Re: Web Wiz to SMF
« Reply #7 on: November 16, 2005, 11:59:04 AM »
You need to convert your webwiz database to MySQL before trying to convert to phpBB. That error message you got makes me think you're trying to use SQLServer with phpBB...
Michael Eshom
Webmaster / SMF Lead Developer
oldiesmann@simplemachines.org

Offline creatures

  • Semi-Newbie
  • *
  • Posts: 68
Re: Web Wiz to SMF
« Reply #8 on: November 16, 2005, 12:39:26 PM »
Maybe you will make a conventer script for web wiz to SMF and i don't make an effort with converting it phpbb :D

On the other hand, i will try to convert my mssql db to mysql. Can anyone give me direct link that works...

Thanks for replys :) I hope i will be one of the other user that use smf :D

Offline H

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 21,662
  • Gender: Male
Re: Web Wiz to SMF
« Reply #9 on: November 16, 2005, 02:27:05 PM »
There isnt (and probably never will be) demand for a WWF >> SMF converter as very few people converter between languages and database systems. Converting to phpbb then to SMF would be your best bet (and it wouldnt be difficult). If you can send me a MYSQL database dump I could see if i can get it working for you.

Try:
http://www.google.co.uk/search?q=mssql+to+mysql&start=0&ie=utf-8&oe=utf-8&client=firefox-a&rls=org.mozilla:en-US:official

http://www.kofler.cc/mysql/mssql2mysql.html

RECOMMENDED:
The offical migration toolkit from mysql:
http://dev.mysql.com/downloads/migration-toolkit/1.0.html
-H
Former Support Team Lead
                              I recommend:
Namecheap (domains)
Fastmail (e-mail)
Linode (VPS)
                             

Offline creatures

  • Semi-Newbie
  • *
  • Posts: 68
Re: Web Wiz to SMF
« Reply #10 on: November 18, 2005, 11:33:19 AM »
There isnt (and probably never will be) demand for a WWF >> SMF converter as very few people converter between languages and database systems. Converting to phpbb then to SMF would be your best bet (and it wouldnt be difficult). If you can send me a MYSQL database dump I could see if i can get it working for you.

Try:
http://www.google.co.uk/search?q=mssql+to+mysql&start=0&ie=utf-8&oe=utf-8&client=firefox-a&rls=org.mozilla:en-US:official

http://www.kofler.cc/mysql/mssql2mysql.html

RECOMMENDED:
The offical migration toolkit from mysql:
http://dev.mysql.com/downloads/migration-toolkit/1.0.html

Thanks for your help huwnet, I have download mysql migration toolkit, First I select source as mssql db. However when i try to connect it i got error.

ReverseEngineeringMssql.getCatalogs: Could not find a Java Charset equivalent to DB charset iso_1

My db charset was Turkish and i changed it Latin_1. However error remains same.

Offline gigashiga

  • Jr. Member
  • **
  • Posts: 170
Re: Web Wiz to SMF
« Reply #11 on: May 31, 2011, 01:36:50 AM »
phpbb version is very old
I urgently need someone to do this quickly...

i have wwf 9.63 and i want it to be converted to current smf forum I can pay 10 dollars for this script any help will be appreciated..

kindly message me or PM me your email ID if someone can provide solution.

Offline gigashiga

  • Jr. Member
  • **
  • Posts: 170
Re: Web Wiz to SMF
« Reply #12 on: May 31, 2011, 09:57:21 AM »
phpbb version is very old
I urgently need someone to do this quickly...

i have wwf 9.63 and i want it to be converted to current smf forum I can pay 10 dollars for this script any help will be appreciated..

kindly message me or PM me your email ID if someone can provide solution.

anybody going to help me ?? please...

Offline gigashiga

  • Jr. Member
  • **
  • Posts: 170
Re: Web Wiz to SMF
« Reply #13 on: June 04, 2011, 01:33:57 AM »
I have done this conversion successfully

webwiz 9.63 > phpbb2> smf1.1.13

I hope now it will run without any problem.