Hello!

I just installed and configured the Staff Directory extension and added some Staff Info Records.
Now, in the FE I'm getting these error messages:

0 Unknown column 'A.name' in 'order clause'
1 SELECT * FROM tx_wecstaffdirectory_info AS A WHERE A.pid in (313) AND A.deleted=0 AND A.t3ver_state<=0 AND A.hidden=0 AND A.sys_language_uid IN (0,-1) ORDER BY A.last_name ASC,A.name

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /var/www/web31/html/t3lib/class.t3lib_db.php on line 796

I thought it is because of the missing extension sr_fe_users but it did no good installing it.
I'm using Typo3 4.2.0alpha, PHP 5.2.0 and MySQL 5.0.32.

Any suggestions would be much appreciated!
Thank you so much and god bless.

Hi Timo,

I missed getting that problem into the release version. I had found it testing, and somehow it did not get in. The problem is that the 'full_name' is new field name in the table, not 'name'. The sorting is done by "name".

I will send you a fix on Monday that will take care of this problem. I will release an update next week too after getting additional feedback.

I appreciate you finding this and sorry it caused the problem.

-Dave

Hi Dave,
thank you for the quick reply!

I have to compliment you on the great work you're doing here and on the outstanding and exceptional support.
Keep at it!

Timo

Hi Timo,

Please download the following, and then upload it through your server in the Ext Manager. It should fix the bug. Let me know if you have any problems.

http://svn.webempoweredchurch.org/wec_staffdirectory/chrome/site/downloads/nightly/wec_staffdirectory-1_2_0-r84.t3x

This will be released in version 1.2.1 soon.

-Dave

Hi Dave,

works like a charm!
Thank you very much!

I recognized another "problem". I will open up a new thread for this.

Timo