Extracting leads to MySQL Error about cakephp-translate HOT 4 CLOSED

The issue was with references being a reserved MySQL keyword:

https://dev.mysql.com/doc/refman/5.7/en/keywords.html

Identifier quoting resolves the problem.

The real fix was to rename the field to some unresreved term.

from cakephp-translate.

It should use the default one currently in selection.

from cakephp-translate.

I thought I had one project as default. It even shows me the green tick under default int he project index and detail view. But that's not correct. In the DB i have it set to 0.

from cakephp-translate.

After setting the one translation project I have to default = 1 and status = 1, I get another MySQL error:

Error: SQLSTATE[42000]: Syntax error or access violation: 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 'references, translate_domain_id, active, is_html, created, modified) VALUES ('xyz' at line 1

SQL Query:

INSERT INTO translate_strings (name, references, translate_domain_id, active, is_html, created, modified) VALUES (:c0, :c1, :c2, :c3, :c4, :c5, :c6)

from cakephp-translate.