OpenBB problems (was 1.1 Converters)

[elvenjess]

I just ran the OpenBB 1.0.x to SMF convertor on a fresh install of SMF 1.1 Beta 3 Public. It was unsuccesful in converting posts. It showed a huge dump of what looks like various posts and then at the end says:

Thanks for testing this - you're the first I know of.

I was able to log into the forum and after using the matience functions it appears that the numbers and members are alright. Trouble is, the categories, topics, and posts are messed up. 

It couldn't finish, so nothing is going to be proper.  Interesting, though.  It almost sounds like there are posts with duplicate IDs or something...

SELECT id, COUNT(id) AS c
FROM obb_posts
GROUP BY id
HAVING c != 1;

If this returns any rows, your database may be... fun to convert.  If it doesn't, I may want to ask for a more complete error message - at least what table it is INSERTing INTO.

-[Unknown]

I ran that in phpMyAdmin, nothing came up as far as I could see.

[[Unknown]]

In that case, please try the conversion again.

Note that if any posts are made while the conversion is in progress, you'll get errors like that.

-[Unknown]

[elvenjess]

Ah, alright. I'll try again and lock the OBB board first.

I'll let you know how it turns out.

EDIT: Hmm, same error. Maybe I didn't run the SQL command properly, but yeah looks like there are duplicates of something.

I uploaded the entire error as a .txt file.

[[Unknown]]

Aha... what about this:

SELECT username, COUNT(id) AS c
FROM obb_profiles
GROUP BY username
HAVING c != 1;

-[Unknown]

[elvenjess]

Yeah, here's the result...

username	c
Elessr	2

[[Unknown]]

Use this one, then.  I guess OpenBB allows registrations with duplicate usernames?

-[Unknown]

[elvenjess]

Use this one, then.  I guess OpenBB allows registrations with duplicate usernames?

-[Unknown]

Not sure, it could be a mistake of my own doing. I do recall having to delete some user acounts via phpMyAdmin for one reason or another..

EDIT: Ok, took a lot longer this time, I guess because it was able to do more of the database? Anyhow, this time we've got the same error (I think) but a different entry.

Caused the error:

    Duplicate entry '58077' for key 1

And again, I've uploaded the full error dump as a txt file.

PS. Thanks for the support guys, hopefully we can get this ironed out. 

[[Unknown]]

What if you just delete the extra profile, or temporarily change its username column?  Like to Elessr(2).

-[Unknown]

[elvenjess]

What if you just delete the extra profile, or temporarily change its username column?  Like to Elessr(2).

-[Unknown]

I'll give that a try, but isn't it a different error this time?

[[Unknown]]

No, it's the same.  Unfortunately, this error is going to be hard to work around because of the way the converter works.

-[Unknown]

[elvenjess]

No, it's the same.  Unfortunately, this error is going to be hard to work around because of the way the converter works.

-[Unknown]

Alright, I've started it up again after deleting the profile...

EDIT: Aaugh!! Same thing..

Caused the error:

    Duplicate entry '58280' for key 1

[[Unknown]]

No, that's a new one.  Maybe it's another duplicate member?  Did you lock the OpenBB forum first?

-[Unknown]

[elvenjess]

No, that's a new one.  Maybe it's another duplicate member?  Did you lock the OpenBB forum first?

-[Unknown]

Yes, the forum is locked. Is there a way to search for all duplicate entries?

[[Unknown]]

Well, okay, try...

SELECT p.id, COUNT(p.id) AS c
FROM obb_posts AS p
   LEFT JOIN obb_profiles AS m ON (m.username = p.poster)
GROUP BY p.id
HAVING c != 1;

Does that return anything?

-[Unknown]

[elvenjess]

Well, okay, try...

SELECT p.id, COUNT(p.id) AS c
FROM obb_posts AS p
   LEFT JOIN obb_profiles AS m ON (m.username = p.poster)
GROUP BY p.id
HAVING c != 1;

Does that return anything?

-[Unknown]

No.

[[Unknown]]

Strange.  If that is fine, it should be fine as well....

Try this one.

-[Unknown]

[elvenjess]

Success!  Everything looks alright, thanks for all the help [Unknown]!