Robert,

Robert L. Tom wrote:
I applied these to my dbmail 1.1 mysql database..

alter table messages add index (unique_id);   <--Got an ERROR right here
alter table messages add index (status);      <-- also here.

But  I got an error on the last two lines from mysql saying they
don't exists!

That shouldn't happen. Those statements are well tested on clean tables created from the sql/mysql/create_tables* files, both the myisam and innodb versions.

Sounds like your messages table is seriously warped. Could you send a schema-dump ?




--
  ________________________________________________________________
  Paul Stevens                                  mailto:[EMAIL PROTECTED]
  NET FACILITIES GROUP                     PGP: finger [EMAIL PROTECTED]
  The Netherlands________________________________http://www.nfg.nl

Reply via email to