I filled in the config file with the details of my Joomla database & password.
I'm getting the following error. please Help:

[code:1]Connecting to Database... OK
Populating Categories...
Invalid query:
INSERT INTO jos_fb_categories (id,parent,name,cat_emoticon,locked,alert_admin,moderated,moderators,pub_access,pub_recurse,admin_access,admin_recurse,ordering,future2,published,checked_out,checked_out_time,review,hits,description) SELECT cat_id + 500, 0, cat_title, 0, 0, 0, 0, NULL, 0, 0, 0, 0, cat_order, 0, 1, 0, '0000-00-00 00:00:00', 0, 0, '' FROM phpbb_categories ORDER BY cat_order
Table 'omsakthi_joomla.phpbb_categories' doesn't exist[/code:1]


Or do i use the PHPBB2 database user & password in the config file?
I dont want to do anything to stuff up my current PHPBB2 database.

Ok, i made some progress....lol

All the posts and categories stuff got converted. However it doesn't say which user posted which post.

Now it says this:

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

Hey there!

Can you please share your conversion script?
The one that was posted here is no longer available.

Once I get my hands on it, I can take a look and see if it needs any updating.

Thanks!
Chumly

Heres the conversion script i used.

It would be great if u could work out why the USERs weren't converted.

Thank you for looking Chumly! My queries to the makers of the previous scripts went unanswered, so I am stuck on this too.

Basically when I run the script, it seems to time out. When I look at my database, all of the content and catagories seems to be transferred, but no users or associations with the content come across. So everything seems to work except the user transfer. Otherwise Fireboard works as expected. I tried for hours to figure it out, in the end I just dont know PHP well enough to do any more, I think it is just a problem with the code. Seemed like someone fixed it before but the last version is no longer hosted...

Not to b!tch too much, just seems odd that there isnt more support for transferring from PHPBB given how many admins use it. Anyway, let me know if there is anything I can do or tell you that might help figure this out!

-Breach

This is wat i think is wrong:
I did a Search through the PHPBB2 Tables using phpmyadmin, Theres no "group_id"

Theres two instances in the code where "group_id" is used. It would need to replaced with the correct one.
I don't really know php @ all, i'm just using common sense.

Herez the 1st instance:
(This is the point of the code where the script returns an error)

[code:1]// Get the group id: S for regular users and administrators in Mambo.
$query = "SELECT group_id FROM {$mosConfig_dbprefix}core_acl_aro_groups WHERE name='Registered' OR name='Administrator' ORDER BY name ASC";
$result = mysql_query($query) or die("Invalid query:$query" . mysql_error());
$admingid = mysql_result( $result, 0, 0 );
$usergid = mysql_result( $result, 1, 0 );
[/code:1]


Here's the 2nd instance where group_id will need to be replaced:

[code:1]// Add user to core acl groups map
$query = "INSERT INTO {$mosConfig_dbprefix}core_acl_groups_aro_map ( group_id, aro_id ) VALUES ( $gid, $newuserid )";
mysql_query($query) or die("Invalid query:$query" . mysql_error());[/code:1]

(Warning: Johnny-come-lately post)

I haven't taken a look at that script closely (don't really know php anyway), but I can tell you that there is a group_id column in the table called jos_core_acl_aro_groups. In fact, it's the primary key. The column/field is also in the second table (mentioned above). Look at the table definitions I took from joomla.sql. This file is in your installation folder for joomla.

[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;

#
# Table structure for table `#__core_acl_groups_aro_map`
#
CREATE TABLE `#__core_acl_groups_aro_map` (
`group_id` int(11) NOT NULL default '0',
`section_value` varchar(240) NOT NULL default '',
`aro_id` int(11) NOT NULL default '0',
UNIQUE KEY `group_id_aro_id_groups_aro_map` (`group_id`,`section_value`,`aro_id`)
) TYPE=MyISAM;
[/code:1]

Here's my understanding of the tables you need to worry about when transferring your users.

[ul][li][b]jos_users[/b] this stores usernames, passwords, emails, etc., for joomla. I believe the [i]group_id[/i] needs to be specified for each user here. At least, that's what I did. When I did my conversion, I made everyone's [i]gid[/i]=18 (except for admins who were [i]gid[/i]=24).[/li]
[li][b]jos_fb_users[/b]: this stores the forum settings for each user, and there must be a row in the [i]jos_users[/i] table for every row in the [i]jos_fb_users[/i] table.[/li]
[li][b]jos_core_acl_aro[/b] this stores the [i]aro id[/i] that correspond to each [i]id[/i] in [i]jos_users[/i]. For every row in [i]jos_users[/i], you need a row in [i]jos_core_acl_aro[/i].[/li]
[li][b]jos_core_acl_groups_aro_map[/b]: this maps [i]group_id[/i] to [i]aro id[/i]. For every row in [i]jos_core_acl_aro[/i], you need a row in [i]jos_core_acl_groups_aro_map[/i].[/li][/ul]

I'm working on a conversion script of my own, and what I learned is that you have to transfer users into four of the tables in your database: [i]jos_users, jos_fb_users, jos_core_acl_aro, and jos_core_acl_groups_aro_map[/i] (users of community builder need data transferred to a fifth table called [i]jos_comprofiler[/i]). I didn't touch [i]jos_core_acl_aro_groups[/i] in my own conversion. I just transferred all of my users as registered or admins in [i]jos_users[/i] and created corresponding rows as described in the list above.

Did I miss something about the groups? I lost all of my groups for my forums because I didn't think Fireboard supported them. (Also, I thought the groups were locked down, so to speak, in Joomla.) I thought we had to go the GroupJive route to recover some of the forum access control we had in phpbb. The fact that your script is messing with one of these tables makes me think I've missed something.

Heres a working version. I hired a Guy to fix it.


www.bestofjoomla.com/component/option,co...id,6/id,32376/#32376