Unable to install
Getting an error when using the installation routine at creating DB. When doing it manually via phpMyAdmin I get the following ;
isys_const_system__idint( 10 ) unsigned NOT NULL AUTO_INCREMENT ,
isys_const_system__isys_const_system_type__idint( 10 ) unsigned default NULL ,
isys_const_system__constvarchar( 255 ) COLLATE latin1_german1_ci NOT NULL default '',
isys_const_system__valueint( 10 ) unsigned default '1',
isys_const_system__descriptiontext COLLATE latin1_german1_ci,
isys_const_system__store_idint( 10 ) unsigned NOT NULL default '0',
isys_const_system__doku_cross_referencetext COLLATE latin1_german1_ci,
PRIMARY KEY (
isys_const_system_ibfk_1FOREIGN KEY (
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.
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.
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
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.
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.
I'll have to setup a seperate system to test this as I have several systems using MySQL 5.