some database columns in Koha match SQL reserved-words this bug will attempt to locate these columns, and rename them fyi: here's some links for reserved-words in mysql and postgres... http://dev.mysql.com/doc/refman/5.5/en/reserved-words.html http://www.postgresql.org/docs/8.1/static/sql-keywords-appendix.html and some other dbs too... http://www.adp-gmbh.ch/ora/sql/reserved_words.html http://msdn.microsoft.com/en-us/library/aa238507(v=sql.80).aspx http://drupal.org/node/141051
(In reply to comment #0) > some database columns in Koha match SQL reserved-words > > this bug will attempt to locate these columns, and rename them afaik, there are 2 offending columns in Koha... - old_issues.return - issues.return i'll attempt to use a script to find more :)
(In reply to Mason James from comment #1) > (In reply to comment #0) > > some database columns in Koha match SQL reserved-words > > > > this bug will attempt to locate these columns, and rename them > > afaik, there are 2 offending columns in Koha... > - old_issues.return > - issues.return > > i'll attempt to use a script to find more :) hmm, this has got to be a WONTFIX, i think.. :p