[Koha-devel] Dewey bug (119)

Paul POULAIN paul.poulain at free.fr
Mon Jul 18 08:13:22 CEST 2005


Chris Cormack a écrit :
> Stephen Hedges wrote:
> 
>>Can anyone think of any reason to keep the biblioitems.dewey column as a
>>DOUBLE(8,6) type?  After installing 2.2.3, I still had problems with this
>>bug, so I did:
>>ALTER TABLE biblioitems MODIFY dewey VARCHAR(10)
>>Everything seems to be working fine -- at least I have yet to find any
>>problems created by this change.  Is the dewey column ever part of any
>>numeric functions?  If we make this change to the biblioitems table, can
>>we close this bug?
>>
> 
> Yep, lets do that.
> 
> Ive made this change to the recent 2.2.x installs ive done, with no ill
> effects thus far. All I suggest is we make it a varchar(50) or something
> a bit larger than 10. But making it a varchar of some point is a lot
> better than have it a double.
> 
> Chris
> 
I thought I changed koha.mysql to have dewey being varchar. Seems I was 
wrong.

I changed it in cvs rel_2_2, for 2.2.4.

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




More information about the Koha-devel mailing list