مشكله في UPDATE user SET

[live]

محتاج مساعدتكم في هذه المشكلهذ
UPDATE user SET

Database error in vBulletin 3.0.3:

Invalid SQL: UPDATE user SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
    username = 'xxxxxx',
    email = 'xxxxxx@hotmail.com',
    languageid = '0',
    usertitle = '<img src=\"http://www.xxxxxx.com/vb/images/deaf/55.gif\" width=\"110\" height=\"20\">',
    customtitle = '1',
    homepage = 'http://www.xxxxxx.com',
    icq = '',
    aim = '-',
    yahoo = '-',
    msn = '',
    parentemail = 'xxxxxx@hotmail.com',
    posts = '2186',
    ipaddress = '213.42.2.6',
    usergroupid = '5',
    reputation = '30',
    pmpopup = '1',
    autosubscribe = '1',
    showvbcode = '1',
    styleid = '0',
    timezoneoffset = '4',
    daysprune = '-1',
    threadedmode = '0',
    referrerid = '0',
    joindate = '1060084800',
    lastvisit = '1095670140',
    lastactivity = '1095671940',
    lastpost = '1095671940',
    birthday = '07-17-0000',
    birthday_search = '0000-07-17',
    options = '7511',
    reputationlevelid = '5',
    membergroupids = '',
    displaygroupid = '0'
WHERE userid=2
mysql error: Unknown column 'birthday_search' in 'field list'

mysql error number: 1054

Date: Monday 20th of September 2004 06:11:02 PM
Script: [url]http://www.xxxxxx.com/vb/admincp/user.php[/url]
Referer: [url]http://www.xxxxxx.com/vb/admincp/user.php?do=edit&userid=2[/url] 

[all-the-vb]

اضف التالى لقاعدة البيانات الـphpmyadmin :

ALTER TABLE `user` ADD ` birthday_search` DATE DEFAULT '0000-00-00' NOT NULL AFTER `birthday` ;

[live]

اخوي تسلم يدك بس هذا الرد الي يوصني بعد مانفذ الامر
MySQL قال:


#1060 - Duplicate column name ' birthday_search'

[all-the-vb]

اخوي تسلم يدك بس هذا الرد الي يوصني بعد مانفذ الامر
MySQL قال:


#1060 - Duplicate column name ' birthday_search'

خلاص تمت اضافة المطلوب,
اذهب الى المنتدى والى مكان الخطأ وتاكد من انه اختفى.

[live]

Database error in vBulletin 3.0.3:

Invalid SQL: 
                SELECT
                user.userid, reputation, username, usergroupid, birthday_search, email,
                parentemail,(options & 8) AS coppauser, homepage, icq, aim, yahoo, msn, signature,
                usertitle, joindate, lastvisit, lastpost, posts, ipaddress, userfield.*
                FROM user AS user
                LEFT JOIN userfield AS userfield ON(userfield.userid = user.userid)
                LEFT JOIN usertextfield AS usertextfield ON(usertextfield.userid = user.userid)
                WHERE 1=1 AND lastactivity > 1095888836
                ORDER BY lastvisit DESC
                LIMIT 0, 25
        
mysql error: Unknown column 'birthday_search' in 'field list'

mysql error number: 1054

Date: Thursday 23rd of September 2004 09:34:03 PM
Script: [url]http://www.xxxxxxx.com/vb/admincp/user.php?do=find&user[/url][lastactivityafter]=1095888836&orderby=lastvisit&direction=DESC
Referer: [url]http://www.xxxxxx.com/vb/admincp/[/url] 

الاسف مازبط وشو ف فوق شو طلع لي ؟
ياشباب الي عنده علم يساعدنا يمكن الكود الي انت وضعتها فيه غلط تاكد ياخوك
:shy:

[live]

Database error in vBulletin 3.0.3:

Invalid SQL: 
                SELECT
                user.userid, reputation, username, usergroupid, birthday_search, email,
                parentemail,(options & 8) AS coppauser, homepage, icq, aim, yahoo, msn, signature,
                usertitle, joindate, lastvisit, lastpost, posts, ipaddress, userfield.*
                FROM user AS user
                LEFT JOIN userfield AS userfield ON(userfield.userid = user.userid)
                LEFT JOIN usertextfield AS usertextfield ON(usertextfield.userid = user.userid)
                WHERE 1=1 AND lastactivity > 1095888836
                ORDER BY lastvisit DESC
                LIMIT 0, 25
        
mysql error: Unknown column 'birthday_search' in 'field list'

mysql error number: 1054

Date: Thursday 23rd of September 2004 09:34:03 PM
Script: [url]http://www.xxxxxxx.com/vb/admincp/user.php?do=find&user[/url][lastactivityafter]=1095888836&orderby=lastvisit&direction=DESC
Referer: [url]http://www.xxxxxx.com/vb/admincp/[/url] 

الاسف مازبط وشو ف فوق شو طلع لي ؟
ياشباب الي عنده علم يساعدنا يمكن الكود الي انت وضعتها فيه غلط تاكد ياخوك
:shy:

[bahlink]

السلام عليكم

صادفتي هذه المشكلة من قبل عند تطوير من النسخة الثالثة rc4 إلى 3.03 و حليتها بـأضافة هذا الأمر بقاعدة البيانات

ALTER TABLE `user` ADD birthday_search  DATE NOT NULL