Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 17 Jul 2012, 09:38
gemmk1 gemmk1 is offline
 
Join Date: Oct 2008
users as guests and not all posts where converted over

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'
Reply With Quote
  #2  
Old 23 Aug 2012, 03:05
Ejecutor Hanzo's Avatar
Ejecutor Hanzo Ejecutor Hanzo is offline
 
Join Date: Sep 2006
Same error here =/

*** Update ***

I fix the problem =D

In impex\systems\ipb3

Search

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

REMOVE pp.notes from the line, like this:


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

Save and run impex.

And impex will work fine =)

Greetings!

Last edited by Ejecutor Hanzo : 23 Aug 2012 at 03:50.
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
Forum Jump


New To Site? Need Help?

All times are GMT. The time now is 07:38.

Layout Options | Width: Wide Color: