Menu
▾
▴
Re: [webERP-users] mysql> SET = OFF;
|
From: <aul...@sc...> - 2025-02-28 14:04:11
|
https://www.stylusstudio.com/edifact/D97A/IFTMAN.htm i have worked with edi messages in my last job …. (progress oe db and 4gl) and after that im now retired … ;-( but im intrested still make same utilities fex by using php weberp contains now code to send edi invoic, i dont know where this sending function is but anyway ? Lähettäjä: aul...@sc... <aul...@sc...> Lähetetty: perjantai 28. helmikuuta 2025 14.34 Vastaanottaja: 'For the general discussion of webERP project' <web...@li...> Aihe: VS: [webERP-users] mysql> SET = OFF; ok im looking that weberp contains edi messages for orders and invoic, i dont find place what handle them how i can add fex iftman message from order or delivery ifcsum message ? Lähettäjä: aul...@sc... <mailto:aul...@sc...> <aul...@sc... <mailto:aul...@sc...> > Lähetetty: perjantai 28. helmikuuta 2025 8.05 Vastaanottaja: 'For the general discussion of webERP project' <web...@li... <mailto:web...@li...> > Aihe: VS: [webERP-users] mysql> SET = OFF; i updated chrome and after that weberp works by using chrome too Lähettäjä: gilberto dos santos alves <gs...@gm... <mailto:gs...@gm...> > Lähetetty: torstai 27. helmikuuta 2025 15.45 Vastaanottaja: For the general discussion of webERP project <web...@li... <mailto:web...@li...> > Aihe: Re: [webERP-users] mysql> SET = OFF; uau!!! On Thu, Feb 27, 2025, 09:40 <aul...@sc... <mailto:aul...@sc...> > wrote: if im use firefox and wmapserver funcs ok and i can start weberp -----Alkuperäinen viesti----- Lähettäjä: Tim Schofield <tim...@gm... <mailto:tim...@gm...> > Lähetetty: torstai 27. helmikuuta 2025 14.09 Vastaanottaja: For the general discussion of webERP project <web...@li... <mailto:web...@li...> > Aihe: Re: [webERP-users] mysql> SET = OFF; I'm afraid I haven't used Windows in a very very long time (Win98 was the last) so I am not the right person to answer this. Maybe someone else here knows? Tim On Thu, 27 Feb 2025 at 11:30, < <mailto:aul...@sc...> aul...@sc...> wrote: > > ok > > there was windows update on my pc today and after that wampserver not > start ok, there is timeout or something else, localhost not respond ok > > could you give advice for this problem? > > > > > > [27-Feb-2025 11:08:55 UTC] PHP Stack trace: > > [27-Feb-2025 11:08:55 UTC] PHP 1. {main}() C:\wamp64\www\index.php:0 > > [27-Feb-2025 11:08:55 UTC] PHP 2. require() C:\wamp64\www\index.php:13 > > [27-Feb-2025 11:20:03 UTC] PHP Fatal error: Maximum execution time of > 120 seconds exceeded in C:\wamp64\scripts\config.inc.php on line 78 > > > > > > -----Alkuperäinen viesti----- > Lähettäjä: Tim Schofield < <mailto:tim...@gm...> tim...@gm...> > Lähetetty: torstai 27. helmikuuta 2025 12.28 > Vastaanottaja: For the general discussion of webERP project > < <mailto:web...@li...> web...@li...> > Aihe: Re: [webERP-users] mysql> SET = OFF; > > > > 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, < <mailto:aul...@sc...> 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 < <mailto:tim...@gm...> tim...@gm...> > > > Lähetetty: torstai 27. helmikuuta 2025 10.33 > > > Vastaanottaja: For the general discussion of webERP project > > > < <mailto:web...@li...> 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, < <mailto:aul...@sc...> aul...@sc...> wrote: > > > > > > > > i downloaded version yesterday 17:18, must i make it again > > > > > > > > -----Alkuperäinen viesti----- > > > > Lähettäjä: Tim Schofield < <mailto:tim...@gm...> tim...@gm...> > > > > Lähetetty: torstai 27. helmikuuta 2025 10.16 > > > > Vastaanottaja: For the general discussion of webERP project > > > > < <mailto:web...@li...> 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, < <mailto:aul...@sc...> 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 < <mailto:tim...@gm...> tim...@gm...> > > > > > Lähetetty: keskiviikko 26. helmikuuta 2025 17.12 > > > > > Vastaanottaja: For the general discussion of webERP project > > > > > < <mailto:web...@li...> web...@li...> > > > > > Aihe: Re: [webERP-users] mysql> SET = OFF; > > > > > > > > > > > > > > > > > > > > <https://github.com/timschofield/webERP> https://github.com/timschofield/webERP > > > > > > > > > > > > > > > > > > > > On Wed, 26 Feb 2025 at 15:11, < <mailto:aul...@sc...> aul...@sc...> wrote: > > > > > > > > > > > > > > > > > > > > > > ok , thanx > > > > > > > > > > > from where i can load latest version? address? > > > > > > > > > > > > > > > > > > > > > > -----Alkuperäinen viesti----- > > > > > > > > > > > Lähettäjä: Tim Schofield < <mailto:tim...@gm...> tim...@gm...> > > > > > > > > > > > Lähetetty: keskiviikko 26. helmikuuta 2025 16.47 > > > > > > > > > > > Vastaanottaja: For the general discussion of webERP project > > > > > > > > > > > < <mailto:web...@li...> web...@li...> > > > > > > > > > > > Aihe: Re: [webERP-users] mysql> SET = OFF; > > > > > > > > > > > > > > > > > > > > > > Hi, can you try downloading the latest from GitHub and try that. I have done some changes that should help you. > > > > > > > > > > > > > > > > > > > > > > Thanks > > > > > > > > > > > Tim > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > On Wed, 26 Feb 2025 at 14:25, < <mailto:aul...@sc...> aul...@sc...> wrote: > > > > > > > > > > > > > > > > > > > > > > > > hi > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > i dont understand why, because weberp install gives fatal error messages and not goes ok ??? > > > > > > > > > > > > > > > > > > > > > > > > now basic install have created weberp empty database ok, but demo data insert is not ok ? > > > > > > > > > > > > > > > > > > > > > > > > populating demo data is not ok because of fatal errors > > > > > > > > > > > > > > > > > > > > > > > > ? > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > Lähettäjä: gilberto dos santos alves < <mailto:gs...@gm...> gs...@gm...> > > > > > > > > > > > > Lähetetty: keskiviikko 26. helmikuuta 2025 14.22 > > > > > > > > > > > > Vastaanottaja: For the general discussion of webERP project > > > > > > > > > > > > < <mailto:web...@li...> web...@li...> > > > > > > > > > > > > Aihe: Re: [webERP-users] mysql> SET = OFF; > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > please look for > > > > > > > > > > > > > > > > > > > > > > > > .. global and local set variables > > > > > > > > > > > > > > > > > > > > > > > > on yor mysql. > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > On Wed, Feb 26, 2025, 05:44 < <mailto:aul...@sc...> aul...@sc...> wrote: > > > > > > > > > > > > > > > > > > > > > > > > database weberp is empty, admin/weberp > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > Lähettäjä: <mailto:aul...@sc...> aul...@sc... < <mailto:aul...@sc...> aul...@sc...> > > > > > > > > > > > > Lähetetty: keskiviikko 26. helmikuuta 2025 10.16 > > > > > > > > > > > > Vastaanottaja: 'For the general discussion of webERP project' > > > > > > > > > > > > < <mailto:web...@li...> web...@li...> > > > > > > > > > > > > Aihe: VS: [webERP-users] mysql> SET = OFF; > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > im reinstall weberp again and i got other error message, is problem now with weberpdemo data base ? > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > i found in phpadmin in locahost place to set variables, and > > > > > > > now it > > > > > > > > > > > > is off, if i understand > > > > > > > > > > > > > > > > > > > > > > > > if i use wampserver mysql console on my c, its was on > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > Lähettäjä: <mailto:aul...@sc...> aul...@sc... < <mailto:aul...@sc...> aul...@sc...> > > > > > > > > > > > > Lähetetty: keskiviikko 26. helmikuuta 2025 7.47 > > > > > > > > > > > > Vastaanottaja: 'For the general discussion of webERP project' > > > > > > > > > > > > < <mailto:web...@li...> web...@li...> > > > > > > > > > > > > Aihe: Re: [webERP-users] mysql> SET = OFF; > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > parameter is off in wamp mysql console session, and still im > > > > > > > getting > > > > > > > > > > > > error when im install weberp in wamp localhost > > > > > > > > > > > > > > > > > > > > > > > > ?? > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > Lähettäjä: Andrew Couling < <mailto:an...@co...> an...@co...> > > > > > > > > > > > > Lähetetty: tiistai 25. helmikuuta 2025 19.13 > > > > > > > > > > > > Vastaanottaja: For the general discussion of webERP project > > > > > > > > > > > > < <mailto:web...@li...> web...@li...> > > > > > > > > > > > > Aihe: Re: [webERP-users] mysql> SET = OFF; > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > You should be able to interrogate the MySQL server settings by running an SQL query like the following in your MySQL console: > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > SHOW VARIABLES WHERE Variable_name= > > > > > > > > > > > > 'restrict_fk_on_non_standard_key'; > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > On 25 Feb 2025 16:41, gilberto dos santos alves < <mailto:gs...@gm...> gs...@gm...> wrote: > > > > > > > > > > > > > > > > > > > > > > > > hi. > > > > > > > > > > > > > > > > > > > > > > > > please take a calm environment and step by step follow each > > > > > > > step > > > > > > > > > > > > > > > > > > > > > > > > regards from sp 25-02-25 > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > On Tue, Feb 25, 2025, 07:15 < <mailto:aul...@sc...> aul...@sc...> wrote: > > > > > > > > > > > > > > > > > > > > > > > > hi again > > > > > > > > > > > > > > > > > > > > > > > > now im trying install weberp again and i think i got same error situation as earlier ??? > > > > > > > > > > > > > > > > > > > > > > > > i have set by using wamp mysql console , should wamp services start after that ? > > > > > > > > > > > > > > > > > > > > > > > > SET restrict_fk_on_non_standard_key = OFF; > > > > > > > > > > > > > > > > > > > > > > > > where i can verified this parameter value ? > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > Lähettäjä: Andrew Couling < <mailto:an...@co...> an...@co...> > > > > > > > > > > > > Lähetetty: tiistai 25. helmikuuta 2025 10.17 > > > > > > > > > > > > Vastaanottaja: For the general discussion of webERP project > > > > > > > > > > > > < <mailto:web...@li...> web...@li...> > > > > > > > > > > > > Aihe: Re: [webERP-users] mysql> SET > > > > > > > restrict_fk_on_non_standard_key > > > > > > > > > > > > = OFF; > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > You can leave the weberpdemo folder. > > > > > > > > > > > > > > > > > > > > > > > > You should delete the folder which has the same name as your database. In your case it's the folder named 'weberp'. > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > On 25 Feb 2025 05:49, <mailto:aul...@sc...> aul...@sc... wrote: > > > > > > > > > > > > > > > > > > > > > > > > 1. Delete the company directory inside /companies > > > > > > > > > > > > > > > > > > > > > > > > this companies dir contains weberp and weberdemo > > > > > > directories, > > > > > > > make i > > > > > > > > > > > > delete for both there is not company dir ? > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > Lähettäjä: <mailto:an...@co...> an...@co... < <mailto:an...@co...> an...@co...> > > > > > > > > > > > > Lähetetty: tiistai 25. helmikuuta 2025 0.46 > > > > > > > > > > > > Vastaanottaja: 'For the general discussion of webERP project' > > > > > > > > > > > > < <mailto:web...@li...> web...@li...> > > > > > > > > > > > > Aihe: Re: [webERP-users] mysql> SET > > > > > > > restrict_fk_on_non_standard_key > > > > > > > > > > > > = OFF; > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > Procedure for re-installation: > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > 1. Drop all tables in database > > > > > > > > > > > > > > > > > > > > > > > > 2. Delete the company directory inside /companies > > > > > > > > > > > > > > > > > > > > > > > > 3. Delete config.php > > > > > > > > > > > > > > > > > > > > > > > > 4. Navigate to the site in your browser and the installer should run. > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > From: <mailto:aul...@sc...> aul...@sc... < <mailto:aul...@sc...> aul...@sc...> > > > > > > > > > > > > Sent: 24 February 2025 13:43 > > > > > > > > > > > > To: 'For the general discussion of webERP project' > > > > > > > > > > > > < <mailto:web...@li...> web...@li...> > > > > > > > > > > > > Subject: Re: [webERP-users] mysql> SET > > > > > > > > > > > > restrict_fk_on_non_standard_key = OFF; > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > yes thanx > > > > > > > > > > > > > > > > > > > > > > > > i have runned command in my wamp mysql console > > > > > > > > > > > > > > > > > > > > > > > > SET restrict_fk_on_non_standard_key = OFF; > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > but how i resinstall weberp after that, weberp database is > > > > > > not > > > > > > > ok > > > > > > > > > > > > after prev error > > > > > > > > > > > > > > > > > > > > > > > > so must i delete current weberp db and after that run > > > > > > > reinstall > > > > > > > > > > > > weberp again > > > > > > > > > > > > > > > > > > > > > > > > ? > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > Lähettäjä: gilberto dos santos alves < <mailto:gs...@gm...> gs...@gm...> > > > > > > > > > > > > Lähetetty: maanantai 24. helmikuuta 2025 15.26 > > > > > > > > > > > > Vastaanottaja: For the general discussion of webERP project > > > > > > > > > > > > < <mailto:web...@li...> web...@li...> > > > > > > > > > > > > Aihe: Re: [webERP-users] mysql> SET > > > > > > > restrict_fk_on_non_standard_key > > > > > > > > > > > > = OFF; > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > after install mysql and before install weberp you must run this command for disable duplicated foreign key validation. > > > > > > > > > > > > > > > > > > > > > > > > then install weberp > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > |
