Welcome to Geeklog, Anonymous Friday, December 06 2024 @ 06:04 am EST

Geeklog Forums

Mail Users Error


AlphaDominion

Anonymous
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!
 Quote

Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany

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

 Quote

Jameson

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

LuigiMD

Anonymous
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
 Quote

Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
Yes, this is fixed in 1.3.5sr1. It's even listed in the docs/history file :-) bye, Dirk
 Quote

All times are EST. The time is now 06:04 am.

  • Normal Topic
  • Sticky Topic
  • Locked Topic
  • New Post
  • Sticky Topic W/ New Post
  • Locked Topic W/ New Post
  •  View Anonymous Posts
  •  Able to post
  •  Filtered HTML Allowed
  •  Censored Content