Help - OpenBiblio Installation fails

Help
2011-01-18
2013-05-30
  • Hi
    I am trying to install OpenBiblio on another computer running XP Pro and using IIS as my webserver.

    I am using MySql 5.5.8 and PHP 5.3.4

    I created the database OpenBiblio using phpMyAdmin

    Both PHP and MySql seem to be running OK

    When I try to install OpenBiblio I get the first screen regarding language and test data. Then, having pressed OK, nothing is created in the OpenBiblio database and I get the following message. Can anyone help solve what I am doing wrong?:

    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:\Inetpub\wwwroot\openbiblio\classes\Error.php:137 FatalHandler->printBackTrace()
    C:\Inetpub\wwwroot\openbiblio\classes\Error.php:105 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:\Inetpub\wwwroot\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:\Inetpub\wwwroot\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:\Inetpub\wwwroot\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:\Inetpub\wwwroot\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:\Inetpub\wwwroot\openbiblio\classes\InstallQuery.php:96 InstallQuery->executeSqlFile('../install/0.7.0/sql/biblio.sql', '')
    C:\Inetpub\wwwroot\openbiblio\classes\InstallQuery.php:84 InstallQuery->executeSqlFilesInDir('../install/0.7.0/sql', '')
    C:\Inetpub\wwwroot\openbiblio\install\install.php:69 InstallQuery->freshInstall('en', true)

     
  • I have solved the problem !!
    I went through every sql file in the install directory and changed TYPE to ENGINE and it worked. The reason as follows:

    The ENGINE and TYPE options specify the storage engine for the table. ENGINE was added
    in MySQL 4.0.18 (for 4.0) and 4.1.2 (for 4.1). It is the preferred option name as of
    those versions, and TYPE has become deprecated. TYPE is supported throughout the 4.x
    series but it was removed in MySQL 5.5. When upgrading to MySQL 5.5 or later, you MUST convert existing
    applications that rely on TYPE to use ENGINE instead.
    So, for all MySQL versions since 4.0.18 and 4.1.2 you can use ENGINE.

    Perhaps any new versions of OpenBiblio will have that change incorporated with cautions for users of older versions of MySQL.