Hey...
we recently switched from storing customavatars in the DB to storing customavatars in the file system... We've recently (since that) have started having problems with avatars that get uploaded not showing up. They exist in the file system, they show up in the users profile, but they dont show in threads. I was poking around in showthread.php to see if I could figure it out, and saw that theirs a few NOT ISNULL(customavatar.filedata)'s in there... I poked around a bit further, and noticed that all the users who's avatars could not be seen had the filedata set to NULL and everyone else's filedata was set to '' (empty string).
and now all the avatars work. Is this a bug in the code, or just an incorrect DB default left over from an old install? Should I just set it to default to '' instead of NULL in the database?
we recently switched from storing customavatars in the DB to storing customavatars in the file system... We've recently (since that) have started having problems with avatars that get uploaded not showing up. They exist in the file system, they show up in the users profile, but they dont show in threads. I was poking around in showthread.php to see if I could figure it out, and saw that theirs a few NOT ISNULL(customavatar.filedata)'s in there... I poked around a bit further, and noticed that all the users who's avatars could not be seen had the filedata set to NULL and everyone else's filedata was set to '' (empty string).
Code:
mysql> update customavatar set filedata = ''; Query OK, 149 rows affected (0.03 sec) Rows matched: 5605 Changed: 149 Warnings: 0
Comment