[TYPO3] BE user error with tt_news

Dmitry Dulepov [typo3] dmitry at typo3.org
Wed Apr 16 09:45:39 CEST 2008


Lars Axberg wrote:
> I've created som BE users which should be able to create and edit tt-news
> records. I've set up the permissions, but when I try to make a new News
> record, I get an MySql error:
> 
> callert3lib_DB::exec_SELECTquery
> ERRORUnknown column 'NEW4805a1e5b914f' in 'where clause'
> lastBuiltQuerySELECT
> 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=NEW4805a1e5b914f AND tt_news_cat.pid IN (107)
> ORDER BY mmsorting
> debug_backtraceSC_alt_doc->main // SC_alt_doc->makeEditForm //
> t3lib_TCEforms->getMainFields // t3lib_TCEforms->getSingleField //
> t3lib_TCEforms->getSingleField_SW // t3lib_TCEforms->getSingleField_typeUser
> // t3lib_div->callUserFunction // call_user_func_array //
> tx_ttnews_treeview->displayTypeFieldCheckCategories //
> t3lib_DB->exec_SELECT_mm_query // t3lib_DB->exec_SELECTquery //
> t3lib_DB->debug
> 
> When I'm logged in as admin I don't get the error. The BE user can still
> inspite of the error message write and publish the news. has anybody got a
> clue?

Please, post into bug tracker! The issue looks pretty serious.

-- 
Dmitry Dulepov
TYPO3 core team
Web: http://typo3bloke.net/
Skype: callto:liels_bugs
"Nothing is impossible. There are only limits to our knowledge"


More information about the TYPO3-english mailing list