[Koha] installing Koha 2.2.8 on Debian etch MySQL 5.0.32

[Rick Welykochy]

Jim L wrote:

> 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

The field named "return" is a reserved word in MySQL5.0.

You must use Koha/2.2.9 to fix this. (Or you can fix it
yourself if you know and understand MySQL quite well)

> DBD::mysql::db do failed: Table 'Koha.categoryitem' doesn't exist at
> scripts/updater/updatedatabase line 1612.
> DBD::mysql::db do failed: Table 'Koha.issuingrules' doesn't exist at
> scripts/updater/updatedatabase line 1613.

If you cannot access MySQL via the installer, try simple things
first. Can you access MySQL from the command line?


cheers
rickw


-- 
_________________________________
Rick Welykochy || Praxis Services

Say what you will about the miracle of unquestioning faith, I consider 
a capacity for it terrifying and absolutely vile.
     -- Howard W Campbell in Kurt Vonnegut Jr's "Mother Night"