Previous Thread
Next Thread
Print Thread
Hop To
Import Error #165241 10/08/2006 10:24 AM
Joined: Jun 2006
Posts: 3,837
Ian Offline OP
Carpal Tunnel
OP Offline
Carpal Tunnel
Joined: Jun 2006
Posts: 3,837
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?

Re: Import Error [Re: Ian] #165244 10/08/2006 11:06 AM
Joined: Jun 2006
Posts: 9,243
Rick Offline
Former Developer
Offline
Former Developer
Joined: Jun 2006
Posts: 9,243
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.

Re: Import Error [Re: Rick] #165245 10/08/2006 11:14 AM
Joined: Jun 2006
Posts: 9,243
Rick Offline
Former Developer
Offline
Former Developer
Joined: Jun 2006
Posts: 9,243
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;




Re: Import Error [Re: Rick] #165261 10/08/2006 12:31 PM
Joined: Jun 2006
Posts: 3,837
Ian Offline OP
Carpal Tunnel
OP Offline
Carpal Tunnel
Joined: Jun 2006
Posts: 3,837
Is there anyway to continue this - or is it easier to just clear the tables?

Re: Import Error [Re: Ian] #165262 10/08/2006 12:35 PM
Joined: Jun 2006
Posts: 9,243
Rick Offline
Former Developer
Offline
Former Developer
Joined: Jun 2006
Posts: 9,243
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 wink

Re: Import Error [Re: Rick] #165265 10/08/2006 1:00 PM
Joined: Jun 2006
Posts: 15,833
Gizmo Offline
UBB.threads Developer
Offline
UBB.threads Developer
Joined: Jun 2006
Posts: 15,833
Do like me, drop the tables then run the createtables.php script in the install directory, painless wink


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Need to Upgrade?
Forums: A Gardeners Forum Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Re: Import Error [Re: Gizmo] #165267 10/08/2006 1:13 PM
Joined: Jun 2006
Posts: 626
Daryl Fawcett Offline
Addict
Offline
Addict
Joined: Jun 2006
Posts: 626
When I reach that stage, I do hope it works as I have updated that import file accordingly. smile

Re: Import Error [Re: Daryl Fawcett] #165270 10/08/2006 1:30 PM
Joined: Jun 2006
Posts: 3,837
Ian Offline OP
Carpal Tunnel
OP Offline
Carpal Tunnel
Joined: Jun 2006
Posts: 3,837
Thanks Gizmo

Re: Import Error [Re: Ian] #165271 10/08/2006 1:59 PM
Joined: Jun 2006
Posts: 3,837
Ian Offline OP
Carpal Tunnel
OP Offline
Carpal Tunnel
Joined: Jun 2006
Posts: 3,837
sorry & Rick LOL

Re: Import Error [Re: Ian] #165284 10/08/2006 3:02 PM
Joined: Jun 2006
Posts: 15,833
Gizmo Offline
UBB.threads Developer
Offline
UBB.threads Developer
Joined: Jun 2006
Posts: 15,833
Oh we all know you love me more... i spam almost as much as Rick! <3


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Need to Upgrade?
Forums: A Gardeners Forum Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Re: Import Error [Re: Gizmo] #165286 10/08/2006 3:07 PM
Joined: Jun 2006
Posts: 3,837
Ian Offline OP
Carpal Tunnel
OP Offline
Carpal Tunnel
Joined: Jun 2006
Posts: 3,837
That worked - however it suddenly finished after 11,000 of 80,000 topics. No error code. It just stopped frown

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?

Re: Import Error [Re: Ian] #165297 10/08/2006 3:35 PM
Joined: Jun 2006
Posts: 15,833
Gizmo Offline
UBB.threads Developer
Offline
UBB.threads Developer
Joined: Jun 2006
Posts: 15,833
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


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Need to Upgrade?
Forums: A Gardeners Forum Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Re: Import Error [Re: Gizmo] #165299 10/08/2006 3:37 PM
Joined: Jun 2006
Posts: 3,837
Ian Offline OP
Carpal Tunnel
OP Offline
Carpal Tunnel
Joined: Jun 2006
Posts: 3,837
Nope -that was the extent of the page frown

Time to delete the tables and restart.... frown

Re: Import Error [Re: Ian] #165300 10/08/2006 3:43 PM
Joined: Jun 2006
Posts: 9,243
Rick Offline
Former Developer
Offline
Former Developer
Joined: Jun 2006
Posts: 9,243
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.

Re: Import Error [Re: Rick] #165301 10/08/2006 3:45 PM
Joined: Jun 2006
Posts: 15,833
Gizmo Offline
UBB.threads Developer
Offline
UBB.threads Developer
Joined: Jun 2006
Posts: 15,833
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...


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Need to Upgrade?
Forums: A Gardeners Forum Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Re: Import Error [Re: Gizmo] #165306 10/08/2006 4:07 PM
Joined: Jun 2006
Posts: 3,837
Ian Offline OP
Carpal Tunnel
OP Offline
Carpal Tunnel
Joined: Jun 2006
Posts: 3,837
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 smile


Re: Import Error [Re: Ian] #165307 10/08/2006 4:12 PM
Joined: Jun 2006
Posts: 9,243
Rick Offline
Former Developer
Offline
Former Developer
Joined: Jun 2006
Posts: 9,243
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

Re: Import Error [Re: Rick] #165308 10/08/2006 4:18 PM
Joined: Jun 2006
Posts: 3,837
Ian Offline OP
Carpal Tunnel
OP Offline
Carpal Tunnel
Joined: Jun 2006
Posts: 3,837
Nope it stopped again in Firefox - exactly the same place. frown

Re: Import Error [Re: Ian] #165309 10/08/2006 4:20 PM
Joined: Jun 2006
Posts: 9,243
Rick Offline
Former Developer
Offline
Former Developer
Joined: Jun 2006
Posts: 9,243
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?

Re: Import Error [Re: Rick] #165310 10/08/2006 4:26 PM
Joined: Jun 2006
Posts: 3,837
Ian Offline OP
Carpal Tunnel
OP Offline
Carpal Tunnel
Joined: Jun 2006
Posts: 3,837
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.

Re: Import Error [Re: Ian] #165317 10/08/2006 5:22 PM
Joined: Jun 2006
Posts: 9,243
Rick Offline
Former Developer
Offline
Former Developer
Joined: Jun 2006
Posts: 9,243
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 wink

Re: Import Error [Re: Rick] #165356 10/09/2006 4:13 AM
Joined: Jun 2006
Posts: 3,837
Ian Offline OP
Carpal Tunnel
OP Offline
Carpal Tunnel
Joined: Jun 2006
Posts: 3,837
Thank you - will delete the tables and start again.

My forums never are simple wink

Re: Import Error [Re: Ian] #165363 10/09/2006 6:14 AM
Joined: Jun 2006
Posts: 3,837
Ian Offline OP
Carpal Tunnel
OP Offline
Carpal Tunnel
Joined: Jun 2006
Posts: 3,837
It is getting further smile

Just waiting for it to hit the thread with 13,000 posts smile


Forum Search
ShoutChat Box
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
Horizontal Image Attachment
by ECNet - 09/11/2019 12:17 PM
user profile, after I click Update nothing happens
by PianoWorld - 09/10/2019 12:38 PM
Inline Image Embeds
by ECNet - 09/03/2019 2:38 PM
Paid Subscriptions - Needs More Incentive
by M4TT - 08/25/2019 10:06 PM
visual accessibility issues.v7.7.3
by Ruben - 08/21/2019 1:50 PM
Who's Online Now
1 registered members (isaac), 71 guests, and 362 spiders.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
Artistic structures
Artistic structures
by isaac, August 29
Stones
Stones
by isaac, August 19
Amusing Terain Scenics
Amusing Terain Scenics
by isaac, August 19
Sky places
Sky places
by isaac, August 19
Powered by UBB.threads™ PHP Forum Software 7.7.3