Jeff McCune wrote:
I ran the following:
use bacula; alter table File drop index FilenameID; alter table Path drop index Path;
Error messages gone.
IT ISN'T THE INDEX!
When you ran the statement: alter table File drop index FilenameID; I think you REMOVED THE PRIMARY KEY from the File table.
According to the description of Path, the primary key on PathId still exists.
mysql> describe Path; +--------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +--------+------------------+------+-----+---------+----------------+ | PathId | int(10) unsigned | | PRI | NULL | auto_increment | | Path | blob | | | | | +--------+------------------+------+-----+---------+----------------+ 2 rows in set (0.00 sec)
As it should... I think you removed the primary key from the *File* table, not the Path table.
What's describe File; look like?
Look at your two alter table statements more closely...
Regards, -- Jeff McCune OSU Department of Mathematics System Support (614) 292-4962 gpg --keyserver pgp.mit.edu --recv-key BAF3211A
signature.asc
Description: OpenPGP digital signature
