[Bug 23960] New: Issue with MariaDB (rows column name in creator_template table)
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23960 Bug ID: 23960 Summary: Issue with MariaDB (rows column name in creator_template table) Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Label/patron card printing Assignee: cnighswonger@foundations.edu Reporter: amitddng135@gmail.com QA Contact: testopia@bugs.koha-community.org Using 'rows' as a column name in creator_templates table giving error while saving. (Issue with MariaDB version: 10.3.13). As in MariaDB 'rows' is a predefined column name. I think we can change the column name rows to rowls -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23960 Amit Gupta <amitddng135@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Assignee|cnighswonger@foundations.ed |amitddng135@gmail.com |u | Status|NEW |ASSIGNED -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23960 Amit Gupta <amitddng135@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |amit.gupta@informaticsgloba | |l.com, | |chris@bigballofwax.co.nz, | |katrin.fischer@bsz-bw.de -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23960 Amit Gupta <amitddng135@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Priority|P5 - low |P2 Severity|enhancement |major -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23960 Amit Gupta <amitddng135@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Summary|Issue with MariaDB (rows |Issue with MariaDB version |column name in |(rows column name in |creator_template table) |creator_template table) -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23960 Amit Gupta <amitddng135@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |chrish@catalyst.net.nz -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23960 Chris Cormack <chris@bigballofwax.co.nz> changed: What |Removed |Added ---------------------------------------------------------------------------- Component|Label/patron card printing |Database --- Comment #1 from Chris Cormack <chris@bigballofwax.co.nz> --- Switching to the DB component so we can try to gather all the DB changes together -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23960 Martin Renvoize <martin.renvoize@ptfs-europe.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |martin.renvoize@ptfs-europe | |.com --- Comment #2 from Martin Renvoize <martin.renvoize@ptfs-europe.com> --- Can you detail how to replicate this issue Amit.. having dug around the codebase it looks like 'rows' is always correctly quoted as an identifier to me, so I'm struggling to narrow down the problem. -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23960 --- Comment #3 from Amit Gupta <amitddng135@gmail.com> --- (In reply to Martin Renvoize from comment #2)
Can you detail how to replicate this issue Amit.. having dug around the codebase it looks like 'rows' is always correctly quoted as an identifier to me, so I'm struggling to narrow down the problem.
Hi Martin, I am using MariaDB version 10.3.13 (while saving the template I found the issue) and checked the log giving errors. Seems "rows" are the keyword in MariaDB 10.3.13. Can you install 10.3.13 and see the issue. -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23960 Jonathan Druart <jonathan.druart@bugs.koha-community.org> changed: What |Removed |Added ---------------------------------------------------------------------------- See Also| |https://bugs.koha-community | |.org/bugzilla3/show_bug.cgi | |?id=23289 CC| |jonathan.druart@bugs.koha-c | |ommunity.org --- Comment #4 from Jonathan Druart <jonathan.druart@bugs.koha-community.org> --- Amit, which version of Koha? Steps to recreate? See also bug 23289, which is supposed to have fixed that. -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23960 --- Comment #5 from Jonathan Druart <jonathan.druart@bugs.koha-community.org> --- (collision with Martin!) -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23960 --- Comment #6 from Amit Gupta <amitddng135@gmail.com> --- (In reply to Jonathan Druart from comment #4)
Amit, which version of Koha? Steps to recreate?
See also bug 23289, which is supposed to have fixed that.
Thanks, Jonathan I applied the patch and the issue is resolved. I am using 18.11 -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23960 Jonathan Druart <jonathan.druart@bugs.koha-community.org> changed: What |Removed |Added ---------------------------------------------------------------------------- Resolution|--- |DUPLICATE Status|ASSIGNED |RESOLVED --- Comment #7 from Jonathan Druart <jonathan.druart@bugs.koha-community.org> --- *** This bug has been marked as a duplicate of bug 23289 *** -- You are receiving this mail because: You are watching all bug changes.
participants (1)
-
bugzilla-daemon＠bugs.koha-community.org