@@ -, +, @@ --- cataloguing/z3950_auth_search.pl | 2 +- installer/data/mysql/de-DE/optional/sample_z3950_servers.sql | 2 +- installer/data/mysql/en/optional/sample_z3950_servers.sql | 2 +- installer/data/mysql/es-ES/optional/sample_z3950_servers.sql | 2 +- installer/data/mysql/fr-CA/facultatif/sample_z3950_servers.sql | 2 +- installer/data/mysql/nb-NO/2-Valgfritt/z3950servers.sql | 2 +- installer/data/mysql/pl-PL/optional/sample_z3950_servers.sql | 2 +- 7 files changed, 7 insertions(+), 7 deletions(-) --- a/cataloguing/z3950_auth_search.pl +++ a/cataloguing/z3950_auth_search.pl @@ -68,7 +68,7 @@ $template->param( ); if ( $op ne "do_search" ) { - my $sth = $dbh->prepare("SELECT id,host,servername,checked FROM z3950servers WHERE recordtype = 'authority' ORDER BY rank, servername"); + my $sth = $dbh->prepare("SELECT id,host,servername,checked FROM z3950servers WHERE recordtype = 'authority' ORDER BY `rank`, servername"); $sth->execute(); my $serverloop = $sth->fetchall_arrayref( {} ); $template->param( --- a/installer/data/mysql/de-DE/optional/sample_z3950_servers.sql +++ a/installer/data/mysql/de-DE/optional/sample_z3950_servers.sql @@ -1,5 +1,5 @@ INSERT INTO z3950servers -(host, port, db, userid, password, servername, checked, rank, syntax, encoding,recordtype) VALUES +(host, port, db, userid, password, servername, checked, `rank`, syntax, encoding,recordtype) VALUES ('lx2.loc.gov',210,'LCDB','','','LIBRARY OF CONGRESS',1,1,'USMARC','utf8','biblio'), ('lx2.loc.gov',210,'NAF','','','LIBRARY OF CONGRESS NAMES',1,1,'USMARC','utf8','authority'), ('lx2.loc.gov',210,'SAF','','','LIBRARY OF CONGRESS SUBJECTS',1,2,'USMARC','utf8','authority'); --- a/installer/data/mysql/en/optional/sample_z3950_servers.sql +++ a/installer/data/mysql/en/optional/sample_z3950_servers.sql @@ -1,5 +1,5 @@ INSERT INTO z3950servers -(host, port, db, userid, password, servername, checked, rank, syntax, encoding,recordtype) VALUES +(host, port, db, userid, password, servername, checked, `rank`, syntax, encoding,recordtype) VALUES ('lx2.loc.gov',210,'LCDB','','','LIBRARY OF CONGRESS',1,1,'USMARC','utf8','biblio'), ('lx2.loc.gov',210,'NAF','','','LIBRARY OF CONGRESS NAMES',1,1,'USMARC','utf8','authority'), ('lx2.loc.gov',210,'SAF','','','LIBRARY OF CONGRESS SUBJECTS',1,2,'USMARC','utf8','authority'); --- a/installer/data/mysql/es-ES/optional/sample_z3950_servers.sql +++ a/installer/data/mysql/es-ES/optional/sample_z3950_servers.sql @@ -1,5 +1,5 @@ INSERT INTO z3950servers -(host, port, db, userid, password, servername, checked, rank, syntax, encoding,recordtype) VALUES +(host, port, db, userid, password, servername, checked, `rank`, syntax, encoding,recordtype) VALUES ('lx2.loc.gov',210,'LCDB','','','LIBRARY OF CONGRESS',1,1,'USMARC','utf8','biblio'), ('lx2.loc.gov',210,'NAF','','','LIBRARY OF CONGRESS NAMES',1,1,'USMARC','utf8','authority'), ('lx2.loc.gov',210,'SAF','','','LIBRARY OF CONGRESS SUBJECTS',1,2,'USMARC','utf8','authority'); --- a/installer/data/mysql/fr-CA/facultatif/sample_z3950_servers.sql +++ a/installer/data/mysql/fr-CA/facultatif/sample_z3950_servers.sql @@ -1,5 +1,5 @@ INSERT INTO z3950servers -(host, port, db, userid, password, servername, checked, rank, syntax, encoding,recordtype) VALUES +(host, port, db, userid, password, servername, checked, `rank`, syntax, encoding,recordtype) VALUES ('lx2.loc.gov',210,'LCDB','','','Bibliothèque du congrès',1,1,'USMARC','utf8','biblio'), ('lx2.loc.gov',210,'NAF','','','Bibliothèque du congrès NOMS',1,1,'USMARC','utf8','authority'), ('lx2.loc.gov',210,'SAF','','','Bibliothèque du congrès SUJETS',1,2,'USMARC','utf8','authority'), --- a/installer/data/mysql/nb-NO/2-Valgfritt/z3950servers.sql +++ a/installer/data/mysql/nb-NO/2-Valgfritt/z3950servers.sql @@ -1,4 +1,4 @@ -INSERT INTO z3950servers (host, port, db, userid, password, servername, id, checked, rank, syntax, timeout, servertype, encoding) VALUES +INSERT INTO z3950servers (host, port, db, userid, password, servername, id, checked, `rank`, syntax, timeout, servertype, encoding) VALUES ('lx2.loc.gov',210,'LCDB','','','LIBRARY OF CONGRESS',1,0,0,'USMARC',0,'zed','utf8'), ('z3950.bibsys.no',2100,'BIBSYS','','','BIBSYS',12,1,1,'NORMARC',0,'zed','ISO_8859-1'), ('z3950.nb.no',2100,'Norbok','','','NORBOK',13,0,0,'NORMARC',0,'zed','ISO_8859-1'), --- a/installer/data/mysql/pl-PL/optional/sample_z3950_servers.sql +++ a/installer/data/mysql/pl-PL/optional/sample_z3950_servers.sql @@ -1,5 +1,5 @@ INSERT INTO z3950servers -(host, port, db, userid, password, servername, checked, rank, syntax, encoding,recordtype) VALUES +(host, port, db, userid, password, servername, checked, `rank`, syntax, encoding,recordtype) VALUES ('alpha.bn.org.pl',210,'INNOPAC','','','BIBLIOTEKA NARODOWA',1,1,'MARC21','utf8', 'biblio'), ('lx2.loc.gov',210,'LCDB','','','LIBRARY OF CONGRESS',1,1,'USMARC','utf8','biblio'), ('lx2.loc.gov',210,'NAF','','','LIBRARY OF CONGRESS NAMES',1,1,'USMARC','utf8','authority'), --