Master detail SQL error - Incorrect syntax near '='

This public forum is for user-to-user discussions of PHPMaker. Note that this is not support forum.
Post Reply
Posts: 48

Master detail SQL error - Incorrect syntax near '='

Post by servgas »

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

Posts: 8746

Post by arbei »

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

Posts: 24

Post by AdyUPL »

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'

Post Reply