This site uses cookies and similar technologies.

If you don't change browser settings, you agree to it.

I understand
Announcement: Please use Github, to report any new issue or pull request.
None
Andre72
2015-03-02
When I'm using free SQL inside the control I get an exeption when I save the form:
1064 - 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 14 SQL=SELECT article.id AS value, article.title AS text, parent_id FROM p2vcj_content AS article, ( SELECT id, related_nationality AS parent_id FROM xxxxx_cck_store_form_dn_series ) AS related, ( SELECT id, title FROM p2vcj_content WHERE catid =30 ) AS series WHERE article.id = related.id AND parent_id = series.id AND parent_id =#parent_id# order by text

As you can see  parent_id =#parent_id# - placeholder is not replaced

The error occurs in function protected static function _getOptionsList, line 601 of the lattest version as query can nt be executed because of placeholder in query.
Same happens if I try [parent] as shown in replace:
preg_replace( '/('.$opt_parent.' ?= ?\[parent\]|'.$opt_parent.' ?= ?\#parent_id\#)/', $opt_value.' = "'.$value.'"', $opt_query );
.
Get a Book for SEBLOD

Comments