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!
9
4
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
7
4
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
8
12
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
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
28
7
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