1. Micah Stetson
  2. obiblio
Issue #76 duplicate

INSTALl ERRO

Anonymous created an issue

Deprecated: Function ereg() is deprecated in C:\Program Files\EasyPHP-5.3.9\www\openbiblio\install\install.php on line 20

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

Deprecated: Function ereg() is deprecated in C:\Program Files\EasyPHP-5.3.9\www\openbiblio\classes\InstallQuery.php on line 95

Deprecated: Function ereg() is deprecated in C:\Program Files\EasyPHP-5.3.9\www\openbiblio\classes\InstallQuery.php on line 95

Deprecated: Function ereg() is deprecated in C:\Program Files\EasyPHP-5.3.9\www\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): C:\Program Files\EasyPHP-5.3.9\www\openbiblio\classes\Error.php:100 FatalHandler->printBackTrace() C:\Program Files\EasyPHP-5.3.9\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:\Program Files\EasyPHP-5.3.9\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:\Program Files\EasyPHP-5.3.9\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:\Program Files\EasyPHP-5.3.9\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:\Program Files\EasyPHP-5.3.9\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:\Program Files\EasyPHP-5.3.9\www\openbiblio\classes\InstallQuery.php:96 InstallQuery->executeSqlFile('../install/0.6.0/sql/biblio.sql', '') C:\Program Files\EasyPHP-5.3.9\www\openbiblio\classes\InstallQuery.php:84 InstallQuery->executeSqlFilesInDir('../install/0.6.0/sql', '') C:\Program Files\EasyPHP-5.3.9\www\openbiblio\install\install.php:69 InstallQuery->freshInstall('tw', false)

Comments (2)

  1. Hans van der Weij

    The TYPE= deprecation and many other issues are fixed in version 0.7.1, so that is the recommended solution.

    If you really need to use OpenBiblio 0.6.1, use MySQL versions below 5.5. EasyPHP 5.3.5.0 should work. Perhaps you'll see "Deprecated ..." messages when running OpenBiblio 0.6.1 on this version. These should go away when error_reporting in PHP.INI is changed to production values.

  2. Log in to comment