Uncaught mysqli_sql_exception: Duplicate entry
Closed this issue · 1 comments
Just migrated to php 8.3 was using 7.2 before with no issues.
i have multiple inserts within the same script which somehow is causing duplicated inserts from another part of the script
on this error the table does not even have primary key date this was a insert from another part of the script
any ideas?
thrown in /scripts/vendor/thingengineer/mysqli-database-class/MysqliDb.php on line 1545
[Wed Jun 5 17:26:05 2024] 127.0.0.1:41774 [500]: PUT /indexLive.php - Uncaught mysqli_sql_exception: Duplicate entry '2024-06-05 17:26:05-6654910' for key 'Date' in /scripts/vendor/thingengineer/mysqli-database-class/MysqliDb.php:1545
Stack trace:
#0 /scripts/vendor/thingengineer/mysqli-database-class/MysqliDb.php(1545): mysqli_stmt->execute()
#1 /scripts/vendor/thingengineer/mysqli-database-class/MysqliDb.php(837): MysqliDb->_buildInsert()
#2 /scripts/vendor/thingengineer/mysqli-database-class/MysqliDb.php(866): MysqliDb->insert()
#3 /scripts/configs/Live/LogLicenses.php(21): MysqliDb->insertMulti()
#4 /scripts/indexLive.php(439): require_once('...')
#5 {main}
Could it perhaps be a UNIQUE constraint (possibly combined with a default value of NOW()) on one of the columns which you're bulk-updating?