Database query failed

Create issue
Issue #58 duplicate
Former user created an issue

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:\Program Files (x86)\EasyPHP-5.3.8.0\www\openbiblio\classes\Error.php:100 FatalHandler->printBackTrace() C:\Program Files (x86)\EasyPHP-5.3.8.0\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 (x86)\EasyPHP-5.3.8.0\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 (x86)\EasyPHP-5.3.8.0\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 (x86)\EasyPHP-5.3.8.0\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 (x86)\EasyPHP-5.3.8.0\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 (x86)\EasyPHP-5.3.8.0\www\openbiblio\classes\InstallQuery.php:96 InstallQuery->executeSqlFile('../install/0.6.0/sql/biblio.sql', '') C:\Program Files (x86)\EasyPHP-5.3.8.0\www\openbiblio\classes\InstallQuery.php:84 InstallQuery->executeSqlFilesInDir('../install/0.6.0/sql', '') C:\Program Files (x86)\EasyPHP-5.3.8.0\www\openbiblio\install\install.php:69 InstallQuery->freshInstall('en', true)

Comments (1)

  1. Hans van der Weij

    For 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. These should go away when error_reporting in PHP.INI is changed to production values.

    Or stay with the most recent Easy PHP 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: it 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.

    Duplicate of #36.

  2. Log in to comment