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

Ian #165244 10/08/2006 11:06 AM
Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
Joined: Jun 2006
Posts: 9,242
Likes: 1
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.

Rick #165245 10/08/2006 11:14 AM
Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
Joined: Jun 2006
Posts: 9,242
Likes: 1
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;



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

Ian #165262 10/08/2006 12:35 PM
Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
Joined: Jun 2006
Posts: 9,242
Likes: 1
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

Rick #165265 10/08/2006 1:00 PM
Joined: Jun 2006
Posts: 16,292
Likes: 116
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,292
Likes: 116
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.
Do you need Forum Install or Upgrade Services?
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!
Gizmo #165267 10/08/2006 1:13 PM
Joined: Jun 2006
Posts: 626
Addict
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

Joined: Jun 2006
Posts: 3,837
I
Ian
Offline
Carpal Tunnel
Carpal Tunnel
I Offline
Joined: Jun 2006
Posts: 3,837
Thanks Gizmo

Ian #165271 10/08/2006 1:59 PM
Joined: Jun 2006
Posts: 3,837
I
Ian
Offline
Carpal Tunnel
Carpal Tunnel
I Offline
Joined: Jun 2006
Posts: 3,837
sorry & Rick LOL

Ian #165284 10/08/2006 3:02 PM
Joined: Jun 2006
Posts: 16,292
Likes: 116
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,292
Likes: 116
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.
Do you need Forum Install or Upgrade Services?
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!
Gizmo #165286 10/08/2006 3:07 PM
Joined: Jun 2006
Posts: 3,837
I
Ian
Offline
Carpal Tunnel
Carpal Tunnel
I Offline
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?

Ian #165297 10/08/2006 3:35 PM
Joined: Jun 2006
Posts: 16,292
Likes: 116
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,292
Likes: 116
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.
Do you need Forum Install or Upgrade Services?
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!
Gizmo #165299 10/08/2006 3:37 PM
Joined: Jun 2006
Posts: 3,837
I
Ian
Offline
Carpal Tunnel
Carpal Tunnel
I Offline
Joined: Jun 2006
Posts: 3,837
Nope -that was the extent of the page frown

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

Ian #165300 10/08/2006 3:43 PM
Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
Joined: Jun 2006
Posts: 9,242
Likes: 1
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.

Rick #165301 10/08/2006 3:45 PM
Joined: Jun 2006
Posts: 16,292
Likes: 116
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,292
Likes: 116
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.
Do you need Forum Install or Upgrade Services?
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!
Gizmo #165306 10/08/2006 4:07 PM
Joined: Jun 2006
Posts: 3,837
I
Ian
Offline
Carpal Tunnel
Carpal Tunnel
I Offline
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


Ian #165307 10/08/2006 4:12 PM
Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
Joined: Jun 2006
Posts: 9,242
Likes: 1
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

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

Ian #165309 10/08/2006 4:20 PM
Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
Joined: Jun 2006
Posts: 9,242
Likes: 1
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?

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

Ian #165317 10/08/2006 5:22 PM
Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
Joined: Jun 2006
Posts: 9,242
Likes: 1
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

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

My forums never are simple wink

Ian #165363 10/09/2006 6:14 AM
Joined: Jun 2006
Posts: 3,837
I
Ian
Offline
Carpal Tunnel
Carpal Tunnel
I Offline
Joined: Jun 2006
Posts: 3,837
It is getting further smile

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


Link Copied to Clipboard
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
spam issues
by ECNet - 03/19/2024 11:45 PM
Looking for a forum
by azr - 03/15/2024 11:26 PM
Editing Links in Post
by Outdoorking - 03/15/2024 9:31 AM
Question on barkrowler and the like
by Mors - 02/29/2024 6:51 PM
Member Permissions Help
by domspeak - 02/27/2024 6:31 PM
Who's Online Now
1 members (Havenofsobriety), 522 guests, and 99 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
Los Angeles
Los Angeles
by isaac, August 6
3D Creations
3D Creations
by JAISP, December 30
Artistic structures
Artistic structures
by isaac, August 29
Stones
Stones
by isaac, August 19
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20230217)