Support Forums › Categories › Webmaster Support › Website Development
SQL Query help (vbulletin)

Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Linear Mode
SQL Query help (vbulletin)
DAMINK™ Away
Moderation is Overrated
*****
Posts: 1,782
Threads: 167
Joined: Oct 2009
Reputation: 71
#3
02-25-2012, 07:27 PM
Thanks Load. I ended up working out a way to do it.
Problem was i had many users with invalid DOB and it was throwing a small error.
So i just make them all the same DOB lols.
Using the below query.

UPDATE user
SET birthday = '' , birthday='1970-01-01'
WHERE birthday = '--'

Yea for some reason the birthday column had -- as the DOB instead of 0000-00-00 which is default if none is chosen i believe.
The Rules!
FTW Forum <-- Home of the Damned! --> Join me On MM


Website Find
Reply


Messages In This Thread
SQL Query help (vbulletin) - by DAMINK™ - 02-20-2012, 12:35 AM
RE: SQL Query help (vbulletin) - by Load - 02-20-2012, 04:50 AM
RE: SQL Query help (vbulletin) - by DAMINK™ - 02-25-2012, 07:27 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
  vBulletin any good? Toxic Injection 8 1,696 08-05-2013, 04:13 AM
Last Post: Uzi
  merging vbulletin v4.2.. HELP!! dark_move 0 646 10-20-2012, 12:46 AM
Last Post: dark_move
  MyBB to vBulletin conversion. Outline 0 1,081 06-07-2012, 11:34 AM
Last Post: Outline
  Another Vbulletin theme edit DAMINK™ 13 4,249 12-30-2011, 06:33 PM
Last Post: AceInfinity
  VBulletin theme edits DAMINK™ 5 1,533 12-25-2011, 07:35 PM
Last Post: King

Forum Jump:


Users browsing this thread: 1 Guest(s)