[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
>>
>