Unable to install

mwoodward

Hey Guys

Getting an error when using the installation routine at creating DB. When doing it manually via phpMyAdmin I get the following ;

Error

SQL query:

CREATE TABLE isys_const_system (
isys_const_system__id int( 10 ) unsigned NOT NULL AUTO_INCREMENT ,
isys_const_system__isys_const_system_type__id int( 10 ) unsigned default NULL ,
isys_const_system__const varchar( 255 ) COLLATE latin1_german1_ci NOT NULL default '',
isys_const_system__value int( 10 ) unsigned default '1',
isys_const_system__description text COLLATE latin1_german1_ci,
isys_const_system__store_id int( 10 ) unsigned NOT NULL default '0',
isys_const_system__doku_cross_reference text COLLATE latin1_german1_ci,
PRIMARY KEY ( isys_const_system__id ) ,
KEY isys_const_system_FKIndex1 ( isys_const_system__isys_const_system_type__id ) ,
CONSTRAINT isys_const_system_ibfk_1 FOREIGN KEY ( isys_const_system__isys_const_system_type__id ) REFERENCES isys_const_system_type ( isys_const_system_type__id ) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE = InnoDB DEFAULT CHARSET = latin1 COLLATE = latin1_german1_ci;

MySQL said: Documentation
#1005 - Can't create table '.\i-doit\isys_const_system.frm' (errno: 150)

Also get the same error mesaage when trying to load the mandator DB also.
I'm using MySQL 5.022, php 5.14 & Apache 2.054 on Windows XP.

Regards
Michael

Guest

Michael,

we use InnoDB as table driver to handle transactions and foreign key integrities - short: special features which MyISAM, the default table driver of mySQL, does not support. Look into your mySQL configuration and search for "skip-innodb". If you discovered it, delete the configuration line and restart the mySQL server. Then it should work.

mwoodward

Andre
I believe my InnoDB is enabled. I do not have a line such as 'skip-innodb' in my.ini
If I use "show variables like '%have%';" I get "have_innodb YES" as the response

Regards
Michael

mwoodward

Andre
Further to my last, it is only the above code that causes trouble (in the system table). Removing the above allows the rest of the table structure and data to load.
MichaelW

Guest

Michael,

you are correct since .frm files are also used with InnoDB, so I retract my statement. I guess, it's something with mySQL. Could you try out the latest version of 4.1? Cause we did not test with 5.0.xx completely yet.

Thanks!
André

mwoodward

I'll have to setup a seperate system to test this as I have several systems using MySQL 5.

Cheers