View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 13447 | Bug reports | ComfortUpdate | public | 2018-03-04 20:34 | 2018-05-23 13:12 |
| Reporter | DenisChenu | Assigned To | |||
| Priority | none | Severity | minor | ||
| Status | closed | Resolution | unable to reproduce | ||
| Product Version | 3.4.x | ||||
| Summary | 13447: Updating with pgsql broke on duplicate key | ||||
| Description | When updating from a 2.72 or lesser version : receive Erreur non récupérable durant la mise à jour. Détails de cette erreur : CDbCommand n'a pas pu exécuter la commande SQL: SQLSTATE[23505]: Unique violation: 7 ERREUR: la valeur d'une clé dupliquée rompt la contrainte unique « lime_boxes_pkey » DETAIL: La clé « (id)=(1) » existe déjà.. The SQL statement executed was: INSERT INTO "lime_boxes" ("position", "url", "title", "ico", "desc", "page", "usergroup") VALUES (:position, :url, :title, :ico, :desc, :page, :usergroup) Fichier updatedb_helper.php, ligne 1949. | ||||
| Steps To Reproduce | Get a pgsql version , update . | ||||
| Additional Information | Delete manually :ico' => 'templates', set test to if (false && $rowToRemove !== false) { fix the issue … pgsql send surely something other than false, maybe null ? | ||||
| Tags | No tags attached. | ||||
| Bug heat | 0 | ||||
| Complete LimeSurvey version number (& build) | 3.4.1git | ||||
| I will donate to the project if issue is resolved | No | ||||
| Browser | not relevant | ||||
| Database type & version | pgsql | ||||
| Server OS (if known) | debian | ||||
| Webserver software & version (if known) | apache2 | ||||
| PHP Version | PHP5.6 | ||||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2018-03-04 20:34 | DenisChenu | New Issue | |
| 2018-03-04 20:34 | DenisChenu | Status | new => assigned |
| 2018-03-04 20:34 | DenisChenu | Assigned To | => LouisGac |
| 2018-05-23 13:12 |
|
Status | assigned => closed |
| 2018-05-23 13:12 |
|
Resolution | open => unable to reproduce |
