xoops converts not working correctly

[vampiro-6]

I'm italian excuseme for my bad english

I have downloading a convert tools for my smf 1.1.
I have upload the 2 file (convert.php and xoops_to_smf.sql) in the forum directory.
When i go in the link hxxp:www.examplesite.net/smfdirectory/convert.php [nonactive] i see the menu where i put the path of my smf, the path of my xoops site and the password of my database.
I click on continue and i see this error:

Converting members... Unsuccessful!
This query:
SELECT
uid AS ID_MEMBER, uname AS memberName, FROM_UNIXTIME(user_regdate) AS dateRegistered,
FROM_UNIXTIME(last_login) AS lastlogin, pass AS passwd, IF(name = '', uname, name) AS realName, posts,
email AS emailAddress, url AS websiteTitle, url AS websiteUrl,
IF(rank = 7, 1, 0) AS ID_GROUP, user_icq AS ICQ, user_aim AS AIM,
user_yim AS YIM, user_msnm AS MSN, user_sig AS signature,
user_viewemail = 0 AS hideEmail, timezone_offset AS timeOffset
FROM `Sql28839_4`.xoops1_users
LIMIT 0, 500;
Caused the error:

Unknown column 'user_regdate' in 'field list'



for fix it?

[Oldiesmann]

Can you run this query in phpMyAdmin and post the results here?

Code Select Expand

SHOW COLUMNS FROM xoops1_users LIKE 'user_%';

[ekose]

I have the same problem, too