The SQL query that is working in wpDataTables 1.7 version (Wordpress 5.8.10) is not working  in wpDataTables 6.7.1 version  (Wordpress 6.6.2). 

Error in the new version:

There was an error while trying to save the table!OK

 
"dc85c00003"
"/vitalsports/wp-admin/admin-ajax.php"
 

</colgroup> event_id </th> ranking_overall </th> ranking_gender </th> category </th> chip_number </th> firstname </th> lastname </th> gender </th> chip_time </th> pace </th> cert </th> photos </th> chip_datetime </th> status </th> </tr> event_id</th> ranking_overall</th> ranking_gender</th> category</th> chip_number</th> firstname</th> lastname</th> gender</th> chip_time</th> pace</th> cert</th> photos</th> chip_datetime</th> status</th> </tr> </thead>



</div>
</div>
</div> </div>

</div>
</div>
</div> </div>

</div>
</div>
</div> </div>

</div>
</div>
</div> </div>

</div>
</div>
</div> </div>

</div>
</div>
</div> </div>

</div>
</div>
</div> </div>

</div>
</div>
</div> </div>

</div>
</div>
</div> </div>

</div>
</div>
</div> </div>

</div>
</div>
</div> </div>

</div>
</div>
</div> </div> </div> </div>

572</td> 36</td> 2</td> JUVENIL - 5K</td> 109</td> PAULA MARMOL</td> </td> F</td> 01:30 AM</td> </td> </td> </td> </td> A</td> </tr>
572</td> 25</td> 8</td> MASTER - 5K</td> 82</td> Liliana del carmen Pauta Moreno</td> </td> F</td> 01:03 AM</td> </td> </td> </td> </td> A</td> </tr>
572</td> 21</td> 5</td> SUPER MASTER - 5K</td> 70</td> GLADIS ELVIRA YANCHATUu00d1A TIBAN</td> </td> F</td> 12:56 AM</td> </td> </td> </td> </td> A</td> </tr>
572</td> 20</td> 4</td> SUPER MASTER - 5K</td> 98</td> Clara Esperanza Almeida Buitru00f3n</td> </td> F</td> 12:56 AM</td> </td> </td> </td> </td> A</td> </tr>
572</td> 19</td> 7</td> MASTER - 5K</td> 83</td> JENNY MARGOTH TOPA SORIA</td> </td> F</td> 12:55 AM</td> </td> </td> </td> </td> A</td> </tr>
572</td> 17</td> 6</td> MASTER - 5K</td> 81</td> SILVIA JANETH TIPANTUu00d1A VILATUu00d1A</td> </td> F</td> 12:55 AM</td> </td> </td> </td> </td> A</td> </tr>
572</td> 13</td> 1</td> SENIOR - 5K</td> 112</td> Olivier Sebastian Martu00ednez Vega</td> </td> M</td> 12:47 AM</td> </td> </td> </td> </td> A</td> </tr>
572</td> 10</td> 3</td> SUPER MASTER - 5K</td> 101</td> Manuela Esther Zambrano Saldarriaga</td> </td> F</td> 12:43 AM</td> </td> </td> </td> </td> A</td> </tr>
572</td> 9</td> 3</td> MASTER - 5K</td> 80</td> Johanna Alexandra Bautista Arias</td> </td> F</td> 12:43 AM</td> </td> </td> </td> </td> A</td> </tr>
572</td> 33</td> 10</td> SUPER MASTER - 5K</td> 95</td> Gloria Inu00e9s Teru00e1n Sotelo</td> </td> F</td> 01:18 AM</td> </td> </td> </td> </td> A</td> </tr> </tbody>  

Attached the error that the module answered

Hi Milos 

the original query that was working is:

////////////////////////////////////////////

SELECT ranking_overall as 'Pos Gene', 
       ranking_gender as 'Pos Categ', 
       category as categoria, 
       chip_number as numero, 
       concat(firstname ," ", lastname) as nombres, 
       gender as genero, 
       chip_time as tiempo,
       time_format(sec_to_time(time_to_sec(chip_time) / 3.5),'%i:%s') as ritmo, 
       case photos when '' then '' else COncat("<button class=","submit-button-style"," onclick=","showPicture(['",photos,"'],",chip_number,");"," id=vtsphoto>Ver</button>") end as fotos,
       cert as certificado 
FROM db_vitalsports_web_online_results 
WHERE event_id = 585 and category like '% 3.5K'

/////////////////////////////////

now I have tried the simplest query

SELECT * FROM db_vitalsports_web_online_results

the error :

/////////////

There was an error while trying to save the table!OK
 \n\n \n <\/colgroup>\n \n \n \n\n \n event_id <\/th>\n ranking_overall <\/th>\n ranking_gender <\/th>\n category <\/th>\n chip_number <\/th>\n firstname <\/th>\n lastname <\/th>\n gender <\/th>\n chip_time <\/th>\n pace <\/th>\n cert <\/th>\n photos <\/th>\n chip_datetime <\/th>\n status <\/th>\n <\/tr>\n\n event_id<\/th> ranking_overall<\/th> ranking_gender<\/th> category<\/th> chip_number<\/th> firstname<\/th> lastname<\/th> gender<\/th> chip_time<\/th> pace<\/th> cert<\/th> photos<\/th> chip_datetime<\/th> status<\/th> <\/tr>\n<\/thead>\n \n\n \n \n\n\n\n\n\n<\/div>\n<\/div>\n<\/div>\n <\/div>\n\n<\/div>\n<\/div>\n<\/div>\n <\/div>\n\n<\/div>\n<\/div>\n<\/div>\n <\/div>\n\n<\/div>\n<\/div>\n<\/div>\n <\/div>\n\n<\/div>\n<\/div>\n<\/div>\n <\/div>\n\n<\/div>\n<\/div>\n<\/div>\n <\/div>\n\n<\/div>\n<\/div>\n<\/div>\n <\/div>\n\n<\/div>\n<\/div>\n<\/div>\n <\/div>\n\n<\/div>\n<\/div>\n<\/div>\n <\/div>\n\n<\/div>\n<\/div>\n<\/div>\n <\/div>\n\n<\/div>\n<\/div>\n<\/div>\n <\/div>\n\n<\/div>\n<\/div>\n<\/div>\n <\/div>\n <\/div>\n<\/div>\n

\n \n \n \n \n \n \n \n \n \n

/////////

Hi Milos,

This is a customized table, in which I insert the data coming from xls files 

This is the dump table: https://drive.google.com/file/d/1IpzttOZIa-07ePAgWdE3qjuypQAvz9YI/view?usp=sharing

no positive results

I decided to create the most simple example, with 3.csv files that are attached and have issues with uploading the files. I don´t know where I am failing. I even removed the plugin and installed it again.

I am working in my WAMPP environment in my laptop to not affect the upgrade development to the production env for the client, could it be the issue?

any update on here?

I tested with: 

SELECT * FROM db_vitalsports_web_posts limit 10

same error