Re: [webERP-users] mysql> SET = OFF;

[Tim S. <tim...@gm...>]

If you are still getting these warnings, then the version of
page_6.php you are using predates the fixes I did to remove these
warnings. However they are very minor and won't affect your use of the
system.

Thanks
Tim

On Thu, 27 Feb 2025 at 08:47, <aul...@sc...> wrote:
>
> do you make changes to ... page_6.php ? or contains it allready your changes ?
>
> -----Alkuperäinen viesti-----
> Lähettäjä: Tim Schofield <tim...@gm...>
> Lähetetty: torstai 27. helmikuuta 2025 10.33
> Vastaanottaja: For the general discussion of webERP project <web...@li...>
> Aihe: Re: [webERP-users] mysql> SET = OFF;
>
> Those warnings were fixed later, though they won't affect the running of the system. The only file that needs changing is install/pages/page_6.php
>
> Tim
>
> On Thu, 27 Feb 2025 at 08:29, <aul...@sc...> wrote:
> >
> > i downloaded version yesterday 17:18, must i make it again
> >
> > -----Alkuperäinen viesti-----
> > Lähettäjä: Tim Schofield <tim...@gm...>
> > Lähetetty: torstai 27. helmikuuta 2025 10.16
> > Vastaanottaja: For the general discussion of webERP project
> > <web...@li...>
> > Aihe: Re: [webERP-users] mysql> SET = OFF;
> >
> > I thought I had fixed those warnings last night?
> >
> > Possibly after you had downloaded?
> >
> > Tim
> >
> > On Thu, 27 Feb 2025 at 08:00, <aul...@sc...> wrote:
> > >
> > > hi
> > >
> > > install gives warning but it is probably ok ?
> > >
> > >
> > >
> > >
> > >
> > > if i press weperp restart ->
> > >
> > >
> > >
> > >
> > >
> > > ?
> > >
> > >
> > >
> > >
> > >
> > > -----Alkuperäinen viesti-----
> > > Lähettäjä: Tim Schofield <tim...@gm...>
> > > Lähetetty: keskiviikko 26. helmikuuta 2025 17.12
> > > Vastaanottaja: For the general discussion of webERP project
> > > <web...@li...>
> > > Aihe: Re: [webERP-users] mysql> SET = OFF;
> > >
> > >
> > >
> > > 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/
> >
> >
> > _______________________________________________
> > 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/