[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