Ok all,
Here is the answer..
I installed FB yesterday and had the same problem as you. Then I read the code and found out why this is happening..
1st. This script will not work if you had phpbb already installed on a working joomla site if you used a phpbb_Bridge.
What happens is the phpbb dosnt share the same user id as the JOOMLA user ID.
To fix this error
*********************************************
SELECT id FROM jos_core_acl_aro_groups WHERE name='Registered' OR name='Administrator' ORDER BY name ASC
Unknown column 'id' in 'field list'
*********************************************
Go To about line 185
and find this
---------------------------------------------
// Get the group id
for regular users and administrators in Mambo.
$query = "SELECT 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 );
------------------------------------------------
And you want to do is change the line 1 in the $query
$query = "SELECT $query = "SELECT group_id FROM {$mosConfig_dbprefix}core_acl_aro_groups WHERE name='Registered' OR name='Administrator' ORDER BY name ASC";
Changing id to => group_id
--------------------------------------------------
This will populate your tables and transfer forums... HOWEVER..
As there will be more then likly errors with 2 user id's being the same "phpbb id" and "Joomla id" because this script is trying to merge two completely deffernt types of id's/
To fix this...
*****************************************************************************
//MySQL Database host - usually 'localhost'
$host='localhost';
//MySQL Database user
$user='you-database-username';
//MySQL Database password
$pass='users-password';
//MySQL Database name
$db='name-of-database';
// Mambo database prefix
$mosConfig_dbprefix = "jos_";
// phpBB2 database prefix
$phpbb_dbprefix = "phpbb_";
/* ---------------------------------------*/
ini_set("magic_quotes_gpc", "1"
;
set_magic_quotes_runtime ( 0 );
echo
Favoured: 0
