I have a form based on a join of two lists. I can add new record fine. Data is inserted into dbase tables correctly. But if I edit the record and save it, I get the following error.
=================================================
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 SQL=UPDATE `dbase23_mv_content` SET `ContentId`='84',`date_time`='2013-09-15 00:51:05',`report_id`='92',`firstname`='sdffdsfsd',`createdby`='108',`updatedby`='108' WHERE
===================================================
It stops at WHERE clause.
I checked the ids of both lists and the elements are all published and linked. I had a similar issue in the past and it was because the id was not specified in the list configuration/data section.
Thanks.