Simple Machines Community Forum

SMF Support => Converting to SMF => phpBB => Topic started by: john1974 on July 16, 2013, 01:06:15 PM

Title: Converting topics...Wrong value type sent to the database. Integer expected. (id
Post by: john1974 on July 16, 2013, 01:06:15 PM
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)

Title: Re: Converting topics...Wrong value type sent to the database. Integer expected. (id
Post by: kat on July 16, 2013, 01:37:09 PM
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:

(https://www.simplemachines.org/community/proxy.php?request=http%3A%2F%2Fwww.katzy.dsl.pipex.com%2FSmileys%2FClick.gif&hash=4d8fc1706bc7130cfabdf49328a7ee4128c9614c) (http://www.metacrawler.com/index.html/search/web?fcoid=485&fcop=&fpid=2&qall=&qexact=Wrong+value+type+sent+to+the+database.+Integer+expected.+%28id_member_updated%29&qany=&qnone=&qimgs=All&qlang=&qdomainf=Include&qdomain=http%3A%2F%2Fwww.simplemachines.org%2Fcommunity)
Title: Re: Converting topics...Wrong value type sent to the database. Integer expected. (id
Post by: john1974 on July 16, 2013, 01:39:01 PM
I'll check those out I have been doing alot of searching with little help found. 
Title: Re: Converting topics...Wrong value type sent to the database. Integer expected. (id
Post by: kat on July 16, 2013, 01:42:56 PM
Come and post back, if you get stuck. :)
Title: Re: Converting topics...Wrong value type sent to the database. Integer expected. (id
Post by: john1974 on July 16, 2013, 01:59:42 PM
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'
Title: Re: Converting topics...Wrong value type sent to the database. Integer expected. (id
Post by: kat on July 16, 2013, 02:02:06 PM
There're a lot of those about, too. :(

With that one, you could try using phpmyadmin to delete one of those duplicates, I believe.
Title: Re: Converting topics...Wrong value type sent to the database. Integer expected. (id
Post by: john1974 on July 16, 2013, 02:18:49 PM
Yeah if I edit them and change them it just goes to the next one, and next one. 
Title: Re: Converting topics...Wrong value type sent to the database. Integer expected. (id
Post by: kat on July 16, 2013, 02:28:48 PM
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...?
Title: Re: Converting topics...Wrong value type sent to the database. Integer expected. (id
Post by: john1974 on July 16, 2013, 02:32:01 PM
Yeah tried that a couple times still same issue.
Title: Re: Converting topics...Wrong value type sent to the database. Integer expected. (id
Post by: kat on July 16, 2013, 02:33:28 PM
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.
Title: Re: Converting topics...Wrong value type sent to the database. Integer expected. (id
Post by: john1974 on July 16, 2013, 02:34:43 PM
np thanks for helping I really appreciate it Ive been trying to convert my forums for 2 months now.
Title: Re: Converting topics...Wrong value type sent to the database. Integer expected. (id
Post by: kat on July 16, 2013, 02:49:35 PM
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... :(
Title: Re: Converting topics...Wrong value type sent to the database. Integer expected. (id
Post by: john1974 on July 16, 2013, 02:55:10 PM
Yeah Im doing alot of searching but coming up with nothing myself (so far.)
Title: Re: Converting topics...Wrong value type sent to the database. Integer expected. (id
Post by: Colin on July 16, 2013, 02:57:37 PM
How many times does this error appear?
Title: Re: Converting topics...Wrong value type sent to the database. Integer expected. (id
Post by: john1974 on July 16, 2013, 02:59:10 PM
Quote from: Colin on July 16, 2013, 02:57:37 PM
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.
Title: Re: Converting topics...Wrong value type sent to the database. Integer expected. (id
Post by: Colin on July 16, 2013, 03:00:43 PM
So every on every incrementkng value it is reporting a duplicate ID?
Title: Re: Converting topics...Wrong value type sent to the database. Integer expected. (id
Post by: john1974 on July 16, 2013, 03:03:23 PM
Quote from: Colin on July 16, 2013, 03:00:43 PM
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.
Title: Re: Converting topics...Wrong value type sent to the database. Integer expected. (id
Post by: john1974 on July 16, 2013, 04:01:46 PM
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?
Title: Re: Converting topics...Wrong value type sent to the database. Integer expected. (id
Post by: john1974 on July 16, 2013, 05:43:13 PM
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.
Title: Re: Converting topics...Wrong value type sent to the database. Integer expected. (id
Post by: kat on July 17, 2013, 04:51:29 AM
Coo! The wonders of teknolergee, huh?

Glad you got there, John!