kevin wrote:If the default table type of your MySQL server is anything other than MyISAM, you may need to add "TYPE = MyISAM" to the end of each of the CREATE TABLE statements in install.php
My default tables are ISAM so that doesn't seem to be the issue. I think it has something to do with the use of FULLTEXT as an index in the papers table. I am not sure why.
The statements for creating the papers table seem to be the only ones causing a problem.
What works is to comment out the lines which use fulltext(foo). To me this means that $db_enable_fulltext is TRUE but there is something wrong with the syntax of the fulltext indexing statements or the create statement for the papers table is wrong in some way.
Anyway, I set OCS up this way last time and it ran with no problems so I think I'll try that again. I am using an Apache server this time so hopefully I won't have to make any changes to the cookies stuff.