Hi List

I am trying to install the 'WEC Staff Directory', and every ting work fine
in backend, but in frontend I get this error message:
------------------------------
0 Unknown column 'B.last_name' in 'order clause'
1 SELECT * FROM tx_wecstaffdirectory_info AS A, fe_users AS B WHERE
A.feuser_id = B.uid AND A.pid in (165) AND A.deleted=0 AND A.hidden=0 AND
A.hidden=0 ORDER BY B.last_name ASC,B.name

Warning: mysql_fetch_assoc( supplied argument is not a valid MySQL result
resource in /var/lib/typo3/typo3_src-4.0.4/t3lib/class.t3lib_db.php on line
802

Warning: Cannot modify header information - headers already sent by (output
started at /var/lib/typo3/typo3_src-4.0.4/t3lib/class.t3lib_div.php:2787) in
/var/lib/typo3/typo3_src-4.0.4/typo3/sysext/cms/tslib/class.tslib_fe.php on
line 2853
-------------------------------


I use:
TYPO3 ver. 4.0.4
TemplaVoila! ver. 1.1.0
WEC Staff Directory ver. 0.9.4


Does anyone have any idea of what I am doing wrong?


Thanks in advance
Jogvan Olsen


_______________________________________________
TYPO3-english mailing list
TYPO3-english (AT) lists (DOT) netfielders.de
http://lists.netfielders.de/cgi-bin/.../typo3-english

Hi,

> Hi List
>
> I am trying to install the 'WEC Staff Directory', and every ting work fine
> in backend, but in frontend I get this error message:
> ------------------------------
> 0 Unknown column 'B.last_name' in 'order clause'
> 1 SELECT * FROM tx_wecstaffdirectory_info AS A, fe_users AS B WHERE
> A.feuser_id = B.uid AND A.pid in (165) AND A.deleted=0 AND A.hidden=0 AND
> A.hidden=0 ORDER BY B.last_name ASC,B.name
>
> Warning: mysql_fetch_assoc( supplied argument is not a valid MySQL
> result
> resource in /var/lib/typo3/typo3_src-4.0.4/t3lib/class.t3lib_db.php on
> line
> 802
>
> Warning: Cannot modify header information - headers already sent by
> (output
> started at /var/lib/typo3/typo3_src-4.0.4/t3lib/class.t3lib_div.php:2787)
> in
> /var/lib/typo3/typo3_src-4.0.4/typo3/sysext/cms/tslib/class.tslib_fe.php
> on
> line 2853
> -------------------------------
>
>
> I use:
> TYPO3 ver. 4.0.4
> TemplaVoila! ver. 1.1.0
> WEC Staff Directory ver. 0.9.4
>
>
> Does anyone have any idea of what I am doing wrong?
>
>
> Thanks in advance
> Jogvan Olsen
>
>

I don't use this extension. But if you don't hear anything back from this
mailing list, I'd suggest you post the problem on
http://webempoweredchurch.com/suppor...aff-directory/.
Those guys are very responsive and helpful. After all, it's them who made
the extension. Just a thought.

Bing
_______________________________________________
TYPO3-english mailing list
TYPO3-english (AT) lists (DOT) netfielders.de
http://lists.netfielders.de/cgi-bin/.../typo3-english

Hi Jogvan,

The extension requires sr_feuser_register extension to be installed. Do
you have that extension installed? This extends the fe_user record with
additional fields like last_name.

As the developer of the extension, I realize this was an oversite in not
making sr_feuser_register required because the staff directory depends
on those fields. The quick fix is to install this extension. In a future
update, I will look into handling if you do not have sr_feuser_register
installed...and eitehr those fields will not be available or I will make
the extension required.

-Dave Slayback
www.WebEmpoweredChurch.org

Jogvan Olsen wrote:
> Hi List
>
> I am trying to install the 'WEC Staff Directory', and every ting work fine
> in backend, but in frontend I get this error message:
> ------------------------------
> 0 Unknown column 'B.last_name' in 'order clause'
> 1 SELECT * FROM tx_wecstaffdirectory_info AS A, fe_users AS B WHERE
> A.feuser_id = B.uid AND A.pid in (165) AND A.deleted=0 AND A.hidden=0 AND
> A.hidden=0 ORDER BY B.last_name ASC,B.name
>
> Warning: mysql_fetch_assoc( supplied argument is not a valid MySQL result
> resource in /var/lib/typo3/typo3_src-4.0.4/t3lib/class.t3lib_db.php on line
> 802
>
> Warning: Cannot modify header information - headers already sent by (output
> started at /var/lib/typo3/typo3_src-4.0.4/t3lib/class.t3lib_div.php:2787) in
> /var/lib/typo3/typo3_src-4.0.4/typo3/sysext/cms/tslib/class.tslib_fe.php on
> line 2853
> -------------------------------
>
>
> I use:
> TYPO3 ver. 4.0.4
> TemplaVoila! ver. 1.1.0
> WEC Staff Directory ver. 0.9.4
>
>
> Does anyone have any idea of what I am doing wrong?
>
>
> Thanks in advance
> Jogvan Olsen
>
>
_______________________________________________
TYPO3-english mailing list
TYPO3-english (AT) lists (DOT) netfielders.de
http://lists.netfielders.de/cgi-bin/.../typo3-english

Thank You

Just the help I needed...

/Jogvan


"Dave Slayback" <dave (AT) webempoweredchurch (DOT) org> wrote in message
news:mailman.1.1178815276.411.typo3-english (AT) lists (DOT) netfielders.de...
> Hi Jogvan,
>
> The extension requires sr_feuser_register extension to be installed. Do
> you have that extension installed? This extends the fe_user record with
> additional fields like last_name.
>
> As the developer of the extension, I realize this was an oversite in not
> making sr_feuser_register required because the staff directory depends on
> those fields. The quick fix is to install this extension. In a future
> update, I will look into handling if you do not have sr_feuser_register
> installed...and eitehr those fields will not be available or I will make
> the extension required.
>
> -Dave Slayback
> www.WebEmpoweredChurch.org
>
> Jogvan Olsen wrote:
>> Hi List
>>
>> I am trying to install the 'WEC Staff Directory', and every ting work
>> fine in backend, but in frontend I get this error message:
>> ------------------------------
>> 0 Unknown column 'B.last_name' in 'order clause'
>> 1 SELECT * FROM tx_wecstaffdirectory_info AS A, fe_users AS B WHERE
>> A.feuser_id = B.uid AND A.pid in (165) AND A.deleted=0 AND A.hidden=0 AND
>> A.hidden=0 ORDER BY B.last_name ASC,B.name
>>
>> Warning: mysql_fetch_assoc( supplied argument is not a valid MySQL
>> result resource in
>> /var/lib/typo3/typo3_src-4.0.4/t3lib/class.t3lib_db.php on line 802
>>
>> Warning: Cannot modify header information - headers already sent by
>> (output started at
>> /var/lib/typo3/typo3_src-4.0.4/t3lib/class.t3lib_div.php:2787) in
>> /var/lib/typo3/typo3_src-4.0.4/typo3/sysext/cms/tslib/class.tslib_fe.php
>> on line 2853
>> -------------------------------
>>
>>
>> I use:
>> TYPO3 ver. 4.0.4
>> TemplaVoila! ver. 1.1.0
>> WEC Staff Directory ver. 0.9.4
>>
>>
>> Does anyone have any idea of what I am doing wrong?
>>
>>
>> Thanks in advance
>> Jogvan Olsen
>>

_______________________________________________
TYPO3-english mailing list
TYPO3-english (AT) lists (DOT) netfielders.de
http://lists.netfielders.de/cgi-bin/.../typo3-english