www.hkvforums.com

Hi,i have a "Custom View" when do the search shows this error.

PHPMaker v2017.0.7

Failed to execute SQL. Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '[corp_fmto_detalle].[corp_2_cliente] = 4 LIMIT 0, 20' at line 1

search by dates:
Failed to execute SQL. Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '[corp_fmto_detalle].[corp_2_fechahora] BETWEEN '2018-01-01' AND '2018-01-31' LIM' at line 1

Thanks.

Change [ and ] to ` character respectively.

mobhar wrote:
Change [ and ] to ` character respectively.

This change where it applies in phpmaker or in a file *.php

eayvl wrote:
mobhar wrote:
Change [ and ] to ` character respectively.

This change where it applies in phpmaker or in a file *.php

I think he is talking about to change the [ and ] to ` character in your SQL.