[Koha] [first installation]Problem updating database..

[Thibaud Hulin]

Hello and happy new year !

The help of Jogiraju has partially solve my problem with php5, but I 
can't always install koha.
Now, I have his error after enter the root password :

Creating the MySQL database for Koha...
0

Start tag expected, '<' not found
  at /usr/lib/perl5/XML/LibXML/SAX.pm line 64
  at /usr/share/perl5/XML/Simple.pm line 287
BEGIN failed--compilation aborted at scripts/updater/updatedatabase line 21.
Problem updating database..

Thanks for help,
Thibaud.

Jogiraju TALLAPRAG a écrit :
 > hi,
 >
 > 'return' is a reserved word in mysql5 which is not so for mysql5. You
 > have to edit the file koha.mysql file found in the koha installation
 > directory ( same directory where installer.pl file is found) and put
 > keyword return in backticks like this `return` and proceed with the
 > installation:
 > perl inataller.pl
 > It is always good to put all the fieldnames of the table definitions in
 > back ticks.
 >
 > Regards,
 >
 >
 > T. Jogi Raju
 > Librarian, Malla Reddy Engieering College, Hyderabad, India
 >
 > */Thibaud Hulin <hulin.thibaud at wanadoo.fr>/* wrote:
 >
 >     Yes, I'm using mysql Ver 14.12 Distrib 5.0.30, for pc-linux-gnu 
(i486)
 >     using readline 5.2
 >     Can I use mysql 4 and 5 ? Or must I uninstall mysql5 and install
 >     mysql 4 ?
 >
 >     Kochin Chang a écrit :
 >      > Are you using MySQL 5.x? The current version of Koha is not
 >     compatible
 >      > with MySQL 5.x.
 >      >
 >      > Kochin
 >      >
 >      > Thibaud Hulin wrote:
 >      >> Hi !
 >      >> I'm trying Koha on a Debian sarge testing, but I have an 
error after
 >      >> launching install.pl and enter my sql password. This is the error
 >      >> message :
 >      >> CREATING DATABASE
 >      >>
 >      >> Creating the MySQL database for Koha...
 >      >> 0
 >      >> 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
 >      >>
 >      >> Start tag expected, '<' not found
 >      >> at /usr/lib/perl5/XML/LibXML/SAX.pm line 64
 >      >> at /usr/share/perl5/XML/Simple.pm line 287
 >      >> BEGIN failed--compilation a
 >      >>
 >      >> I'm a beginner with sql.
 >      >>
 >      >> Thanks for help,
 >      >> Thibaud.
 >      >
 >      > _______________________________________________
 >      > Koha mailing list
 >      > Koha at lists.katipo.co.nz
 >      > http://lists.katipo.co.nz/mailman/listinfo/koha
 >      >
 >      >
 >
 >     _______________________________________________
 >     Koha mailing list
 >     Koha at lists.katipo.co.nz
 >     http://lists.katipo.co.nz/mailman/listinfo/koha
 >
 >
 > __________________________________________________
 > Do You Yahoo!?
 > Tired of spam? Yahoo! Mail has the best spam protection around
 > http://mail.yahoo.com
 >