Problem with Importing from vBulletin 3.8

A.Chakery

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.

A.Chakery

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_J

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?

hgtonight

The second select doesn't have the filethumb field.