Summary: | fr-FR/1-Obligatoire/authorised_values.sql is invalid | ||
---|---|---|---|
Product: | Koha | Reporter: | Jonathan Druart <jonathan.druart> |
Component: | Architecture, internals, and plumbing | Assignee: | Jonathan Druart <jonathan.druart> |
Status: | CLOSED FIXED | QA Contact: | Testopia <testopia> |
Severity: | normal | ||
Priority: | P5 - low | CC: | andrewfh, caroline.cyr-la-rose, fridolin.somers, kyle |
Version: | unspecified | Keywords: | rel_20_11_candidate |
Hardware: | All | ||
OS: | All | ||
Change sponsored?: | --- | Patch complexity: | --- |
Documentation contact: | Documentation submission: | ||
Text to go in the release notes: | Version(s) released in: |
21.05.00,20.11.01
|
|
Bug Depends on: | 25534 | ||
Bug Blocks: | 17809 | ||
Attachments: |
Bug 27331: (bug 27331 follow-up) Fix syntax error in authorised_values.sql for fr-FR
Bug 27331: (bug 27331 follow-up) Fix syntax error in authorised_values.sql for fr-FR |
Description
Jonathan Druart
2021-01-04 13:43:44 UTC
Created attachment 114789 [details] [review] Bug 27331: (bug 27331 follow-up) Fix syntax error in authorised_values.sql for fr-FR ERROR 1064 (42000) at line 724: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '+ +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('HOLD' at line 1 File appears to still be invalid do to unrelated issues: ERROR 1062 (23000) at line 121: Duplicate entry 'COUNTRY-ER' for key 'av_uniq' INSERT INTO `authorised_values` ( `category`, `authorised_value`, `lib`) VALUES ( 'COUNTRY', 'ER', 'Érythrée'); INSERT INTO `authorised_values` ( `category`, `authorised_value`, `lib`) VALUES ( 'COUNTRY', 'ER', 'Allemagne'); (In reply to Kyle M Hall from comment #2) > File appears to still be invalid do to unrelated issues: > ERROR 1062 (23000) at line 121: Duplicate entry 'COUNTRY-ER' for key > 'av_uniq' > > INSERT INTO `authorised_values` ( `category`, `authorised_value`, `lib`) > VALUES ( 'COUNTRY', 'ER', 'Érythrée'); > INSERT INTO `authorised_values` ( `category`, `authorised_value`, `lib`) > VALUES ( 'COUNTRY', 'ER', 'Allemagne'); Yes, it's related to bug 17809 that I am about to push :) But then it's not blocker I guess. Created attachment 114791 [details] [review] Bug 27331: (bug 27331 follow-up) Fix syntax error in authorised_values.sql for fr-FR ERROR 1064 (42000) at line 724: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '+ +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('HOLD' at line 1 Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com> Pushed to master for 21.05, thanks to everybody involved! Pushed to 20.11.x for 20.11.01 Missing dependencies, not backported to 20.05 |