Menu
▾
▴
Re: [webERP-users] mysql> SET restrict_fk_on_non_standard_key = OFF;
|
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> |
![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}