Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Try Vanilla Forums Cloud product
Please upgrade to 2.3 here. The 2.2 and earlier branches are no longer being updated.

Problem with Importing from vBulletin 3.8

This discussion is related to the Vanilla Porter addon.
A.ChakeryA.Chakery New
edited July 2015 in Vanilla 2.0 - 2.3

Hello ,

I am having trouble with exporting my vBulletin 3.8 database .

It gives me this error when I press begin export button :

            insert into VbulletinUserMeta (UserID, Name, Value)
                           select userid, 'Profile.Phone Model', field5 from userfield where field5 != '';Unknown column 'field5' in 'field list'
            Error: (1024) Unknown column 'field5' in 'field list'

Would you please help me to solve this issue ?

Thank you very much.

Comments

  • Ok I solved my previous issue but now it is giving me below error... would you please help me to solve it ?

    Thank you

    select a.attachmentid, a.filename, right(a.filename, instr(reverse(a.filename), '.')) as extension , null as hash, a.filehash, a.userid,
                  'local' as StorageMethod,
                  'discussion' as ForeignTable,
                  t.threadid as ForeignID,
                  FROM_UNIXTIME(a.dateline) as DateInserted,
                  '1' as height,
                  '1' as width,
                  null as filethumb
               from thread t
                  left join attachment a ON a.postid = t.firstpostid
               where a.attachmentid > 0
    
               union all
    
               select a.attachmentid, a.filename, right(a.filename, instr(reverse(a.filename), '.')) as extension , null as hash, a.filehash, a.userid,
                  'local' as StorageMethod,
                  'comment' as ForeignTable,
                  a.postid as ForeignID,
                  FROM_UNIXTIME(a.dateline) as DateInserted,
                  '1' as height,
                  '1' as width
               from post p
                  inner join thread t ON p.threadid = t.threadid
                  left join attachment a ON a.postid = p.postid
               where p.postid <> t.firstpostid and  a.attachmentid > 0
               ;The used SELECT statements have a different number of columns
    
    Error: (1024) The used SELECT statements have a different number of columns 
    
  • R_JR_J Cheerleader & Troubleshooter Munich Moderator

    Not sure if this is a copy & paste error, but since the two select statements have the same amount of columns: have you seen that in your code above in line 26 there is a colon which normally shows the end of a command and afterwards there is the text you get as an error?

  • hgtonighthgtonight ∞ · New Moderator

    The second select doesn't have the filethumb field.

    Search first

    Check out the Documentation! We are always looking for new content and pull requests.

    Click on insightful, awesome, and funny reactions to thank community volunteers for their valuable posts.

Sign In or Register to comment.