[TYPO3-ttnews] Rights for Categories be_users

Antonio Willybiro keiser_soze at hotmail.com
Thu Mar 23 19:46:46 CET 2006


Hi,
I would also want to know about this.
Anyone have a solution?

Regards,
Antonio

"Joachim Streit" <jstreit at ditnetwork.de> wrote in message 
news:mailman.1.1143026019.31444.typo3-project-tt-news at lists.netfielders.de...
> 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