Today's Birthdays not showing up in WGO

[BGObsession]

I have the option to show 'Today's Birthdays' enabled in my 4.2.1 board's admin cp, but this function has never worked since upgrading to 4.2.1. Is anyone else experiencing this? Anyone got a fix for it? Thanks in advance for any input!

The code text in the FORUMHOME template is as follows:

<!-- today's birthdays -->
<div id="wgo_birthdays" class="wgo_subblock section">
<h3 class="blocksubhead"><img src="{vb:stylevar imgdir_misc}/birthday.png" alt="{vb:rawphrase todays_birthdays}" />{vb:rawphrase todays_birthdays}</h3>
<ol class="commalist">
<vb:each from="birthdays" value="row">
<li><a href="{vb:link member, {vb:raw row}}">{vb:raw row.username}</a><vb:if condition="$row['age']"> ({vb:raw row.age})</vb:if>{vb:raw row.comma}</li>
</vb:each>
</ol>
</div>
<!-- end today's birthdays -->

[ozzy47]

If the user has, Hide Age and Date of Birth or Display Only Age set, they will not show up in there.

[BGObsession]

Thanks! Hey Ozzy, is there a setting to set ALL members to 'Display Only Day and Month of Birth' for all members as a default (so it cannot be changed, or at least, sets all current members to that option)?

Also - is there a working CMS widget to display this same information on the CMS page?

[ozzy47]

Run this querry:

UPDATE `user` SET `showbirthday` = '3';

I would imagine the widget will work now, https://vborg.vbsupport.ru/showthread.php?t=255015

[BGObsession]

I've not 'run a query' before. I assume I should be using the 'execute SQL query' function in the 'Maintenance' section of the Admin CP, but when I select that I get message 'You are not authorized to execute SQL queries'. I am an Admin btw...

[ozzy47]

You need to set you user Id to be able to do thin in the includes/config.php file

	//	****** USERS WITH QUERY RUNNING PERMISSIONS ******
	//	The users specified here will be allowed to run queries from the control panel.
	//	See the above entries for more information on the format.
	//	Please note that the ability to run queries is quite powerful. You may wish
	//	to remove all user IDs from this list for security reasons.
$config['SpecialUsers']['canrunqueries'] = '1';

[BGObsession]

Thanks Ozzy - as always - you are the man! One of the biggest assets on vbulletin.org!

[ozzy47]

Not a problem, glad to help.

[BGObsession]

Hey Ozzy, after running that query I am getting the following error when trying to access my site:

Warning: Cannot modify header information - headers already sent by (output started at [path]/includes/config.php:1) in [path]/includes/functions.php on line 4370

Thoughts?

[ozzy47]

Sounds to me like you messed something up in the config file, undo any changes and see if that fixes it.