October 2012 - Koha-bugs - lists.koha-community.org

[Bug 8915] New: Referential integrity constraints and InnoDB vs MyISAM storage engine
by bugzilla-daemon＠bugs.koha-community.org 22 Apr '13

22 Apr '13

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8915 Priority: P5 - low Change sponsored?: --- Bug ID: 8915 Assignee: gmcharlt(a)gmail.com Summary: Referential integrity constraints and InnoDB vs MyISAM storage engine Severity: enhancement Classification: Unclassified OS: All Reporter: frederic(a)tamil.fr Hardware: All Status: NEW Version: rel_3_10 Component: Architecture, internals, and plumbing Product: Koha An increasing number of Koha functionalities rely on database level referential integrity constraints. For example, see bug 1963, when a biblio record is deleted, it is also deleted in all the virtual shelves containing it. If you do: SHOW CREATE TABLE virtualshelfcontents you see this specific constraint: CONSTRAINT shelfcontents_ibfk_2 FOREIGN KEY biblionumber REFERENCES biblio (biblionumber) ON DELETE CASCADE ON UPDATE CASCADE, Depending on MySQL storage engine, constraints are supported or not. InnoDB support referential integrity constraints, MyISAM doesn't. Since version 5.1, MySQL default storage engine is InnoDB. Prior to this version, MyISAM was the default engine. So depending on various parameters, a Koha DB can contain MyISAM tables, therefore without integrity constraints, when those constraints are required by Koha for proper operations. Those parameters are: - Old Koha DB can have been created at first place with MyISAM engine, and never upgraded to InnoDB. - The upgrade to InnoDB can have been done later, but some constraints have been added by updatedatabase.pl when tables was still MyISAM. - The InnoDB can be silently disabled on the server: DBA choice, bad my.cnf configuration, etc. -- You are receiving this mail because: You are watching all bug changes.

1 16

[Bug 6428] New: refered column 'items.coded_location_qualifier' does not exist
by bugzilla-daemon＠bugs.koha-community.org 22 Apr '13

22 Apr '13

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6428 Bug #: 6428 Summary: refered column 'items.coded_location_qualifier' does not exist Classification: Unclassified Change sponsored?: --- Product: Koha Version: master Platform: All OS/Version: All Status: NEW Severity: major Priority: P5 Component: Database AssignedTo: gmcharlt(a)gmail.com ReportedBy: mtj(a)kohaaloha.com QAContact: koha-bugs(a)lists.koha-community.org -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug.

1 52

[Bug 7857] New: database upgrade fails with plack
by bugzilla-daemon＠bugs.koha-community.org 22 Apr '13

22 Apr '13

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7857 Priority: P5 - low Change sponsored?: --- Bug ID: 7857 Assignee: gmcharlt(a)gmail.com Summary: database upgrade fails with plack QA Contact: koha.sekjal(a)gmail.com Severity: enhancement Classification: Unclassified OS: All Reporter: dpavlin(a)rot13.org Hardware: All Status: NEW Version: master Component: Architecture, internals, and plumbing Product: Koha -- You are receiving this mail because: You are watching all bug changes.

1 24

[Bug 8931] New: submit buttons have blue background
by bugzilla-daemon＠bugs.koha-community.org 22 Apr '13

22 Apr '13

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8931 Priority: P5 - low Change sponsored?: --- Bug ID: 8931 Assignee: oleonard(a)myacpl.org Summary: submit buttons have blue background Severity: normal Classification: Unclassified OS: All Reporter: nengard(a)gmail.com Hardware: All Status: NEW Version: rel_3_10 Component: Templates Product: Koha Created attachment 12862 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=12862&action=edit one example In my staff client on Mac/FF all submit buttons have a blue shaded background - I think it should be white or be included in the outline for the box. -- You are receiving this mail because: You are watching all bug changes.

1 22

[Bug 8972] New: Due Date set to 100 years ago.
by bugzilla-daemon＠bugs.koha-community.org 22 Apr '13

22 Apr '13

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8972 Priority: P5 - low Change sponsored?: --- Bug ID: 8972 CC: gmcharlt(a)gmail.com, kyle.m.hall(a)gmail.com Assignee: koha-bugs(a)lists.koha-community.org Summary: Due Date set to 100 years ago. Severity: enhancement Classification: Unclassified OS: All Reporter: jesse(a)bywatersolutions.com Hardware: All Status: NEW Version: rel_3_8 Component: Circulation Product: Koha Created attachment 13063 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=13063&action=edit 1912 due date When renewing an item for a patron. If you enter a two digit year (11/01/12) Koha defaults to 1912 and gives you an enormous fine. Koha performs correctly if you enter a four digit year (11/01/2012). -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 17

[Bug 8832] New: can't enter a tax rate on vendor or when ordering
by bugzilla-daemon＠bugs.koha-community.org 22 Apr '13

22 Apr '13

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8832 Priority: P5 - low Change sponsored?: --- Bug ID: 8832 Assignee: koha-bugs(a)lists.koha-community.org Summary: can't enter a tax rate on vendor or when ordering Severity: major Classification: Unclassified OS: All Reporter: nengard(a)gmail.com Hardware: All Status: NEW Version: master Component: Acquisitions Product: Koha Created attachment 12536 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=12536&action=edit placing an order I can no longer enter a tax rate when adding a new vendor, editing a vendor or placing an order. It's always a pull down with 0% in it. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 24

[Bug 8919] New: ExtendedPatronAttributes not populated when replicating data from LDAP
by bugzilla-daemon＠bugs.koha-community.org 22 Apr '13

22 Apr '13

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8919 Priority: P5 - low Change sponsored?: --- Bug ID: 8919 CC: dpavlin(a)rot13.org Assignee: gmcharlt(a)gmail.com Summary: ExtendedPatronAttributes not populated when replicating data from LDAP Severity: enhancement Classification: Unclassified OS: All Reporter: dpavlin(a)rot13.org Hardware: All Status: NEW Version: rel_3_8 Component: Authentication Product: Koha -- You are receiving this mail because: You are watching all bug changes.

1 14

[Bug 8784] New: Missing files in debian.packages list
by bugzilla-daemon＠bugs.koha-community.org 22 Apr '13

22 Apr '13

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8784 Priority: P5 - low Change sponsored?: --- Bug ID: 8784 Assignee: gmcharlt(a)gmail.com Summary: Missing files in debian.packages list Severity: minor Classification: Unclassified OS: All Reporter: mtompset(a)hotmail.com Hardware: All Status: NEW Version: unspecified Component: Installation and upgrade (command-line installer) Product: Koha Based on the output of koha_perl_deps.pl, several things need updating in install_misc/debian.packages for a simpler git installation. Testing would involve a fresh git install, and doing: sudo apt-get install dselect sudo dpkg --set-selections < install_misc/debian.packages sudo dselect I, C, R, and then Q. ./koha_perl_deps.pl -m -u Noticeable list apply patch sudo dpkg --set-selections < install_misc/debian.packages sudo dselect I, C, R, and then Q. ./koha_perl_deps.pl -m -u All the required items should be installed. DateTime::TimeZone may still be listed, but that's because of a min_ver problem, not a missing problem. This helps people first starting with a git set up to not have to figure out where to get missing required libraries. -- You are receiving this mail because: You are watching all bug changes.

1 10

[Bug 5490] New: Is smsoverdues.pl an orphan
by bugzilla-daemon＠bugs.koha-community.org 22 Apr '13

22 Apr '13

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5490 Summary: Is smsoverdues.pl an orphan Change sponsored?: --- Product: Koha Version: HEAD Platform: All OS/Version: All Status: NEW Severity: trivial Priority: P5 Component: Notices AssignedTo: henridamien(a)koha-fr.org ReportedBy: colin.campbell(a)ptfs-europe.com QAContact: koha-bugs(a)lists.koha-community.org Estimated Hours: 0.0 In the course of checking something else I noticed that misc/cronjobs/smsoverdues.pl does not even compile due to a use of a non-existant module. This suggests that noone is using this script. Either it should be removed or given some love and attention. -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA contact for the bug.

1 9

[Bug 8633] New: Translate script hardcoded to prog template
by bugzilla-daemon＠bugs.koha-community.org 22 Apr '13

22 Apr '13

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8633 Priority: P5 - low Change sponsored?: --- Bug ID: 8633 CC: frederic(a)tamil.fr Assignee: koha-bugs(a)lists.koha-community.org Summary: Translate script hardcoded to prog template Severity: normal Classification: Unclassified OS: All Reporter: jcamins(a)cpbibliography.com Hardware: All Status: NEW Version: master Component: I18N/L10N Product: Koha misc/translator/translate is hardcoded to translate only prog, when in fact it should be translating any themes included in Koha. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 13