Page 1 of 1
PRIMARY KEY must be unique
Posted: Fri Nov 26, 2010 8:42 pm
by stanioomega
Hi
how to fix this problem
19:14:44 manager,error,info,debug failed to add purchase: PRIMARY KEY must be unique
19:15:18 manager,error,info,debug failed to add userprofile: PRIMARY KEY must be unique
19:16:15 manager,error,info,debug failed to add payment: PRIMARY KEY must be unique
tested with rebuild db but I get this errot
19:40:28 manager,error,info,debug error:
the version is 5rc4
the data bases is of 4.11
Re: PRIMARY KEY must be unique
Posted: Sat Nov 27, 2010 12:40 pm
by SurferTim
That is normally an error that occurs in a database (I get this error with MySQL and FreeRADIUS also) when the primary key (unique value) field in in a record already has a duplicate entry. Looks like in this case it might be the payment id. If you have rebuilt the database and still having problems, you should generate a supout.rif and email to support(at)mikrotik.com.
Re: PRIMARY KEY must be unique
Posted: Sun Nov 28, 2010 4:01 pm
by stanioomega
Yes, in paments there are some who have a name (unknown)
But I can not edit or delete
What solution is there?
/tool user-manager payment print
26 user=(unknown) customer=admin price=1075 currency="EUR" trans-start=nov/03/2010 10:22:09
trans-end=nov/03/2010 10:22:09 trans-status=approved result-code=0 result-msg=""
method=customer-deposit
sorry for my bad english
I use translate.google.com to spanish > english
Re: PRIMARY KEY must be unique
Posted: Sun Nov 28, 2010 5:52 pm
by SurferTim
You should email a supout.rif file to support(at)mikrotik.com, and include that "unknown" user record in the email with an explanation of your problem.
Re: PRIMARY KEY must be unique
Posted: Sun Nov 28, 2010 9:10 pm
by stanioomega
You should email a supout.rif file to support(at)mikrotik.com, and include that "unknown" user record in the email with an explanation of your problem.
I tried to send from my account in
www.mikrotik.com
but get this error ¨
Invalid supout.rif file.¨
Re: PRIMARY KEY must be unique
Posted: Sun Nov 28, 2010 10:25 pm
by SurferTim
Did you generate a valid supout.rif file with WinBox or the CLI?
/system sup-output
Re: PRIMARY KEY must be unique
Posted: Sun Nov 28, 2010 10:47 pm
by stanioomega
yes
[admin@La Cala] > /system sup-output
creating supout.rif file, might take a while
done
[admin@La Cala] >
same error ... Invalid supout.rif file.
Re: PRIMARY KEY must be unique
Posted: Sun Nov 28, 2010 11:01 pm
by SurferTim
Then email it from your normal email account with the supout.rif file attached.
Re: PRIMARY KEY must be unique
Posted: Thu Jul 07, 2011 4:39 pm
by imaljko4
What was the solution to your problem? Because I am having exactly the same problem.
Thanks