Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBWiki.com
Who's Online
3 registered (capnbob, JetStar, GregK), 39 Guests and 16 Spiders online.
Key: Admin, Global Mod, Mod
Featured Member
Registered: 06/08/06
Posts: 1465
Top Posters (30 Days)
Ruben 50
DennyP 24
Gizmo 24
Dunny 17
SteveS 14
AllenAyres 12
dbremer 10
SD 9
drkknght00 9
driv 8
Latest Photos
OK Corral Shoot Out
Testing
Basildon Train Station
Basildon Town Centre looking from the rounderbout
Basildon Town Square
Page 1 of 2 1 2 >
Topic Options
#165635 - 10/10/06 02:02 PM Importing Topics Error
Daryl Fawcett Offline
addict
Registered: 06/05/06
Posts: 469
Loc: Canada
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?
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."
#165638 - 10/10/06 02:04 PM Re: Importing Topics Error [Re: Daryl Fawcett]
Daryl Fawcett Offline
addict
Registered: 06/05/06
Posts: 469
Loc: Canada
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.
Top
#165639 - 10/10/06 02:07 PM Re: Importing Topics Error [Re: Daryl Fawcett]
Rick Offline
Post-a-holic
Registered: 06/04/06
Posts: 10164
Loc: Aberdeen, WA
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='';
Top
#165643 - 10/10/06 02:47 PM Re: Importing Topics Error [Re: Rick]
Daryl Fawcett Offline
addict
Registered: 06/05/06
Posts: 469
Loc: Canada
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.
Top
#165672 - 10/10/06 06:03 PM Re: Importing Topics Error [Re: Daryl Fawcett]
Daryl Fawcett Offline
addict
Registered: 06/05/06
Posts: 469
Loc: Canada
Has the importer script been updated for importing from UBBT6.5.5?
Top
#165676 - 10/10/06 06:12 PM Re: Importing Topics Error [Re: Daryl Fawcett]
Rick Offline
Post-a-holic
Registered: 06/04/06
Posts: 10164
Loc: Aberdeen, WA
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
Top
#165681 - 10/10/06 06:16 PM Re: Importing Topics Error [Re: Rick]
Daryl Fawcett Offline
addict
Registered: 06/05/06
Posts: 469
Loc: Canada
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.
Top
#165682 - 10/10/06 06:17 PM Re: Importing Topics Error [Re: Daryl Fawcett]
Daryl Fawcett Offline
addict
Registered: 06/05/06
Posts: 469
Loc: Canada
By the way, doesn't this forum do post wraps for long script code quoted here?
Top
#165689 - 10/10/06 06:31 PM Re: Importing Topics Error [Re: Daryl Fawcett]
Rick Offline
Post-a-holic
Registered: 06/04/06
Posts: 10164
Loc: Aberdeen, WA
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.
Top
#165766 - 10/11/06 01:33 PM Re: Importing Topics Error [Re: Rick]
Daryl Fawcett Offline
addict
Registered: 06/05/06
Posts: 469
Loc: Canada
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.
Top
#165769 - 10/11/06 01:37 PM Re: Importing Topics Error [Re: Daryl Fawcett]
Rick Offline
Post-a-holic
Registered: 06/04/06
Posts: 10164
Loc: Aberdeen, WA
Most things will work in older versions, but you'll get errors with a few things, like searching
Top
#165776 - 10/11/06 03:00 PM Re: Importing Topics Error [Re: Daryl Fawcett]
Daryl Fawcett Offline
addict
Registered: 06/05/06
Posts: 469
Loc: Canada
I noticed that Firefox supports it as I am looking at it through Firefox.
Top
Page 1 of 2 1 2 >



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