[Koha-devel] [Bug 98] New: Portability problem with field names

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

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

           Summary: Portability problem with field names
           Product: Koha
           Version: unspecified
          Platform: All
        OS/Version: All
            Status: NEW
          Severity: minor
          Priority: P2
         Component: Database
        AssignedTo: chris at katipo.co.nz
        ReportedBy: a.c.li at ieee.org
         QAContact: koha-devel at lists.sourceforge.net


In old MySQL versions (e.g., 3.21.29), SQL keywords cannot be used for field
names. If Koha is installed on such old systems, the installation can also fail
due to the addition reason that the "index_priv" privilege does not exist. 

During installation, my installer.pl reports

[...]
CREATING DATABASE
=================
Database "Koha" created.
ERROR 1064 at line 749: parse error near 'datetime datetime DEFAULT '0000-00-00
00:00:00' NOT NULL,
  branch varchar(4),
 ' at line 2
ERROR 1054 at line 1: Unknown column 'index_priv' in 'field list'



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