2.2.7-installer problems
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
Am 03.03.2007 um 01:06 schrieb Dorian Meid:
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
Found the bug: It's in the koha.mysql, line 780 it is: return char(4) default NULL, and should be: `return` char(4) default NULL, since "return" is a key-word in mysql. Who will fix it in cvs? Dorian Meid
On Sat, Mar 03, 2007 at 02:03:05AM +0100, Dorian Meid said:
Am 03.03.2007 um 01:06 schrieb Dorian Meid:
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
Found the bug: It's in the koha.mysql, line 780
it is: return char(4) default NULL,
and should be: `return` char(4) default NULL,
Dorian, This is just one of the problems with 2.2.7 and mysql 5. There have been quite a few mails on the list about them. Heres a little write up http://blog.katipo.co.nz/?p=18 As far as I know they have all been fixed in cvs now. Chris -- Chris Cormack Programmer 027 4500 789 Katipo Communications Ltd chris@katipo.co.nz www.katipo.co.nz
participants (2)
-
Chris Cormack -
Dorian Meid