[Len Johnson]

The latest update appears to have inserted a database error for birthdays. The upcoming birthday short code is now showing them one day off, and there are two birthday entries in each contact. Our admin doesn’t want birth years, and had changed the date to ‘9999’. The new entry is one day earlier and uses the current year instead of ‘9999’ for the new entry.

[Steven Zahm]

@ Len

The database is fine, I believe this issue is related to a timezone issue as I can not replicate it. I’m certain this issue popped up because the dates can now be properly internationalized.

Another user resolved the issue by manually setting the timezone with this function: date_default_timezone_set

They’ve kindly given me access to the server and site so I can debug this.

As for putting the date in as 9999 … the upcoming list calculates the next date, not the actual date. For example lets say a persons birthday occurs in April, since it is now June, the birthday will show up as the date in April 2014. Conversely, if the person’s birthday is in July, it will show up with a 2013 date in July.

[Len Johnson]

Thanks Steve. I took a look at the connections_data table and I see what you mean about the DB. Regarding the date, I was talking about the ‘manage’ area of Connections management. You see two birthdate entries for any user you choose, one the 9999 (or whatever you entered when creating the entry originally) and a second birthdate preceding it with the upcoming birthdate (as you describe) which we can’t get rid of. There are two such entries for every user. This was like the problem we had earlier which you fixed for us.

I don’t believe I killed the access I gave you before. If you want to get in and don’t have it, I’d send it to you by email.

I’m not sure what the function you referenced does for me- the timezone is selected in WP settings, and it appears to be correct. Are there timezone settings I should place elsewhere? (I haven’t done much coding in years, and never in php.)

[Steven Zahm]

@ Len

I think I solved the issue with the birthdates. I’m converting the time to GMT which, I think, was throwing off the timezone offset. Working with dates and timezones is annoyingly difficult, especially when you throw in internationalization into the mix.

If you’d like, send me the temp WordPress admin account and I’ll take a look…

One thing that still does not make sense is the double date. I’d have to see that.

[Len Johnson]

You should receive an admin user acct at the help desk email addr.

[Steven Zahm]

@ Len

Ok, I think I narrowed the issue down and made a hotfix to your site. Can you check to make sure the dates are correct? Also, I did edit the dates in testing for both Donna A. and Connie B. I think I’m certain I get used to correct date, but I suggest double checking me.

[Stewart Savage]

@ Steve

I am having the same problem except that some of my entries have double birthdays and others do not. I found that the entries I imported into Connections display only a single birthday. However, as soon as an entry is modified in some manner and updated, two birthdays are displayed in the entries.

[Steven Zahm]

@ Stewart

The update, 0.7.8, I will be releasing in the next couple day should address this. Please let me know if it does not.

[Len Johnson]

IT looks good Steve– I’ll put the update in and let you know how that looks. Thanks!

[Gilbertmi]

This reply has been marked as private.

[Author]

Posts