On Sun, 1 Aug 2010 22:31:51 +0200 (CEST) "Imposit.com - webmaster" <webmas...@imposit.com> wrote:
> > > >It's strange. I don't see any constrains. I just created the tables on a > >test instance and applied those constrains and then executed the commands > >and this is the output I get: > > Ah Dam sorry no. I delete them already, when i aply them i get the error i > posted earlier. > Okay. Then let me ask you a bunch of questions: - do you run a virtual user setup? - if you don't run a virtual user setup, then what kind of setup do you have? - what version of mysql? > The Problem is that as soon i aply them every mail bounces with error code 11 > so i cant do much testing with it > You mean the signal 11? That is usually a segmentation fault. Aug 1 07:38:40 mail postfix/local[21761]: 8A898E200F0: to=<whate...@example.com>, relay=local, delay=1.4, delays=0.07/0/0/1.3, dsn=5.3.0, status=bounced (Command died with signal 11: "/usr/local/dspam391/bin/dspam --deliver=innocent --user $USER -- -d %u") Might I ask why you insist in adding those constrains? The error below is telling me that DSPAM is trying to add signature for a UID that does not exist in dspam_virtual_uids or is not unique in dspam_virtual_uids. Can this be? Aug 1 07:38:40 mail dspam[21837]: query error: Cannot add or update a child row: a foreign key constraint fails (`admin_dspam`.`dspam_signature_data`, CONSTRAINT `dspam_signature_data_ibfk_1` FOREIGN KEY (`uid`) REFERENCES `dspam_virtual_uids` (`uid`) ON DELETE CASCADE): see sql.errors for more details Can you run the following commands and post the result: select count(uid) from dspam_virtual_uids; select count(distinct uid) from dspam_virtual_uids; Actually I don't need the number. All I would like to know is if the two numbers match or not? You could try as well to see if you got some signatures with an old uid. Could you run this here and post the output: select count(uid) from dspam_signature_data where not uid in (select distinct uid from dspam_virtual_uids); Have you ever run the purge script? If not, could you try to run it? It has actually nothing to do with your problem but if you never have run the purge script then the purging of old data will shrink the data in MySQL and this is beneficial for you. -- Kind Regards from Switzerland, Stevan Bajić ------------------------------------------------------------------------------ The Palm PDK Hot Apps Program offers developers who use the Plug-In Development Kit to bring their C/C++ apps to Palm for a share of $1 Million in cash or HP Products. Visit us here for more details: http://p.sf.net/sfu/dev2dev-palm _______________________________________________ Dspam-devel mailing list Dspam-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspam-devel
