Wrong SQL statement in \F3\Persistence\Backend\GenericPdo\Backend.php
upon testing the blog example, I found a wrong SQL-statement generated in the above mentioned class.
$sql['tables'] = '"entities" AS "_entity", "properties_data" AS "d"';
$sql['tables'] = '"properties_data" AS "d", "entities" AS "_entity"';
The commented line contains the wrong code throwing a SQL-Error.
Hope it helps.
Updated by Regine Rosewich almost 10 years ago
In the meantime I use the Doctrine2 persistence, so the error will not happen any more. But as far as I remember it happend, when trying to add a new post to the blog-example without Doctrine2 Persistence.
I dumped the SQL-Statement with a \F3\var_dump() in Backend.php, cut it out and pasted it into the SQL-editor of PhpMyAdmin. There it threw the same error as in FLOW3.
When changing the syntax as shown in my issue, the error was gone.