[Koha-devel] 2.2.7-installer problems

[Dorian Meid]

I just downloaded 2.2.7 from the website and tried to install on OSX.

First the INSTALL-File is outdated, it requires the wrong modules.

Then after having finished the installation of all the modules I ran  
the installer and came across this errors:

In the routine for missing Perl-modules the warnings are correct up  
to the PDF-stuff, but then I get warnings, which I can understand,  
but the suggestions are wrong.


Creating the MySQL database for Koha...

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 1600.
DBD::mysql::db do failed: Table 'koha.issuingrules' doesn't exist at  
scripts/updater/updatedatabase line 1601.
DBD::mysql::db do failed: Table 'koha.issuingrules' doesn't exist at  
scripts/updater/updatedatabase line 1602.
DBD::mysql::db do failed: Table 'koha.issuingrules' doesn't exist at  
scripts/updater/updatedatabase line 1603.
DBD::mysql::st execute failed: Table 'koha.statistics' doesn't exist  
at scripts/updater/updatedatabase line 1615.
DBD::mysql::st fetchrow failed: fetch() without execute() at scripts/ 
updater/updatedatabase line 1617.
DBD::mysql::st execute failed: Table 'koha.statistics' doesn't exist  
at scripts/updater/updatedatabase line 1632.
**Error : DBI::st=HASH(0x18de730)->errstr
DBD::mysql::st execute failed: Table 'koha.itemtypes' doesn't exist  
at scripts/updater/updatedatabase line 1615.
DBD::mysql::st fetchrow failed: fetch() without execute() at scripts/ 
updater/updatedatabase line 1617.
DBD::mysql::st execute failed: Table 'koha.itemtypes' doesn't exist  
at scripts/updater/updatedatabase line 1632.
**Error : DBI::st=HASH(0x17408)->errstr
DBD::mysql::st execute failed: Table 'koha.systempreferences' doesn't  
exist at scripts/updater/updatedatabase line 1615.
DBD::mysql::st fetchrow failed: fetch() without execute() at scripts/ 
updater/updatedatabase line 1617.
DBD::mysql::st execute failed: Table 'koha.systempreferences' doesn't  
exist at scripts/updater/updatedatabase line 1632.
**Error : DBI::st=HASH(0x172b8)->errstr
DBD::mysql::st execute failed: Table 'koha.systempreferences' doesn't  
exist at scripts/updater/updatedatabase line 1632.
**Error : DBI::st=HASH(0x173a8)->errstr
DBD::mysql::st execute failed: Table 'koha.systempreferences' doesn't  
exist at scripts/updater/updatedatabase line 1632.
**Error : DBI::st=HASH(0x1724c)->errstr
DBD::mysql::st execute failed: Table 'koha.items' doesn't exist at  
scripts/updater/updatedatabase line 1615.
DBD::mysql::st fetchrow failed: fetch() without execute() at scripts/ 
updater/updatedatabase line 1617.
DBD::mysql::st execute failed: Table 'koha.items' doesn't exist at  
scripts/updater/updatedatabase line 1632.
**Error : DBI::st=HASH(0x18dc048)->errstr
DBD::mysql::st execute failed: Table 'koha.items' doesn't exist at  
scripts/updater/updatedatabase line 1632.
**Error : DBI::st=HASH(0x16e20)->errstr
DBD::mysql::st execute failed: Table 'koha.printers' doesn't exist at  
scripts/updater/updatedatabase line 1644.
DBD::mysql::st fetchrow failed: fetch() without execute() at scripts/ 
updater/updatedatabase line 1646.
DBD::mysql::st execute failed: Table 'koha.printers' doesn't exist at  
scripts/updater/updatedatabase line 1705.
DBD::mysql::st execute failed: Invalid default value for 'aqbudgetid'  
at scripts/updater/updatedatabase line 1705.
DBD::mysql::st execute failed: Invalid default value for 'id' at  
scripts/updater/updatedatabase line 1705.
DBD::mysql::st execute failed: Table 'koha.items' doesn't exist at  
scripts/updater/updatedatabase line 1746.
DBD::mysql::st fetchrow failed: fetch() without execute() at scripts/ 
updater/updatedatabase line 1747.
DBD::mysql::st execute failed: Table 'koha.items' doesn't exist at  
scripts/updater/updatedatabase line 1761.
DBD::mysql::st execute failed: Table 'koha.items' doesn't exist at  
scripts/updater/updatedatabase line 1769.
DBD::mysql::st fetchrow failed: fetch() without execute() at scripts/ 
updater/updatedatabase line 1770.
DBD::mysql::db do failed: Table 'koha.items' doesn't exist at scripts/ 
updater/updatedatabase line 1785.
DBD::mysql::st execute failed: Table 'koha.items' doesn't exist at  
scripts/updater/updatedatabase line 1930.
DBD::mysql::st fetchrow failed: fetch() without execute() at scripts/ 
updater/updatedatabase line 1931.
DBD::mysql::st execute failed: Table 'koha.issuingrules' doesn't  
exist at scripts/updater/updatedatabase line 1974.
DBD::mysql::st fetchrow failed: fetch() without execute() at scripts/ 
updater/updatedatabase line 1976.
DBD::mysql::db do failed: Table 'koha.issuingrules' doesn't exist at  
scripts/updater/updatedatabase line 1990.
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 2047.
DBD::mysql::st fetchrow failed: fetch() without execute() at scripts/ 
updater/updatedatabase line 2049.
synch'ing biblio
synch'ing biblioitems
creating column place
DBD::mysql::st execute failed: Table 'koha.systempreferences' doesn't  
exist at scripts/updater/updatedatabase line 2130.
DBD::mysql::st execute failed: Table 'koha.systempreferences' doesn't  
exist at scripts/updater/updatedatabase line 2138.
DBD::mysql::st execute failed: Table 'koha.systempreferences' doesn't  
exist at scripts/updater/updatedatabase line 2138.
(Last three lines repeating a few dozen times)



Later:

Choose MARC definition [1]: 3

ERROR 1048 (23000) at line 165: Column 'frameworkcode' cannot be null

Later:

Which language do you choose? en

ERROR 1146 (42S02) at line 1: Table 'koha.systempreferences' doesn't  
exist


BTW: I'm using MySQL 5.0.27

Dorian Meid