error with the order by using the between operator

[AfADaDa1]

Hi,

When I search with the between operator and then try to order by, i get the following error message :

Forbidden
You don't have permission to access index.php on this server.

What should I do to fix this ?



You are using DaDaBIK version 9.4-Monterosso enterprise, installed on 08-06-2019 (installation code: 142225c234f511eb07), the latest version of DaDaBIK is 9.4-Monterosso released on 07-23-2019

You are runnning the last release of DaDaBIK

PHP Version: 7.1.31

mysql version: 5.5.5-10.1.40-MariaDB

Web server: Apache

Client: Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/76.0.3809.100 Safari/537.36

 

[eugenio]

Hello,
I don't think it could be related to the use of the between operator, but please paste here the URL dadabik is trying to access when you get the error so I can investigate further (you can replace your real domain with mysite.com if you want ).

Best,

 

[AfADaDa1]

Hello,

Here is the url :

mysite.com/index.php?tablename=films&function=search&where_clause=%60films%60.%60year_of_publication%60+BETWEEN+%271965%27+AND+%271999%27&page=0&order=film_number&order_type=ASC

Thanks
Best,
Florian

 

[eugenio]

Hello,
the URL is correct so it is not the reason of the error
.
Maybe there is a filter on your Web server that erroneously sees that URL as dangerous?

Is your DaDaBIK running on a hosting provider server? If yes, you could ask them if they can give some more details about the error you see.

Best,