Is this topic also used for converting to SMF 2 RC2?
If not, please move my posting to the right place.
I just tried to convert using the latest files from the download area and I got two errors. I could fix the first one but I am hanging on the second one.Converting members
The SELECT statement contains
'' AS total_time_logged_in
This generates the error:
Wrong value type sent to the database. Integer expected. (total_time_logged_in)
If I change this to
0 AS total_time_logged_in
it works.Converting topics
...Wrong value type sent to the database. Integer expected. (id_member_updated)
I can't fix this.
id_member_updated is mediumint(
r.userid which is referenced is int(10)
Every CAST statement I tried resulted in a SQL Syntax error.
I am used to work with SQL Server, DB2 and Oracle but have almost no experience with mySQL.
BTW, I am using MySQL 5.0.77 on CentOS 5.4