Opnebiblio installatin under win7?

Help
2011-10-02
2013-05-30
  • Rainer Jaag
    Rainer Jaag
    2011-10-02

    Hi,

    I'm trying to install openbiblio 0.6.1 under win7.

    I am using MySql 5.5.8 and PHP 5.3.4

    When I try to install OpenBiblio I get the installation screen, where I can chose the language. After pressing OK, the installation aborts with the following information:

    OpenBiblio Installation:
    Database connection is good.
    Building OpenBiblio tables, please wait…
    Database Query Error - You've Probably Found a Bug
    Database query failed

    Please give all the information on this page to your support personnel.

    Query create table biblio ( bibid integer auto_increment primary key ,create_dt datetime not null ,last_change_dt datetime not null ,last_change_userid integer not null ,material_cd smallint not null ,collection_cd smallint not null ,call_nmbr1 varchar(20) null ,call_nmbr2 varchar(20) null ,call_nmbr3 varchar(20) null ,title text null ,title_remainder text null ,responsibility_stmt text null ,author text null ,topic1 text null ,topic2 text null ,topic3 text null ,topic4 text null ,topic5 text null ,opac_flg char(1) not null ) TYPE=MyISAM failed. The DBMS said this:

    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 'TYPE=MyISAM' at line 22

    Debug Backtrace (most recent call first):

    C:\mowes_portable\www\openbiblio\classes\Error.php:100 FatalHandler->printBackTrace()
    C:\mowes_portable\www\openbiblio\classes\Error.php:68 FatalHandler->dbError('
    create table biblio (
      bibid integer auto_increment primary key
      ,create_dt datetime not null
      ,last_change_dt datetime not null
      ,last_change_userid integer not null
      ,material_cd smallint not null
      ,collection_cd smallint not null
      ,call_nmbr1 varchar(20) null
      ,call_nmbr2 varchar(20) null
      ,call_nmbr3 varchar(20) null
      ,title text null
      ,title_remainder text null
      ,responsibility_stmt text null
      ,author text null
      ,topic1 text null
      ,topic2 text null
      ,topic3 text null
      ,topic4 text null
      ,topic5 text null
      ,opac_flg char(1) not null
      )
      TYPE=MyISAM
    ', 'Database query failed', '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 \'TYPE=MyISAM\' at line 22')
    C:\mowes_portable\www\openbiblio\classes\Query.php:91 Fatal->dbError('
    create table biblio (
      bibid integer auto_increment primary key
      ,create_dt datetime not null
      ,last_change_dt datetime not null
      ,last_change_userid integer not null
      ,material_cd smallint not null
      ,collection_cd smallint not null
      ,call_nmbr1 varchar(20) null
      ,call_nmbr2 varchar(20) null
      ,call_nmbr3 varchar(20) null
      ,title text null
      ,title_remainder text null
      ,responsibility_stmt text null
      ,author text null
      ,topic1 text null
      ,topic2 text null
      ,topic3 text null
      ,topic4 text null
      ,topic5 text null
      ,opac_flg char(1) not null
      )
      TYPE=MyISAM
    ', 'Database query failed', '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 \'TYPE=MyISAM\' at line 22')
    C:\mowes_portable\www\openbiblio\classes\Query.php:266 Query->_act('
    create table biblio (
      bibid integer auto_increment primary key
      ,create_dt datetime not null
      ,last_change_dt datetime not null
      ,last_change_userid integer not null
      ,material_cd smallint not null
      ,collection_cd smallint not null
      ,call_nmbr1 varchar(20) null
      ,call_nmbr2 varchar(20) null
      ,call_nmbr3 varchar(20) null
      ,title text null
      ,title_remainder text null
      ,responsibility_stmt text null
      ,author text null
      ,topic1 text null
      ,topic2 text null
      ,topic3 text null
      ,topic4 text null
      ,topic5 text null
      ,opac_flg char(1) not null
      )
      TYPE=MyISAM
    ')
    C:\mowes_portable\www\openbiblio\classes\Query.php:271 Query->_exec('
    create table biblio (
      bibid integer auto_increment primary key
      ,create_dt datetime not null
      ,last_change_dt datetime not null
      ,last_change_userid integer not null
      ,material_cd smallint not null
      ,collection_cd smallint not null
      ,call_nmbr1 varchar(20) null
      ,call_nmbr2 varchar(20) null
      ,call_nmbr3 varchar(20) null
      ,title text null
      ,title_remainder text null
      ,responsibility_stmt text null
      ,author text null
      ,topic1 text null
      ,topic2 text null
      ,topic3 text null
      ,topic4 text null
      ,topic5 text null
      ,opac_flg char(1) not null
      )
      TYPE=MyISAM
    ')
    C:\mowes_portable\www\openbiblio\classes\InstallQuery.php:121 Query->exec('
    create table biblio (
      bibid integer auto_increment primary key
      ,create_dt datetime not null
      ,last_change_dt datetime not null
      ,last_change_userid integer not null
      ,material_cd smallint not null
      ,collection_cd smallint not null
      ,call_nmbr1 varchar(20) null
      ,call_nmbr2 varchar(20) null
      ,call_nmbr3 varchar(20) null
      ,title text null
      ,title_remainder text null
      ,responsibility_stmt text null
      ,author text null
      ,topic1 text null
      ,topic2 text null
      ,topic3 text null
      ,topic4 text null
      ,topic5 text null
      ,opac_flg char(1) not null
      )
      TYPE=MyISAM
    ')
    C:\mowes_portable\www\openbiblio\classes\InstallQuery.php:96 InstallQuery->executeSqlFile('../install/0.6.0/sql/biblio.sql', '')
    C:\mowes_portable\www\openbiblio\classes\InstallQuery.php:84 InstallQuery->executeSqlFilesInDir('../install/0.6.0/sql', '')
    C:\mowes_portable\www\openbiblio\install\install.php:69 InstallQuery->freshInstall('en', false)

    Can somebody tell me what went wrong? Is it about win7?

    thanks

    biberbuder

     
  • Fred LaPlante
    Fred LaPlante
    2011-10-02

    Locate the my.ini file and verify that the 'MyIsam' engine is enabled.

    Fred LaPlante

     
  • MySQL version 5.5 and higher do not support TYPE=

    For OpenBiblio 0.6.1, simply use MySQL versions below 5.5.
    With PHP 5.3 you'll probably see "Deprecated …" messages when running OpenBiblio. These should go away when error_reporting in PHP.INI is changed to production values.

    Or stay with recent PHP and MySQL versions and try https://bitbucket.org/jgvdweij/obiblio/get/tip.zip This 'fork' says it's OpenBiblio 0.7.1, but it's not an official release. It aims to be an official release: installs on MySQL 5.5, will even run on EasyPHP 5.4 alpha3 and it's compatible with OpenBiblio 0.7.0, the double o seven version that unfortunately never was released.

    MySQL TYPE deprecation is a known issue for OpenBiblio
    https://bitbucket.org/mstetson/obiblio/issue/36/mysql-558-type-deprecation

     
  • Herman Boswijk
    Herman Boswijk
    2011-10-03

    How do I verify that the MyISAM engine is enabled?

    I am trying to install the 0.7 'tip'-version I found on https://bitbucket.org/mstetson/obiblio/downloads (XP, xampp 1.7.4) and get the same error.

    By the way: I kept getting the message 'the mysql server is not running or is blocked by a firewall' after installing xampp and finally found out I had to disable ipv6 to find the mysql-server. With ipv6 enabled, the local address of the server was set to "::", which seemed to cause the problem. Now with ipv4 it's set to "0.0.0.0".

     
  • Herman Boswijk
    Herman Boswijk
    2011-10-03

    Sorry.  As infinite-mnkz wrote, MySQL version should be lower than 5.5. Using xampp 1.7.3 (with MySQL 5.1) fixed the problem :-)

     


Anonymous


Cancel   Add attachments