Import Error - UBB.threads PHP Forum Software Community

You are not logged in. [Log In] UBB.threads PHP Forum Software Community » Forums » UBB.threads 7 Discussion » Importer Assistance » Import Error

Site Links

Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBWiki.com

Top Posters (30 Days)

Ruben	33
Gizmo	18
Rob Provencher	12
SD	9
Rimex	9
Bert	8
sw55	7
Eugene	5
TCS1	4
Matthias1976	4

Latest Photos

Page 1 of 3

Topic Options

#165241 - 10/08/06 09:24 AM

Import Error

Ian

Registered: 06/05/06
Posts: 4349
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 10:06 AM

Re: Import Error [Re: Ian]

Rick

Post-a-holic

Registered: 06/04/06
Posts: 10177
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 10:14 AM

Re: Import Error [Re: Rick]

Rick

Post-a-holic

Registered: 06/04/06
Posts: 10177
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 11:31 AM

Re: Import Error [Re: Rick]

Ian

Registered: 06/05/06
Posts: 4349
Loc: Essex, UK

Is there anyway to continue this - or is it easier to just clear the tables?

Top

#165262 - 10/08/06 11:35 AM

Re: Import Error [Re: Ian]

Rick

Post-a-holic

Registered: 06/04/06
Posts: 10177
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 12:00 PM

Re: Import Error [Re: Rick]

Gizmo

Registered: 06/05/06
Posts: 15452
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 Supporter, Beta Tester & Resident Post-A-Holic.
Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!

Top