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

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

hi.
please take a calm environment and step by step follow each step
regards from sp 25-02-25

On Tue, Feb 25, 2025, 07:15 <aul...@sc...> wrote:

> hi again
>
> now im trying install weberp again and i think i got same error situation
> as earlier ???
>
> i have set by using wamp mysql console , should wamp services start after
> that ?
>
> SET restrict_fk_on_non_standard_key = OFF;
>
> where i can verified this parameter value ?
>
>
>
>
>
>
>
> *Lähettäjä:* Andrew Couling <an...@co...>
> *Lähetetty:* tiistai 25. helmikuuta 2025 10.17
> *Vastaanottaja:* For the general discussion of webERP project <
> web...@li...>
> *Aihe:* Re: [webERP-users] mysql> SET restrict_fk_on_non_standard_key =
> OFF;
>
>
>
> You can leave the weberpdemo folder.
>
> You should delete the folder which has the same name as your database. In
> your case it's the folder named 'weberp'.
>
>
>
> On 25 Feb 2025 05:49, aul...@sc... wrote:
>
> 1.      Delete the company directory inside /companies
>
> this companies dir contains weberp and weberdemo directories, make i
> delete for both
> there is not company dir ?
>
>
>
> *Lähettäjä:* an...@co... <an...@co...>
> *Lähetetty:* tiistai 25. helmikuuta 2025 0.46
> *Vastaanottaja:* 'For the general discussion of webERP project' <
> web...@li...>
> *Aihe:* Re: [webERP-users] mysql> SET restrict_fk_on_non_standard_key =
> OFF;
>
>
>
> 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...>
> *Lähetetty:* maanantai 24. helmikuuta 2025 15.26
> *Vastaanottaja:* For the general discussion of webERP project <
> 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...> 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
>
>
>
>
> <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient>
>
> Virus-free.www.avast.com
> <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient>
>
>
>
>
> _______________________________________________
> web-ERP-users mailing list
> web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-users
>