spotweb/spotweb — Issue #1089: Duplicate entry
Author: Carnifex
Created: 2011-10-25 09:21:46+00:00
State: open

tijdens het draaien van upgrade-db.php na het pullen van commit 6f6bbf0dfa

```
Validating index idx_reportsposted_2
Adding index idx_reportsposted_2

SpotWeb crashed

Database schema of settings upgrade mislukt:
SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'FXtXFh
NF4RB2vA6G8MlHw@spot.net-4' for key 'idx_reportsposted_2'

#0 C:\xampp\htdocs\spotweb\lib\dbeng\dbeng_pdo.php(62): PDO->query('ALTER IGNORE
TA...')
#1 C:\xampp\htdocs\spotweb\lib\dbstruct\SpotStruct_mysql.php(63): dbeng_pdo->raw
Exec('ALTER IGNORE TA...')
#2 C:\xampp\htdocs\spotweb\lib\dbstruct\SpotStruct_abs.php(100): SpotStruct_mysq
l->addIndex('idx_reportspost...', 'UNIQUE', 'reportsposted', Array)
#3 C:\xampp\htdocs\spotweb\lib\dbstruct\SpotStruct_abs.php(605): SpotStruct_abs-
>validateIndex('idx_reportspost...', 'UNIQUE', 'reportsposted', Array)
#4 C:\xampp\htdocs\spotweb\lib\SpotUpgrader.php(53): SpotStruct_abs->updateSchem
a()
#5 C:\xampp\htdocs\spotweb\upgrade-db.php(22): SpotUpgrader->database()
#6 {main}
```