Zhang Huangbin, > I tryed to import SQL from README.sql-mysql(amavisd-new-2.6.1-rc1), but > failed too. > > Seperate SQL from README.sql-mysql, and 'SOURCE' it from mysql command > line: > > 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)
As reported by Leonardo Rodrigues, there is a mismatch on data types on foreign keys, which is why a table msgs (and subsequent ones) can not be built, because msgs.sid is referencing maddr.id of a different type. Please try the schema in: http://www.ijs.si/software/amavisd/README.sql-mysql.txt Mark ------------------------------------------------------------------------- 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 AMaViS-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/amavis-user AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3 AMaViS-HowTos:http://www.amavis.org/howto/