UBB.threads PHP Forum Software Community Forums UBB.threads Importer Support Importing Topics Error

I received the following error when at the importing of the topics stage:

Processing topics (5968 - 5987) of 6238 total topics.

Script:
Line#:
SQL Error:
SQL Error #: 0
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,POST_IS_APPROVED,POST_HAS_FILE,POST_HAS_POLL,POST_MARKUP_TYPE,POST_LAST_EDITED_TIME,POST_LAST_EDITED_BY,POST_PARENT_USER_ID) values ( 0 , 6015 , 1 , 1149529059 , '142.177.197.84' , 'Still another test. :thanks: ' , 'Still another test. ' , 'Still another test. ' , 'cool.gif' , 1 , 3 , 0 , 1 , 0 , 0 , 'markup' , '' , '' , '' )

I hit the back button and tried it a few more times but only made things worse, therefore, when I have more time, I will be deleting the whole database and doing a new install.

In the meantime, can you tell me what happened, why, and what I should do to correct it?

I think I know what happened.

It looks like I ran out of disk space, therefore, I will be doing a lot of deleting of old topics, etc. before starting again.

I'm going to guess that this is related to MySQL 5's strict mode in where you can't have a blank value for an integer column. Is this your server or a hosted server? I'm making some changes to the import script to account for this and should have it finished by this afternoon. If this is your server there is a SQL command that you can use to disable strict mode so the importer will work properly:

SET GLOBAL SQL_MODE='';

It is a hosted server, and I did run out of my allotted server space, which I feel is the problem, however, if it happens again, which I will be surprised if it does.

At any rate, after I do the install, if you have the importer script done, then I will download it for future use.

Has the importer script been updated for importing from UBBT6.5.5?

If it was just a space issue then you won't need the updated importer. We will be updating the importers tommorow in the mebers area but that will only address the problem with MySQL 5 and strict mode, which I wrongly assumed your problem was

OK.

I have been deleting unnecessary items.

I will soon be ready to try another import.

If I still have the same problem, I will let you know.

By the way, doesn't this forum do post wraps for long script code quoted here?

If you're using a browser that will support it there is a css attribute for overflow that will actually give a side scrolling bar in the content of the post. We may end up sticking something in to force a wrap on long strings but it does add a bit to the processing of posts.

I imported again today without any problems at all.

By the way, I tested this out on a version of MySql that is less than version 4.

So far, it is working great!

Thought you might like to know.

Most things will work in older versions, but you'll get errors with a few things, like searching

I noticed that Firefox supports it as I am looking at it through Firefox.