I installed the update and then set it up, and got this email.

Database error in vBulletin 4.0.3:

Invalid SQL:

SELECT forumid FROM vbwsm_forum
WHERE (forum.options & 4096)
ORDER BY forumid;

MySQL Error : Unknown column 'forum.options' in 'where clause'
Error Number : 1054
Request Date : Saturday, June 25th 2011 @ 12:21:01 PM
Error Date : Saturday, June 25th 2011 @ 12:21:01 PM
Script : http://www.westsidemustangs.com/cron...and=1309022460
Referrer : http://www.westsidemustangs.com/forum.php
IP Address : 99.153.185.197
Username : Unregistered
Classname : vB_Database
MySQL Version :

Brain fart - fixed (again) :D

I re installed, updated the settings and got this email.


************************************************** ****

Database error in vBulletin 4.0.3:

Invalid SQL:
SELECT userid, username, usergroupid, birthday, showbirthday, posts, timezoneoffset,
DATE_FORMAT(DATE_ADD(UTC_TIMESTAMP(), INTERVAL ((timezoneoffset - 4)*60) MINUTE), '%D of %M') AS BDisplay,
(DATE_FORMAT(DATE_SUB(UTC_TIMESTAMP(), INTERVAL (timezoneoffset - 4) HOUR), '%Y') - SUBSTRING(birthday,7,4)) AS UserAge
FROM vbwsm_user
WHERE birthday LIKE DATE_FORMAT(DATE_ADD(UTC_TIMESTAMP(), INTERVAL ((timezoneoffset - 4)*60) MINUTE), '%m-%d%%')
AND showbirthday > '1'
AND usergroupid NOT IN (1,3,4,8,45,51)
AND userid NOT IN (SELECT ap_birthday.userid FROM vbwsm_ap_birthday);

MySQL Error : Unknown column 'ap_birthday.userid' in 'field list'
Error Number : 1054
Request Date : Sunday, June 26th 2011 @ 12:00:30 AM
Error Date : Sunday, June 26th 2011 @ 12:00:30 AM
Script : http://www.westsidemustangs.com/cron...and=1309064428
Referrer : http://www.westsidemustangs.com/sear...earchid=400030
IP Address : 208.54.83.141
Username : Unregistered
Classname : vB_Database
MySQL Version :

seams to work fine for me on 4.1.4

Ahhhhhhhhhhh!!!! It databases with pre-fix table names - which i don't use. I only do that by eyeballing the code.


Mea culpa :(

do we need to update the xml file or just the ap_birthday.php file

Just the ap_birthday.php, but the XML ups the version number so you can track it.

Do this allow you to turn off the PM option while keeping the thread option open?

Well 1.0.5 seems to be working fine now. I didn't receive any database error emails, but I also don't appear to have any birthdays today..

Thank you for all of your help!

No, but 1.0.6 will :D