Profile edit birthday problems

[Alovepoem]

Warning: #1265 Data truncated for column 'birthday_search' at row 1

SQL sorgusu:UPDATE `forum`.`user` SET `birthday` = '',
`birthday_search` = '',
`startofweek` = '-1' WHERE `user`.`userid` =2 LIMIT 1 ;

Php myadmin search code;

UPDATE `adminlog` SET `userid` = '2' WHERE `adminlog`.`userid` =62;
UPDATE `announcement` SET `userid` = '2' WHERE `announcement`.`userid` =62;
UPDATE `announcementread` SET `userid` = '2' WHERE `announcementread`.`userid` =62;
UPDATE `attachment` SET `userid` = '2' WHERE `attachment`.`userid` =62;
UPDATE `calendarmoderator` SET `userid` = '2' WHERE `calendarmoderator`.`userid` =62;
UPDATE `cpsession` SET `userid` = '2' WHERE `cpsession`.`userid` =62;
UPDATE `customavatar` SET `userid` = '2' WHERE `customavatar`.`userid` =62;
UPDATE `customprofilepic` SET `userid` = '2' WHERE `customprofilepic`.`userid` =62;
UPDATE `deletionlog` SET `userid` = '2' WHERE `deletionlog`.`userid` =62;
UPDATE `editlog` SET `userid` = '2' WHERE `editlog`.`userid` =62;
UPDATE `event` SET `userid` = '2' WHERE `event`.`userid` =62;
UPDATE `forumread` SET `userid` = '2' WHERE `forumread`.`userid` =62;
UPDATE `infraction` SET `userid` = '2' WHERE `infraction`.`userid` =62;
UPDATE `moderator` SET `userid` = '2' WHERE `moderator`.`userid` =62;
UPDATE `moderatorlog` SET `userid` = '2' WHERE `moderatorlog`.`userid` =62;
UPDATE `passwordhistory` SET `userid` = '2' WHERE `passwordhistory`.`userid` =62;
UPDATE `paymentinfo` SET `userid` = '2' WHERE `paymentinfo`.`userid` =62;
UPDATE `pm` SET `userid` = '2' WHERE `pm`.`userid` =62;
UPDATE `pmreceipt` SET `userid` = '2' WHERE `pmreceipt`.`userid` =62;
UPDATE `pollvote` SET `userid` = '2' WHERE `pollvote`.`userid` =62;
UPDATE `post` SET `userid` = '2' WHERE `post`.`userid` =62;
UPDATE `posthash` SET `userid` = '2' WHERE `posthash`.`userid` =62;
UPDATE `reminder` SET `userid` = '2' WHERE `reminder`.`userid` =62;
UPDATE `reputation` SET `userid` = '2' WHERE `reputation`.`userid` =62;
UPDATE `rssfeed` SET `userid` = '2' WHERE `rssfeed`.`userid` =62;
UPDATE `search` SET `userid` = '2' WHERE `search`.`userid` =62;
UPDATE `session` SET `userid` = '2' WHERE `session`.`userid` =62;
UPDATE `sigparsed` SET `userid` = '2' WHERE `sigparsed`.`userid` =62;
UPDATE `sigpic` SET `userid` = '2' WHERE `sigpic`.`userid` =62;
UPDATE `subscribeevent` SET `userid` = '2' WHERE `subscribeevent`.`userid` =62;
UPDATE `subscribeforum` SET `userid` = '2' WHERE `subscribeforum`.`userid` =62;
UPDATE `subscribethread` SET `userid` = '2' WHERE `subscribethread`.`userid` =62;
UPDATE `subscriptionlog` SET `userid` = '2' WHERE `subscriptionlog`.`userid` =62;
UPDATE `tachyforumpost` SET `userid` = '2' WHERE `tachyforumpost`.`userid` =62;
UPDATE `tachythreadpost` SET `userid` = '2' WHERE `tachythreadpost`.`userid` =62;
UPDATE `threadrate` SET `userid` = '2' WHERE `threadrate`.`userid` =62;
UPDATE `threadread` SET `userid` = '2' WHERE `threadread`.`userid` =62;
UPDATE `user` SET `userid` = '2' WHERE `user`.`userid` =62;
UPDATE `useractivation` SET `userid` = '2' WHERE `useractivation`.`userid` =62;
UPDATE `userban` SET `userid` = '2' WHERE `userban`.`userid` =62;
UPDATE `userfield` SET `userid` = '2' WHERE `userfield`.`userid` =62;
UPDATE `usergroupleader` SET `userid` = '2' WHERE `usergroupleader`.`userid` =62;
UPDATE `usergrouprequest` SET `userid` = '2' WHERE `usergrouprequest`.`userid` =62;
UPDATE `usernote` SET `userid` = '2' WHERE `usernote`.`userid` =62;
UPDATE `usertextfield` SET `userid` = '2' WHERE `usertextfield`.`userid` =62;
UPDATE `thread` SET `postuserid` = '2' WHERE `thread`.`postuserid` =62;

Screen;

Please help me

[Lynne]

I don't understand what it is your were trying to do. It looks like you were running a query in phpMyAdmin and got an error? And then what are all the UPDATE statements posted above? Why did you run those - or did you? And I don't have that field in my User CP so I'm not sure what I'm looking at.

[Alovepoem]

My users "Usercp" edit birthday error



screen link: http://img515.imageshack.us/img515/8...gumgunuuq9.png

[Lynne]

Try disabling your plugins and see if you still get this error:
Note: To temporarily disable the plugin system, edit config.php and add this line right under <?php

PHP Code:

define('DISABLE_HOOKS', true); 


[Alovepoem]

I united two user's nick and i tryed to run functions from "Php My Admin".but some parts had been error and united user's birthday selection mode is disactive (off). he has not got birthday function screen same this screen. How does he change his birthday function? Can you help me please. Thanks.

[Lynne]

I don't know. I would try disabling the plugins, as I suggested, and see if the problem goes away. I'd also see if I could change it via the admin panel and then see if it works. You might also try reuploading the php page he is using to see if there is an error in the page causing the problem. Another thing to try is to create a new style with no parent - Styles & Templates > Style Manager > Add New Style > no parent - then have the user use that style and try to change his birthday. See if it works with that style.