error on installation

Help
eloelo22
2012-01-19
2013-05-30
  • eloelo22
    eloelo22
    2012-01-19

    penBiblio Installation:
    Database connection is good.
    Building OpenBiblio tables, please wait…

    Deprecated: Function ereg() is deprecated in D:\xampp\htdocs\openbiblio\classes\InstallQuery.php on line 95

    Deprecated: Function ereg() is deprecated in D:\xampp\htdocs\openbiblio\classes\InstallQuery.php on line 95

    Deprecated: Function ereg() is deprecated in D:\xampp\htdocs\openbiblio\classes\InstallQuery.php on line 95
    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):

    D:\xampp\htdocs\openbiblio\classes\Error.php:100 FatalHandler->printBackTrace()
    D:\xampp\htdocs\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')
    D:\xampp\htdocs\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')
    D:\xampp\htdocs\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
    ')
    D:\xampp\htdocs\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
    ')
    D:\xampp\htdocs\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
    ')
    D:\xampp\htdocs\openbiblio\classes\InstallQuery.php:96 InstallQuery->executeSqlFile('../install/0.6.0/sql/biblio.sql', '')
    D:\xampp\htdocs\openbiblio\classes\InstallQuery.php:84 InstallQuery->executeSqlFilesInDir('../install/0.6.0/sql', '')
    D:\xampp\htdocs\openbiblio\install\install.php:69 InstallQuery->freshInstall('en', true)

     
  • Are you trying to install OpenBiblio on a portable webserver like XAMPP or EasyPHP?
    EasyPHP 5.3.5.0 and XAMPP 1.7.3 are known to run OpenBiblio 0.6.1 and lower versions numbers without the error.

    There are fixes for running OpenBiblio on recent versions of MySQL and PHP, but these are yet not available in a release.

     


Anonymous


Cancel   Add attachments