[Koha-devel] Bibliothesaurus table

[Jerome Vizcaino]

Hello Paul

Nope we didn't upgrade an old Koha version. We installed Koha 1.9.2 on a 
clean Debian Woody install.
However we didn't install the sample information in the database. Maybe 
this is the problem.
By the way the installation of Koha was a real problem and we had to 
install all the required Perl modules by hand due to a problem with the 
CPAN module. Building a debian package for Koha would be a good idea. If 
anyone knows how to do this...

Jerome

paul POULAIN wrote:

> 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...
>