Update body of note from outside, but not display in OTRS

bhcuong2008 · Post by **bhcuong2008** » 25 Mar 2013, 15:18

Hi,

I face an issue, but can't figure out this. I added an internal note to a ticket. After that, I wanted to change its body (content), then I modify its content with db admin tool. If using query statement in SQL Box of OTRS to read it (select * from article where id = xxx), it displays right content. But when viewing in Ticket Zoom, it only shows the old content, I dont see any new content of that note.

Thanks,

Post by **crythias** » 25 Mar 2013, 15:45

you need to update the blob in article_plain (yeah, I know.)

jojo · Post by **jojo** » 25 Mar 2013, 16:33

you should not write manually in the database.

Also cache updates will be needed. Only use API for writing data to OTRS DB

bhcuong2008 · Post by **bhcuong2008** » 25 Mar 2013, 18:52

Hi crythias,

I dont see any entry in article_plain with article_id that I want to modify.

@jojo: I deleted cache, also restart apache, mysql server. I did it yesterday. Until now, it's not been updated.

jojo · Post by **jojo** » 25 Mar 2013, 19:06

again, manipulating the database directly is not supported

bhcuong2008 · Post by **bhcuong2008** » 25 Mar 2013, 19:27

I found it

. It's in article_attachment.

@jojo: I know. I do it very limited.

Thank all,

Znuny Open Source Ticketsystem

Update body of note from outside, but not display in OTRS

Update body of note from outside, but not display in OTRS

Re: Update body of note from outside, but not display in OTR

Re: Update body of note from outside, but not display in OTR

Re: Update body of note from outside, but not display in OTR

Re: Update body of note from outside, but not display in OTR

Re: Update body of note from outside, but not display in OTR