After looking for weeks trying to fix it myself. I Hired a PHP programmer from \"www.scriptlance.com\" to fix the one found on this forum. Set me $75 USD but it was worth it.

Here is the conversion details from my test forum.

[code:1]Importing data from phpBB2
Connecting to Database... OK
Populating Categories... OK
Populating Messages Table... OK
Populating Messages_Text Table... OK
Populating Users Table... omsakthi: 63 - NEW sakthi_yugam: 64 - NEW Thiruma: 65 - NEW Sakthi: 66 - NEW Thumby: 67 - NEW Gauthamy: 68 - NEW Amman disciple: 69 - NEW OhmSakthi: 70 - NEW suren: 71 - NEW Sutha!!: 72 - NEW sakthi_01: 73 - NEW Sangi: 74 - NEW Sakthi Mayam: 75 - NEW Adharvana Pathirakali: 76 - NEW thondan: 77 - NEW sakthiademi: 78 - NEW SakthiPraba: 79 - NEW anukaruna: 80 - NEW Sakthi.B: 81 - NEW Gurudhasan: 82 - NEW sakthivel_dv: 83 - NEW sakthiveldv: 84 - NEW rajan: 85 - NEW kkiree: 86 - NEW harish: 87 - NEW sakthisarguna: 88 - NEW sakthiom: 89 - NEW aanma: 90 - NEW toxic_forever: 91 - NEW balanarayan: 92 - NEW K. Sankarapapavinasam: 93 - NEW Rameshsx: 94 - NEW puven85: 95 - NEW Prema: 96 - NEW sakthidaasan: 97 - NEW Gayathri: 98 - NEW RaM.A.kA.Me =D: 99 - NEW neetha: 100 - NEW sakthi_oli: 101 - NEW jaya_srikanth: 102 - NEW aishkumar: 103 - NEW sakthinagaraj: 104 - NEW Rajaram: 105 - NEW dattaswami: 106 - NEW ramadurai: 107 - NEW JOTHI: 108 - NEW srigowri: 109 - NEW amir: 110 - NEW rumeskanna: 111 - NEW viji: 112 - NEW Sakthi vijaya kumar.B: 113 - NEW OK
Complete...[/code:1]

Keep in mind that both Joomla & PHPBB2 tables need to be in the Same database.
Open up the attached php file. And fill in the details. AND ENJOY

-------------Config---------------------*/

//MySQL Database host - usually \'localhost\'
$host=\'localhost\';

//MySQL Database user
$user=\'root\';

//MySQL Database password
$pass=\'enter password here\';

//MySQL Database name
$db=\'enter username here\';

// Mambo database prefix
$mosConfig_dbprefix = \"jos_\";

// phpBB2 database prefix
$phpbb_dbprefix = \"phpbb_\";

/* ---------------------------------------*/

After looking for weeks trying to fix it myself. I Hired a PHP programmer from \"www.scriptlance.com\" to fix the one found on this forum. Set me $75 USD but it was worth it.

Here is the conversion details from my test forum.

[code:1]Importing data from phpBB2
Connecting to Database... OK
Populating Categories... OK
Populating Messages Table... OK
Populating Messages_Text Table... OK
Populating Users Table... omsakthi: 63 - NEW sakthi_yugam: 64 - NEW Thiruma: 65 - NEW Sakthi: 66 - NEW Thumby: 67 - NEW Gauthamy: 68 - NEW Amman disciple: 69 - NEW OhmSakthi: 70 - NEW suren: 71 - NEW Sutha!!: 72 - NEW sakthi_01: 73 - NEW Sangi: 74 - NEW Sakthi Mayam: 75 - NEW Adharvana Pathirakali: 76 - NEW thondan: 77 - NEW sakthiademi: 78 - NEW SakthiPraba: 79 - NEW anukaruna: 80 - NEW Sakthi.B: 81 - NEW Gurudhasan: 82 - NEW sakthivel_dv: 83 - NEW sakthiveldv: 84 - NEW rajan: 85 - NEW kkiree: 86 - NEW harish: 87 - NEW sakthisarguna: 88 - NEW sakthiom: 89 - NEW aanma: 90 - NEW toxic_forever: 91 - NEW balanarayan: 92 - NEW K. Sankarapapavinasam: 93 - NEW Rameshsx: 94 - NEW puven85: 95 - NEW Prema: 96 - NEW sakthidaasan: 97 - NEW Gayathri: 98 - NEW RaM.A.kA.Me =D: 99 - NEW neetha: 100 - NEW sakthi_oli: 101 - NEW jaya_srikanth: 102 - NEW aishkumar: 103 - NEW sakthinagaraj: 104 - NEW Rajaram: 105 - NEW dattaswami: 106 - NEW ramadurai: 107 - NEW JOTHI: 108 - NEW srigowri: 109 - NEW amir: 110 - NEW rumeskanna: 111 - NEW viji: 112 - NEW Sakthi vijaya kumar.B: 113 - NEW OK
Complete...[/code:1]

Keep in mind that both Joomla & PHPBB2 tables need to be in the Same database.
Open up the attached php file. And fill in the details. AND ENJOY

-------------Config---------------------*/

//MySQL Database host - usually \'localhost\'
$host=\'localhost\';

//MySQL Database user
$user=\'root\';

//MySQL Database password
$pass=\'enter password here\';

//MySQL Database name
$db=\'enter username here\';

// Mambo database prefix
$mosConfig_dbprefix = \"jos_\";

// phpBB2 database prefix
$phpbb_dbprefix = \"phpbb_\";

/* ---------------------------------------*/

LoL...I forgot to attach it!

Here it is [file name=phpbb2fb-28fd40c4226b68488a0ad611ec944798.zip size=4078]http://fireboard.bestofjoomla.com/images/fbfiles/files/phpbb2fb-28fd40c4226b68488a0ad611ec944798.zip[/file]

Nice, kangt7. Thank you for sharing!!!!

crap.. I get;

Connecting to Database... OK
Populating Categories... OK
Populating Messages Table... OK
Populating Messages_Text Table... OK
Populating Users Table...
Invalid query:
SELECT id FROM jos_core_acl_aro_groups WHERE name=\'Registered\' OR name=\'Administrator\' ORDER BY name ASC
Unknown column \'id\' in \'field list\'

Hi.
well. . it imported phpbb even though there is an error..

but what about images.. I have an imagegallery where users can upload images to use in their posts..
how can I migrate those?

sorry for the apparent diffucult question.

Edit:
I don\'t think the scripts take into account any SMF add-ons. Might wanna hit up Scriptlance.

[b]symbiot wrote:[/b]
[quote]crap.. I get;

Connecting to Database... OK
Populating Categories... OK
Populating Messages Table... OK
Populating Messages_Text Table... OK
Populating Users Table...
Invalid query:
SELECT id FROM jos_core_acl_aro_groups WHERE name=\'Registered\' OR name=\'Administrator\' ORDER BY name ASC
Unknown column \'id\' in \'field list\'[/quote]

I believe this should be group_id. See below.

[code:1]#
# Table structure for table `#__core_acl_aro_groups`
#
CREATE TABLE `#__core_acl_aro_groups` (
`group_id` int(11) NOT NULL auto_increment,
`parent_id` int(11) NOT NULL default \'0\',
`name` varchar(255) NOT NULL default \'\',
`lft` int(11) NOT NULL default \'0\',
`rgt` int(11) NOT NULL default \'0\',
PRIMARY KEY (`group_id`),
KEY `parent_id_aro_groups` (`parent_id`),
KEY `#__gacl_parent_id_aro_groups` (`parent_id`),
KEY `#__gacl_lft_rgt_aro_groups` (`lft`,`rgt`)
) TYPE=MyISAM;[/code:1]

[b]symbiot wrote:[/b]
[quote]Hi.
well. . it imported phpbb even though there is an error..

but what about images.. I have an imagegallery where users can upload images to use in their posts..
how can I migrate those?

sorry for the apparent diffucult question.[/quote]

This must be from a mod. I don\'t see anything in my standard phpbb tables that point to images outside of phpbb_ranks and phpbb_smilies.

Hey,

I\'ve tested it twice it works perfectly!
I cant see why it doesn\'t work for you guys....

These are the steps i followed.
my phpBB2 & Joomla Tables are in different databases. so...

1) I dumped the phpBB2 tables on to my comp.
2) installed Joomla on another database.
3) imported the phpBB2 tables in to the joomla database
4) installed fireboard.
5) Ran the script.

I\'m running phpBB2 with \"Extreme styles Mod\" I wonder if that makes a difference.

I Gave the guy from \"www.scriptlance.com\" access to my databases and he pretty much made it for me within 12 hours.