[robhob]

Hello

On Friday, the server OpenCATS was running from ran out of hard drive space... today when users browse to the server they're getting the following error message:
Query Error -- Report to System Administrator ASAP
MySQL Query Failed: Duplicate column name 'directory_name'
ALTER IGNORE TABLE `attachment` ADD COLUMN `directory_name` VARCHAR(40) DEFAULT 0

We've got two instances of OpenCATS on the same server the 2nd one it still running fine. The funny thing is, if I log into it and then in the faulty one, the faulty one works until I log out at which point I get the same error message. The host is a windows 2000 machine and we're running OpenCATS version 0.9.1 (Beas).

Hope someone's got some ideas.

Cheers

Rob

[robhob]

Fixed!

There seemed to be a problem with the table module_schema. The entry "extension-statistics = 1" was missing and there where two "install" entries, the one equal to zero and the other to 363. I removed the zero entry and added the extension-statistics record. The system now seems to be stable.

SELECT * FROM cats.module_schema

[RussH]

I'd optimise my sql database as well, just to be safe..