Database Index Bug
There’s a small bug in the database creation / update code for the 1.5.0b release. An extra index is being created on the tblDocumentContent table that should not be there. It is simple to fix and should not affect the running of MyDMS, but it will cause warning messages to appear, at least in MySQL. The solution is simply to delete the index.
If you are aleady running 1.5.0b, execute the following command in your database:
ALTER TABLE `tblDocumentContent` DROP INDEX `document`
Otherwise, before installing or upgrading, delete the following line from create_tables.sql (line 32):
KEY `document` (`document`)
Remember to also remove the comma from the end of the preceding line (PRIMARY KEY ...).
Upgraders should remove this line from update_tables.sql (line 33):
ALTER TABLE `tblDocumentContent` ADD INDEX ( `document` ) ;