[Dolibarr-bugtrack] [Bug #1363] Unable to update from 3.5.1 to 3.5.2

[Doliforge]

Is this email not displaying correctly? update email preferences.

Dolibarr ERP & CRM » Bugs » bug #1363

Unable to update from 3.5.1 to 3.5.2

Latest modifications

Marcos García (marcosgdf)

2014-05-01 15:46 (Europe/Madrid)

Changes:

Database type and version:

-  +5.6.17-1~dotdeb.1

Answer now

Snapshot

Details
Last Modified On:	2014-05-01 15:45		Submitted by:	Marcos García (marcosgdf)
Submitted on:	2014-05-01 15:43
Summary:	Unable to update from 3.5.1 to 3.5.2
Description:	URL http://dev.dolibarr.org/install/upgrade.php?action=""> Request 36 sql='ALTER TABLE llx_categorie_contact ADD CONSTRAINT fk_categorie_contact_categorie_rowid FOREIGN KEY (fk_categorie) REFERENCES llx_categorie (rowid);' Error DB_ERROR_1022: ALTER TABLE llx_categorie_contact ADD CONSTRAINT fk_categorie_contact_categorie_rowid FOREIGN KEY (fk_categorie) REFERENCES llx_categorie (rowid); Can't write; duplicate key in table '#sql-a32_169' Request 37 sql='ALTER TABLE llx_categorie_contact ADD CONSTRAINT fk_categorie_contact_fk_socpeople FOREIGN KEY (fk_socpeople) REFERENCES llx_socpeople (rowid);' Error DB_ERROR_1022: ALTER TABLE llx_categorie_contact ADD CONSTRAINT fk_categorie_contact_fk_socpeople FOREIGN KEY (fk_socpeople) REFERENCES llx_socpeople (rowid); Can't write; duplicate key in table '#sql-a32_169'
Step to reproduce bug:	1. Fresh install (git checkout 3.5.1) 2. Initial config, enabled modules: thirds, invoices, products 3. Create product: PRODA 4. Create a client: "Client" 5. Create a prov invoice for "Client". 6. Update files (git checkout 3.5.2) 7. Install wizard is shown, choose to update 3.4.0 - 3.5.0 > 3.5.0 8. KO queries
Detected in version:	3.5.2		Category:	Core Problem
Severity:	9 - Blocking - Critical		OS Type/Version:
PHP version:			Database type and version:	5.6.17-1~dotdeb.1
Status
Status:	Open		Assigned to:	None
Resolution:	None

 Direct link to the artifact  |  Update your email preferences