[Koha-bugs] [Bug 10402] Add multiple contacts for vendors

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

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

Bernardo Gonzalez Kriegel <bgkriegel at gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|Needs Signoff               |Failed QA
                 CC|                            |bgkriegel at gmail.com

--- Comment #38 from Bernardo Gonzalez Kriegel <bgkriegel at gmail.com> ---
There is a problem in updatedatabase.pl
this creates the table, note selected columns (->)

    $dbh->do("CREATE TABLE aqcontacts (
        id int(11) NOT NULL auto_increment,
        name varchar(100) default NULL,
        position varchar(100) default NULL,
        phone varchar(100) default NULL,
        altphone varchar(100) default NULL,
        fax varchar(100) default NULL,
        email varchar(100) default NULL,
        notes mediumtext,
->        claimacquisition BOOLEAN NOT NULL DEFAULT 0,
->        claimissues BOOLEAN NOT NULL DEFAULT 0,
        booksellerid int(11) not NULL,
        PRIMARY KEY  (id),
        CONSTRAINT booksellerid_fk2 FOREIGN KEY (booksellerid)
            REFERENCES aqbooksellers (id) ON DELETE CASCADE ON UPDATE CASCADE
        ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;");

this try to insert into non-existent columns (->)

    $dbh->do("INSERT INTO aqcontacts (name, position, phone, altphone, fax,
            email, notes, booksellerid, -> acq_claim, -> serial_claim)

perl installer/data/mysql/updatedatabase.pl
DBD::mysql::db do failed: Unknown column 'acq_claim' in 'field list' at
installer/data/mysql/updatedatabase.pl line 7176.

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