Jerome Vizcaino wrote:
Hello
Inspecting the acquisition process we found that the editors popup
didn't worked.
The problem comes from the unimarc_210c.pl and thesaurus_popup.pl.
The SQL instructions
are looking for a 'father' field in the bibliothesaurus table.
Unfortunately, this field doesn't exist.
Can someone tell me what was this field used for and what is its new
name ? (the hierarchy field maybe ?)
The bibliothesaurus table should be :
CREATE TABLE bibliothesaurus (
id bigint(20) NOT NULL auto_increment,
freelib char(80) NOT NULL default '',
stdlib char(80) NOT NULL default '',
category char(10) NOT NULL default '',
father char(80) default NULL,
level tinyint(4) NOT NULL default '1',
hierarchy char(80) NOT NULL default '',
PRIMARY KEY (id),
KEY freelib (freelib),
KEY hierarchy (hierarchy),
KEY father (father),
KEY stdlib (stdlib),
KEY category (category),
FULLTEXT KEY category_2 (category,freelib)
) TYPE=MyISAM;
Why is the father row missing in your install is a good question ? Did
you upgrade from a 1.9.1 DB (we spoke of such an upgrade with Serge
IIRC)?
In updater/updatedatabase, line 109, the father table is here.
So...