users as guests and not all posts where converted over

[gemmk1]

I dont know if this is the right section.I am so sorry if it is not

I just did the conversion from ipb board 3.3 to vbulletin 3.8 and all the users are showing up as guests and also i only was able to bring over 5000 posts when my ipb forum has over 10k in posts.Really need some help please

I just went back to the import and tried to import the users again and i get this error

ImpEx Database error

mysql error: Invalid SQL:
SELECT
m.*,
pp.notes, pp.signature, pp.avatar_location, pp.avatar_size, pp.avatar_type
,pf.field_1 AS aim_name,pf.field_2 AS msnname,pf.field_3 AS website,pf.field_4 AS icq_number,pf.field_6 AS location,pf.field_7 AS interests,pf.field_8 AS yahoo
FROM members AS m
LEFT JOIN profile_portal AS pp ON (m.member_id = pp.pp_member_id)
LEFT JOIN pfields_content AS pf ON (m.member_id = pf.member_id)
ORDER BY m.member_id
LIMIT 0, 70


mysql error: Unknown column 'pp.notes' in 'field list'

mysql error number: 1054

Date: Monday 16th 2012f July 2012 09:22:11 PM
Database: chatters_oldf
MySQL error: Unknown column 'pp.notes' in 'field list'

[Ejecutor Hanzo]

Same error here =/

*** Update ***

I fix the problem =D

In impex\systems\ipb3

Search


pp.notes, pp.signature, pp.avatar_location, pp.avatar_size, pp.avatar_type


REMOVE pp.notes from the line, like this:


pp.signature, pp.avatar_location, pp.avatar_size, pp.avatar_type


Save and run impex.

And impex will work fine =)

Greetings!