Master detail SQL error - Incorrect syntax near '='

servgas · Post by **servgas** » Sat Nov 11, 2023 1:09 am

Hi, please, I loaded and generated my old project from phpmaker 2018 to the 2024 version. Every table is working fine.

But one table has a master/detail relation.

But when I click the icon to see the detail I got this error:

C:\xampp\htdocs\checklist\phpmaker\vendor\doctrine\dbal\src\Driver\API\SQLSrv\ExceptionConverter.php(33): An exception occurred while executing a query: SQLSTATE [42000, 102]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Incorrect syntax near '='. SQLSTATE [42000, 8180]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Statement(s) could not be prepared.

how can I fix this. or what could be the issue.?
thank you
Gustavo

arbei · Post by **arbei** » Sat Nov 11, 2023 9:53 am

You may enable Debug and check the log file for detailed error message with the complete SQL.

AdyUPL · Post by **AdyUPL** » Wed Nov 29, 2023 2:54 pm

We need your sql code you executed on this page.

Propably you have wrong condiion ex. where ID == 1 and its should be a where ID=1 or where ID='1'