Redmine Email Configuration – Resolve Sending Email Notifications

I upgraded my Redmine installation after a while to 2.3.1 and I noticed email notifications weren’t being sent out. I tried to send a test email from “Administration => Settings => Email notifications” and received the following error message: An error occurred while sending mail (wrong argument (Fixnum)! (Expected kind of OpenSSL::SSL::SSLContext)) After trying different…

Calculating MySQL Age from Date of Birth Column and Selecting Records Between Age Range

While developing a Facebook Dating app recently, I needed to return records for a date range between minimum and maximum age from users table but the data was in the date format (birthday). Following select command will calculate the age from the `birthday` column value for you for each record: SELECT EXTRACT(YEAR FROM (FROM_DAYS(DATEDIFF(NOW(),`birthday`))))+0 AS…