-->
Welcome, Guest
Username: Password: Remember me
You can also tweak your setup of Dolibarr by setting hidden configurations found in Dolibarr Setup Other

TOPIC: 1062 - Duplicate entry '2147483647-1' for key 'uk_

1062 - Duplicate entry '2147483647-1' for key 'uk_ 4 months 3 days ago #34094

  • maximoss
  • maximoss's Avatar
  • OFFLINE
  • Newcomer
  • Posts: 1
  • Karma: 0
I have dolibarr 7.0.3 and all worked properly!! After my mass import with default module stock a lot of errors occured, so i decided to change via phpmyadmin the uk_product_stock to INDEX from (default UNIQUE).

Now the modulestock does not works correctly.

I tried to change it back to UNIQUE but with no luck.
Here what message displays

ALTER TABLE `paloubis_doli461`.`llxwz_product_stock` DROP INDEX `uk_product_stock`, ADD UNIQUE `uk_product_stock` (`fk_product`, `fk_entrepot`) USING BTREE;
1062 - Duplicate entry '2147483647-1' for key 'uk_product_stock'

Could you helping me to change it again to its default ?? Can anyone ????????

Very thanks in advance guys!!
The administrator has disabled public write access.

1062 - Duplicate entry '2147483647-1' for key 'uk_ 3 months 1 week ago #34291

  • aljawaid
  • aljawaid's Avatar
  • OFFLINE
  • Moderator
  • Trying to make the source open.
  • Posts: 715
  • Thank you received: 111
  • Karma: 12
Hello, I would run the installer again. Hopefully, the database queries will be refreshed so your problem will go away.
The administrator has disabled public write access.
Time to create page: 0.075 seconds