need sql help re- xoops/newbb2 to smf

[kayte]

i have run it an issue with my conversion. some columns are missing in my xoops. i'm guessing it may be the versions of xoops/ newbb i have. xoops 2.2.3 and newbb 2.30. i have been making my way through adding the missing columns. however i have hit a snag- i'm not really sure how to fix this. my sql knowledge is limited.

This query:
SELECT
p.post_id AS ID_MSG, p.topic_id AS ID_TOPIC, p.post [nofollow]_time AS posterTime,
p.uid AS ID_MEMBER, p.subject AS subject, u.email [nofollow] AS posterEmail,
IFNULL(u.name, 'Guest') AS posterName, p.poster_ip AS posterIP,
IF(p.nosmiley, 0, 1) AS smileysEnabled, p.forum [nofollow]_id AS ID_BOARD,
REPLACE(pt.post_text, '<br>', '<br />') AS body
FROM (`progressiveparenting_net_-_xoops`.xoops_bb_posts AS p, `progressiveparenting_net_-_xoops`.xoops_bb_posts_text AS pt)
LEFT JOIN `progressiveparenting_net_-_xoops`.xoops_users AS u ON (u.uid = p.uid)
WHERE pt.post [nofollow]_id = p.post [nofollow]_id
LIMIT 0, 200;
Caused the error:

Unknown column 'p.nosmiley' in 'field list'

[kayte]

i figured it out. thanks.