title: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '25' for key 'tbl_item_item_ID_UNIQUE'
body: <p>I have a table named <code>inventory</code> and it has 04 fields. They are  <code>qty</code>,<code>inventory_dateTime</code>,<code>tbl_item_item_ID</code>, and <code>tbl_branch_branch_ID</code>.<br/></p>
  
  <p><code>tbl_item_item_ID</code> and <code>tbl_branch_branch_ID</code> both are primary keys and currently the table has (1000 ,2015-11-12 19:01:04 ,25 ,2) values respectively.</p>
  
  <p>I wanted to add other data for the same table and values for <code>tbl_item_item_ID</code> and <code>tbl_branch_branch_ID</code> would be (25 ,3)<br/><br/>
  [<em>that simply means add 25th item_id from another branch to the inventory</em>]</p>
  
  <p>But it gives</p>
  
  <blockquote>
    <p>SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '25' for key 'tbl_item_item_ID_UNIQUE'</p>
  </blockquote>
  
  <p>How would I solve this? Help me please.</p>