Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 03 Aug 2011, 18:18
matt94gt matt94gt is offline
 
Join Date: Jul 2011
Change default allowed birthdate year?!

Hi,

I converted from SMF > vBulletin 4 all went fairly well.

Issue is quite a few members bithdates got set to Jan 1 1901, and vbulletin does not like that year.

The problem is members have to reset their passwords, but members with these invalid birthdates cant, they get the error "The solution of task you submitted was incorrect. Please read the
instruction and try again.."

So I wanted to figure out where I can change that and allow 1901 so my members can get online easier.

Thanks!
Reply With Quote
  #2  
Old 03 Aug 2011, 21:34
Spyike Spyike is offline
 
Join Date: Nov 2010
Go to PHPMYADMIN and execute the following query:
SELECT *
FROM `user`
WHERE `birthday` LIKE '%1901%'
LIMIT 0 , 30

When the list of results comes up, you can easily see which users you can either 1) Manually modify their birthdate via ACP or 2) Update all via SQL query
Reply With Quote
  #3  
Old 04 Aug 2011, 00:22
matt94gt matt94gt is offline
 
Join Date: Jul 2011
Originally Posted by Spyike View Post
Go to PHPMYADMIN and execute the following query:
SELECT *
FROM `user`
WHERE `birthday` LIKE '%1901%'
LIMIT 0 , 30

When the list of results comes up, you can easily see which users you can either 1) Manually modify their birthdate via ACP or 2) Update all via SQL query


Thats a bit over my head, I would update all to like 1980 for now, so how would I do that?

Thanks
Reply With Quote
  #4  
Old 04 Aug 2011, 05:39
Spyike Spyike is offline
 
Join Date: Nov 2010
Originally Posted by matt94gt View Post
Thats a bit over my head, I would update all to like 1980 for now, so how would I do that?

Thanks
What I posted may look hard, but it is very easy. Navigate to PHPMYADMIN via cPanel , Plesk, or whatever panel your server is using. You can copy and paste the contents I posted above and you will get your results which you can update.
Reply With Quote
  #5  
Old 04 Aug 2011, 17:00
matt94gt matt94gt is offline
 
Join Date: Jul 2011
Strange its only pulling up one user when I do that query?
Reply With Quote
  #6  
Old 08 Aug 2011, 15:49
matt94gt matt94gt is offline
 
Join Date: Jul 2011
anyone?!
Reply With Quote
  #7  
Old 08 Aug 2011, 16:11
kh99 kh99 is offline
 
Join Date: Aug 2009
Real name: Kevin
Originally Posted by matt94gt View Post
Strange its only pulling up one user when I do that query?
That should have shown the first 30 users with a 1901 birth year (I just tried it and it worked for me). Are you sure you have more than one in the db?
Reply With Quote
  #8  
Old 09 Aug 2011, 00:56
matt94gt matt94gt is offline
 
Join Date: Jul 2011
yes I keep getting emails from members needing help and when i go to reset their logins there dates are set like that.

For some reason only one user is showing up, I know for a fact there are LOTS more then that...any idea?! Maybe im running the query wrong Im going in phpMyAdmin selecting my database from the drop down then running the query.
Reply With Quote
  #9  
Old 15 Sep 2011, 01:19
matt94gt matt94gt is offline
 
Join Date: Jul 2011
anyone?
Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 20:48.

Layout Options | Width: Wide Color: