[Koha-bugs] [Bug 13790] Add unique id issue_id to issues and old_issues tables

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

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

Dobrica Pavlinusic <dpavlin at rot13.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |dpavlin at rot13.org

--- Comment #34 from Dobrica Pavlinusic <dpavlin at rot13.org> ---
I have problem with this patch. When applied to our database it generates
following errors:


    [Mon Apr 27 12:33:40 2015] updatedatabase.pl: DBD::mysql::db do failed:
Multiple primary key defined at
/srv/koha/installer/data/mysql/updatedatabase.pl line 10166.
    [Mon Apr 27 12:33:40 2015] updatedatabase.pl: DBD::mysql::db do failed:
Unknown column 'issue_id' in 'order clause' at
/srv/koha/installer/data/mysql/updatedatabase.pl line 10170.
    [Mon Apr 27 12:33:40 2015] updatedatabase.pl: DBD::mysql::st execute
failed: Unknown column 'me.issue_id' in 'field list' at
/usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1481.
    DBIx::Class::ResultSetColumn::max(): Unknown column 'me.issue_id' in 'field
list' at /srv/koha/installer/data/mysql/updatedatabase.pl line 10174


It seems that

ALTER TABLE issues ADD issue_id INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY
FIRST

doesn't work because we already have itemnumber defined as primary key. Should
we drop it before this alter table?

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