Menu
▾
▴
Re: [webERP-users] mysql> SET = OFF;
|
From: Tim S. <tim...@gm...> - 2025-02-26 21:35:12
|
Thanks Gilberto. Tim On Wed, 26 Feb 2025 at 21:32, gilberto dos santos alves <gs...@gm...> wrote: > > Hi. > I made download this version on my windows 11 home edition. > apache 2.4.63 win64 VS17 > php 8.4.2 for windows version > mysql from 11.7.2-MariaDB, client 15.2 for Win64 (AMD64), source revision 80067a69feaeb5df30abb1bfaf7d4e713ccbf027 > > and for connections manager on windows i use > > https://www.heidisql.com/help.php?place=connform#connecting > or > https://dbeaver.io/ > or > phpmyadmin > > here i paste some images and phpinfo for demonstrations that it is all ok with weberp 5.0.0. rc 14 > > install ok. > > > step 6 all items ok. > > main menu home theme default > > professional theme from weberp > > > and here details of data base and users mysql created before instalation > > This is very important for make things smooth and not use root user with security exposure but one specific user for weberp. > see grants necessary for work connect and install ok. > > and finally phpinfo > > I do not tests language translation for pt_BR portuguese brasil > > thanks for your work on weberp 5. > > > > > -- > gilberto dos santos alves > +5511986465049 > > > > > > > > Em qua., 26 de fev. de 2025 às 12:12, Tim Schofield <tim...@gm...> escreveu: >> >> https://github.com/timschofield/webERP >> >> On Wed, 26 Feb 2025 at 15:11, <aul...@sc...> wrote: >> > >> > 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 >> > >> > >> > >> > _______________________________________________ >> > 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 -- www.weberp.org @TimSchofield2 Blog: https://kwamoja.home.blog/ |
