[TYPO3] BE user error with tt_news

[Lars Axberg]

Well it's already in the bugtracker
http://bugs.typo3.org/bug_view_advanced_page.php?bug_id=4016#bugnotes
updated last 10.08.06 and the status is "new" how is that possible almost 2
years after...

 - Lars

-----Oprindelig meddelelse-----
Fra: typo3-english-bounces at lists.netfielders.de
[mailto:typo3-english-bounces at lists.netfielders.de] På vegne af Dmitry
Dulepov [typo3]
Sendt: 16. april 2008 09:46
Til: typo3-english at lists.netfielders.de
Emne: Re: [TYPO3] BE user error with tt_news

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"
_______________________________________________
TYPO3-english mailing list
TYPO3-english at lists.netfielders.de
http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-english