Converting form XOOPS 2.2.6 with newbb/CBB 3.08

[lifeaddict]

Hi there!

I'm trying to convert from XOOPS 2.2.6 with newbb/CBB 3.08 to SMF 2.0.2.
Here's some system info:

XOOPS-Version : XOOPS 2.2.6
PHP Version : 5.3.6-13ubuntu3.3
MySQL Version : 5.1.58-1ubuntu1
Server Software : Apache/2.2.20
Status safe_mode : OFF
Register Globals : OFF

I tried the Xoops 2 to SMF 2-0  Converter from http://download.simplemachines.org/?converters;software=xoops but it refused to work because

Unknown column 'user_regdate' in 'field list'

After some research I found the column 'user_regdate' in the 'user_profile' table. So I changed the query in 'xoops2x_to_smf.sql' from

[...]FROM {$from_prefix}users;

to

[...]FROM {$from_prefix}users u
JOIN {$from_prefix}user_profile p
ON u.uid=p.profileid;

Now I get the following error:

Converting members...
Unknown column '_' in 'field list'

Can anyone help me to resolve this problem?

[density5]

I have the same error, it looks like the "user_profile" table needs to be joined, as the converter is asking for fields in that table. I had the same idea as lifeaddict but without luck.

After Checking the join MYSQL Query, it turns out that some of the column names are turned in to "_" on the join, even tho all the fields in the SQL have "AS name" set. on the join result - i can see that the member_name column gets set to "_" which does not look good at all.

The query look like this :

SELECT uid AS id_member, SUBSTRING( uname, 1, 80 ) AS _, user_regdate AS _, SUBSTRING( pass, 1, 64 ) AS passwd, SUBSTRING( IF( name = '', uname, name ) , 1, 255 ) AS _, posts, SUBSTRING( email, 1, 255 ) AS _, SUBSTRING( url, 1, 255 ) AS _, SUBSTRING( url, 1, 255 ) AS _, IF( rank =7, 1, 0 ) AS id_group, SUBSTRING( user_icq, 1, 255 ) AS icq, SUBSTRING( user_aim, 1, 16 ) AS aim, SUBSTRING( user_yim, 1, 32 ) AS yim, SUBSTRING( user_msnm, 1, 255 ) AS msn, SUBSTRING( user_sig, 1, 65534 ) AS signature, IF( user_viewemail = '0', 1, 0 ) AS _, timezone_offset AS _, '' AS lngfile, '' AS buddy_list, '' AS pm_ignore_list, '' AS _, '' AS _, '' AS location, '' AS _, '' AS avatar, '' AS usertitle, '' AS member_ip, '' AS _, '' AS _, '' AS validation_code, '' AS _, '' AS _, '' AS _, '' AS member_ip2
FROM 635yhesf_users u
JOIN 635yhesf_user_profile p ON u.uid = p.profileid
LIMIT 0 , 30


PHP File query is :

SELECT
   uid AS id_member, SUBSTRING(uname, 1, 80) AS member_name,
   user_regdate AS date_registered, SUBSTRING(pass, 1, 64) AS passwd,
   SUBSTRING(IF(name = '', uname, name), 1, 255) AS real_name, posts,
   SUBSTRING(email, 1, 255) AS email_address,
   SUBSTRING(url, 1, 255) AS website_title,
   SUBSTRING(url, 1, 255) AS website_url, IF(rank = 7, 1, 0) AS id_group,
   SUBSTRING(user_icq, 1, 255) AS icq, SUBSTRING(user_aim, 1, 16) AS aim,
   SUBSTRING(user_yim, 1, 32) AS yim, SUBSTRING(user_msnm, 1, 255) AS msn,
   SUBSTRING(user_sig, 1, 65534) AS signature,
   user_viewemail = 0 AS hide_email, timezone_offset AS time_offset,
   '' AS lngfile, '' AS buddy_list, '' AS pm_ignore_list, '' AS message_labels,
   '' AS personal_text, '' AS location, '' AS time_format, '' AS avatar,
   '' AS usertitle, '' AS member_ip, '' AS secret_question, '' AS secret_answer,
   '' AS validation_code, '' AS additional_groups, '' AS smiley_set,
   '' AS password_salt, '' AS member_ip2

FROM {$from_prefix}users u
JOIN {$from_prefix}user_profile p
ON u.uid=p.profileid;

Could anybody advise on this?

Kind Regards

density5

[cbung]

*Bump*

We're you able to sort this out?

I just had the same error, "Converting members...Unknown column '_' in 'field list'"

CBB 3.0.8 (on XOOPS 2.4.4 but shouldnt matter?) to SMF 2.0.2

Thanks for any help.