1.1.1 UBB Import problem

[Herb]

While importing UBB I get through everything up to the point of importing the posts..

I choose to do a mass import, cycle rate 200..

Next screen says..

Doing forum 1. This could take a while - it can do at least 200 threads per minute on my test server

Doing threads threads 0 to 200

Doing thread Another Test
Warning: Failed to Connect in db_mysql.php on line 128

There seems to have been a slight problem with the database. Please try again by pressing the refresh button in your browser.

An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.

We apologise for any inconvenience.

Any ideas?

[John]

Hmmm. It should have sent you an email - could you forward that to me, or post it here.

John

[Herb]

sorry I did not get an email either..

[John]

OK - when you get that error, view the HTML source of that page. Embedded in comment tags should be the error. Please post that.

John

[Herb]

John,

I setup my test box to work with the mail function.. So.... You have mail..

[John]

Hmmm. What version of MySQL are you running?

John

[Herb]

3.21.29 win32

Keep in mind 1.1.0 of vBulletin did not do this..

[Herb]

So whats up fella's?

There sure does seem to be alot of problems with the import in this version.. How much did you guys change it? It worked fine in 1.1.0 minus the nutscrape Javascript errors, which I still get with 1.1.1

[John]

That would explain it then. That is a very old version, and I would recommend that you download a newer version. If this is not possible, find these lines in import.php (line 712)


if ($query=="") {
$query="INSERT INTO post (postid,threadid,username,userid,title,dateline,pa getext,allowsmilie,email,signature,ipaddress,iconi d,visible) VALUES (NULL,$threadid,'".addslashes($postusername)."',$userid,'',$dateline,'".addslashes($postmessage)."',1,$threadnotify,0,'".addslashes($ipaddress)."',$iconid,1)";
} else {
$query.=",(NULL,$threadid,'".addslashes($postusername)."',$userid,'',$dateline,'".addslashes($postmessage)."',1,$threadnotify,0,'".addslashes($ipaddress)."',$iconid,1)";
}
} // if postval!=""
} // while each post

$DB_site->query($query);


and replace with this:


$DB_site->query("INSERT INTO post (postid,threadid,username,userid,title,dateline,pa getext,allowsmilie,email,signature,ipaddress,iconi d,visible) VALUES (NULL,$threadid,'".addslashes($postusername)."',$userid,'',$dateline,'".addslashes($postmessage)."',1,$threadnotify,0,'".addslashes($ipaddress)."',$iconid,1)");
} // if postval!=""
} // while each post



John

[Herb]

I upgraded as suggested and all went well.. Thanks for all your help John.. The latest version adds more features as well, so it was a good thing.. ;)

ps.. still getting the jscript errors on the import with netscape 4.x.. I just used ie and all went smooth..

Thanks..