Problem with registration and with smilies.

[makmak]

Hi from greece.I have a site (www.bmw-fanatics.eu) and i have some problems...
1.A few members have registered with no problems, but certain people click on register, but they go back again on register area (member fields).I take the next message....

(Database error in vBulletin 3.6.5:

Invalid SQL:

SELECT administrator.*,
userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid,
language.phrasegroup_adv_portal_cp AS phrasegroup_adv_portal_cp,
language.phrasegroup_cpglobal AS phrasegroup_cpglobal,
language.phrasegroup_global AS phrasegroup_global,
language.options AS lang_options,
language.languagecode AS lang_code,
language.charset AS lang_charset,
language.locale AS lang_locale,
language.imagesoverride AS lang_imagesoverride,
language.dateoverride AS lang_dateoverride,
language.timeoverride AS lang_timeoverride,
language.registereddateoverride AS lang_registereddateoverride,
language.calformat1override AS lang_calformat1override,
language.calformat2override AS lang_calformat2override,
language.logdateoverride AS lang_logdateoverride,
language.decimalsep AS lang_decimalsep,
language.thousandsep AS lang_thousandsep

FROM user AS user
LEFT JOIN userfield AS userfield ON (user.userid = userfield.userid)
LEFT JOIN usertextfield AS usertextfield ON (usertextfield.userid = user.userid) LEFT JOIN administrator AS administrator ON (administrator.userid = user.userid) LEFT JOIN language AS language ON (language.languageid = IF(user.languageid = 0, 4, user.languageid))

WHERE user.userid = 8;

MySQL Error : Unknown column 'language.phrasegroup_adv_portal_cp' in 'field list'
Error Number : 1054
Date : Wednesday, May 9th 2007 @ 12:12:04 AM
Script : http://www.bmw-fanatics.eu/forums/ad...hp?do=download
Referrer : http://www.bmw-fanatics.eu/forums/ad...dex.php?do=nav
IP Address : 212.54.221.178
Username :
Classname : vB_Database)

2.I can see the smilies on shoutbox,but i can't see them when i put smilie in a post.I can see only the name of the smilie.Some users posting smilie with no problem.
I'm going to crazy.

[Michael Biddle]

MySQL Error : Unknown column 'language.phrasegroup_adv_portal_cp' in 'field list'

You need to add in that column