Manual insert data into a table

[benjamin1]

Hello,

I need to manually insert data back into table dynamic_field_value which was deleted when I archived some tickets:

INSERT into dynamic_field_value (id,field_id,object_id,value_text) values( ,'27','5439','Test')

Can someone advise how I can populate ID column with next available value.

Thanks, Ben

[root]

There is no need to insert data direct into the table. Use XML-RPC (deprecated), GenericInterface (SOAP/REST) or the Perl API. Never ignore the provided APIs.

[benjamin1]

Is there a way to do it from DB as I am more familiar with SQL than webservice

[root]

Is there a way to do it from DB as I am more familiar with SQL than webservice

I can't recommend bypassing the API. What's your exactly use case?

[benjamin1]

Data loss occurred due to use of a 3rd party plugin (DynamicFieldRemoteDB), when we archived tickets the dynamic field value populated using this plugin was lost.

We have extracted lost data from ticket_history table.

We now need to insert data back into dynamic_field_value table
e.g.
INSERT into dynamic_field_value (id,field_id,object_id,value_text) values( ,'27','5439','Test')

[root]

Data loss occurred due to use of a 3rd party plugin (DynamicFieldRemoteDB), when we archived tickets the dynamic field value populated using this plugin was lost.

That's the first time that I heard this about this add on. And I guess it has nothing to do with the data loss, because the values are stored in the same table. The addon is used when entering new data and displaying the data. :-/

We now need to insert data back into dynamic_field_value table
e.g.
INSERT into dynamic_field_value (id,field_id,object_id,value_text) values( ,'27','5439','Test')

For a one time job you can try this, but be sure to delete all caches after this.