Bug #33639
Error in mySQL Statements with columnnames like "from" or "char"
| Status: | Rejected | Start date: | 2012-02-02 | |
|---|---|---|---|---|
| Priority: | Won't have this time | Due date: | ||
| Assigned To: | Karsten Dambekalns | % Done: | 0% |
|
| Category: | Persistence | |||
| Target version: | - | |||
| PHP Version: | Complexity: | |||
| Has patch: | No | Affected Flow version: | FLOW3 1.0.2 |
Description
The mySQL Statements must be escaped with `columnname`
SQLSTATE42000: 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 'from VARCHAR DEFAULT NULL, PRIMARY KEY) ENGIN' at line 1
Related issues
History
#1 Updated by Karsten Dambekalns over 3 years ago
- Category set to Persistence
- Status changed from New to Rejected
- Assigned To set to Karsten Dambekalns
- Priority changed from Must have to Won't have this time
As per the recommendations in Doctrine 2, no automatic quoting is done. You are advised to not use reserved words as column names. If needed you can add a Column annotation and provide a different column name for a property.