Max Matslofva wrote:
>
> Hi Zhang
>
> Can you send the output from
> mysql> show tables;
>
> and
>
> mysql> CREATE TABLE quarantine (
> mail_id varchar(12) NOT NULL, -- long-term unique mail id
> chunk_ind integer unsigned NOT NULL, -- chunk number, starting with 1
> mail_text blob NOT NULL, -- store mail as chunks of octets
> PRIMARY KEY (mail_id,chunk_ind),
> FOREIGN KEY (mail_id) REFERENCES msgs(mail_id) ON DELETE CASCADE
> ) ENGINE=InnoDB;
>
>
> /Max
>
hi, Max. Thanks for your reply. :)
mysql> show tables;
Empty set (0.00 sec)
mysql> source README.sql-mysql; # <- Removed non-SQL sentences.
Query OK, 0 rows affected (0.02 sec)
Query OK, 0 rows affected (0.01 sec)
Query OK, 0 rows affected (0.01 sec)
Query OK, 0 rows affected (0.01 sec)
Query OK, 0 rows affected (0.03 sec)
ERROR 1005 (HY000): Can't create table './amavisd/msgs.frm' (errno: 150)
ERROR 1146 (42S02): Table 'amavisd.msgs' doesn't exist
ERROR 1146 (42S02): Table 'amavisd.msgs' doesn't exist
ERROR 1146 (42S02): Table 'amavisd.msgs' doesn't exist
ERROR 1005 (HY000): Can't create table './amavisd/msgrcpt.frm' (errno: 150)
ERROR 1146 (42S02): Table 'amavisd.msgrcpt' doesn't exist
ERROR 1146 (42S02): Table 'amavisd.msgrcpt' doesn't exist
ERROR 1005 (HY000): Can't create table './amavisd/quarantine.frm'
(errno: 150)
mysql> show tables;
+-------------------+
| Tables_in_amavisd |
+-------------------+
| maddr |
| mailaddr |
| policy |
| users |
| wblist |
+-------------------+
5 rows in set (0.00 sec)
mysql> CREATE TABLE quarantine (
-> mail_id varchar(12) NOT NULL, -- long-term unique mail id
-> chunk_ind integer unsigned NOT NULL, -- chunk number, starting
with 1
-> mail_text blob NOT NULL, -- store mail as chunks
of octets
-> PRIMARY KEY (mail_id,chunk_ind),
-> FOREIGN KEY (mail_id) REFERENCES msgs(mail_id) ON DELETE CASCADE
-> ) ENGINE=InnoDB;
ERROR 1005 (HY000): Can't create table './amavisd/quarantine.frm'
(errno: 150)
Is it OK? Any other info i can privide to help solve this issue?
--
Best Regards.
Zhang Huangbin
- Mail Server Solution for Red Hat(R) Enterprise Linux & CentOS 5.x:
http://rhms.googlecode.com/
-------------------------------------------------------------------------
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
http://sourceforge.net/services/buy/index.php
_______________________________________________
AMaViS-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/amavis-user
AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3
AMaViS-HowTos:http://www.amavis.org/howto/
