I don't really know, but it looks like you need to delete the old database first and create it again. Don't do this if you have anything in your koha system already that you want to keep. Only do this to start with a fresh koha install. This will delete all current entries. To delete the old database, type: mysqladmin drop koha To create again, type: mysqladmin create koha Then continue with the instructions to set up the database. Alex jennyzhang wrote:

Hi Alex,

Thanks very much for your answers. I am happy to be in the koha family. You know, it is the first time for me to use opensource.

The only problem now is:

ERROR 1062 (23000) at line 1: Duplicate entry 'localhost-kohaadmin' for key 1 256

DBD::mysql::st execute failed: Invalid default value for 'aqbudgetid' at scripts /updater/updatedatabase line 1185. DBD::mysql::st execute failed: Invalid default value for 'id' at scripts/updater /updatedatabase line 1185. synch'ing borrowers creating column textmessaging creating column password creating column flags creating column userid creating column homezipcode creating column zipcode creating column sort1 creating column sort2 synch'ing items creating column itemcallnumber synch'ing biblio synch'ing biblioitems creating column place

From the list, I saw you have got the same problem and chris said it will fixed in the release of koha2.2.6. I wander if you have solve your problem now.

Thanks again for your help.

Jenny ----- Original Message ----- From: "Alex King" <alex@king.net.nz> To: "jennyzhang" <jennyzhang@nsia.ac.nz> Cc: <koha@lists.katipo.co.nz> Sent: Thursday, August 17, 2006 8:57 AM Subject: Re: [Koha] Koha installation