database error

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

database error

Danabalou Mohanassoundarame
Bonjour/hello

I am a newbie to koha

trying to install koha in my server linux mandrak
with
perl, v5.8.5 built for i386-linux-thread-multi
Apache2
Mysql-5.1.8
koha-2.2.5

the installer.pl  give the following errers

any idea!!!!!!!!

thanks in advance
mohan
----------------

DATABASE

Creating the MySQL database for Koha...
0ERROR 1062 (23000) at line 1: Duplicate entry '%-Koha-kohaadmin' for key 1

ERROR 1064 (42000) at line 772: You have an error in your SQL syntax;
check the manual that corresponds to your MySQL server version for the
right syntax to use near 'return char(4) default NULL,
 renewals tinyint(4) default NULL,
 timestamp tim' at line 9

DBD::mysql::db do failed: Table 'Koha.categoryitem' doesn't exist at
scripts/updater/updatedatabase line 1092.
DBD::mysql::db do failed: Table 'Koha.issuingrules' doesn't exist at
scripts/updater/updatedatabase line 1093.
DBD::mysql::db do failed: Table 'Koha.issuingrules' doesn't exist at
scripts/updater/updatedatabase line 1094.
DBD::mysql::db do failed: Table 'Koha.issuingrules' doesn't exist at
scripts/updater/updatedatabase line 1095.
DBD::mysql::st execute failed: Table 'Koha.statistics' doesn't exist at
scripts/updater/updatedatabase line 1106.
DBD::mysql::st fetchrow failed: no statement executing
DBD::mysql::st execute failed: Table 'Koha.statistics' doesn't exist at
scripts/updater/updatedatabase line 1122.
**Error : DBI::st=HASH(0x834ae28)->errstr
DBD::mysql::st execute failed: Table 'Koha.itemtypes' doesn't exist at
scripts/updater/updatedatabase line 1106.
DBD::mysql::st fetchrow failed: no statement executing
DBD::mysql::st execute failed: Table 'Koha.itemtypes' doesn't exist at
scripts/updater/updatedatabase line 1122.
**Error : DBI::st=HASH(0x8351810)->errstr
DBD::mysql::st execute failed: Table 'Koha.systempreferences' doesn't
exist at scripts/updater/updatedatabase line 1106.
DBD::mysql::st fetchrow failed: no statement executing
DBD::mysql::st execute failed: Table 'Koha.systempreferences' doesn't
exist at scripts/updater/updatedatabase line 1122.
**Error : DBI::st=HASH(0x83531b4)->errstr
DBD::mysql::st execute failed: Table 'Koha.systempreferences' doesn't
exist at scripts/updater/updatedatabase line 1122.
**Error : DBI::st=HASH(0x8351798)->errstr
DBD::mysql::st execute failed: Table 'Koha.systempreferences' doesn't
exist at scripts/updater/updatedatabase line 1122.
**Error : DBI::st=HASH(0x8348410)->errstr
DBD::mysql::st execute failed: Table 'Koha.items' doesn't exist at
scripts/updater/updatedatabase line 1106.
DBD::mysql::st fetchrow failed: no statement executing
DBD::mysql::st execute failed: Table 'Koha.items' doesn't exist at
scripts/updater/updatedatabase line 1122.
**Error : DBI::st=HASH(0x83517e0)->errstr
DBD::mysql::st execute failed: Table 'Koha.items' doesn't exist at
scripts/updater/updatedatabase line 1122.
**Error : DBI::st=HASH(0x8352f2c)->errstr
DBD::mysql::st execute failed: Table 'Koha.printers' doesn't exist at
scripts/updater/updatedatabase line 1134.
DBD::mysql::st fetchrow failed: no statement executing
DBD::mysql::st execute failed: Table 'Koha.printers' doesn't exist at
scripts/updater/updatedatabase line 1185.
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.
DBD::mysql::st execute failed: Table 'Koha.items' doesn't exist at
scripts/updater/updatedatabase line 1227.
DBD::mysql::st fetchrow failed: no statement executing
DBD::mysql::st execute failed: Table 'Koha.items' doesn't exist at
scripts/updater/updatedatabase line 1242.
DBD::mysql::st execute failed: Table 'Koha.items' doesn't exist at
scripts/updater/updatedatabase line 1249.
DBD::mysql::st fetchrow failed: no statement executing
DBD::mysql::db do failed: Table 'Koha.items' doesn't exist at
scripts/updater/updatedatabase line 1257.
DBD::mysql::st execute failed: Table 'Koha.items' doesn't exist at
scripts/updater/updatedatabase line 1374.
DBD::mysql::st fetchrow failed: no statement executing
DBD::mysql::st execute failed: Table 'Koha.issuingrules' doesn't exist
at scripts/updater/updatedatabase line 1410.
DBD::mysql::st fetchrow failed: no statement executing
DBD::mysql::db do failed: Table 'Koha.issuingrules' doesn't exist at
scripts/updater/updatedatabase line 1419.
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
DBD::mysql::st execute failed: Table 'Koha.items' doesn't exist at
scripts/updater/updatedatabase line 1460.
DBD::mysql::st fetchrow failed: no statement executing
synch'ing biblio
synch'ing biblioitems
creating column place
Can't call method "execute" on an undefined value at
scripts/updater/updatedatabase line 1510.
Problem updating database...


_______________________________________________
Koha mailing list
[hidden email]
http://lists.katipo.co.nz/mailman/listinfo/koha

mohanassoundarame.danabalou.vcf (443 bytes) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Re: database error

Stephen Hedges
mohan -

I looks like you already have set up your Koha admin user in MySQL, so it
complains when you try to set it up again.  Did you start the install once
before?  See if you can remove kohaadmin completely from the MySQL
database and then try the Koha install again.

Good luck with MySQL 5 -- last I knew there here still some problems with
reserved words.  Anyone know if that's been corrected?

Stephen

Danabalou Mohanassoundarame wrote:

> Bonjour/hello
>
> I am a newbie to koha
>
> trying to install koha in my server linux mandrak
> with
> perl, v5.8.5 built for i386-linux-thread-multi
> Apache2
> Mysql-5.1.8
> koha-2.2.5
>
> the installer.pl  give the following errers
>
> any idea!!!!!!!!
>
> thanks in advance
> mohan
> ----------------
>
> DATABASE
>
> Creating the MySQL database for Koha...
> 0ERROR 1062 (23000) at line 1: Duplicate entry '%-Koha-kohaadmin' for key
> 1
>


--
Stephen Hedges
Skemotah Solutions, USA
www.skemotah.com  --  [hidden email]

_______________________________________________
Koha mailing list
[hidden email]
http://lists.katipo.co.nz/mailman/listinfo/koha