Doctrine syntax error with field named "order"

Question

I have the following ajax call ``` var prev_sibling = $(this).prev().attr("value"); var next_sibling = $(this).next().attr("value"); var order = (prev_sibling + next_sibling)/2; var data = {PID:element_id, TGID:parent_id, ORD:order}; $.ajax({ type: "POST", data: data, url:"{{ path('v2_pm_patents_dragpatents') }}", cache: false }); ``` And in my action I get the order and set it like this ``` $order = $request->get('ORD'); $patent->setOrder($order); ``` but the ajax call give me thew following error ``` 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 'order = '750' WHERE id = '0d0c0810-bc75-11e1-96a5-9787dec335c2'' at line 1 (500 Internal Server Error) ``` I get the post data correctly and the query which gives me these records is also working fine. Where is the problem? Any ideas? Thanks in advance

Accepted Answer

The problem is `order` being a reserved word in MySQL. If you are using doctrine you can tell it to escape reserved words in the mapping like so:

```
/** @Column(name="`order`", type="integer") */
private $order;
```

http://docs.doctrine-project.org/en/latest/reference/basic-mapping.html#quoting-reserved-words

Doctrine syntax error with field named "order"

Solution

Problem