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

SourceForge Headquarters 1320 Columbia Street Suite 310 San Diego, CA 92101 +1 (858) 422-6466

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.

[image: image.png]
step 6 all items ok.
[image: image.png]
main menu home theme default
[image: image.png]
professional theme from weberp

[image: image.png]
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
>

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

Accounting & Best Practice Business Administration System

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