The database update script failed for me. The itemnumber field was already in the 1.06 table, so the itemtype field never got added. Also, I noticed that the new 1.07 koha.mysql data had a key on the datetime field. I had to modify the statistics datetime field so that it was NOT NULL and then add the key. Steve.
* Tonnesen Steve <tonnesen@cmsd.bc.ca> [001221 07:45]:
The database update script failed for me.
The itemnumber field was already in the 1.06 table, so the itemtype field never got added. Also, I noticed that the new 1.07 koha.mysql data had a key on the datetime field. I had to modify the statistics datetime field so that it was NOT NULL and then add the key.
Ahhh whoops I'll fix that now. A new version of the database update script is at www.koha.org/download/ Ill replace the one in the tarballs as well now also. Chris -- Chris Cormack Programmer 025 500 789 Katipo Communications Ltd chris@katipo.co.nz www.katipo.co.nz
On Thu, 21 Dec 2000, Chris Cormack wrote:
Ahhh whoops I'll fix that now. A new version of the database update script is at www.koha.org/download/ Ill replace the one in the tarballs as well now also.
Chris: Typo alert on statistics. Can't say I blame you on that one. What an awful word to type. :) create index timeidx on statisctics (datetime); Steve.
* Tonnesen Steve <tonnesen@cmsd.bc.ca> [001221 08:59]:
On Thu, 21 Dec 2000, Chris Cormack wrote:
Ahhh whoops I'll fix that now. A new version of the database update script is at www.koha.org/download/ Ill replace the one in the tarballs as well now also.
Chris:
Typo alert on statistics. Can't say I blame you on that one. What an awful word to type. :)
create index timeidx on statisctics (datetime);
Ack its not my day :-) Ill try again :-) Ok this time, typo free database update script at http://www.koha.org/download/databasepatch1.06-1.07 (I hope) Chris -- Chris Cormack Programmer 025 500 789 Katipo Communications Ltd chris@katipo.co.nz www.katipo.co.nz
participants (2)
-
Chris Cormack -
Tonnesen Steve