Mysql Duplicate Entry Error On Insert

Question

Something very bizare is happening right now and I don't understand how to fix it... Well, temporarily I do but the solution I found is not how the program should behave...

So I have this employeetimesheets table:

empsheet_id | employee_id |timesheet_status |last_update |isWeekNumber|total_hours|isMonth|isYear|overtimeHours

the variables:

    $isWeekNumber =  $_POST['isWeekNumber'];
    $attendanceyear= $_POST['attendanceyear'];
    $attendancemonth= $_POST['attendancemonth'];
    $employee_id=  $_POST['employee_id'];

the query:

    $insertemptime= $db->prepare("INSERT INTO employeetimesheets (employee_id,isWeekNumber,isMonth,isYear) VALUES (?,?,?,?)");
    $insertemptime->bind_param("iiss",$employee_id,$isWeekNumber,$attendancemonth,$attendanceyear);
    $insertemptime->execute() or die(mysqli_error($db)); 
    $insertemptime->close();

On insert NEW row I receive this error when there is already a row with same employee_id

Fatal error: Uncaught exception 'mysqli_sql_exception' with message 'Duplicate entry '6748372' for key 'EmployeeTimeSheetsKey''

If I delete the row with the employee_id I'm trying to insert, the query works. I"m confused because it's an insert statement... I should be able to add as many rows I want with the same employee_id, yes? Anybody has an idea what's going on?

Fatal error: Uncaught exception 'mysqli_sql_exception' with message 'Duplicate entry '6748372' for key 'EmployeeTimeSheetsKey'' You are getting this message because you have already an entry with6748372 id in your mysql table — Sahil Gulati
– Sahil Gulati, Commented Apr 1, 2017 at 2:09
For that you have to do two things i am updating my post for that — Sahil Gulati
– Sahil Gulati, Commented Apr 1, 2017 at 2:11

Nawwar Elnarsh · Accepted Answer · 2017-04-01 02:16:50Z

3

You've set the field employee_id to unique instead of index

Remove unique index from field and add index again without unique

Example sql code

Check index
```
SHOW INDEX FROM employeetimesheets;
```

Remove Index

ALTER TABLE employeetimesheets DROP INDEX employee_id;

Add Index

CREATE INDEX employeetimesheets ON employee_id;

edited Apr 1, 2017 at 2:16

answered Apr 1, 2017 at 2:10

Nawwar Elnarsh

1,08917 silver badges29 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Mysql Duplicate Entry Error On Insert

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related