problems with calendar birthdays

[marcnyc]

Hello I have enabled the calendar on my board but there is something wrong with the birthdays... Basically it says that all my members (or most of them, at least 20) have birthday today. Can somebody tell me how I can fix this? I have 1.5.1 build 42 and I have converted the board from Gold SP1.1 where I had the birthday mod installed. How can I fix it?
Thanks

[[Unknown]]

Hmmm... how many times have I posted this?

Run this in phpMyAdmin:

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

(replace YYYY-MM-DD with the date you installed the board.)

This, I think, was fixed in Compuart's updated converter.

-[Unknown]

[marcnyc]

I am sorry if I have been redundant with my question but as I have posted somewhere else I was having problems performing searches...

I have tried to run the query you told me and I have replaced the date with the date that all the birthdays show up (I don't remember what day I installed it but I am assuming that must be the date).

I get this error:

Error

SQL-query :  [Edit]

UPDATE yabbse_members SET birthdate=NULL WHERE birthdate=\'2003-02-19\';

MySQL said:

You have an error in your SQL syntax near '\'2003-02-19\'' at line 1


Also I want you to know that before posting this error I have done a search with the words "update birthdate" looking in all boards, message and subject and NOTHING came up!

Also I want you to know I used the latest converter that was available one week ago.

[marcnyc]

Ok I was able to guess that in your code the single quotes might be wrong so I tried without them and I thought that did the trick but PHP MyAdmin said:

Affected rows: 0
SQL-query :
UPDATE yabbse_members SET birthdate=NULL WHERE birthdate=2003-02-19

and althought it showed no error the birthdays are still showing all on Feb 19th on my forum...

[[Unknown]]

Well, for some reason it added slashes... that screwed it up.

Otherwise the query would have worked.

-[Unknown]

[marcnyc]

So what can I do to solve the problem??? I tried with and without single quotes, I also tried with double quotes and it either gives me the error or says 0 rows affected.

[marcnyc]

Does somebody have a fix for this? I still see all my birthdays on one day!  

[[Unknown]]

Hmmm... how many times have I posted this?

Run this in phpMyAdmin:

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

(replace YYYY-MM-DD with the date you installed the board.)

This, I think, was fixed in Compuart's updated converter.

-[Unknown]

This is the fix.

-[Unknown]

[marcnyc]

Ok, but I told you it didn't work...  

[[Unknown]]

Code Select Expand

<?phpinclude 'Settings.php';$dblink = mysqlconnnect($db_server, $db_user, $db_passwd);mysql_select_db($db_name);mysql_query("   UPDATE {$db_prefix}members   SET birthdate=NULL   WHERE YEAR(birthdate) > 2000") or die(mysql_error());?>

-[Unknown]

[marcnyc]

and where exactly do I need to put this code?

do I just create a blank php page with that code and launch it from the browser or what?

[David]

and where exactly do I need to put this code?

do I just create a blank php page with that code and launch it from the browser or what?

Yes, make a new file, bday.php or something like that, and put it in the directory where Settings.php is.  Call it in your browser and once it has run then delete it.

[marcnyc]

Ok this seems to have worked  

For those who will be reading this post the correct code is:

Code Select Expand

<?phpinclude 'Settings.php';$dblink = mysql_connect($db_server, $db_user, $db_passwd);mysql_select_db($db_name);mysql_query("  UPDATE {$db_prefix}members  SET birthdate=NULL  WHERE YEAR(birthdate) > 2000") or die(mysql_error());?>

In the previous example the underscore _ in the mysql_connect function was missing.

Thank you very much for your help.

[[Unknown]]

Heh... your welcome, and sorry about the typo.

-[Unknown]