Hello,

I have the plugins wpDataTable which was working fine. But after the update, I notice that the Advanced filters is not working is no more working on my site (http://etlsx.ecowas.int/liste-de-produits-aggrees/?lang=fr).

It's  giving "No matching records found".

I have gone through all the setings but no good result.

Please advise.

Dear Milan,

In fact I have found the problem.  It was in the query. I have just added a parenthese "(" after FROM and before WHERE and it's ok.

Thank you for the reaction.

Paul

SELECT 
      B.countryname,
      C.company,
      C.address,
      D.product,
  FROM (A
INNER JOIN B
     ON A.prodid = D.id
INNER JOIN C
     ON A.companyid = C.id
INNER JOIN D
ON A.countryid = B.id)
  WHERE D.langid = 2