Just curious. How do you convert a photo album, to Fireboard when FB has no such add-on? I think the more customized you need these conversion scripts to be the more likely it is that you may need to have a professional write a custom converter for you.

I think the scope of the discussion has grown beyond phpbb to fireboard to include joomla + extensions. I was just trying to get some more information from him to see if it was something easy to add to my the conversion utility that I'm creating.

Im having some problems!
Im getting this.

Code:

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 'db97771.phpbb_categories' doesn't exist

What is wrong?

This.
Table 'db97771.phpbb_categories' doesn't exist

Also
Keep in mind that both Joomla & PHPBB2 tables need to be in the Same database.

Not saying that this is your issue but I thought it might be a cause of your problems.

xCav8r wrote:
kangt7 wrote:
The programmers there will write custom fix the script for you in a day according to your databases. It would cost you anywhere between $20 - $80 USD. Obviously you have to pay more for an experienced programmer.

Alternatively, if you don't have to have it today, you can wait for me to finish my free script. I've already successfully converted my database from phpnuke with phpbb integrated to Joomla with Fireboard and Community Builder. I have a stand-alone phpbb forum (in SQL Server 2000) that I'm adding to the Joomla installation, and next I'm adding yahoo groups to the mix. I'm doing this all largely for myself, because I'm combining three disparate sites together, but I'm happy to share the fruits of my labor if someone else can benefit. It's just something I'm working on in my free time, so I'm not promising it for tomorrow, but it will be done soon (I'm not adding any new features so I get it done.)

Of course, if this script you paid to have modified is working or others are finding it easy to use to convert their databases, even better. Mine will just be another option.

Yeah hopefully we can get a Solid stable PHPBB 2.22 Converter to Fireboard that works as most people use PHPBB and seems essential to have this as it would get many more people to switch to Fireboard..

Seems there is good progress being made but would be nice if someone from the team here could help on this and release a solid converter..

we be watching this topic closely..

I have PhpBB 3. Anyone got succesfully converted v.3 to FB??

HI.

I just redid the whole conversion, but alas..
I still get the:

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'

Now I have decided to leave the old album gallery, and just continue with the new fb...

but I still need to import the whole of phpbb2..

any ideas what's causing this error?

I checked the table. and that seems fine:

DROP TABLE IF EXISTS `jos_core_acl_aro_groups`;
CREATE TABLE IF NOT EXISTS `jos_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 `jos_gacl_parent_id_aro_groups` (`parent_id`),
KEY `jos_gacl_lft_rgt_aro_groups` (`lft`,`rgt`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=31 ;

That's the same definition I have for my jos_core_acl_aro_groups table. I'd need to see the php where the error happened to know specifically what it's looking for. Without knowing more details, I'd guess it's looking for group_id, which is the primary key.

symbiot wrote:

SELECT id FROM jos_core_acl_aro_groups WHERE name='Registered' OR name='Administrator' ORDER BY name ASC
Unknown column 'id' in 'field list'

DROP TABLE IF EXISTS `jos_core_acl_aro_groups`;
CREATE TABLE IF NOT EXISTS `jos_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 `jos_gacl_parent_id_aro_groups` (`parent_id`),
KEY `jos_gacl_lft_rgt_aro_groups` (`lft`,`rgt`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=31 ;

Modify the query above and replace 'id' with 'group_id' - that should do the trick.

I hadn't been willing to say that without seeing the php script, but he sound like he knows where in the script you got this error and what the script wants to do with it, so go for it!