Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBWiki.com
Who's Online
1 registered (SteveS), 29 Guests and 14 Spiders online.
Key: Admin, Global Mod, Mod
Featured Member
Registered: 06/05/06
Posts: 105
Top Posters (30 Days)
Ruben 49
Gizmo 24
DennyP 24
Dunny 17
SteveS 14
AllenAyres 12
dbremer 10
drkknght00 9
SD 9
driv 8
Latest Photos
OK Corral Shoot Out
Testing
Basildon Train Station
Basildon Town Centre looking from the rounderbout
Basildon Town Square
Topic Options
#170243 - 12/13/06 05:21 PM 6.7 importer crashing on older posts
coleslaw Offline
stranger
Registered: 12/13/06
Posts: 4
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 )
Top
Express Hosting
Express Hosting "We are the official hosting company of UBB.threads. Ask us about our free migration services to migrate your UBB.threads installation."
#170244 - 12/13/06 06:17 PM Re: 6.7 importer crashing on older posts [Re: coleslaw]
Rick Offline
Post-a-holic
Registered: 06/04/06
Posts: 10164
Loc: Aberdeen, WA
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=”;
Top
#170334 - 12/15/06 11:03 AM Re: 6.7 importer crashing on older posts [Re: Rick]
coleslaw Offline
stranger
Registered: 12/13/06
Posts: 4
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
Top
#170337 - 12/15/06 11:54 AM Re: 6.7 importer crashing on older posts [Re: coleslaw]
Rick Offline
Post-a-holic
Registered: 06/04/06
Posts: 10164
Loc: Aberdeen, WA
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?
Top
#170338 - 12/15/06 01:21 PM Re: 6.7 importer crashing on older posts [Re: Rick]
coleslaw Offline
stranger
Registered: 12/13/06
Posts: 4
6.7.1...This board has been through a couple of upgrades though. Thanks in advance.
Top
#170340 - 12/15/06 01:34 PM Re: 6.7 importer crashing on older posts [Re: coleslaw]
Rick Offline
Post-a-holic
Registered: 06/04/06
Posts: 10164
Loc: Aberdeen, WA
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.
Top



Moderator:  AllenAyres, Harold, Ian, Ron M 
Shout Box

Today's Birthdays
No Birthdays
Recent Topics
Ability to "like" individual posts (not Facebook "likes)
by doug
Yesterday at 09:03 AM
Island Permissions
by ThreadsUser
05/22/12 03:03 PM
streaming video
by prkrgrp
05/20/12 07:02 PM
New Posts Corrupted? Can someone help?
by PianoWorld
05/19/12 09:41 AM
Custom forum permissions
by ntdoc
05/18/12 02:07 PM
Forum Stats
10489 Members
36 Forums
33840 Topics
181693 Posts

Max Online: 978 @ 06/24/07 11:19 PM
Random Image