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

4 Jan 2007

      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@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@lists.katipo.co.nz
     > http://lists.katipo.co.nz/mailman/listinfo/koha
     >
     >
_______________________________________________
    Koha mailing list
    Koha@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