Hi, Roman

Sorry for the inconvenience. Our developers will implement a fix as quickly as possible.

-

In the last update, the devs implemented improved sanitizing data from all sources in the plugin and one of them are SQL queries.

This will be fixed in the next update which will be very soon.

Until that, if you can please update this function 

wdtSanitizeQuery

in file wp-content/plugins/wpdatatables/controllers/wdt_functions.php around line 892 you will find this

function wdtSanitizeQuery($query) {  
  $query = str_replace('DELETE', '', $query);   
 $query = str_replace('delete', '', $query);  
  $query = str_replace('DROP', '', $query);  
  $query = str_replace('drop', '', $query);   
 $query = str_replace('INSERT', '', $query);  
  $query = str_replace('insert', '', $query); 
   $query = str_replace('UPDATE', '', $query); 
   $query = str_replace('update', '', $query);  
  $query = str_replace('TRUNCATE', '', $query); 
   $query = str_replace('truncate', '', $query); 
   $query = str_replace('CREATE', '', $query);    
$query = str_replace('create', '', $query);   
 $query = str_replace('ALTER', '', $query);   
 $query = str_replace('alter', '', $query); 
   $query = stripslashes($query);  
  $query = apply_filters('wpdt_sanitize_query',$query);  
  return $query;
} 

and you will need to replace it with this

function wdtSanitizeQuery($query) {   
 $query = str_replace('DELETE ', '', $query); 
   $query = str_replace('DELETE', '', $query); 
   $query = str_replace('delete ', '', $query);  
  $query = str_replace('DROP ', '', $query);  
  $query = str_replace('DROP', '', $query); 
   $query = str_replace('drop ', '', $query); 
   $query = str_replace('INSERT ', '', $query); 
   $query = str_replace('INSERT', '', $query);   
 $query = str_replace('insert ', '', $query); 
   $query = str_replace('UPDATE ', '', $query); 
   $query = str_replace('UPDATE', '', $query);  
  $query = str_replace('update ', '', $query);  
  $query = str_replace('TRUNCATE ', '', $query); 
   $query = str_replace('TRUNCATE', '', $query);  
  $query = str_replace('truncate ', '', $query); 
   $query = str_replace('CREATE ', '', $query);   
 $query = str_replace('CREATE', '', $query);  
  $query = str_replace('create ', '', $query); 
   $query = str_replace('ALTER ', '', $query); 
   $query = str_replace('ALTER', '', $query);   
 $query = str_replace('alter ', '', $query); 
   $query = stripslashes($query);  
  $query = apply_filters('wpdt_sanitize_query',$query);  
  return $query;}

After that insert your requested query and save it and check if everything is OK.

Sorry for the inconvenience once more, and let me know how it goes.

Best regards.

Hey, Roman

We have released the update today. Can you please update the plugin and see, it should be fixed?

Please let me know if you need help. Thank you

Hey, Roman

I am delighted to hear that this has been resolved. Thank you for letting us know.
Anything else that we could assist with, don't hesitate to create new tickets.

Have a great day!