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

[<aul...@sc...>]

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