Hey Jerry,
Importing went fine but i have a little problem with the PM import.
That's what i get:
Fatal error: Call to undefined function: get_phpbb2_pm_text() in XXX\pago2\impex\systems\thwboard\009.php on line 154
Now i have added
to 000.php and changed the function in 009.php.
It seems to work
Now there's another problem. The PM were not imported. Any chance to import just them? Normally i would have to re-import the users to do so (impex tells me) but iam afraid i'll loose my users
Next problem: all my users went to the guest usergroup twice. Once as the primary usergroup and as the secondary usergroup. How can i remove all 101 user from that additional usergroup? Is there some sort of query which makes it easy?!
I used Prune / Move Users do move them to another primary usergroup but that doesn't work for additional usergroups.
edit:
The problem is even worse
I get the following error when i try to edit a user:
Importing went fine but i have a little problem with the PM import.
That's what i get:
Fatal error: Call to undefined function: get_phpbb2_pm_text() in XXX\pago2\impex\systems\thwboard\009.php on line 154
Now i have added
PHP Code:
/**
* Returns the pm text
*
* @param object databaseobject The database object to run the query against
* @param string mixed Table database type
* @param string mixed The prefix to the table name i.e. 'vb3_'
* @param int mixed pm id
*
* @return array
*/
function get_thwboard_pm_text(&$DB_object, &$database_type, &$table_prefix, &$pm_id)
{
if ($database_type == 'mysql')
{
$sql = "
SELECT * FROM " .
$table_prefix."pm
WHERE pmid ='" . $pm_id ."'"
;
$pms = $DB_object->query_first($sql);
return $pms;
}
else
{
return false;
}
return $return_array;
}
It seems to work

Now there's another problem. The PM were not imported. Any chance to import just them? Normally i would have to re-import the users to do so (impex tells me) but iam afraid i'll loose my users

Next problem: all my users went to the guest usergroup twice. Once as the primary usergroup and as the secondary usergroup. How can i remove all 101 user from that additional usergroup? Is there some sort of query which makes it easy?!
I used Prune / Move Users do move them to another primary usergroup but that doesn't work for additional usergroups.
edit:
The problem is even worse

I get the following error when i try to edit a user:
Database error in vBulletin 3.0.2:
Invalid SQL: SELECT title, usergroupid FROM usergroup WHERE usergroupid IN (2,,1,) ORDER BY title
mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '1,) ORDER BY title' at line 1
mysql error number: 1064
Date: Sunday 04th of July 2004 02:42:28 PM
Script: XXX/pago2/admincp/user.php?s=&do=edit&userid=11
Referer:
Username: d.Hahn
IP Address: XXX.168.XXX.XXX
Invalid SQL: SELECT title, usergroupid FROM usergroup WHERE usergroupid IN (2,,1,) ORDER BY title
mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '1,) ORDER BY title' at line 1
mysql error number: 1064
Date: Sunday 04th of July 2004 02:42:28 PM
Script: XXX/pago2/admincp/user.php?s=&do=edit&userid=11
Referer:
Username: d.Hahn
IP Address: XXX.168.XXX.XXX
Comment