[TYPO3] BE user error with tt_news

Lars Axberg lars at axberg.dk
Wed Apr 16 09:02:29 CEST 2008


Hey

 

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?

 

-          Lars Axberg



More information about the TYPO3-english mailing list