Update column a_body

Moderator: crythias

Locked
tka
Znuny newbie
Posts: 2
Joined: 01 Mar 2013, 14:18
Znuny Version: 3.0.11

Update column a_body

Post by tka »

Hi all
I have a problem with updating fields a_body table article
I need to change the content of a_body
I do

Code: Select all

update article set a_body='change contetnt......' where ticket_id=4308 and id=13376;
and the gui, nothing changes. I have restart otrs and nothing.
crythias
Moderator
Posts: 10170
Joined: 04 May 2010, 18:38
Znuny Version: 5.0.x
Location: SouthWest Florida, USA
Contact:

Re: Update column a_body

Post by crythias »

because the document came in as HTML, you also have to edit the blob
OTRS 6.0.x (private/testing/public) on Linux with MySQL database.
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
tka
Znuny newbie
Posts: 2
Joined: 01 Mar 2013, 14:18
Znuny Version: 3.0.11

Re: Update column a_body

Post by tka »

I change the type of mediumtext the blob?
crythias
Moderator
Posts: 10170
Joined: 04 May 2010, 18:38
Znuny Version: 5.0.x
Location: SouthWest Florida, USA
Contact:

Re: Update column a_body

Post by crythias »

no, you need to edit the blob in article_plain.body
OTRS 6.0.x (private/testing/public) on Linux with MySQL database.
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
Locked