problem with import from phpBB2
select user_id, group_id from BBoard_users
select user_id, group_id from BBoard_user_group where user_pending = 0;
Notice: Unknown column 'group_id' in 'field list' in /home/siriushr/public_html/forum/vanilla2export.php on line 1151
There is no group_id in phpBB2 BBoard_users table ... And looking through the DB table in question BBoard_user_group there are no users that have user_pending field set to anything but zero.
This is the original query.
$Ex->ExportTable('UserRole', 'select user_id, group_id from :_users union select user_id, group_id from :_user_group where user_pending = 0', $UserRole_Map);
So the question is this... Is this gonna work ?
$Ex->ExportTable('UserRole', 'select u.user_id, g.group_id from :_users u join :_user_group ug on ug.user_id = u.user_id right join :_groups g on ug.group_id = g.group_id', $UserRole_Map);