Kunena conversion error

[pixelgeek]

I am using the Kunena 2.0x to SMF converter and I have the settings etc configured correctly but when it starts to convert I get the following error

Converting members...Wrong value type sent to the database. Integer expected. (last_login)

Anyone have an idea what the issue is?

I have tried the 1.5 and 1.6 converters with no luck. 1.5 generates the fb_users error and 1.6 generates the same Integer expected error.

[pixelgeek]

I think I figured out what the issue is.

The Kunena tables include users that have not logged in. So the UNIX_TIMESTAMP() function is returning NULL for those records.

The same error happens with the registerDate value

I had to replace

UNIX_TIMESTAMP(m.registerDate) AS date_registered,
UNIX_TIMESTAMP(m.lastvisitDate) AS last_login,

to

COALESCE (UNIX_TIMESTAMP(m.registerDate), UNIX_TIMESTAMP()) AS date_registered,
   COALESCE (UNIX_TIMESTAMP(m.lastvisitDate), UNIX_TIMESTAMP()) AS last_login,

That solved that error

Additionally I had to replace the parent_id references in the category to parent

Once I did that it worked correctly

[Stevewildman]

pixelgeek, I also am running Joomla 2.5 Ver. , 2.5.9.  and Kunena 2.4
I have my register/members  on both : synchronized so when they sign in on Joomla or Kunena forums it does both.
Can this be done with SMF?
Any input  from you or anyone running Joomla with SMF would be great.

[Oldiesmann]

It's possible to sync membership between Joomla and SMF by using JFusion. See http://www.jfusion.org/docs#smf for more info.