Menu
▾
▴
Re: [webERP-users] mysql> SET restrict_fk_on_non_standard_key = OFF;
|
From: <aul...@sc...> - 2025-02-25 10:13:23
|
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... <mailto: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ä: <mailto:an...@co...> an...@co... < <mailto:an...@co...> an...@co...> Lähetetty: tiistai 25. helmikuuta 2025 0.46 Vastaanottaja: 'For the general discussion of webERP project' < <mailto:web...@li...> 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: <mailto:aul...@sc...> aul...@sc... < <mailto:aul...@sc...> aul...@sc...> Sent: 24 February 2025 13:43 To: 'For the general discussion of webERP project' < <mailto:web...@li...> 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 < <mailto:gs...@gm...> gs...@gm...> Lähetetty: maanantai 24. helmikuuta 2025 15.26 Vastaanottaja: For the general discussion of webERP project < <mailto:web...@li...> 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 <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campai gn=sig-email&utm_content=emailclient> Virus-free. <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campai gn=sig-email&utm_content=emailclient> www.avast.com |
