More Trouble! UBB Members Import Problem

[Morgo]

After sorting out step 3 of the install, everything went smoothly and the database was created perfectly.

Now I have walked into the next stumbling block...trying to import UBB members. I have looked through the previous posts on this forum regarding this situation but have found them not to have been of much use. This is the email I get when I try to import my members (only about 2600):

Database error in vBulletin Control Panel: Invalid SQL: SELECT title FROM usertitle WHERE minposts<= ORDER BY minposts DESC LIMIT 1
mysql error: You have an error in your SQL syntax near 'ORDER BY minposts DESC LIMIT 1' at line 1
mysql error number: 1064
Date: Wednesday 24th of May 2000 11:37:50 AM
Script: /forums/admin/import.php
Referer:

I have tried varying the number of members for the import procedure to process at once from 1 up to 2000, but with no joy.

When I check out the users that have been successfully imported I find that my user name (the first registered member from the UBB) has been replicated about 10 times, while everyone else seems to be fine. Making a guess here, but would the fact that my user name was the admin on the previous UBB, be causing a hiccup on the vB where the same name is admin?

Im on a virtual server (as stated in a previous message) so I don't have much choice when it comes to configuring the server.

Any hints anyone? I sent John an email, but that was only a couple of hours ago - so understandably hasn't had time to respond. Perhaps you guys have some idea what I can do?

[Edited by Morgo on 05-24-2000 at 04:07 PM]

[Greg]

Hmm...did taking admin power away from your UBB username and then trying to import it help?

[John]

This is a known bug, and fixed in the next version. If you would like to make the change yourself, please replace the first 30 lines of import.php with this code:


<?

if (function_exists("set_time_limit")==1 and get_cfg_var("safe_mode")==0) {
set_time_limit(1200);
}

require("global.php");

function getuserinfo($userid) {
global $ubbmembersdir;
$userinfos=file("$ubbmembersdir/$userid.cgi");

$userinfo[username]=trim($userinfos[0]);
$userinfo[password]=trim($userinfos[1]);
$userinfo[email]=trim($userinfos[2]);
$userinfo[url]=trim($userinfos[3]);
$userinfo[permissions]=trim($userinfos[4]);
$userinfo[job]=trim($userinfos[5]);
$userinfo[country]=trim($userinfos[6]);
$userinfo[posts]=intval(trim($userinfos[7]));
$userinfo[status]=trim($userinfos[8]);
$userinfo[interests]=trim($userinfos[9]);
$userinfo[datejoined]=trim($userinfos[10]);
$userinfo[showemail]=trim($userinfos[11]);
$userinfo[signature]=trim($userinfos[12]);
$userinfo[icq]=trim($userinfos[13]);
$userinfo[allowmail]=trim($userinfos[14]);
return $userinfo;

}


John