PRIMARY KEY must be unique

RouterOS The User Manager
1

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

2

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.

3

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

4

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.

5

I tried to send from my account in www.mikrotik.com
but get this error ¨Invalid supout.rif file.¨

6

Did you generate a valid supout.rif file with WinBox or the CLI?
/system sup-output

7

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.

8

Then email it from your normal email account with the supout.rif file attached.

9

What was the solution to your problem? Because I am having exactly the same problem.

Thanks