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)