Menu
▾
▴
Re: [webERP-users] mysql> SET = OFF;
|
From: <aul...@sc...> - 2025-02-26 15:10:59
|
ok , thanx from where i can load latest version? address? -----Alkuperäinen viesti----- Lähettäjä: Tim Schofield <tim...@gm...> Lähetetty: keskiviikko 26. helmikuuta 2025 16.47 Vastaanottaja: For the general discussion of webERP project <web...@li...> Aihe: Re: [webERP-users] mysql> SET = OFF; Hi, can you try downloading the latest from GitHub and try that. I have done some changes that should help you. Thanks Tim On Wed, 26 Feb 2025 at 14:25, <aul...@sc...> wrote: > > hi > > > > i dont understand why, because weberp install gives fatal error messages and not goes ok ??? > > now basic install have created weberp empty database ok, but demo data insert is not ok ? > > populating demo data is not ok because of fatal errors > > ? > > > > Lähettäjä: gilberto dos santos alves <gs...@gm...> > Lähetetty: keskiviikko 26. helmikuuta 2025 14.22 > Vastaanottaja: For the general discussion of webERP project > <web...@li...> > Aihe: Re: [webERP-users] mysql> SET = OFF; > > > > please look for > > .. global and local set variables > > on yor mysql. > > > > > > On Wed, Feb 26, 2025, 05:44 <aul...@sc...> wrote: > > database weberp is empty, admin/weberp > > > > > > Lähettäjä: aul...@sc... <aul...@sc...> > Lähetetty: keskiviikko 26. helmikuuta 2025 10.16 > Vastaanottaja: 'For the general discussion of webERP project' > <web...@li...> > Aihe: VS: [webERP-users] mysql> SET = OFF; > > > > > > im reinstall weberp again and i got other error message, is problem now with weberpdemo data base ? > > > > > > i found in phpadmin in locahost place to set variables, and now it is > off, if i understand > > if i use wampserver mysql console on my c, its was on > > > > Lähettäjä: aul...@sc... <aul...@sc...> > Lähetetty: keskiviikko 26. helmikuuta 2025 7.47 > Vastaanottaja: 'For the general discussion of webERP project' > <web...@li...> > Aihe: Re: [webERP-users] mysql> SET = OFF; > > > > parameter is off in wamp mysql console session, and still im getting > error when im install weberp in wamp localhost > > ?? > > > > > > Lähettäjä: Andrew Couling <an...@co...> > Lähetetty: tiistai 25. helmikuuta 2025 19.13 > Vastaanottaja: For the general discussion of webERP project > <web...@li...> > Aihe: Re: [webERP-users] mysql> SET = OFF; > > > > You should be able to interrogate the MySQL server settings by running an SQL query like the following in your MySQL console: > > > > SHOW VARIABLES WHERE Variable_name= 'restrict_fk_on_non_standard_key'; > > > > On 25 Feb 2025 16:41, gilberto dos santos alves <gs...@gm...> wrote: > > 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 > > > > Virus-free.www.avast.com > > > > > > _______________________________________________ > 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 > > _______________________________________________ > 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 |
