[Koha-bugs] [Bug 6716] Database Documentation

[bugzilla-daemon at bugs.koha-community.org]

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716

Paul Poulain <paul.poulain at biblibre.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|Needs Signoff               |Signed Off

--- Comment #123 from Paul Poulain <paul.poulain at biblibre.com> ---
seems there's something wrong with -- comment at table level

I applied all those patches, then tried to load kohastructure.sql, and got a
nasty:
ERROR 1064 (42000) at line 2737: 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 '--information related to the basket line items
  `ordernumber` int(11) NOT NULL ' at line 1

which is:
DROP TABLE IF EXISTS `aqorders`;
CREATE TABLE `aqorders` ( --information related to the basket line items
  `ordernumber` int(11) NOT NULL auto_increment, -- primary key and unique
identifier assigned by Koha to each li     ne

seems mySQL don't like the --SOMETHING without space: after adding a space:
CREATE TABLE `aqorders` ( -- information related to the basket line items

things are OK

signed off, passed QA and pushed in master branch all in one go.

Thx for your hard work Nicole !

-- 
You are receiving this mail because:
You are watching all bug changes.