Geeklog Forums

I just tried testing out the Mail Users functionality in GL 1.3.5 and I got the following error: 1054: Unknown column 'emailfromadmin' in 'field list' I looked for the field 'emailfromadmin' in the following tables and didn't find it: users userprefs group_assignments Can someone please tell me where it should be and how I can remedy this problem? Thanks!

Just had the same problem. While digging around in the SQL files I noticed that the field emailfromadmin is created when you upgrade your database to 1.3.5, but it is not created when you do a fresh install.

So, to fix the problem apply the following SQL request from the update file:

ALTER TABLE userprefs ADD emailfromadmin tinyint(1) NOT NULL DEFAULT '1';

bye, Dirk

Thanks Dirk! I'm glad that someone finally found the problem. =D I was too sloooooowwwww to figure it out. ;p :\\\\ Jameson DiscoBiscuit.com

I checked on the '/sql/mysql_tableanddata.php' and that field 'emailfromadmin' is there on the creation of the 'userprefs' table. I'm using 1.3.5sr1.

Just making it clear because when i read about the bug and tried it, i got a blank screen with nothing but the word 'from' on the upper left corner of the screen (just after pressing submit).

Fyi,
Luigi

Yes, this is fixed in 1.3.5sr1. It's even listed in the docs/history file :-) bye, Dirk