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: 22910
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 »

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 »

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: 22910
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 »

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 »

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 »

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 »

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 »

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 »

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 »

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 »

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 »

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 »

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

Return to “[2.0.x] Convertors”