Instalation Problem

Issue #40 duplicate
Former user created an issue

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

Deprecated: Function ereg() is deprecated in /opt/lampp/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 material_type_dm ( code smallint auto_increment primary key ,description varchar(40) not null ,default_flg char(1) not null ,image_file varchar(128) 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 7

Debug Backtrace (most recent call first):

/opt/lampp/htdocs/openbiblio/classes/Error.php:100 FatalHandler->printBackTrace()
/opt/lampp/htdocs/openbiblio/classes/Error.php:68 FatalHandler->dbError('
create table material_type_dm (
code smallint auto_increment primary key
,description varchar(40) not null
,default_flg char(1) not null
,image_file varchar(128) 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 7')
/opt/lampp/htdocs/openbiblio/classes/Query.php:91 Fatal->dbError('
create table material_type_dm (
code smallint auto_increment primary key
,description varchar(40) not null
,default_flg char(1) not null
,image_file varchar(128) 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 7')
/opt/lampp/htdocs/openbiblio/classes/Query.php:266 Query->_act('
create table material_type_dm (
code smallint auto_increment primary key
,description varchar(40) not null
,default_flg char(1) not null
,image_file varchar(128) null
)
TYPE=MyISAM
')
/opt/lampp/htdocs/openbiblio/classes/Query.php:271 Query->_exec('
create table material_type_dm (
code smallint auto_increment primary key
,description varchar(40) not null
,default_flg char(1) not null
,image_file varchar(128) null
)
TYPE=MyISAM
')
/opt/lampp/htdocs/openbiblio/classes/InstallQuery.php:121 Query->exec('
create table material_type_dm (
code smallint auto_increment primary key
,description varchar(40) not null
,default_flg char(1) not null
,image_file varchar(128) null
)
TYPE=MyISAM
')
/opt/lampp/htdocs/openbiblio/classes/InstallQuery.php:96 InstallQuery->executeSqlFile('../install/0.6.0/sql/material_type_dm.sql', '')
/opt/lampp/htdocs/openbiblio/classes/InstallQuery.php:84 InstallQuery->executeSqlFilesInDir('../install/0.6.0/sql', '')
/opt/lampp/htdocs/openbiblio/install/install.php:69 InstallQuery->freshInstall('en', false)

Comments (2)

  1. Former user Account Deleted

    Is it possible for you to use a MySQL version lower than 5.5? And to change PHP.INI to production values, so that deprecated warnings do not show?

  2. Log in to comment