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

[<an...@co...>]

Procedure for re-installation:

 

1.	Drop all tables in database
2.	Delete the company directory inside /companies
3.	Delete config.php
4.	Navigate to the site in your browser and the installer should run.

 

From: aul...@sc... <aul...@sc...> 
Sent: 24 February 2025 13:43
To: 'For the general discussion of webERP project' <web...@li...>
Subject: Re: [webERP-users] mysql> SET restrict_fk_on_non_standard_key = OFF; 

 

yes thanx

i have runned command in my wamp mysql console

SET restrict_fk_on_non_standard_key = OFF;


but how i resinstall weberp after that, weberp database is not ok after prev error

so must i delete current weberp db and after that run reinstall weberp again

?

 

Lähettäjä: gilberto dos santos alves <gs...@gm... <mailto:gs...@gm...> > 
Lähetetty: maanantai 24. helmikuuta 2025 15.26
Vastaanottaja: For the general discussion of webERP project <web...@li... <mailto:web...@li...> >
Aihe: Re: [webERP-users] mysql> SET restrict_fk_on_non_standard_key = OFF; 

 

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... <mailto: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... <mailto:tim...@gm...> > 
Lähetetty: sunnuntai 23. helmikuuta 2025 17.47
Vastaanottaja: For the general discussion of webERP project
<web...@li... <mailto: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... <mailto: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... <mailto:web...@li...> 
> https://lists.sourceforge.net/lists/listinfo/web-erp-users



--
www.weberp.org <http://www.weberp.org> 
@TimSchofield2
Blog: https://kwamoja.home.blog/


_______________________________________________
web-ERP-users mailing list
web...@li... <mailto:web...@li...> 
https://lists.sourceforge.net/lists/listinfo/web-erp-users



_______________________________________________
web-ERP-users mailing list
web...@li... <mailto:web...@li...> 
https://lists.sourceforge.net/lists/listinfo/web-erp-users



-- 
This email has been checked for viruses by Avast antivirus software.
www.avast.com