[TYPO3-ttnews] Rights for Categories be_users

Joachim Streit jstreit at ditnetwork.de
Wed Mar 22 12:13:30 CET 2006


Hi
I've severral categories and BE_USERS.
I don't want that group a) could select the newscategory for group b)

so i build this:

BE_USER TSCONFIG:
options.useListOfAllowedItems = 1
tt_newsPerms.tt_news_cat.allowedItems = 19 (uid of the News Cat.)

that fits, if a news was allready made, but not when making a new one.
By making a new "news" I get this erorrs in the backend:
(class.t3lib_db.php DEBUG = TRUE)


caller    t3lib_DB::exec_SELECTquery
ERROR    Unknown column 'NEW441ec7a731bec' in 'where clause'
lastBuiltQuery    SELECT 
tt_news_cat.uid,tt_news_cat.title,tt_news_cat_mm.sorting AS mmsorting
FROM tt_news,tt_news_cat_mm,tt_news_cat
WHERE
tt_news.uid=tt_news_cat_mm.uid_local AND 
tt_news_cat.uid=tt_news_cat_mm.uid_foreign AND 
tt_news_cat_mm.uid_local=NEW441ec7a731bec AND tt_news_cat.pid IN (147)
ORDER BY mmsorting
debug_backtrace
file    /home/httpd/vhosts/domain/httpdocs/typo/t3lib/class.t3lib_db.php
line    254
function    exec_selectquery
class    t3lib_db
type    ->
args
0    tt_news_cat.uid,tt_news_cat.title,tt_news_cat_mm.sorting AS mmsorting
1    tt_news,tt_news_cat_mm,tt_news_cat
2    tt_news.uid=tt_news_cat_mm.uid_local AND 
tt_news_cat.uid=tt_news_cat_mm.uid_foreign AND 
tt_news_cat_mm.uid_local=NEW441ec7a731bec AND tt_news_cat.pid IN (147)
3
4    mmsorting
5

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL 
result resource in 
/home/httpd/vhosts/domain/httpdocs/typo/t3lib/class.t3lib_db.php on line 741


thanx for any hints / and please excuse my horrible english ...


Joachim



More information about the TYPO3-project-tt-news mailing list