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

Cheers

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

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

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