Hi,

I am restoring a 5.0.3 Dolibarr and mysql command prints:
ERROR 1005 (HY000) at line 20: Can't create table
`dolibarr`.`llx_accounting_account` (errno: 150 "Foreign key constraint
is incorrectly formed")

In the dump, I added, as recommended on the wiki:

SET FOREIGN_KEY_CHECKS=0;
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

and at the end:
SET FOREIGN_KEY_CHECKS=0;

I addd this after the error appeared. Then i retried, idem.

Should I be worry with it? Can I fix it? What about the remaining of the 
database, can I consider it is restored?

Tnaks for help 
regards,


-- 
signature_jp_2
Logo Hypra      JEAN-PHILIPPE MENGUAL
DIRECTEUR TECHNIQUE ET QUALITÉ
102, rue des poissonniers, 75018, Paris
Tel : +331 84 73 06 61 <tel:+33184730661> Mob : +336 76 34 93 37
<tel:+33676349337>
[email protected] <mailto:[email protected]>
www.hypra.fr <http://www.hypra.fr/>
Facebook Hypra <https://www.facebook.com/hyprasoftware/> Twitter Hypra
<https://twitter.com/Hypra_> Linkedin Jean-Philippe
<https://fr.linkedin.com/in/jean-philippe-mengual-800133135>


_______________________________________________
Dolibarr-user mailing list
[email protected]
https://lists.nongnu.org/mailman/listinfo/dolibarr-user

Répondre à