Uploaded image for project: 'Doctrine DBAL'
  1. Doctrine DBAL
  2. DBAL-471

when persisting objects to Doctrine2 and one of the tables are named the same as a MySQL reserved word


    • Type: Improvement
    • Status: Closed
    • Priority: Minor
    • Resolution: Invalid
    • Affects Version/s: 2.3.2
    • Fix Version/s: None
    • Component/s: Platforms
    • Labels:
    • Environment:
      MySQL on Ubuntu


      I am not sure this is a correct posting to your issue tracker, as I am a beginner at development, at least in the sense of doctrine.

      I have an entity named Trigger in my Symfony2 project. I had set the table name to be "trigger", and this did not work. However, the entities were created without any problems, I first discovered the problem when attempting to persist a Trigger entity. The solution was to rename the table to "mtrigger" or something else, but I think the error message could be better somehow. Now it throws an exception with the MySQL error, which only says there's an error in the syntax, and to check the manual. The manual is quite huge and it was a horror for me before I started thinking in the field of reserved words.

      Note that this is just a proposal to an improvement. It might be that it is hard to implement it for you. In that case, please just close the issue.



          • Assignee:
            ocramius Marco Pivetta
            pan100 Per-Øivin Berg Andersen
          • Votes:
            0 Vote for this issue
            2 Start watching this issue


            • Created: