Issue #62 duplicate
emongkee created an issue

Deprecated: Function set_magic_quotes_runtime() is deprecated in C:\xampp\htdocs\openbiblio\shared\common.php on line 24

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

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

Deprecated: Function ereg() is deprecated in C:\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):

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

Comments (2)

  1. Log in to comment