vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)
-   -   Profile edit birthday problems (https://vborg.vbsupport.ru/showthread.php?t=195012)

Alovepoem 10-30-2008 01:18 PM

Profile edit birthday problems
 
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;

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;
https://vborg.vbsupport.ru/
Please help me:mad:

Lynne 10-30-2008 01:48 PM

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 10-30-2008 01:58 PM

My users "Usercp" edit birthday error :(

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

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

Lynne 10-30-2008 02:58 PM

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 10-30-2008 07:16 PM

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 10-30-2008 07:36 PM

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.


All times are GMT. The time now is 05:29 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.02211 seconds
  • Memory Usage 1,732KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_code_printable
  • (1)bbcode_php_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (6)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete