Re: [webERP-users] mysql> SET restrict_fk_on_non_standard_key = OFF;

[gilberto d. s. a. <gs...@gm...>]

after install mysql and before install weberp you must run this command for
disable duplicated foreign key validation.
then install weberp

On Mon, Feb 24, 2025, 02:45 <aul...@sc...> wrote:

> ok
> how i can reinstall weberp ?
> delete  current weberp database which is ok
> and reinstall web?
>
> -----Alkuperäinen viesti-----
> Lähettäjä: Tim Schofield <tim...@gm...>
> Lähetetty: sunnuntai 23. helmikuuta 2025 17.47
> Vastaanottaja: For the general discussion of webERP project
> <web...@li...>
> Aihe: Re: [webERP-users] mysql> SET restrict_fk_on_non_standard_key = OFF;
>
> This has been discussed here:
> https://github.com/timschofield/webERP/issues/351 and it seems mysql have
> agreed it is a bug in 8.4 and it will be fixed, but thanks for the tip
> about
> setting
>
> SET restrict_fk_on_non_standard_key = OFF;
>
> Thanks
> Tim
>
> On Sun, 23 Feb 2025 at 15:27, adm ti auvix <us...@au...> wrote:
> >
> > hi!
> >
> > This url [https://bugs.mysql.com/bug.php?id=114838] show how to
> > disable
> >
> > There is a seemingly undocumented variable introduced in MySQL 8.4
> "RESTRICT_FK_ON_NON_STANDARD_KEY" which is enabled by default.
> >
> > "Disallow the creation of foreign keys referencing non-unique key"
> >
> > [7 May 2024 20:04] Evan Elias
> >
> > Wow, excellent find. Strangely, not only is that new variable
> undocumented, but it is also deprecated. If you disable it, a warning is
> issued:
> >
> > mysql> SET restrict_fk_on_non_standard_key = OFF;
> > Query OK, 0 rows affected, 1 warning (0.01 sec)
> >
> > mysql> SHOW WARNINGS\G
> > *************************** 1. row ***************************
> >   Level: Warning
> >    Code: 4166
> > Message: 'restrict_fk_on_non_standard_key' is deprecated and will be
> removed in a future release. Foreign key referring to non-unique or partial
> keys is unsafe and may break replication.
> > 1 row in set (0.00 sec)
> >
> >
> >
> > please in your mysql environment run  SET
> > restrict_fk_on_non_standard_key = OFF;
> >
> > regards.
> >
> > _______________________________________________
> > web-ERP-users mailing list
> > web...@li...
> > https://lists.sourceforge.net/lists/listinfo/web-erp-users
>
>
>
> --
> www.weberp.org
> @TimSchofield2
> Blog: https://kwamoja.home.blog/
>
>
> _______________________________________________
> web-ERP-users mailing list
> web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-users
>
>
>
> _______________________________________________
> web-ERP-users mailing list
> web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-users
>