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.
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
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');
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);
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 givingtodespudel wrote:Just import it to a phpbb2 forum database, then you will see if everything is ok.
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';
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
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' );