[Koha] table systempreferences is not updated

[Paul POULAIN]

Eric G. Salayon a écrit :

>hi,
>
>  here i am again, seeking for your help. im adding a system parameter in
>KOHA (V2.O), but after saving the record it doesn't appear (the record
>i've added)eventhough it confirmed it adds a new record. What i did was to
>browse the log file (koha-error_log), and found out that field
>'explanation' was causing the error.  i opened the table
>systempreferences and saw that there are only 2 fields: variable and value
>only. but when i checked the file systempreferences.pl, it was select few
>more fields like 'explanation', 'type', and 'option'. What are the data
>types of these fields? another is that the
>systempreferences.pl only displayed 3 fields to update namely variable,
>value and explanation, can i have your updated systempreferences.pl
>file... TIA!
>  
>
CREATE TABLE systempreferences (
  variable varchar(50) NOT NULL default '',
  value varchar(200) default NULL,
  explanation varchar(80) default NULL,
  options text,
  type varchar(20) default NULL,
  PRIMARY KEY  (variable)
) TYPE=MyISAM;

-- 
Paul POULAIN
Consultant indépendant en logiciels libres
responsable francophone de koha (SIGB libre http://www.koha-fr.org)