Menu
▾
▴
Re: [webERP-users] mysql> SET = OFF;
|
From: <aul...@sc...> - 2025-02-27 08:27:11
|
hi install gives warning but it is probably ok ? if i press weperp restart -> ? my wamp environment is phpmyadmin -----Alkuperäinen viesti----- Lähettäjä: Tim Schofield <tim...@gm... <mailto:tim...@gm...> > Lähetetty: keskiviikko 26. helmikuuta 2025 17.12 Vastaanottaja: For the general discussion of webERP project <web...@li... <mailto:web...@li...> > Aihe: Re: [webERP-users] mysql> SET = OFF; <https://github.com/timschofield/webERP> https://github.com/timschofield/webERP On Wed, 26 Feb 2025 at 15:11, < <mailto:aul...@sc...> aul...@sc...> wrote: > > ok , thanx > from where i can load latest version? address? > > -----Alkuperäinen viesti----- > Lähettäjä: Tim Schofield < <mailto:tim...@gm...> tim...@gm...> > Lähetetty: keskiviikko 26. helmikuuta 2025 16.47 > Vastaanottaja: For the general discussion of webERP project > < <mailto:web...@li...> 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, < <mailto:aul...@sc...> 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 < <mailto:gs...@gm...> gs...@gm...> > > Lähetetty: keskiviikko 26. helmikuuta 2025 14.22 > > Vastaanottaja: For the general discussion of webERP project > > < <mailto:web...@li...> 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 < <mailto:aul...@sc...> aul...@sc...> wrote: > > > > database weberp is empty, admin/weberp > > > > > > > > > > > > Lähettäjä: <mailto:aul...@sc...> aul...@sc... < <mailto:aul...@sc...> aul...@sc...> > > Lähetetty: keskiviikko 26. helmikuuta 2025 10.16 > > Vastaanottaja: 'For the general discussion of webERP project' > > < <mailto:web...@li...> 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ä: <mailto:aul...@sc...> aul...@sc... < <mailto:aul...@sc...> aul...@sc...> > > Lähetetty: keskiviikko 26. helmikuuta 2025 7.47 > > Vastaanottaja: 'For the general discussion of webERP project' > > < <mailto:web...@li...> 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 < <mailto:an...@co...> an...@co...> > > Lähetetty: tiistai 25. helmikuuta 2025 19.13 > > Vastaanottaja: For the general discussion of webERP project > > < <mailto:web...@li...> 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 < <mailto:gs...@gm...> 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 < <mailto:aul...@sc...> 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 < <mailto:an...@co...> an...@co...> > > Lähetetty: tiistai 25. helmikuuta 2025 10.17 > > 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; > > > > > > > > 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, <mailto:aul...@sc...> 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 < <mailto:aul...@sc...> 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 < <mailto:tim...@gm...> tim...@gm...> > > Lähetetty: sunnuntai 23. helmikuuta 2025 17.47 > > 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; > > > > This has been discussed here: > > <https://github.com/timschofield/webERP/issues/351> 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 < <mailto:us...@au...> 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 > > > <mailto:web...@li...> web...@li... > > > <https://lists.sourceforge.net/lists/listinfo/web-erp-users> https://lists.sourceforge.net/lists/listinfo/web-erp-users > > > > > > > > -- > > <http://www.weberp.org> www.weberp.org > > @TimSchofield2 > > Blog: <https://kwamoja.home.blog/> https://kwamoja.home.blog/ > > > > > > _______________________________________________ > > web-ERP-users mailing list > > <mailto:web...@li...> web...@li... > > <https://lists.sourceforge.net/lists/listinfo/web-erp-users> https://lists.sourceforge.net/lists/listinfo/web-erp-users > > > > > > > > _______________________________________________ > > web-ERP-users mailing list > > <mailto:web...@li...> web...@li... > > <https://lists.sourceforge.net/lists/listinfo/web-erp-users> https://lists.sourceforge.net/lists/listinfo/web-erp-users > > > > > > > > Virus-free.www.avast.com > > > > > > > > > > > > _______________________________________________ > > web-ERP-users mailing list > > <mailto:web...@li...> web...@li... > > <https://lists.sourceforge.net/lists/listinfo/web-erp-users> https://lists.sourceforge.net/lists/listinfo/web-erp-users > > > > > > > > _______________________________________________ > > web-ERP-users mailing list > > <mailto:web...@li...> web...@li... > > <https://lists.sourceforge.net/lists/listinfo/web-erp-users> https://lists.sourceforge.net/lists/listinfo/web-erp-users > > > > _______________________________________________ > > web-ERP-users mailing list > > <mailto:web...@li...> web...@li... > > <https://lists.sourceforge.net/lists/listinfo/web-erp-users> https://lists.sourceforge.net/lists/listinfo/web-erp-users > > > > -- > <http://www.weberp.org> www.weberp.org > @TimSchofield2 > Blog: <https://kwamoja.home.blog/> https://kwamoja.home.blog/ > > > _______________________________________________ > web-ERP-users mailing list > <mailto:web...@li...> web...@li... > <https://lists.sourceforge.net/lists/listinfo/web-erp-users> https://lists.sourceforge.net/lists/listinfo/web-erp-users > > > > _______________________________________________ > web-ERP-users mailing list > <mailto:web...@li...> web...@li... > <https://lists.sourceforge.net/lists/listinfo/web-erp-users> https://lists.sourceforge.net/lists/listinfo/web-erp-users -- <http://www.weberp.org> www.weberp.org @TimSchofield2 Blog: <https://kwamoja.home.blog/> https://kwamoja.home.blog/ _______________________________________________ web-ERP-users mailing list <mailto:web...@li...> web...@li... <https://lists.sourceforge.net/lists/listinfo/web-erp-users> https://lists.sourceforge.net/lists/listinfo/web-erp-users |
