Menu
▾
▴
web-erp-users — User general webERP discussion list
You can subscribe to this list here.
| 2003 |
Jan
(1) |
Feb
|
Mar
(20) |
Apr
(24) |
May
(7) |
Jun
(5) |
Jul
(4) |
Aug
(35) |
Sep
(34) |
Oct
(21) |
Nov
(39) |
Dec
(15) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2004 |
Jan
(11) |
Feb
(30) |
Mar
(60) |
Apr
(98) |
May
(61) |
Jun
(33) |
Jul
(44) |
Aug
(102) |
Sep
(59) |
Oct
(152) |
Nov
(86) |
Dec
(39) |
| 2005 |
Jan
(96) |
Feb
(117) |
Mar
(75) |
Apr
(144) |
May
(78) |
Jun
(47) |
Jul
(58) |
Aug
(87) |
Sep
(89) |
Oct
(120) |
Nov
(43) |
Dec
(15) |
| 2006 |
Jan
(142) |
Feb
(55) |
Mar
(67) |
Apr
(79) |
May
(44) |
Jun
(62) |
Jul
(104) |
Aug
(90) |
Sep
(38) |
Oct
(70) |
Nov
(17) |
Dec
(80) |
| 2007 |
Jan
(108) |
Feb
(121) |
Mar
(33) |
Apr
(17) |
May
(18) |
Jun
(60) |
Jul
(62) |
Aug
(101) |
Sep
(94) |
Oct
(117) |
Nov
(44) |
Dec
(23) |
| 2008 |
Jan
(106) |
Feb
(67) |
Mar
(169) |
Apr
(73) |
May
(101) |
Jun
(112) |
Jul
(125) |
Aug
(149) |
Sep
(139) |
Oct
(162) |
Nov
(92) |
Dec
(88) |
| 2009 |
Jan
(199) |
Feb
(219) |
Mar
(372) |
Apr
(246) |
May
(146) |
Jun
(159) |
Jul
(276) |
Aug
(146) |
Sep
(143) |
Oct
(76) |
Nov
(65) |
Dec
(208) |
| 2010 |
Jan
(129) |
Feb
(76) |
Mar
(127) |
Apr
(131) |
May
(90) |
Jun
(237) |
Jul
(108) |
Aug
(75) |
Sep
(39) |
Oct
(92) |
Nov
(118) |
Dec
(63) |
| 2011 |
Jan
(96) |
Feb
(146) |
Mar
(190) |
Apr
(141) |
May
(142) |
Jun
(109) |
Jul
(112) |
Aug
(182) |
Sep
(115) |
Oct
(100) |
Nov
(278) |
Dec
(169) |
| 2012 |
Jan
(134) |
Feb
(156) |
Mar
(161) |
Apr
(81) |
May
(16) |
Jun
(72) |
Jul
(99) |
Aug
(64) |
Sep
(90) |
Oct
(47) |
Nov
(86) |
Dec
(49) |
| 2013 |
Jan
(29) |
Feb
(14) |
Mar
(12) |
Apr
(25) |
May
(10) |
Jun
(26) |
Jul
(12) |
Aug
(17) |
Sep
(6) |
Oct
(3) |
Nov
(13) |
Dec
(27) |
| 2014 |
Jan
(18) |
Feb
(14) |
Mar
(17) |
Apr
(17) |
May
(23) |
Jun
(25) |
Jul
(25) |
Aug
(12) |
Sep
(7) |
Oct
(33) |
Nov
(39) |
Dec
(12) |
| 2015 |
Jan
(21) |
Feb
(39) |
Mar
(41) |
Apr
(9) |
May
(16) |
Jun
(7) |
Jul
(8) |
Aug
(2) |
Sep
|
Oct
|
Nov
(24) |
Dec
(12) |
| 2016 |
Jan
(15) |
Feb
(17) |
Mar
(23) |
Apr
(11) |
May
(3) |
Jun
(7) |
Jul
(3) |
Aug
|
Sep
(5) |
Oct
(5) |
Nov
(2) |
Dec
|
| 2017 |
Jan
|
Feb
(12) |
Mar
(14) |
Apr
|
May
(1) |
Jun
(10) |
Jul
(7) |
Aug
(5) |
Sep
(3) |
Oct
(1) |
Nov
|
Dec
|
| 2018 |
Jan
|
Feb
|
Mar
|
Apr
|
May
(1) |
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
| 2019 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
(2) |
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
| 2020 |
Jan
|
Feb
(1) |
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
| 2021 |
Jan
|
Feb
|
Mar
|
Apr
(1) |
May
(1) |
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
(1) |
| 2024 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
(27) |
Nov
|
Dec
(5) |
| 2025 |
Jan
|
Feb
(56) |
Mar
(28) |
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
|
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 |
|
From: Tim S. <tim...@gm...> - 2025-02-26 14:47:28
|
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/ |
|
From: <aul...@sc...> - 2025-02-26 14:07:00
|
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... <mailto:aul...@sc...> > wrote: database weberp is empty, admin/weberp Lähettäjä: aul...@sc... <mailto:aul...@sc...> <aul...@sc... <mailto:aul...@sc...> > Lähetetty: keskiviikko 26. helmikuuta 2025 10.16 Vastaanottaja: 'For the general discussion of webERP project' <web...@li... <mailto: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... <mailto:aul...@sc...> <aul...@sc... <mailto:aul...@sc...> > Lähetetty: keskiviikko 26. helmikuuta 2025 7.47 Vastaanottaja: 'For the general discussion of webERP project' <web...@li... <mailto: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 <gs...@gm... <mailto: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... <mailto: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, 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_campaign=sig-email&utm_content=emailclient> Virus-free. <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient> www.avast.com _______________________________________________ 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 |
|
From: gilberto d. s. a. <gs...@gm...> - 2025-02-26 12:22:11
|
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 > > > > > <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 > > > _______________________________________________ > web-ERP-users mailing list > web...@li... > https://lists.sourceforge.net/lists/listinfo/web-erp-users > |
|
From: <aul...@sc...> - 2025-02-26 08:41:06
|
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... <mailto:aul...@sc...> <aul...@sc... <mailto:aul...@sc...> > Lähetetty: keskiviikko 26. helmikuuta 2025 7.47 Vastaanottaja: 'For the general discussion of webERP project' <web...@li... <mailto: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 <gs...@gm... <mailto: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... <mailto: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, 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 _______________________________________________ web-ERP-users mailing list web...@li... <mailto:web...@li...> https://lists.sourceforge.net/lists/listinfo/web-erp-users |
|
From: <aul...@sc...> - 2025-02-26 08:16:36
|
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... <mailto:aul...@sc...> <aul...@sc... <mailto:aul...@sc...> > Lähetetty: keskiviikko 26. helmikuuta 2025 7.47 Vastaanottaja: 'For the general discussion of webERP project' <web...@li... <mailto: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 <gs...@gm... <mailto: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... <mailto: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, 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 _______________________________________________ web-ERP-users mailing list web...@li... <mailto:web...@li...> https://lists.sourceforge.net/lists/listinfo/web-erp-users |
|
From: <aul...@sc...> - 2025-02-26 07:58:56
|
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 < <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 <gs...@gm... <mailto: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... <mailto: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, 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 _______________________________________________ web-ERP-users mailing list web...@li... <mailto:web...@li...> https://lists.sourceforge.net/lists/listinfo/web-erp-users |
|
From: <aul...@sc...> - 2025-02-26 05:46:55
|
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... <mailto: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... <mailto: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... <mailto:an...@co...> > Lähetetty: tiistai 25. helmikuuta 2025 10.17 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; 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_campaign=sig-email&utm_content=emailclient> Virus-free. <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient> www.avast.com _______________________________________________ web-ERP-users mailing list web...@li... <mailto:web...@li...> https://lists.sourceforge.net/lists/listinfo/web-erp-users |
|
From: <aul...@sc...> - 2025-02-26 05:35:54
|
it was on, i set it now off 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... <mailto: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... <mailto: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... <mailto:an...@co...> > Lähetetty: tiistai 25. helmikuuta 2025 10.17 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; 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_campaign=sig-email&utm_content=emailclient> Virus-free. <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient> www.avast.com _______________________________________________ web-ERP-users mailing list web...@li... <mailto:web...@li...> https://lists.sourceforge.net/lists/listinfo/web-erp-users |
|
From: Andrew C. <an...@co...> - 2025-02-25 17:13:40
|
<div dir='auto'>You should be able to interrogate the MySQL server settings by running an SQL query like the following in your MySQL console:<div dir="auto"><br></div><div dir="auto">SHOW VARIABLES WHERE Variable_name= 'restrict_fk_on_non_standard_key';</div></div><div class="gmail_extra"><br><div class="gmail_quote">On 25 Feb 2025 16:41, gilberto dos santos alves <gs...@gm...> wrote:<br type="attribution" /><blockquote class="quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="auto">hi.<div dir="auto">please take a calm environment and step by step follow each step </div><div dir="auto">regards from sp 25-02-25</div></div><br /><div><div dir="ltr">On Tue, Feb 25, 2025, 07:15 <<a href="mailto:aulislap@sci.fi">aulislap@sci.fi</a>> wrote:<br /></div><blockquote style="margin:0 0 0 0.8ex;border-left:1px #ccc solid;padding-left:1ex"><div style="word-wrap:break-word"><div><p>hi again<u></u><u></u></p><p>now im trying install weberp again and i think i got same error situation as earlier ???<u></u><u></u></p><p>i have set by using wamp mysql console , should wamp services start after that ?<u></u><u></u></p><p>SET restrict_fk_on_non_standard_key = OFF;<u></u><u></u></p><p>where i can verified this parameter value ?<u></u><u></u></p><p><u></u> <u></u></p><p><u></u> <u></u></p><p><img width="961" height="659" style="width:10.0104in;height:6.8645in" src="cid:image001.png@01DB877E.09A6FF90" /><u></u><u></u></p><p><u></u> <u></u></p><div style="border:none;border-top:solid #e1e1e1 1pt;padding:3pt 0cm 0cm 0cm"><p><b><span style="font-size:11pt;font-family:'calibri' , sans-serif">Lähettäjä:</span></b><span style="font-size:11pt;font-family:'calibri' , sans-serif"> Andrew Couling <<a href="mailto:andrew@couling.org">andrew@couling.org</a>> <br /><b>Lähetetty:</b> tiistai 25. helmikuuta 2025 10.17<br /><b>Vastaanottaja:</b> For the general discussion of webERP project <<a href="mailto:web-erp-users@lists.sourceforge.net">web-erp-users@lists.sourceforge.net</a>><br /><b>Aihe:</b> Re: [webERP-users] mysql> SET restrict_fk_on_non_standard_key = OFF; <u></u><u></u></span></p></div><p><u></u> <u></u></p><div><p>You can leave the weberpdemo folder.<u></u><u></u></p><div><p>You should delete the folder which has the same name as your database. In your case it's the folder named 'weberp'.<u></u><u></u></p></div></div><div><p><u></u> <u></u></p><div><p>On 25 Feb 2025 05:49, <a href="mailto:aulislap@sci.fi">aulislap@sci.fi</a> wrote:<u></u><u></u></p><blockquote style="border:none;border-left:solid #cccccc 1pt;padding:0cm 0cm 0cm 6pt;margin-left:4.8pt;margin-top:5pt;margin-right:0cm;margin-bottom:5pt"><div><div><p style="margin-left:46.35pt"><u></u>1.<span style="font:7pt 'times new roman'"> </span><u></u><span style="color:black;background:yellow">Delete the company directory inside /companies</span><u></u><u></u></p><p style="margin-bottom:12pt">this companies dir contains weberp and weberdemo directories, make i delete for both<br />there is not company dir ?<u></u><u></u></p><p> <u></u><u></u></p><div><div style="border:none;border-top:solid #e1e1e1 1pt;padding:3pt 0cm 0cm 0cm"><p><b><span style="font-size:11pt;font-family:'calibri' , sans-serif">Lähettäjä:</span></b><span style="font-size:11pt;font-family:'calibri' , sans-serif"> </span><a href="mailto:andrew@couling.org"><span style="font-size:11pt;font-family:'calibri' , sans-serif">andrew@couling.org</span></a><span style="font-size:11pt;font-family:'calibri' , sans-serif"> <</span><a href="mailto:andrew@couling.org"><span style="font-size:11pt;font-family:'calibri' , sans-serif">andrew@couling.org</span></a><span style="font-size:11pt;font-family:'calibri' , sans-serif">> <br /><b>Lähetetty:</b> tiistai 25. helmikuuta 2025 0.46<br /><b>Vastaanottaja:</b> 'For the general discussion of webERP project' <</span><a href="mailto:web-erp-users@lists.sourceforge.net"><span style="font-size:11pt;font-family:'calibri' , sans-serif">web-erp-users@lists.sourceforge.net</span></a><span style="font-size:11pt;font-family:'calibri' , sans-serif">><br /><b>Aihe:</b> Re: [webERP-users] mysql> SET restrict_fk_on_non_standard_key = OFF; </span><u></u><u></u></p></div></div><p> <u></u><u></u></p><p>Procedure for re-installation:<u></u><u></u></p><p> <u></u><u></u></p><p style="margin-left:46.35pt"><u></u>1.<span style="font:7pt 'times new roman'"> </span><u></u>Drop all tables in database<u></u><u></u></p><p style="margin-left:46.35pt"><u></u>2.<span style="font:7pt 'times new roman'"> </span><u></u><span style="color:black;background:yellow">Delete the company directory inside /companies</span><u></u><u></u></p><p style="margin-left:46.35pt"><u></u>3.<span style="font:7pt 'times new roman'"> </span><u></u>Delete config.php<u></u><u></u></p><p style="margin-left:46.35pt"><u></u>4.<span style="font:7pt 'times new roman'"> </span><u></u>Navigate to the site in your browser and the installer should run.<u></u><u></u></p><p> <u></u><u></u></p><div><div style="border:none;border-top:solid #e1e1e1 1pt;padding:3pt 0cm 0cm 0cm"><p><b><span style="font-size:11pt;font-family:'calibri' , sans-serif">From:</span></b><span style="font-size:11pt;font-family:'calibri' , sans-serif"> </span><a href="mailto:aulislap@sci.fi"><span style="font-size:11pt;font-family:'calibri' , sans-serif">aulislap@sci.fi</span></a><span style="font-size:11pt;font-family:'calibri' , sans-serif"> <</span><a href="mailto:aulislap@sci.fi"><span style="font-size:11pt;font-family:'calibri' , sans-serif">aulislap@sci.fi</span></a><span style="font-size:11pt;font-family:'calibri' , sans-serif">> <br /><b>Sent:</b> 24 February 2025 13:43<br /><b>To:</b> 'For the general discussion of webERP project' <</span><a href="mailto:web-erp-users@lists.sourceforge.net"><span style="font-size:11pt;font-family:'calibri' , sans-serif">web-erp-users@lists.sourceforge.net</span></a><span style="font-size:11pt;font-family:'calibri' , sans-serif">><br /><b>Subject:</b> Re: [webERP-users] mysql> SET restrict_fk_on_non_standard_key = OFF; </span><u></u><u></u></p></div></div><p> <u></u><u></u></p><p>yes thanx<u></u><u></u></p><p>i have runned command in my wamp mysql console<u></u><u></u></p><p>SET restrict_fk_on_non_standard_key = OFF;<u></u><u></u></p><p><br />but how i resinstall weberp after that, weberp database is not ok after prev error<u></u><u></u></p><p>so must i delete current weberp db and after that run reinstall weberp again<u></u><u></u></p><p>?<u></u><u></u></p><p> <u></u><u></u></p><div style="border:none;border-top:solid #e1e1e1 1pt;padding:3pt 0cm 0cm 0cm"><p><b><span style="font-size:11pt;font-family:'calibri' , sans-serif">Lähettäjä:</span></b><span style="font-size:11pt;font-family:'calibri' , sans-serif"> gilberto dos santos alves <</span><a href="mailto:gsavix@gmail.com"><span style="font-size:11pt;font-family:'calibri' , sans-serif">gsavix@gmail.com</span></a><span style="font-size:11pt;font-family:'calibri' , sans-serif">> <br /><b>Lähetetty:</b> maanantai 24. helmikuuta 2025 15.26<br /><b>Vastaanottaja:</b> For the general discussion of webERP project <</span><a href="mailto:web-erp-users@lists.sourceforge.net"><span style="font-size:11pt;font-family:'calibri' , sans-serif">web-erp-users@lists.sourceforge.net</span></a><span style="font-size:11pt;font-family:'calibri' , sans-serif">><br /><b>Aihe:</b> Re: [webERP-users] mysql> SET restrict_fk_on_non_standard_key = OFF; </span><u></u><u></u></p></div><p> <u></u><u></u></p><div><p>after install mysql and before install weberp you must run this command for disable duplicated foreign key validation.<u></u><u></u></p><div><p>then install weberp<u></u><u></u></p></div></div><p> <u></u><u></u></p><div><div><p>On Mon, Feb 24, 2025, 02:45 <<a href="mailto:aulislap@sci.fi">aulislap@sci.fi</a>> wrote:<u></u><u></u></p></div><blockquote style="border:none;border-left:solid #cccccc 1pt;padding:0cm 0cm 0cm 6pt;margin-left:4.8pt;margin-top:5pt;margin-right:0cm;margin-bottom:5pt"><p>ok<br />how i can reinstall weberp ?<br />delete current weberp database which is ok <br />and reinstall web?<br /><br />-----Alkuperäinen viesti-----<br />Lähettäjä: Tim Schofield <<a href="mailto:tim.schofield1960@gmail.com">tim.schofield1960@gmail.com</a>> <br />Lähetetty: sunnuntai 23. helmikuuta 2025 17.47<br />Vastaanottaja: For the general discussion of webERP project<br /><<a href="mailto:web-erp-users@lists.sourceforge.net">web-erp-users@lists.sourceforge.net</a>><br />Aihe: Re: [webERP-users] mysql> SET restrict_fk_on_non_standard_key = OFF; <br /><br />This has been discussed here:<br /><a href="https://github.com/timschofield/webERP/issues/351">https://github.com/timschofield/webERP/issues/351</a> and it seems mysql have<br />agreed it is a bug in 8.4 and it will be fixed, but thanks for the tip about<br />setting<br /><br />SET restrict_fk_on_non_standard_key = OFF;<br /><br />Thanks<br />Tim<br /><br />On Sun, 23 Feb 2025 at 15:27, adm ti auvix <<a href="mailto:usradm@auvix.com.br">usradm@auvix.com.br</a>> wrote:<br />><br />> hi!<br />><br />> This url [<a href="https://bugs.mysql.com/bug.php?id=114838">https://bugs.mysql.com/bug.php?id=114838</a>] show how to <br />> disable<br />><br />> There is a seemingly undocumented variable introduced in MySQL 8.4<br />"RESTRICT_FK_ON_NON_STANDARD_KEY" which is enabled by default.<br />><br />> "Disallow the creation of foreign keys referencing non-unique key"<br />><br />> [7 May 2024 20:04] Evan Elias<br />><br />> Wow, excellent find. Strangely, not only is that new variable<br />undocumented, but it is also deprecated. If you disable it, a warning is<br />issued:<br />><br />> mysql> SET restrict_fk_on_non_standard_key = OFF;<br />> Query OK, 0 rows affected, 1 warning (0.01 sec)<br />><br />> mysql> SHOW WARNINGS\G<br />> *************************** 1. row ***************************<br />> Level: Warning<br />> Code: 4166<br />> Message: 'restrict_fk_on_non_standard_key' is deprecated and will be<br />removed in a future release. Foreign key referring to non-unique or partial<br />keys is unsafe and may break replication.<br />> 1 row in set (0.00 sec)<br />><br />><br />><br />> please in your mysql environment run SET <br />> restrict_fk_on_non_standard_key = OFF;<br />><br />> regards.<br />><br />> _______________________________________________<br />> web-ERP-users mailing list<br />> <a href="mailto:web-ERP-users@lists.sourceforge.net">web-ERP-users@lists.sourceforge.net</a><br />> <a href="https://lists.sourceforge.net/lists/listinfo/web-erp-users">https://lists.sourceforge.net/lists/listinfo/web-erp-users</a><br /><br /><br /><br />--<br /><a href="http://www.weberp.org">www.weberp.org</a><br />@TimSchofield2<br />Blog: <a href="https://kwamoja.home.blog/">https://kwamoja.home.blog/</a><br /><br /><br />_______________________________________________<br />web-ERP-users mailing list<br /><a href="mailto:web-ERP-users@lists.sourceforge.net">web-ERP-users@lists.sourceforge.net</a><br /><a href="https://lists.sourceforge.net/lists/listinfo/web-erp-users">https://lists.sourceforge.net/lists/listinfo/web-erp-users</a><br /><br /><br /><br />_______________________________________________<br />web-ERP-users mailing list<br /><a href="mailto:web-ERP-users@lists.sourceforge.net">web-ERP-users@lists.sourceforge.net</a><br /><a href="https://lists.sourceforge.net/lists/listinfo/web-erp-users">https://lists.sourceforge.net/lists/listinfo/web-erp-users</a><u></u><u></u></p></blockquote></div><div><p> <u></u><u></u></p><table border="1" cellpadding="0" style="border:none;border-top:solid #d3d4de 1pt"><tbody><tr><td width="55" style="width:41.25pt;border:none;padding:9.75pt 0.75pt 0.75pt 0.75pt"><p><a href="https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient"><span style="text-decoration:none"><img border="0" width="46" height="29" style="width:0.4791in;height:0.302in" src="https://s-install.avcdn.net/ipm/preview/icons/icon-envelope-tick-round-orange-animated-no-repeat-v1.gif" /></span></a><u></u><u></u></p></td><td width="470" style="width:352.5pt;border:none;padding:9pt 0.75pt 0.75pt 0.75pt"><p style="line-height:13.5pt"><span style="font-size:10pt;font-family:'arial' , sans-serif;color:#41424e">Virus-free.</span><a href="https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient"><span style="font-size:10pt;font-family:'arial' , sans-serif;color:#4453ea">www.avast.com</span></a><u></u><u></u></p></td></tr></tbody></table><p> <u></u><u></u></p></div></div></div></blockquote></div><p><u></u> <u></u></p></div></div></div>_______________________________________________<br /> web-ERP-users mailing list<br /> <a href="mailto:web-ERP-users@lists.sourceforge.net">web-ERP-users@lists.sourceforge.net</a><br /> <a href="https://lists.sourceforge.net/lists/listinfo/web-erp-users">https://lists.sourceforge.net/lists/listinfo/web-erp-users</a><br /> </blockquote></div> </blockquote></div><br></div> |
|
From: gilberto d. s. a. <gs...@gm...> - 2025-02-25 16:41:36
|
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 > |
|
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 |
|
From: <aul...@sc...> - 2025-02-25 10:02:37
|
ok, thanx 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ä: an...@co... <mailto:an...@co...> <an...@co... <mailto:an...@co...> > Lähetetty: tiistai 25. helmikuuta 2025 0.46 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; 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... <mailto:aul...@sc...> <aul...@sc... <mailto:aul...@sc...> > Sent: 24 February 2025 13:43 To: 'For the general discussion of webERP project' <web...@li... <mailto: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 <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient> Virus-free. <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient> www.avast.com |
|
From: Andrew C. <an...@co...> - 2025-02-25 08:16:45
|
<div dir='auto'>You can leave the weberpdemo folder.<div dir="auto">You should delete the folder which has the same name as your database. In your case it's the folder named 'weberp'.</div></div><div class="gmail_extra"><br><div class="gmail_quote">On 25 Feb 2025 05:49, aul...@sc... wrote:<br type="attribution" /><blockquote class="quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div style="word-wrap:break-word"><div><ol style="margin-top:0cm" start="1" type="1"><li style="margin-left:10.35pt"> <span style="background:yellow">Delete the company directory inside /companies</span></li></ol><p>this companies dir contains weberp and weberdemo directories, make i delete for both<br />there is not company dir ?<br /><br /></p><p> </p><div><div style="border:none;border-top:solid #e1e1e1 1pt;padding:3pt 0cm 0cm 0cm"><p><b><span style="font-size:11pt;font-family:'calibri' , sans-serif">Lähettäjä:</span></b><span style="font-size:11pt;font-family:'calibri' , sans-serif"> andrew@couling.org <andrew@couling.org> <br /><b>Lähetetty:</b> tiistai 25. helmikuuta 2025 0.46<br /><b>Vastaanottaja:</b> 'For the general discussion of webERP project' <web-erp-users@lists.sourceforge.net><br /><b>Aihe:</b> Re: [webERP-users] mysql> SET restrict_fk_on_non_standard_key = OFF; </span></p></div></div><p> </p><p>Procedure for re-installation:</p><p> </p><ol style="margin-top:0cm" start="1" type="1"><li style="margin-left:10.35pt">Drop all tables in database</li><li style="margin-left:10.35pt"><span style="background:yellow">Delete the company directory inside /companies</span></li><li style="margin-left:10.35pt">Delete config.php</li><li style="margin-left:10.35pt">Navigate to the site in your browser and the installer should run.</li></ol><p> </p><div><div style="border:none;border-top:solid #e1e1e1 1pt;padding:3pt 0cm 0cm 0cm"><p><b><span style="font-size:11pt;font-family:'calibri' , sans-serif">From:</span></b><span style="font-size:11pt;font-family:'calibri' , sans-serif"> <a href="mailto:aulislap@sci.fi">aulislap@sci.fi</a> <<a href="mailto:aulislap@sci.fi">aulislap@sci.fi</a>> <br /><b>Sent:</b> 24 February 2025 13:43<br /><b>To:</b> 'For the general discussion of webERP project' <<a href="mailto:web-erp-users@lists.sourceforge.net">web-erp-users@lists.sourceforge.net</a>><br /><b>Subject:</b> Re: [webERP-users] mysql> SET restrict_fk_on_non_standard_key = OFF; </span></p></div></div><p> </p><p>yes thanx</p><p>i have runned command in my wamp mysql console</p><p>SET restrict_fk_on_non_standard_key = OFF;</p><p><br />but how i resinstall weberp after that, weberp database is not ok after prev error</p><p>so must i delete current weberp db and after that run reinstall weberp again</p><p>?</p><p> </p><div style="border:none;border-top:solid #e1e1e1 1pt;padding:3pt 0cm 0cm 0cm"><p><b><span style="font-size:11pt;font-family:'calibri' , sans-serif">Lähettäjä:</span></b><span style="font-size:11pt;font-family:'calibri' , sans-serif"> gilberto dos santos alves <<a href="mailto:gsavix@gmail.com">gsavix@gmail.com</a>> <br /><b>Lähetetty:</b> maanantai 24. helmikuuta 2025 15.26<br /><b>Vastaanottaja:</b> For the general discussion of webERP project <<a href="mailto:web-erp-users@lists.sourceforge.net">web-erp-users@lists.sourceforge.net</a>><br /><b>Aihe:</b> Re: [webERP-users] mysql> SET restrict_fk_on_non_standard_key = OFF; </span></p></div><p> </p><div><p>after install mysql and before install weberp you must run this command for disable duplicated foreign key validation.</p><div><p>then install weberp</p></div></div><p> </p><div><div><p>On Mon, Feb 24, 2025, 02:45 <<a href="mailto:aulislap@sci.fi">aulislap@sci.fi</a>> wrote:</p></div><blockquote style="border:none;border-left:solid #cccccc 1pt;padding:0cm 0cm 0cm 6pt;margin-left:4.8pt;margin-top:5pt;margin-right:0cm;margin-bottom:5pt"><p>ok<br />how i can reinstall weberp ?<br />delete current weberp database which is ok <br />and reinstall web?<br /><br />-----Alkuperäinen viesti-----<br />Lähettäjä: Tim Schofield <<a href="mailto:tim.schofield1960@gmail.com">tim.schofield1960@gmail.com</a>> <br />Lähetetty: sunnuntai 23. helmikuuta 2025 17.47<br />Vastaanottaja: For the general discussion of webERP project<br /><<a href="mailto:web-erp-users@lists.sourceforge.net">web-erp-users@lists.sourceforge.net</a>><br />Aihe: Re: [webERP-users] mysql> SET restrict_fk_on_non_standard_key = OFF; <br /><br />This has been discussed here:<br /><a href="https://github.com/timschofield/webERP/issues/351">https://github.com/timschofield/webERP/issues/351</a> and it seems mysql have<br />agreed it is a bug in 8.4 and it will be fixed, but thanks for the tip about<br />setting<br /><br />SET restrict_fk_on_non_standard_key = OFF;<br /><br />Thanks<br />Tim<br /><br />On Sun, 23 Feb 2025 at 15:27, adm ti auvix <<a href="mailto:usradm@auvix.com.br">usradm@auvix.com.br</a>> wrote:<br />><br />> hi!<br />><br />> This url [<a href="https://bugs.mysql.com/bug.php?id=114838">https://bugs.mysql.com/bug.php?id=114838</a>] show how to <br />> disable<br />><br />> There is a seemingly undocumented variable introduced in MySQL 8.4<br />"RESTRICT_FK_ON_NON_STANDARD_KEY" which is enabled by default.<br />><br />> "Disallow the creation of foreign keys referencing non-unique key"<br />><br />> [7 May 2024 20:04] Evan Elias<br />><br />> Wow, excellent find. Strangely, not only is that new variable<br />undocumented, but it is also deprecated. If you disable it, a warning is<br />issued:<br />><br />> mysql> SET restrict_fk_on_non_standard_key = OFF;<br />> Query OK, 0 rows affected, 1 warning (0.01 sec)<br />><br />> mysql> SHOW WARNINGS\G<br />> *************************** 1. row ***************************<br />> Level: Warning<br />> Code: 4166<br />> Message: 'restrict_fk_on_non_standard_key' is deprecated and will be<br />removed in a future release. Foreign key referring to non-unique or partial<br />keys is unsafe and may break replication.<br />> 1 row in set (0.00 sec)<br />><br />><br />><br />> please in your mysql environment run SET <br />> restrict_fk_on_non_standard_key = OFF;<br />><br />> regards.<br />><br />> _______________________________________________<br />> web-ERP-users mailing list<br />> <a href="mailto:web-ERP-users@lists.sourceforge.net">web-ERP-users@lists.sourceforge.net</a><br />> <a href="https://lists.sourceforge.net/lists/listinfo/web-erp-users">https://lists.sourceforge.net/lists/listinfo/web-erp-users</a><br /><br /><br /><br />--<br /><a href="http://www.weberp.org">www.weberp.org</a><br />@TimSchofield2<br />Blog: <a href="https://kwamoja.home.blog/">https://kwamoja.home.blog/</a><br /><br /><br />_______________________________________________<br />web-ERP-users mailing list<br /><a href="mailto:web-ERP-users@lists.sourceforge.net">web-ERP-users@lists.sourceforge.net</a><br /><a href="https://lists.sourceforge.net/lists/listinfo/web-erp-users">https://lists.sourceforge.net/lists/listinfo/web-erp-users</a><br /><br /><br /><br />_______________________________________________<br />web-ERP-users mailing list<br /><a href="mailto:web-ERP-users@lists.sourceforge.net">web-ERP-users@lists.sourceforge.net</a><br /><a href="https://lists.sourceforge.net/lists/listinfo/web-erp-users">https://lists.sourceforge.net/lists/listinfo/web-erp-users</a></p></blockquote></div><div><p> </p><table border="1" cellpadding="0" style="border:none;border-top:solid #d3d4de 1pt"><tbody><tr><td width="55" style="width:41.25pt;border:none;padding:9.75pt 0.75pt 0.75pt 0.75pt"><p><a href="https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient"><span style="text-decoration:none"><img border="0" width="46" height="29" style="width:0.4791in;height:0.302in" src="https://s-install.avcdn.net/ipm/preview/icons/icon-envelope-tick-round-orange-animated-no-repeat-v1.gif" /></span></a></p></td><td width="470" style="width:352.5pt;border:none;padding:9pt 0.75pt 0.75pt 0.75pt"><p style="line-height:13.5pt"><span style="font-size:10pt;font-family:'arial' , sans-serif;color:#41424e">Virus-free.<a href="https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient"><span style="color:#4453ea">www.avast.com</span></a></span></p></td></tr></tbody></table><p> </p></div></div></div></blockquote></div><br></div> |
|
From: <aul...@sc...> - 2025-02-25 05:49:25
|
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... <mailto:aul...@sc...> <aul...@sc... <mailto:aul...@sc...> > Sent: 24 February 2025 13:43 To: 'For the general discussion of webERP project' <web...@li... <mailto: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 <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient> Virus-free. <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient> www.avast.com |
|
From: gilberto d. s. a. <gs...@gm...> - 2025-02-25 02:03:17
|
yes. On Mon, Feb 24, 2025, 10:43 <aul...@sc...> wrote: > 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 > > _______________________________________________ > web-ERP-users mailing list > web...@li... > https://lists.sourceforge.net/lists/listinfo/web-erp-users > |
|
From: <an...@co...> - 2025-02-24 22:46:27
|
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 |
|
From: <aul...@sc...> - 2025-02-24 13:43:09
|
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... <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 |
|
From: gilberto d. s. a. <gs...@gm...> - 2025-02-24 13:26:21
|
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 > |
|
From: <aul...@sc...> - 2025-02-24 05:45:14
|
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 |
|
From: Tim S. <tim...@gm...> - 2025-02-23 15:47:38
|
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/ |
|
From: adm ti a. <us...@au...> - 2025-02-23 14:42:11
|
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
</head>
<body>
<font face="Ubuntu Mono">hi!<br>
<br>
This url [<a class="moz-txt-link-freetext" href="https://bugs.mysql.com/bug.php?id=114838">https://bugs.mysql.com/bug.php?id=114838</a>] show how to
disable <br>
</font>
<pre class="note">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"
</pre>
<div id="c543064" class="comment">
<div class="header"> [7 May 2024 20:04] Evan Elias </div>
<pre class="note">Wow, excellent find. Strangely, not only is that new variable undocumented, but it is also deprecated. If you disable it, a warning is issued:
<font size="5">mysql> SET restrict_fk_on_non_standard_key = OFF;</font>
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.
</pre>
</div>
</body>
</html>
|
|
From: <aul...@sc...> - 2025-02-23 13:54:30
|
mysql> status -------------- C:\Program Files\MySQL\MySQL Server 8.0\bin\mysql.exe Ver 8.0.40 for Win64 on x86_64 (MySQL Community Server - GPL) i have tested cobol and mysql c api interface by using above version, so this is allready installed wamp use different version Lähettäjä: aul...@sc... <aul...@sc...> Lähetetty: sunnuntai 23. helmikuuta 2025 15.47 Vastaanottaja: 'For the general discussion of webERP project' <web...@li...> Aihe: Re: [webERP-users] weberp install error hi yes im testing now mysql + php and so i can downgrade it from 9.1.0 to 8.3, but how ? im using wamp 3.3.7 in win11 php 8.3.14 , apache 2.4.62.1 … when i installed winamp all other software came sametime ….. ps i have used progress oe database + 4gl over 20 years … Lähettäjä:s Andrew Couling <an...@co... <mailto:an...@co...> > Lähetetty: sunnuntai 23. helmikuuta 2025 14.46 Vastaanottaja: For the general discussion of webERP project <web...@li... <mailto:web...@li...> > Aihe: Re: [webERP-users] weberp install error Hi Aulis, I had the same issue when trying to install with MySQL 9.1.0. There is a bug in MySQL which affects versions 8.4.0 onwards: https://bugs.mysql.com/bug.php?id=114838 While we await a bug fix, are you able to downgrade to MySQL 8.3? Andy. On 23 Feb 2025 12:29, aul...@sc... <mailto:aul...@sc...> wrote: last table in weberp database is purchorders Lähettäjä: aul...@sc... <mailto:aul...@sc...> <aul...@sc... <mailto:aul...@sc...> > Lähetetty: sunnuntai 23. helmikuuta 2025 12.46 Vastaanottaja: 'For the general discussion of webERP project' <web...@li... <mailto:web...@li...> > Aihe: VS: [webERP-users] weberp install error sorry mysql9.1.0 Lähettäjä: aul...@sc... <mailto:aul...@sc...> <aul...@sc... <mailto:aul...@sc...> > Lähetetty: sunnuntai 23. helmikuuta 2025 12.36 Vastaanottaja: 'For the general discussion of webERP project' <web...@li... <mailto:web...@li...> > Aihe: Re: [webERP-users] weberp install error hi im using mysql 8.0 and wamp 3.0 win11 Lähettäjä: Andrew Couling <an...@co... <mailto:an...@co...> > Lähetetty: sunnuntai 23. helmikuuta 2025 11.46 Vastaanottaja: For the general discussion of webERP project <web...@li... <mailto:web...@li...> > Aihe: Re: [webERP-users] weberp install error Hi Aulis, It looks like this might be related to the MySQL bug which was reported here: https://github.com/timschofield/webERP/issues/351 Which database and version are you using? Andy. On 23 Feb 2025 07:58, aul...@sc... <mailto:aul...@sc...> wrote: hi and thanx i tried this new version and got error messages ? ? Aulis Lappalainen aul...@dl... <mailto:aul...@dl...> (aul...@sc... <mailto:aul...@sc...> ) 050 5319427 |
|
From: <aul...@sc...> - 2025-02-23 13:47:29
|
hi yes im testing now mysql + php and so i can downgrade it from 9.1.0 to 8.3, but how ? im using wamp 3.3.7 in win11 php 8.3.14 , apache 2.4.62.1 … when i installed winamp all other software came sametime ….. ps i have used progress oe database + 4gl over 20 years … Lähettäjä:s Andrew Couling <an...@co...> Lähetetty: sunnuntai 23. helmikuuta 2025 14.46 Vastaanottaja: For the general discussion of webERP project <web...@li...> Aihe: Re: [webERP-users] weberp install error Hi Aulis, I had the same issue when trying to install with MySQL 9.1.0. There is a bug in MySQL which affects versions 8.4.0 onwards: https://bugs.mysql.com/bug.php?id=114838 While we await a bug fix, are you able to downgrade to MySQL 8.3? Andy. On 23 Feb 2025 12:29, aul...@sc... <mailto:aul...@sc...> wrote: last table in weberp database is purchorders Lähettäjä: aul...@sc... <mailto:aul...@sc...> <aul...@sc... <mailto:aul...@sc...> > Lähetetty: sunnuntai 23. helmikuuta 2025 12.46 Vastaanottaja: 'For the general discussion of webERP project' <web...@li... <mailto:web...@li...> > Aihe: VS: [webERP-users] weberp install error sorry mysql9.1.0 Lähettäjä: aul...@sc... <mailto:aul...@sc...> <aul...@sc... <mailto:aul...@sc...> > Lähetetty: sunnuntai 23. helmikuuta 2025 12.36 Vastaanottaja: 'For the general discussion of webERP project' <web...@li... <mailto:web...@li...> > Aihe: Re: [webERP-users] weberp install error hi im using mysql 8.0 and wamp 3.0 win11 Lähettäjä: Andrew Couling <an...@co... <mailto:an...@co...> > Lähetetty: sunnuntai 23. helmikuuta 2025 11.46 Vastaanottaja: For the general discussion of webERP project <web...@li... <mailto:web...@li...> > Aihe: Re: [webERP-users] weberp install error Hi Aulis, It looks like this might be related to the MySQL bug which was reported here: https://github.com/timschofield/webERP/issues/351 Which database and version are you using? Andy. On 23 Feb 2025 07:58, aul...@sc... <mailto:aul...@sc...> wrote: hi and thanx i tried this new version and got error messages ? ? Aulis Lappalainen aul...@dl... <mailto:aul...@dl...> (aul...@sc... <mailto:aul...@sc...> ) 050 5319427 |
|
From: gilberto d. s. a. <gs...@gm...> - 2025-02-23 12:46:43
|
hi. pls. let me reproduce this environment and soon i will help. On Sun, Feb 23, 2025, 09:30 <aul...@sc...> wrote: > last table in weberp database is purchorders > > > > *Lähettäjä:* aul...@sc... <aul...@sc...> > *Lähetetty:* sunnuntai 23. helmikuuta 2025 12.46 > *Vastaanottaja:* 'For the general discussion of webERP project' < > web...@li...> > *Aihe:* VS: [webERP-users] weberp install error > > > > sorry mysql9.1.0 > > > > *Lähettäjä:* aul...@sc... <aul...@sc...> > *Lähetetty:* sunnuntai 23. helmikuuta 2025 12.36 > *Vastaanottaja:* 'For the general discussion of webERP project' < > web...@li...> > *Aihe:* Re: [webERP-users] weberp install error > > > > hi > > im using mysql 8.0 and wamp 3.0 win11 > > > > > > > > *Lähettäjä:* Andrew Couling <an...@co...> > *Lähetetty:* sunnuntai 23. helmikuuta 2025 11.46 > *Vastaanottaja:* For the general discussion of webERP project < > web...@li...> > *Aihe:* Re: [webERP-users] weberp install error > > > > Hi Aulis, > > > > It looks like this might be related to the MySQL bug which was reported > here: > > https://github.com/timschofield/webERP/issues/351 > > > > Which database and version are you using? > > > > > > Andy. > > > > > > On 23 Feb 2025 07:58, aul...@sc... wrote: > > hi and thanx > > i tried this new version and got error messages ? > > > > > > ? > > > > > > > > Aulis Lappalainen > > aul...@dl... > > (aul...@sc...) > > 050 5319427 > > > > > _______________________________________________ > web-ERP-users mailing list > web...@li... > https://lists.sourceforge.net/lists/listinfo/web-erp-users > |
221 messages has been excluded from this view by a project administrator.
![https://s-install.avcdn.net/ipm/preview/icons/icon-envelope-tick-round-orange-animated-no-repeat-v1.gif"](https://s-install.avcdn.net/ipm/preview/icons/icon-envelope-tick-round-orange-animated-no-repeat-v1.gif"){kind=link}