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
todespudel
Registered User
Posts: 37
Joined: Fri Oct 05, 2007 4:15 pm

Re: Python MyBB 1.2.9 ---> phpBB2.0.22 convertor

Post by todespudel » Sat Nov 17, 2007 11:14 pm

134bs?

I've almost fixed the problem with bbcodes....
Last edited by todespudel on Sat Nov 17, 2007 11:43 pm, edited 1 time in total.

lordtopcat
Registered User
Posts: 194
Joined: Tue Sep 14, 2004 6:52 am
Location: New Zealand
Contact:

Re: Python MyBB 1.2.9 ---> phpBB2.0.22 convertor

Post by lordtopcat » Sat Nov 17, 2007 11:23 pm

That is the size of the file after the converter..

I have pm'd you the location of the file.
- Lord Top Cat -
Loving the new site.

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

Re: Python MyBB 1.2.9 ---> phpBB2.0.22 convertor

Post by todespudel » Sat Nov 17, 2007 11:40 pm

I've fixed the bbcode issue

You've got a pm.

ibrar mirza
Registered User
Posts: 5
Joined: Thu Mar 20, 2008 11:50 am

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

Post by ibrar mirza » Thu Mar 20, 2008 11:56 am

Hello I tried to convert the mybb db by installing the dumb following the steps provided above. My python script is giving the errors which are underway............ can any one tell me where i am doing wrong! i have checked the users table there are admin users of group 4 exists. so what should i do???

Code: Select all

D:\>Python25\python.exe d:\mybb12x_phpbb2_convertor.py
Dumping.
Dumping.
Dumping.
Dumping.
Dumping.
Dumping.
Dumping.
Dumping.
List  posts  is empty. Conversion could have failed!
List  posts_text  is empty. Conversion could have failed!
List  topics  is empty. Conversion could have failed!
################################################################
There are no admins in your Mybb installation.
mybb  ? =  ?  seems to be wrong.
Please correct this problem first before restarting.
################################################################
Conversion step users failed. Press Enter.
After Enter i see following errors

Code: Select all

writing phpbb2_users 0
List  forums  is empty. Conversion could have failed!
List  categories  is empty. Conversion could have failed!
List  privmsgs  is empty. Conversion could have failed!
List  privmsgs_text  is empty. Conversion could have failed!
List  vote_desc  is empty. Conversion could have failed!
List  vote_voters  is empty. Conversion could have failed!
List  vote_results  is empty. Conversion could have failed!
Traceback (most recent call last):
  File "d:\mybb12x_phpbb2_convertor.py", line 1164, in <module>
    phpbb_prefix)
  File "d:\mybb12x_phpbb2_convertor.py", line 1061, in start
    phpbb_groups, columns_names = phpbb2_groups(structure, auth_tuple)
  File "d:\mybb12x_phpbb2_convertor.py", line 575, in phpbb2_groups
    admin_id = auth_tuple[0][0]
IndexError: tuple index out of range

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 Mar 20, 2008 2:11 pm

Hi,

I need some information:

1. Script version (see the date at line #3 or so in the script)?
2. MyBB version?
3. Size of your dump?
4. Please check if there is a regular MyBB admin in your MyBB forum (usergroup = 4) (you can check it using phpmyadmin, table mybb_users, and sort the table by usergroup by clicking on it).


Edit: Sry, I haven't read your post carefully. As you have already checked for usergroup4 I have to think a little - brb ;)

Edit 2: Ok, as I don't have your dump I can only guess: did you use phpmyadmin for the dump? Are you sure, that you have not used "extended inserts" and "complete inserts"? Could you give me some lines of your dump so that I can have a look at the format?

ibrar mirza
Registered User
Posts: 5
Joined: Thu Mar 20, 2008 11:50 am

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

Post by ibrar mirza » Sat Mar 22, 2008 12:40 pm

1. The date in the script given is # 14.3.08
2. Mybb Version 1.2.8
3. DB Dump size 12.7MB
4. Yes i do care about extended and complete inserts according to the steps given.(means untick both of them) using phpmyadmin

Code: Select all

-- phpMyAdmin SQL Dump
-- version 2.6.3-pl1
-- http://www.phpmyadmin.net
-- 
-- Host: localhost
-- Generation Time: Mar 22, 2008 at 12:09 PM
-- Server version: 4.1.20
-- PHP Version: 5.0.4
-- 
-- Database: `raabtacareers`
-- 

-- --------------------------------------------------------

-- 
-- Table structure for table `cr_adminlog`
-- 

CREATE TABLE `cr_adminlog` (
  `uid` int(10) unsigned NOT NULL default '0',
  `dateline` bigint(30) NOT NULL default '0',
  `scriptname` varchar(50) NOT NULL default '',
  `action` varchar(50) NOT NULL default '',
  `querystring` varchar(150) NOT NULL default '',
  `ipaddress` varchar(50) NOT NULL default '',
  KEY `scriptname` (`scriptname`,`action`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `cr_adminlog`
-- 

INSERT INTO `cr_adminlog` VALUES (1, 1182164571, 'index.php', 'home', '', '203.82.59.56');
INSERT INTO `cr_adminlog` VALUES (1, 1182164601, 'themes.php', 'modify', '', '203.82.59.56');
INSERT INTO `cr_adminlog` VALUES (1, 1182164614, 'themes.php', 'edit', 'tid = 2', '203.82.59.56');
INSERT INTO `cr_adminlog` VALUES (1, 1182164631, 'templates.php', 'modify', '', '203.82.59.56');
INSERT INTO `cr_adminlog` VALUES (1, 1182164637, 'templates.php', '', 'expand = -1', '203.82.59.56');

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 Mar 22, 2008 12:58 pm

The dump seems to be fine.

What about the forum prefix?
Have you set mybb_prefix to 'cr_'?

If that doesn't help, you could send me the dump so that I can have a look at it (but that way you must trust me or make the dump anonymous by copying it to another database, and delete user e-mails and passwords (Sql: UPDATE cr_users SET email = 'foo@bar.com and the same for password - you can run that from phpmyadmin) - but make sure that you don't delete them from your 'real' copy :) )

ibrar mirza
Registered User
Posts: 5
Joined: Thu Mar 20, 2008 11:50 am

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

Post by ibrar mirza » Sat Mar 22, 2008 1:22 pm

Yessssss Thanks It converted successfully... it is giving me the size of 2.69MB(phpbb2.sql) and kindly guide me the rest of the steps..... where i can find bigdump.php or what is sth..........
one thing i must say I really appreciate your help and so quick problem solving.
Thanks again for the solution
Edit: As i have installed the phpbb version under following address http://meraraabta.com/careers

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 Mar 22, 2008 2:14 pm

Most hosters have a size limit for uploading a dump. For example, you can only import dumps up to 1MB, but your dump is 3 MB. Then bigdump.php takes care of this and splits the dump in 3 parts.

But your dump is not that big, so you can try to import it at once. If it is too big try bigdump.php which you can download here.

As your MyBB dump was about 12MB and the converted dump is ~3 MB I'm curious if the conversion was really successfull. ^^ It could still be fine, though.

ibrar mirza
Registered User
Posts: 5
Joined: Thu Mar 20, 2008 11:50 am

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

Post by ibrar mirza » Sat Mar 22, 2008 2:25 pm

It took some 10 seconds after running command and gave the successful message. and it gave me 2.69MB of data with initial lines like

Code: Select all

-- phpbb2_posts
TRUNCATE TABLE `phpbb_posts`; 
INSERT INTO `phpbb_posts` ( `post_id`,`topic_id`,`forum_id`,`poster_id`,`post_time`,`poster_ip`,`post_username`,
`enable_bbcode`,`enable_html`,`enable_smilies`,`enable_sig`,`post_edit_time`,`post_edit_count`) 
VALUES ( 1, 1, 7, 2, 1182279994, '0c0adb25', 'aamir', 1, 0, 1, 1, NULL, 0);
INSERT INTO `phpbb_posts` ( `post_id`,`topic_id`,`forum_id`,`poster_id`,`post_time`,`poster_ip`,`post_username`,
`enable_bbcode`,`enable_html`,`enable_smilies`,`enable_sig`,`post_edit_time`,`post_edit_count`)
 VALUES 
( 2, 2, 7, 2, 1182280893, '0c0adb25', 'aamir', 1, 0, 1, 1, NULL, 0);
INSERT INTO `phpbb_posts` ( `post_id`,`topic_id`,`forum_id`,`poster_id`,`post_time`,`poster_ip`,`post_username`,
`enable_bbcode`,`enable_html`,`enable_smilies`,`enable_sig`,`post_edit_time`,`post_edit_count`)
 VALUES 
( 3, 3, 8, 2, 1182281564, '0c0adb25', 'aamir', 1, 0, 1, 1, NULL, 0);
INSERT INTO `phpbb_posts` ( `post_id`,`topic_id`,`forum_id`,`poster_id`,`post_time`,`poster_ip`,`post_username`,
`enable_bbcode`,`enable_html`,`enable_smilies`,`enable_sig`,`post_edit_time`,`post_edit_count`)
 VALUES
 ( 4, 4, 7, 2, 1182282275, '0c0adb25', 'aamir', 1, 0, 1, 1, NULL, 0);
INSERT INTO `phpbb_posts` ( `post_id`,`topic_id`,`forum_id`,`poster_id`,`post_time`,`poster_ip`,`post_username`,
`enable_bbcode`,`enable_html`,`enable_smilies`,`enable_sig`,`post_edit_time`,`post_edit_count`) 
VALUES
 ( 5, 5, 7, 2, 1182283393, '0c0adb25', 'aamir', 1, 0, 1, 1, NULL, 0);
INSERT INTO `phpbb_posts`
 ( `post_id`,`topic_id`,`forum_id`,`poster_id`,`post_time`,`poster_ip`,`post_username`,
`enable_bbcode`,`enable_html`,`enable_smilies`,`enable_sig`,`post_edit_time`,`post_edit_count`)
 VALUES ( 6, 6, 9, 2, 1182284231, '0c0adb25', 'aamir', 1, 0, 1, 1, NULL, 0);
INSERT INTO `phpbb_posts`
 ( `post_id`,`topic_id`,`forum_id`,`poster_id`,`post_time`,`poster_ip`,`post_username`,
`enable_bbcode`,`enable_html`,`enable_smilies`,`enable_sig`,`post_edit_time`,`post_edit_count`)
 VALUES
 ( 14, 14, 67, 2, 1182310788, '4a674ac3', 'aamir', 1, 0, 1, 1, NULL, 0);
Last edited by ibrar mirza on Sat Mar 22, 2008 3:01 pm, edited 1 time in total.

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 Mar 22, 2008 2:29 pm

Just import it to a phpbb2 forum database, then you will see if everything is ok. :)

ibrar mirza
Registered User
Posts: 5
Joined: Thu Mar 20, 2008 11:50 am

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

Post by ibrar mirza » Sat Mar 22, 2008 3:11 pm

todespudel wrote:Just import it to a phpbb2 forum database, then you will see if everything is ok. :)
I tried by both method using browse button to upload phpbb2.sql and uploaded via ftp and gave the filename in bigdump.php but same error it is giving
Error uploading file phpbb2.sql
what can be the reason let me tell you about the information i have provided in bigdump.php

Code: Select all

$db_server   = 'localhost';
$db_name     = 'dbname';// MyBB database name which is online not the database name which created the new forum installation
$db_username = 'dbuser';
$db_password = 'dbpassword';

$filename         = 'phpbb2.sql'; 
Edit: one thing that i have phpbb 3 installed on my server will it work fine??

Edit2: OH yes I installed it successfully. That was phpbb version problem now i installed 2.0.22 instead of 3 and it works fine

I really thankful to you todespudel........ You are such a nice person.. Your help was very helpful to me.. Thanks again

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 Mar 22, 2008 4:07 pm

So you can see all your posts, users etc.? I have posted sth. about upgrading to phpbb3 at page 1 of this topic.

Nice, np :)

a0309
Registered User
Posts: 7
Joined: Sat Mar 22, 2008 4:27 pm

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

Post by a0309 » Sat Mar 22, 2008 4:30 pm

Hey todespudel,

I did everything according to the instructions. I have now uploaded bigdump.php together with the .sql file to /phpbb/dump/. But when I run bigdump I get this:

Code: Select all

Error at the line 6224: INSERT INTO `phpbb3_mybb_passwords` ( `username`,`password`,`salt`,`new_pw_set`) VALUES ( 'administrator', 'f759b61526c5de9103b715bbbdb04ae0', 'ijc9WMqQ', 0);

Query: INSERT INTO `phpbb3_mybb_passwords` ( `username`,`password`,`salt`,`new_pw_set`) VALUES ( 'administrator', 'f759b61526c5de9103b715bbbdb04ae0', 'ijc9WMqQ', 0);

MySQL: Table 'db0030421.phpbb3_mybb_passwords' doesn't exist
Any ideas?

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 Mar 22, 2008 4:42 pm

Yeah, one more (small) bug found ;)

Now you have two options:
1. Download the new version of the script and run it again.

2. Create the specified table yourself:
phpmyadmin->select the right database->SQL->insert the following command:

Code: Select all

'CREATE TABLE `phpbb3_mybb_passwords` (`username` varchar(25) NOT NULL, `password` varchar(120) NOT NULL, `salt` varchar(10) NOT NULL, `new_pw_set` tinyint(1) NOT NULL default '0' );
Reimport phpbb2.sql.

Locked

Return to “[2.0.x] Convertors”