Community discussions

MikroTik App
  4. Other topics
  5. The User Manager

PRIMARY KEY must be unique

Post Reply
 
stanioomega
just joined
Topic Author
Posts: 16
Joined: Tue Feb 16, 2010 4:27 am

PRIMARY KEY must be unique

Fri Nov 26, 2010 8:42 pm

Hi
how to fix this problem
Code: Select all
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
Code: Select all
19:40:28 manager,error,info,debug error:
the version is 5rc4
the data bases is of 4.11
Top
 
SurferTim
Forum Guru
Forum Guru
Posts: 4636
Joined: Mon Jan 07, 2008 10:31 pm
Location: Miramar Beach, Florida

Re: PRIMARY KEY must be unique

Sat Nov 27, 2010 12:40 pm

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.
Top
 
stanioomega
just joined
Topic Author
Posts: 16
Joined: Tue Feb 16, 2010 4:27 am

Re: PRIMARY KEY must be unique

Sun Nov 28, 2010 4:01 pm

Yes, in paments there are some who have a name (unknown)
But I can not edit or delete
What solution is there?
Code: Select all
/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
Top
 
SurferTim
Forum Guru
Forum Guru
Posts: 4636
Joined: Mon Jan 07, 2008 10:31 pm
Location: Miramar Beach, Florida

Re: PRIMARY KEY must be unique

Sun Nov 28, 2010 5:52 pm

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.
Top
 
stanioomega
just joined
Topic Author
Posts: 16
Joined: Tue Feb 16, 2010 4:27 am

Re: PRIMARY KEY must be unique

Sun Nov 28, 2010 9:10 pm

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.¨
Top
 
SurferTim
Forum Guru
Forum Guru
Posts: 4636
Joined: Mon Jan 07, 2008 10:31 pm
Location: Miramar Beach, Florida

Re: PRIMARY KEY must be unique

Sun Nov 28, 2010 10:25 pm

Did you generate a valid supout.rif file with WinBox or the CLI?
/system sup-output
Top
 
stanioomega
just joined
Topic Author
Posts: 16
Joined: Tue Feb 16, 2010 4:27 am

Re: PRIMARY KEY must be unique

Sun Nov 28, 2010 10:47 pm

yes
Code: Select all
[admin@La Cala] > /system sup-output
creating supout.rif file, might take a while
done
[admin@La Cala] >
same error ... Invalid supout.rif file.
Top
 
SurferTim
Forum Guru
Forum Guru
Posts: 4636
Joined: Mon Jan 07, 2008 10:31 pm
Location: Miramar Beach, Florida

Re: PRIMARY KEY must be unique

Sun Nov 28, 2010 11:01 pm

Then email it from your normal email account with the supout.rif file attached.
Top
 
imaljko4
Member Candidate
Member Candidate
Posts: 250
Joined: Fri Apr 25, 2008 6:52 pm

Re: PRIMARY KEY must be unique

Thu Jul 07, 2011 4:39 pm

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

Thanks
Top
Post Reply
  4. Other topics
  5. The User Manager