Welcome, Guest. Please Login or Register.
October 01, 2024, 03:48:39 PM
Home Help Search Log in Register
News: SMF is the next generation in forum software, almost completely re-written from the ground up, make sure you don't fall for cheap imitations that suffer from feature bloat!

YaBB SE Community  |  English User Help  |  English Help  |  Calendar after convert « previous next »
Pages: [1] Reply Ignore Print
Author Topic: Calendar after convert  (Read 4149 times)
Marli
Noobie
*
Posts: 39


I'm a llama!
Calendar after convert
« on: March 16, 2003, 06:15:26 AM »		 Reply with quote
Some time ago I converted my Yabb gold to Yabbse, all went well.

except

I have all people who did not enter a birthday, listed on the same day, the day I converted.

You will see this at www.agforum.info in the moth of January.

Is there a way to fix this. They do not disappear when I choose the option of not displaying birthdays.

Any ideas.
Logged
[Unknown]
Global Moderator
YaBB God
*****
Posts: 7830


ICQ - 179721867unknownbrackets@hotmail.com WWW
Re:Calendar after convert
« Reply #1 on: March 16, 2003, 06:24:34 AM »		 Reply with quote
I will post this query for the 982nd time... I suppose no one will ever use the search button....

UPDATE yabbse_members SET birthdate='00-00-0000' WHERE birthdate='MM-DD-YYYY';

Replace MM-DD-YYYY with the day you installed it, (which is the same day everyone is having a birthday...) and 'yabbse_' with yuor table prefix.

-[Unknown]
Logged
Marli
Noobie
*
Posts: 39


I'm a llama!
Re:Calendar after convert
« Reply #2 on: March 17, 2003, 04:52:51 AM »		 Reply with quote
Sorry, I had a look but didnt see anything, nextime I will look harder.
Logged
Marli
Noobie
*
Posts: 39


I'm a llama!
Re:Calendar after convert
« Reply #3 on: March 17, 2003, 01:14:49 PM »		 Reply with quote
I ran this and it did not change a thing?

It change the members birthdate to 00-00-0000 but they still show on the calendar.

I double checked the string but had it correct.

mmm
Logged
Marli
Noobie
*
Posts: 39


I'm a llama!
Re:Calendar after convert
« Reply #4 on: March 17, 2003, 01:30:02 PM »		 Reply with quote
I found this and it worked

update yabbse_members set birthdate = NULL where birthdate = '2002-11-12'
Logged
[Unknown]
Global Moderator
YaBB God
*****
Posts: 7830


ICQ - 179721867unknownbrackets@hotmail.com WWW
Re:Calendar after convert
« Reply #5 on: March 18, 2003, 01:09:21 AM »		 Reply with quote
Darn... I forgot it wasn't a date.

Too much secret project on the brain.  ;D

-[Unknown]
Logged
Pages: [1] Reply Ignore Print 
YaBB SE Community  |  English User Help  |  English Help  |  Calendar after convert « previous - next »
 


Powered by MySQL Powered by PHP YaBB SE Community | Powered by YaBB SE
© 2001-2003, YaBB SE Dev Team. All Rights Reserved.
SMF 2.1.4 © 2023, Simple Machines
 Valid XHTML 1.0! Valid CSS

Page created in 0.065 seconds with 21 queries.