|
Joined: Jun 2006
Posts: 3,837
Carpal Tunnel
|
Carpal Tunnel
Joined: Jun 2006
Posts: 3,837 |
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?
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
Former Developer
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.
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
Former Developer
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:
$groups = split("-",$user_data['U_Groups']);
// Insert into USER_GROUPS
foreach($groups as $k => $v) {
if (!$v) continue;
Change that, to this:
$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;
|
|
|
|
Joined: Jun 2006
Posts: 3,837
Carpal Tunnel
|
Carpal Tunnel
Joined: Jun 2006
Posts: 3,837 |
Is there anyway to continue this - or is it easier to just clear the tables?
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
Former Developer
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
|
|
|
|
Joined: Jun 2006
Posts: 16,299 Likes: 116
|
Joined: Jun 2006
Posts: 16,299 Likes: 116 |
Do like me, drop the tables then run the createtables.php script in the install directory, painless
|
|
|
|
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.
|
|
|
|
Joined: Jun 2006
Posts: 3,837
Carpal Tunnel
|
Carpal Tunnel
Joined: Jun 2006
Posts: 3,837 |
|
|
|
|
Joined: Jun 2006
Posts: 3,837
Carpal Tunnel
|
Carpal Tunnel
Joined: Jun 2006
Posts: 3,837 |
|
|
|
|
Joined: Jun 2006
Posts: 16,299 Likes: 116
|
Joined: Jun 2006
Posts: 16,299 Likes: 116 |
Oh we all know you love me more... i spam almost as much as Rick! <3
|
|
|
|
Joined: Jun 2006
Posts: 3,837
Carpal Tunnel
|
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 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?
|
|
|
|
Joined: Jun 2006
Posts: 16,299 Likes: 116
|
Joined: Jun 2006
Posts: 16,299 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
|
|
|
|
Joined: Jun 2006
Posts: 3,837
Carpal Tunnel
|
Carpal Tunnel
Joined: Jun 2006
Posts: 3,837 |
Nope -that was the extent of the page Time to delete the tables and restart....
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
Former Developer
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.
|
|
|
|
Joined: Jun 2006
Posts: 16,299 Likes: 116
|
Joined: Jun 2006
Posts: 16,299 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...
|
|
|
|
Joined: Jun 2006
Posts: 3,837
Carpal Tunnel
|
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
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
Former Developer
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
|
|
|
|
Joined: Jun 2006
Posts: 3,837
Carpal Tunnel
|
Carpal Tunnel
Joined: Jun 2006
Posts: 3,837 |
Nope it stopped again in Firefox - exactly the same place.
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
Former Developer
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?
|
|
|
|
Joined: Jun 2006
Posts: 3,837
Carpal Tunnel
|
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.
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
Former Developer
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
|
|
|
|
Joined: Jun 2006
Posts: 3,837
Carpal Tunnel
|
Carpal Tunnel
Joined: Jun 2006
Posts: 3,837 |
Thank you - will delete the tables and start again. My forums never are simple
|
|
|
|
Joined: Jun 2006
Posts: 3,837
Carpal Tunnel
|
Carpal Tunnel
Joined: Jun 2006
Posts: 3,837 |
It is getting further Just waiting for it to hit the thread with 13,000 posts
|
|
|
Bots
by Outdoorking - 04/13/2024 5:08 PM
|
|
|
|
|
|
2 members (DennyP, 1 invisible),
972
guests, and
155
robots. |
Key:
Admin,
Global Mod,
Mod
|
|
|
|