12-04-2012, 05:55 AM
Hi again 
Found some time today and tried to update to the latest stable version 3.3.11. It went good so on and also switching to the new content directory format went fine.
I created a new DB and imported the old DB into the new one and run the update.sql. Then I tried to switch the DB to innoDB like "ALTER TABLE `tblDirPath` ENGINE = InnoDB" for each single table but on some tables I got an error.
The Error is (e.g. when altering tblDirPath to innoDB)
'#1075 - Incorrect table definition; there can be only one auto column and it must be defined as a key'
update.php is also not working. It says
Fatal error: Call to a member function Execute() on a non-object in /volume1/web/letoDMS-3.3.11/install/update-3.3.0/update.php on line 48
Table Field Old Value New Value Update statement
How can I switch my database from MyISAM to innoDB?
John
Found some time today and tried to update to the latest stable version 3.3.11. It went good so on and also switching to the new content directory format went fine.
I created a new DB and imported the old DB into the new one and run the update.sql. Then I tried to switch the DB to innoDB like "ALTER TABLE `tblDirPath` ENGINE = InnoDB" for each single table but on some tables I got an error.
The Error is (e.g. when altering tblDirPath to innoDB)
'#1075 - Incorrect table definition; there can be only one auto column and it must be defined as a key'
update.php is also not working. It says
Fatal error: Call to a member function Execute() on a non-object in /volume1/web/letoDMS-3.3.11/install/update-3.3.0/update.php on line 48
Table Field Old Value New Value Update statement
How can I switch my database from MyISAM to innoDB?
John