Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBWiki.com
Who's Online
1 registered (Myke), 40 Guests and 14 Spiders online.
Key: Admin, Global Mod, Mod
Featured Member
Registered: 06/05/06
Posts: 708
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 3 1 2 3 >
Topic Options
#165241 - 10/08/06 10:24 AM Import Error
Ian Offline
Registered: 06/05/06
Posts: 4337
Loc: Essex, UK
Quote:
Script:
Line#:
SQL Error:
SQL Error #: 0
Query: insert into ubbt_USER_GROUPS values ( 281 , 5 )



This was during... Processing users 201 - 401 of 6167

If we restart it, will these users just be overwritten or duplicated?
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."
#165244 - 10/08/06 11:06 AM Re: Import Error [Re: Ian]
Rick Offline
Post-a-holic
Registered: 06/04/06
Posts: 10164
Loc: Aberdeen, WA
Restarting it from scratch would duplicate them. Going off of a wild guess it looks like this user was assigned to group #5 twice in 6.5 and it's erroring out when trying to add him twice. I may have to update the importer to prevent this.
Top
#165245 - 10/08/06 11:14 AM Re: Import Error [Re: Rick]
Rick Offline
Post-a-holic
Registered: 06/04/06
Posts: 10164
Loc: Aberdeen, WA
This should fix the issue if the problem is what I think it is. If you open up line 523 of threads_import.php. The code looks like this:

Code:
$groups = split("-",$user_data['U_Groups']);

// Insert into USER_GROUPS
foreach($groups as $k => $v) {        
     if (!$v) continue;


Change that, to this:

Code:
$groups = split("-",$user_data['U_Groups']);
$done = array();

// Insert into USER_GROUPS
foreach($groups as $k => $v) {        
if (isset($done[$v])) continue;
   $done[$v] = 1;
   if (!$v) continue;
Top
#165261 - 10/08/06 12:31 PM Re: Import Error [Re: Rick]
Ian Offline
Registered: 06/05/06
Posts: 4337
Loc: Essex, UK
Is there anyway to continue this - or is it easier to just clear the tables?
Top
#165262 - 10/08/06 12:35 PM Re: Import Error [Re: Ian]
Rick Offline
Post-a-holic
Registered: 06/04/06
Posts: 10164
Loc: Aberdeen, WA
It's probably safest to clear the tables. Although you can't clear them completely since there is some data that needs to be there. It's a bit of a hassle I know, but what you'll probably want to do is delete the tables, and reinstall. Then what you could do is backup the database after the install, so if you encounter any problems again you can just restore that backup. We'll hope that this fixes the problem so you won't have to do that though
Top
#165265 - 10/08/06 01:00 PM Re: Import Error [Re: Rick]
Gizmo Offline

Registered: 06/05/06
Posts: 14994
Loc: Portland, OR; USA
Do like me, drop the tables then run the createtables.php script in the install directory, painless
_________________________
Forums: UGN Security & VNC Web Design & Development
UBB.Threads: UBB.Wiki, My UBBSkins, UBB.Sitemaps
Longtime UBB Supporter, UBB Beta Tester & Resident Post-A-Holic.
UBB Modifications, Styling, Coding Services, Disaster Recovery, and more!
Top
#165267 - 10/08/06 01:13 PM Re: Import Error [Re: Gizmo]
Daryl Fawcett Offline
addict
Registered: 06/05/06
Posts: 469
Loc: Canada
When I reach that stage, I do hope it works as I have updated that import file accordingly.
Top
#165270 - 10/08/06 01:30 PM Re: Import Error [Re: Daryl Fawcett]
Ian Offline
Registered: 06/05/06
Posts: 4337
Loc: Essex, UK
Thanks Gizmo
Top
#165271 - 10/08/06 01:59 PM Re: Import Error [Re: Ian]
Ian Offline
Registered: 06/05/06
Posts: 4337
Loc: Essex, UK
sorry & Rick LOL
Top
#165284 - 10/08/06 03:02 PM Re: Import Error [Re: Ian]
Gizmo Offline

Registered: 06/05/06
Posts: 14994
Loc: Portland, OR; USA
Oh we all know you love me more... i spam almost as much as Rick! <3
_________________________
Forums: UGN Security & VNC Web Design & Development
UBB.Threads: UBB.Wiki, My UBBSkins, UBB.Sitemaps
Longtime UBB Supporter, UBB Beta Tester & Resident Post-A-Holic.
UBB Modifications, Styling, Coding Services, Disaster Recovery, and more!
Top
#165286 - 10/08/06 03:07 PM Re: Import Error [Re: Gizmo]
Ian Offline
Registered: 06/05/06
Posts: 4337
Loc: Essex, UK
That worked - however it suddenly finished after 11,000 of 80,000 topics. No error code. It just stopped

Quote:

Processing topics (11464 - 11483) of 80314 total topics.

Importing Topic (Car insurance fraud) and its 21 replies.
Importing Topic (Award Times on Saturday) and its 2 replies.
Importing Topic (Fadhel) and its 2 replies.


Is it just a case of deleting and re-running until it works - or are there other issues?
Top
#165297 - 10/08/06 03:35 PM Re: Import Error [Re: Ian]
Gizmo Offline

Registered: 06/05/06
Posts: 14994
Loc: Portland, OR; USA
It should show a link at the bottom of each import step, you could kick it forard by clicking the link...

IE lieks to time out randomly, I'd recommend using FireFox
_________________________
Forums: UGN Security & VNC Web Design & Development
UBB.Threads: UBB.Wiki, My UBBSkins, UBB.Sitemaps
Longtime UBB Supporter, UBB Beta Tester & Resident Post-A-Holic.
UBB Modifications, Styling, Coding Services, Disaster Recovery, and more!
Top
#165299 - 10/08/06 03:37 PM Re: Import Error [Re: Gizmo]
Ian Offline
Registered: 06/05/06
Posts: 4337
Loc: Essex, UK
Nope -that was the extent of the page

Time to delete the tables and restart....
Top
#165300 - 10/08/06 03:43 PM Re: Import Error [Re: Ian]
Rick Offline
Post-a-holic
Registered: 06/04/06
Posts: 10164
Loc: Aberdeen, WA
Was there a long wait before it resulted in the white page? If so then it's possibly a timeout issue. You could try reloading, which may result in a couple duplicate topics but those could be taken care of after the import.
Top
#165301 - 10/08/06 03:45 PM Re: Import Error [Re: Rick]
Gizmo Offline

Registered: 06/05/06
Posts: 14994
Loc: Portland, OR; USA
I ended up having to do that on my server, I know for a fact we have about 100 duplicate threads, but I don't wan to hunt them down lol...
_________________________
Forums: UGN Security & VNC Web Design & Development
UBB.Threads: UBB.Wiki, My UBBSkins, UBB.Sitemaps
Longtime UBB Supporter, UBB Beta Tester & Resident Post-A-Holic.
UBB Modifications, Styling, Coding Services, Disaster Recovery, and more!
Top
#165306 - 10/08/06 04:07 PM Re: Import Error [Re: Gizmo]
Ian Offline
Registered: 06/05/06
Posts: 4337
Loc: Essex, UK
Didn't get a white page - just the information shown above - that was the extent of the page.

I tried starting the page from the next topic, and simply got nothing.

I have started again using firefox
Top
#165307 - 10/08/06 04:12 PM Re: Import Error [Re: Ian]
Rick Offline
Post-a-holic
Registered: 06/04/06
Posts: 10164
Loc: Aberdeen, WA
Hmm, that's a bit odd. If that happens again, might want you to just leave it at that spot and then if I can get ftp access to your site I'd like to do a bit of debugging. Hopefully it won't come to that, but if it does...let me know ;0
Top
#165308 - 10/08/06 04:18 PM Re: Import Error [Re: Rick]
Ian Offline
Registered: 06/05/06
Posts: 4337
Loc: Essex, UK
Nope it stopped again in Firefox - exactly the same place.
Top
#165309 - 10/08/06 04:20 PM Re: Import Error [Re: Ian]
Rick Offline
Post-a-holic
Registered: 06/04/06
Posts: 10164
Loc: Aberdeen, WA
Ok, that sounds like some type of database issue perhaps. If you still have the page open can you copy the actual URL it shows and send it to me via PM? Also, is it possible to get the info to access your server so I can take a look at a few things, add some debug code, etc?
Top
#165310 - 10/08/06 04:26 PM Re: Import Error [Re: Rick]
Ian Offline
Registered: 06/05/06
Posts: 4337
Loc: Essex, UK
Thanks - I have PM'd you all the info.

The page literally contained just the above info. There was nothing else on the page.

Thanks.
Top
#165317 - 10/08/06 05:22 PM Re: Import Error [Re: Ian]
Rick Offline
Post-a-holic
Registered: 06/04/06
Posts: 10164
Loc: Aberdeen, WA
Ok Ian. I tracked it down. Here's the scoop. It was coming across a post that had a TON of graemlins in it. You also have quite a few graemlins in your 6.5 board. So when it went to undo the markup for these it was basically choking. I redid the code a little bit on this and it seems to be working fine now. The altered code is still on your server so if you go ahead and start clean again you should be good to go
Top
#165356 - 10/09/06 04:13 AM Re: Import Error [Re: Rick]
Ian Offline
Registered: 06/05/06
Posts: 4337
Loc: Essex, UK
Thank you - will delete the tables and start again.

My forums never are simple
Top
#165363 - 10/09/06 06:14 AM Re: Import Error [Re: Ian]
Ian Offline
Registered: 06/05/06
Posts: 4337
Loc: Essex, UK
It is getting further

Just waiting for it to hit the thread with 13,000 posts
Top
Page 1 of 3 1 2 3 >



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
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
181692 Posts

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