[TYPO3] problem to update tt_news

[Andreas Balzer]

Andreas Balzer schrieb:
> Hi! I would like to update tt_news 1.0.4 to the current version in TER, 
> but i get the following error as soon as i clicked on install:
> You have an error in your SQL syntax; check the manual that corresponds 
> to your MySQL server version for the right syntax to use near ') as 
> testit FROM tt_news LEFT JOIN tt_news_cat_mm ON 
> tt_news.uid=tt_news_cat_' at line 1
> 
> I also tried to set the news plugin manually, but it doesn't display 
> anything in the FE. What can i do to update?
> 
> Andreas

Hi!
Does anyone has an idea about what i can do?
I mean the error doesn't show any file that could be corrupted or 
anything special..

What could cause an error like this, and how can i get rid of it?

How can i delete the tt_news tables, reinstall tt_news and restore the 
backup?

Or is there a possibily to add the tables manually into the database (as 
EM shows, that there is something missing..)

Please help me... ..please :-/

Andreas