Converting topics...Wrong value type sent to the database. Integer expected. (id

[john1974]

So I finally got past some of my other converting issues and here is the latest error

Converting topics...Wrong value type sent to the database. Integer expected. (id_member_updated)

[kat]

Not trying to fob you off, here, John.

But, rather than go through loads of different things, you might get some joy, if you look at these:

[john1974]

I'll check those out I have been doing alot of searching with little help found. 

[kat]

Come and post back, if you get stuck.

[john1974]

Well got past it the last issue and now get the following (currently doing a search for fix.)
Converting topics...Duplicate entry '4353' for key 'PRIMARY'

[kat]

There're a lot of those about, too.

With that one, you could try using phpmyadmin to delete one of those duplicates, I believe.

[john1974]

Yeah if I edit them and change them it just goes to the next one, and next one. 

[kat]

If there're so many duplicate entries, I wonder if it'll be worth going to CPanel>Databases and trying a repair, on the db...?

[john1974]

Yeah tried that a couple times still same issue.

[kat]

Other than plodding on, doing what you're doing...

...I'm stuck.

Let's hope someone else can come-up with some ideas.

Sorry 'bout that.

[john1974]

np thanks for helping I really appreciate it Ive been trying to convert my forums for 2 months now.

[kat]

I have a feeling that there's a kinda "One click fix", for this.

But, I'm buggered if I can figure out what it is, at the moment...

[john1974]

Yeah Im doing alot of searching but coming up with nothing myself (so far.)

[Colin]

How many times does this error appear?

[john1974]

How many times does this error appear?

So far it will say Converting topics...Duplicate entry '4357' for key 'PRIMARY' 

When I go into PHPadmin and change the topic ID and rerun converter it will go to 4358 and so on everytime I edit a topic ID.

[Colin]

So every on every incrementkng value it is reporting a duplicate ID?

[john1974]

So every on every incrementkng value it is reporting a duplicate ID?

So far yes I have edited about 12 and it just keeps going.

[john1974]

ok so here is what I did now

edit the phpnuke_to_smf.sql and search for:


Code: [Select]
---* {$to_prefix}topics
replace with:

Code: [Select]
---* {$to_prefix}topics
---{
$ignore = true;
---}

That worked but now I get the following error
Converting...
Converting posts (this may take some time)...
Duplicate entry '10075' for key 'PRIMARY'

Does this mean its still working or did it stop?

[john1974]

Wanted to let everyone know I fixed my last problem and my forums are converted with no errors.

I just let the converter run WITHOUT hitting continue.

[kat]

Coo! The wonders of teknolergee, huh?

Glad you got there, John!