UBB.threads PHP Forum Software Community Forums UBB.threads 7 Importer Support 6.7 importer crashing on older posts

This is what happens...it's on older posts...any suggestions?

Importing threads from UBB.classic™ Forum number 1, 1 of 17 total to be imported.

Continuing the import of "new SoBes..."
Importing " " (-1 replies)
Script: <path removed>\classic_import.php
Line#: 1266
SQL Error: Out of range value adjusted for column 'POST_POSTED_TIME' at row 1
SQL Error #: 1264
Query: INSERT INTO ubbt_POSTS (POST_PARENT_ID,TOPIC_ID,POST_IS_TOPIC,POST_POSTED_TIME,POST_POSTER_IP,POST_SUBJECT,POST_BODY,POST_DEFAULT_BODY, POST_ICON,POST_IS_MEMBER_POST,USER_ID,POST_ADD_SIGNATURE) VALUES ( 0 , 47 , 1 , '' , '' , '\r\n' , '' , '' , 'book.gif' , 0 , 1 , 1 )

First thing, make sure you rebuild all of the meta data files before trying to import. The second, the error itself comes from MySQL 5's default strict mode. The post itself might be corrupt because it doesn't seem to contain any data, but you can try running the following SQL command from something like phpmyadmin before the import to disable the strict mode for mysql 5 and see if that helps:

SET GLOBAL SQL_MODE=”;

OK, did both of those things (I had already been doing the rebuild before importing).

Anyway, now the import runs forever...Literally let it run for 2 days. It always gets to the point where I have 826 messages in one of the forums, and then vague warning messages (see below) keep displaying...Any suggestions?

Importing threads from UBB.classic™ Forum number 1, 1 of 12 total to be imported.

Continuing the import of " "

Continuing... (please wait)
(classic_import.php?ubb=posts&forum=1&topic=45&post=32442&first_post=0&thistopic=46&thispost=33267#bottom)
Generated in 1.2390 seconds in which 0.014 seconds were spent on a total of 208 queries.
eter 1 to be long, string given in c:\inetpub\wwwroot\forums\importers\classic_import.php on line 2164 PHP Warning: mktime() expects parameter 1 to be long, string given in c:\inetpub\wwwroot\forums\importers\classic_import.php on line 2164 PHP Warning: mktime() expects parameter 1 to be long, string given in c:\inetpub\wwwroot\forums\importers\classic_import.php on line 2164 PHP Warning: mktime() expects parameter 1 to be long, string given in c:\inetpub\wwwroot\forums\importers\classic_import.php on line 2164 PHP Warning: mktime() expects parameter 1 to be long, string given in c:\inetpub\wwwroot\forums\importers\classic_import.php on line 2164 PHP Warning: mktime() expects parameter 1 to be long, string given in c:\inetpub\wwwroot\forums\importers\classic_import.php on line 2164 PHP Warning: mktime() expects parameter 1 to be long, string given in c:\inetpub\wwwroot\forums\importers\classic_import.php on line 2164 PHP Warning: mktime() expects parameter 1 to be long, string given in c:\inetpub\wwwroot\forums\importers\classic_import.php on line 2164 PHP Warning: mktime() expects parameter 1 to be long, string given in c:\inetpub\wwwroot\forums\importers\classic_import.php on line 2164 PHP Warning: mktime() expects parameter 1 to be long, string given in c:\inetpub\wwwroot\forums\importers\classic_import.php on line 2164 PHP Warning: mktime() expects parameter 1 to be long, string given in c:\inetpub\wwwroot\forums\importers\classic_import.php on line 2164 PHP Warning: mktime() expects parameter 1 to be long, string given in c:\inetpub\wwwroot\forums\importers\classic_import.php on line 2164 PHP Warning: mktime() expects parameter 1 to be long, string given in c:\inetpub\wwwroot\forums\importers\classic_import.php on line 2164 PHP Warning: mktime() expects parameter 1 to be long, string given in c:\inetpub\wwwroot\forums\importers\classic_import.php on line 2164 PHP Warning: mktime() expects parameter 1 to be long, string given in c:\inetpub\wwwroot\forums\importers\classic_import.php on line 2164 PHP Warning: mktime() expects parameter 1 to be long, string given in c:\inetpub\wwwroot\forums\importers\classic_import.php on line 2164 PHP Warning: mktime() expects parameter 1 to be long, string given in c:\inetpub\wwwroot\forums\importers\classic_import.php on line 2164 PHP Warning: mktime() expects parameter 1 to be long, string given in c:\inetpub\wwwroot\forums\importers\classic_import.php on line 2164 PHP Warning: mktime() expects parameter 1 to be long, string given in c:\inetpub\wwwroot\forums\importers\classic_import.php on line 2164 PHP Warning: mktime() expects parameter 1 to be long, string given in c:\inetpub\wwwroot\forums\importers\classic_import.php on line 2164 PHP Warning: mktime() expects parameter 1 to be long, string given in c:\inetpub\wwwroot\forums\importers\classic_import.php on line 2164 PHP Warning: mktime() expects parameter 1 to be long, string given in c:\inetpub\wwwroot\forums\importers\classic_import.php on line 2164

It's hard to say, but it definitely looks like the data being parsed isn't what it's expected to be. What version of UBB.classic are you importing from?

6.7.1...This board has been through a couple of upgrades though. Thanks in advance.

It looks like it's getting hung up on a corrupt topic. Especially where you're not seeing a topic subject in this:

Continuing the import of " "

Might need you to open a support ticket so I can take a look at a couple things on the server.