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