MyBB 1.2.x ---> phpBB2.0.22 convertor

This is an archive of the phpBB 2.0.x convertors forum. Support for phpBB2 has now ended.
Forum rules
Following phpBB2's EoL, this forum is now archived for reference purposes only.
Please see the following announcement for more information: viewtopic.php?f=14&t=1385785
User avatar
ric323
Former Team Member
Posts: 22909
Joined: Tue Feb 06, 2007 12:33 am
Location: Melbourne, Australia
Name: Ric
Contact:

Re: MyBB 1.2.x ---> phpBB2.0.22 convertor

Post by ric323 » Tue Apr 29, 2008 11:01 pm

Mr.TAEL wrote:...
How can I open DB ?
The backup is just a text file containing SQL queries.
If it is a .SQL fle, you can just open it in a text editor (but it must be able to handle large files.)
If it is a .ZIP or.GZ file, you will need to extract the SQL file from it first.
The Knowledge Base contains solutions to many common problems!
How to fix "Doesn't have a default value" and "Incorrect string value: xxx for column 'post_text' " errors.
How to do a clean re-install of the latest phpBB3 version.
Problems with permissions? Read phpBB3 Permissions

Mr.TAEL
Registered User
Posts: 12
Joined: Tue Apr 15, 2008 9:48 pm

Re: MyBB 1.2.x ---> phpBB2.0.22 convertor

Post by Mr.TAEL » Wed Apr 30, 2008 4:17 pm

ric323 wrote:
Mr.TAEL wrote:...
How can I open DB ?
The backup is just a text file containing SQL queries.
If it is a .SQL fle, you can just open it in a text editor (but it must be able to handle large files.)
If it is a .ZIP or.GZ file, you will need to extract the SQL file from it first.
It is a large DB and I cannot open it with text editor (~70 MB)

Format of backup is .SQL

User avatar
ric323
Former Team Member
Posts: 22909
Joined: Tue Feb 06, 2007 12:33 am
Location: Melbourne, Australia
Name: Ric
Contact:

Re: MyBB 1.2.x ---> phpBB2.0.22 convertor

Post by ric323 » Wed Apr 30, 2008 10:25 pm

Mr.TAEL wrote: It is a large DB and I cannot open it with text editor (~70 MB)
Yes you can, you just need a better text editor. Try some from: Knowledge Base - Tools needed to set up and customise phpBB
The Knowledge Base contains solutions to many common problems!
How to fix "Doesn't have a default value" and "Incorrect string value: xxx for column 'post_text' " errors.
How to do a clean re-install of the latest phpBB3 version.
Problems with permissions? Read phpBB3 Permissions

Mr.TAEL
Registered User
Posts: 12
Joined: Tue Apr 15, 2008 9:48 pm

Re: MyBB 1.2.x ---> phpBB2.0.22 convertor

Post by Mr.TAEL » Thu May 01, 2008 9:44 am

ric323 wrote:
Mr.TAEL wrote: It is a large DB and I cannot open it with text editor (~70 MB)
Yes you can, you just need a better text editor. Try some from: Knowledge Base - Tools needed to set up and customise phpBB
Thanks a lot.

I saw my converted DB and it's good and no ???? ? ???? characters . (it's in UTF-8 format and Persian language)

So what's the problem . Also in BigDump I've set encoding to utf-8 .

todespudel
Registered User
Posts: 37
Joined: Fri Oct 05, 2007 4:15 pm

Re: MyBB 1.2.x ---> phpBB2.0.22 convertor

Post by todespudel » Thu May 01, 2008 9:14 pm

Have you re-uploaded the dump to the database after you changed the collation?

Mr.TAEL
Registered User
Posts: 12
Joined: Tue Apr 15, 2008 9:48 pm

Re: MyBB 1.2.x ---> phpBB2.0.22 convertor

Post by Mr.TAEL » Fri May 09, 2008 1:39 pm

todespudel wrote:Have you re-uploaded the dump to the database after you changed the collation?
No .

todespudel
Registered User
Posts: 37
Joined: Fri Oct 05, 2007 4:15 pm

Re: MyBB 1.2.x ---> phpBB2.0.22 convertor

Post by todespudel » Sat May 10, 2008 10:19 am

Well, try that!

Mr.TAEL
Registered User
Posts: 12
Joined: Tue Apr 15, 2008 9:48 pm

Re: MyBB 1.2.x ---> phpBB2.0.22 convertor

Post by Mr.TAEL » Fri May 23, 2008 9:44 am

todespudel wrote:Well, try that!
No . It doesn't any effects .

Lieto007
Registered User
Posts: 1
Joined: Tue May 27, 2008 1:38 pm

Re: MyBB 1.2.x ---> phpBB2.0.22 convertor

Post by Lieto007 » Tue May 27, 2008 2:01 pm

hello i need help with convert
when i try to convert

Code: Select all

Dumping.
Traceback (most recent call last):
  File "C:\sql\mybb12x_phpbb2_convertor.py", line 1164, in <module>
    phpbb_prefix)
  File "C:\sql\mybb12x_phpbb2_convertor.py", line 1014, in start
    phpbb2_posts(structure)
  File "C:\sql\mybb12x_phpbb2_convertor.py", line 442, in phpbb2_posts
    number = int(poster_ip[start:end])
ValueError: invalid literal for int() with base 10: '\xaa\xae\xe2\xae\xe0\xeb\xa
9 \xaf\xe0\xa8\xae\xe2\xaa\xe0\xeb\xa2\xa0\xa5\xe2 \xa7\xa0\xa2\xa5\xe1\xe3 \xad
\xa0\xa4 \xa2\xad\xa5\xe8\xad\xae\xe1\xe2\xec\xee \xe0\xa5\xe1\xe2\xa0\xa9\xab\x
a8\xad\xa3\xae\xa2\xae\xa9 \xac\xae\xa4\xa5\xab\xa8 Lanos'
help please
where the problem and how to decide it

sorry for my ENGLISH

todespudel
Registered User
Posts: 37
Joined: Fri Oct 05, 2007 4:15 pm

Re: MyBB 1.2.x ---> phpBB2.0.22 convertor

Post by todespudel » Tue May 27, 2008 4:37 pm

Ok, sorry guys, I do not have the time anymore to support this converter.

It was once meant to help ME (and it did that very well) and it was a nice learning project, but there are some issues with it.

So learn a programming language and after some days you should be able to write a converter which does the job (at least for you).

User avatar
Shaythong
Registered User
Posts: 48
Joined: Sun May 22, 2005 1:57 am

Re: MyBB 1.2.x ---> phpBB2.0.22 convertor

Post by Shaythong » Wed Jun 25, 2008 6:37 am

Lieto007 wrote:hello i need help with convert
when i try to convert

Code: Select all

Dumping.
Traceback (most recent call last):
  File "C:\sql\mybb12x_phpbb2_convertor.py", line 1164, in <module>
    phpbb_prefix)
  File "C:\sql\mybb12x_phpbb2_convertor.py", line 1014, in start
    phpbb2_posts(structure)
  File "C:\sql\mybb12x_phpbb2_convertor.py", line 442, in phpbb2_posts
    number = int(poster_ip[start:end])
ValueError: invalid literal for int() with base 10: '\xaa\xae\xe2\xae\xe0\xeb\xa
9 \xaf\xe0\xa8\xae\xe2\xaa\xe0\xeb\xa2\xa0\xa5\xe2 \xa7\xa0\xa2\xa5\xe1\xe3 \xad
\xa0\xa4 \xa2\xad\xa5\xe8\xad\xae\xe1\xe2\xec\xee \xe0\xa5\xe1\xe2\xa0\xa9\xab\x
a8\xad\xa3\xae\xa2\xae\xa9 \xac\xae\xa4\xa5\xab\xa8 Lanos'
help please
where the problem and how to decide it

sorry for my ENGLISH
Same here.

Code: Select all

    post_id = int(mybb_posts[row][structure['posts']['pid']])
ValueError: invalid literal for int() with base 10: '`pid`'
Too bad he doesn't support this anymore. :cry:

einmalzwei
Registered User
Posts: 1
Joined: Mon Sep 08, 2008 7:11 pm

Re: MyBB 1.2.x ---> phpBB2.0.22 convertor

Post by einmalzwei » Mon Sep 08, 2008 7:13 pm

Can anyone upload the Script again? Alle Links in this topic are broken...

Locked

Return to “[2.0.x] Convertors”

cron