[geeklog-users] Re: emailfromadmin

[Jerry Rocteur]

OUCH.. Sorry.. I have to add it..

I posted because as I had done an upgrade I thought this thing would be 
taken care of..

Sorry.

Jerry

ws in set (0.00 sec)

mysql> describe gl_userprefs
     -> ;
+---------------+---------------------+------+-----+---------+-------+

| Field         | Type                | Null | Key | Default | Extra |

+---------------+---------------------+------+-----+---------+-------+

| uid           | mediumint(8)        |      | PRI | 1       |       |

| noicons       | tinyint(3) unsigned |      |     | 0       |       |

| willing       | tinyint(3) unsigned |      |     | 1       |       |

| dfid          | tinyint(3) unsigned |      |     | 0       |       |

| tzid          | char(3)             |      |     | edt     |       |

| emailstories  | tinyint(4)          |      |     | 1       |       |

| emailfromuser | tinyint(1)          |      |     | 1       |       |

| showonline    | tinyint(1)          |      |     | 1       |       |

+---------------+---------------------+------+-----+---------+-------+
8 rows in set (0.00 sec)


On Sunday, Nov 23, 2003, at 01:11 Europe/Brussels, Jerry Rocteur wrote:


> Thanks heaps Dirk..

>

> I have successfully upgrade from 1.3.5sr1

>

> I get this when I go to user Preferences..

>

> Sat 22 Nov 2003 11:56:38 PM UTC - 1054: Unknown column 

> 'emailfromadmin' in 'field list'. SQL in question: SELECT 

> username,fullname,email,emailfromadmin FROM 

> gl_users,gl_userprefs,gl_group_assignments WHERE gl_users.uid > 1 AND 

> gl_users.uid = gl_userprefs.uid AND emailfromadmin = 1 AND ug_uid = 

> gl_users.uid AND ug_main_grp_id = 13

>

> TIA,

>

> Jerry

>

> On Saturday, Nov 22, 2003, at 23:17 Europe/Brussels, Dirk Haun wrote:

>

>> Jerry,

>>

>>> Stupid question perhaps but I've been out of the loop for a year, 

>>> I've

>>> got 3 Geeklog sites and I'm upgrading, I have different versions but

>>> I'm trying to find out which version I have and I can't find it ??

>>

>> The Geeklog version is really only held in the config.php:

>>

>> if (!defined ('VERSION')) {

>>     define('VERSION', '1.3.8-1sr2');

>> }

>>

>>

>>> // $Id: config.php,v 1.30.2.1 2002/06/09 21:12:33 dhaun Exp $

>>>

>>>  So I guess I have 1.30.2.1 but then, the new one says:

>>

>> Nope, that's only the (CVS) version number of that particular file. 

>> It's

>> not the same as the Geeklog version.

>>

>> bye, Dirk

>>

>>

>> -- 

>> http://www.haun-online.de/

>> http://geeklog.info/

>>

>> _______________________________________________

>> geeklog-users mailing list

>> geeklog-users at lists.geeklog.net

>> http://lists.geeklog.net/listinfo/geeklog-users

>>

>