2. PHPRunner General questions
  3. [SOLVED]  Error I cannot figure out
This topic is locked
[SOLVED]

 Error I cannot figure out

 		12/1/2010 9:20:37 AM
PHPRunner General questions
K
 karmacomposer author

My client registered and entered job data into the database and was able to enter one record. However, when trying to add another record, they got the following error:
============
<<< Record was NOT added >>>
Duplicate entry '169' for key 1
=============
Now, the security is set to edit and see their own data only and pages include add, edit, etc. Under security, they can add, edit, etc.
There is no special code in the events section that would limit this.
Why can they not add another record?
Mike
P
 		procheck 12/1/2010

This is because you have an index which doesn't allow duplicates.
K
 		karmacomposer author 12/1/2010



This is because you have an index which doesn't allow duplicates.


OK. The only duplicate is the UserID, so how do I make it so it can allow duplicates? Is this a phprunner setting or a mysql setting?
Mike
F
 		FreddieM 12/1/2010

This is to do with the database.
K
 		karmacomposer author 12/1/2010



This is to do with the database.


Can I change this in PHPMyAdmin or does this need to be done in the admin panel for mysql?
F
 		FreddieM 12/1/2010

yes you can change an Index in phpmyadmin. Go to the structure tab and expand the details section at the bottom.
J
 		Jane 12/1/2010

Hi,
please make sure this field is not set up as OwnerID field on the Advanced security settings dialog. OwnerID field is filled automatically with value from users table.
K
 		karmacomposer author 12/1/2010



Hi,
please make sure this field is not set up as OwnerID field on the Advanced security settings dialog. OwnerID field is filled automatically with value from users table.


Jane,
If you would just take a quick look and make sure I did not screw anything up - as long as you are coding the other stuff, right?
Mike