Running into this error message on the InvisionBoard converter:
ipb.php error message:
Importing blocked words
Done: Importing 0 blocked words
Importing forum members
Done: Importing 11175 IPB members
Importing buddies/ignored users
Done: Importing 5 buddies and 1 ignored users
Importing member ranks
Done: Importing 0 member ranks
Importing categories
Done: Importing 10 categories
Importing forums
Done: Importing 71 forums
Importing permissions
(ipb.php) 1054: Unknown column 'up_file' in 'where clause'
Query: SELECT id FROM fud25_groups WHERE forum_id=up_file
Server Version: 3.23.55-log
I've looked at the code, but don't see anything wrong with the syntax of the key/value assignments that are occurring:
print_msg("Importing permissions");
$r = mysql_query("SELECT count(*), mgroup FROM {$ipb}members WHERE mgroup NOT IN({$INFO['admin_group']}, {$INFO['auth_group']}, {$INFO['member_group']}, {$INFO['guest_group']}) GROUP BY mgroup", $ib) or die(mysql_error($ib));
while (list(, $g) = mysql_fetch_row($r)) {
if (!isset($ib_g[$g])) {
continue;
}
/* list of members for a particular group */
$users = array();
$r2 = mysql_query("SELECT id FROM {$ipb}members WHERE mgroup=".$g);
while (list($id) = mysql_fetch_row($r2)) {
$users[] = $id;
}
mysql_free_result($r2);
foreach ($ib_g[$g] as $fl) {
foreach ($fl as $k => $v) {
$gid = q_singleval("SELECT id FROM {$DBHOST_TBL_PREFIX}groups WHERE forum_id=".$k);
$perms = array_change_key_case(db_arr_assoc("SELECT * FROM {$DBHOST_TBL_PREFIX}group_members WHERE group_id={$gid} AND user_id=0"));
unset($perms['id'], $perms['user_id'], $perms['group_id']);
$fields = implode(',', array_keys($perms));
foreach ($v as $pt => $p) {
$perms[$pt] = $p;
}
$data = "'" . implode("', '", $perms);
foreach ($users as $u) {
q("INSERT INTO {$DBHOST_TBL_PREFIX}group_members {$fields} VALUES({$u}, {$gid}, {$data})");
}
}
}
}