[Koha-bugs] [Bug 1280] New: Reserved MySQL keywords in koha.mysql

[bugzilla-daemon at daddy.katipo.co.nz]

http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=1280

           Summary: Reserved MySQL keywords in koha.mysql
           Product: Koha
           Version: 2.2.7
          Platform: PC
        OS/Version: All
            Status: NEW
          Severity: trivial
          Priority: P2
         Component: Database
        AssignedTo: chris at katipo.co.nz
        ReportedBy: cboyce at sonic.net
         QAContact: koha-bugs at nongnu.org


Using MySQL 5.0.22, hoka.mysql causes an error when it encounters the 'return'
field in the itemtypes table.  'return' is a reserved keyword
<http://dev.mysql.com/doc/refman/5.0/en/reserved-words.html>, and putting
quotes around it fixed the problem on my sytem.

koha.mysql:
780c780
<   return char(4) default NULL,
---
>   `return` char(4) default NULL,




------- You are receiving this mail because: -------
You are the QA contact for the bug, or are watching the QA contact.