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
Switching to the DB component so we can try to gather all the DB changes together
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.
(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.
Amit, which version of Koha? Steps to recreate? See also bug 23289, which is supposed to have fixed that.
(collision with Martin!)
(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
*** This bug has been marked as a duplicate of bug 23289 ***