Menu
▾
▴
Re: [webERP-users] mysql> SET = OFF;
|
From: Andrew C. <an...@co...> - 2025-02-25 17:13:40
|
<div dir='auto'>You should be able to interrogate the MySQL server settings by running an SQL query like the following in your MySQL console:<div dir="auto"><br></div><div dir="auto">SHOW VARIABLES WHERE Variable_name= 'restrict_fk_on_non_standard_key';</div></div><div class="gmail_extra"><br><div class="gmail_quote">On 25 Feb 2025 16:41, gilberto dos santos alves <gs...@gm...> wrote:<br type="attribution" /><blockquote class="quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="auto">hi.<div dir="auto">please take a calm environment and step by step follow each step </div><div dir="auto">regards from sp 25-02-25</div></div><br /><div><div dir="ltr">On Tue, Feb 25, 2025, 07:15 <<a href="mailto:aulislap@sci.fi">aulislap@sci.fi</a>> wrote:<br /></div><blockquote style="margin:0 0 0 0.8ex;border-left:1px #ccc solid;padding-left:1ex"><div style="word-wrap:break-word"><div><p>hi again<u></u><u></u></p><p>now im trying install weberp again and i think i got same error situation as earlier ???<u></u><u></u></p><p>i have set by using wamp mysql console , should wamp services start after that ?<u></u><u></u></p><p>SET restrict_fk_on_non_standard_key = OFF;<u></u><u></u></p><p>where i can verified this parameter value ?<u></u><u></u></p><p><u></u> <u></u></p><p><u></u> <u></u></p><p><img width="961" height="659" style="width:10.0104in;height:6.8645in" src="cid:image001.png@01DB877E.09A6FF90" /><u></u><u></u></p><p><u></u> <u></u></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"> Andrew Couling <<a href="mailto:andrew@couling.org">andrew@couling.org</a>> <br /><b>Lähetetty:</b> tiistai 25. helmikuuta 2025 10.17<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; <u></u><u></u></span></p></div><p><u></u> <u></u></p><div><p>You can leave the weberpdemo folder.<u></u><u></u></p><div><p>You should delete the folder which has the same name as your database. In your case it's the folder named 'weberp'.<u></u><u></u></p></div></div><div><p><u></u> <u></u></p><div><p>On 25 Feb 2025 05:49, <a href="mailto:aulislap@sci.fi">aulislap@sci.fi</a> wrote:<u></u><u></u></p><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"><div><div><p style="margin-left:46.35pt"><u></u>1.<span style="font:7pt 'times new roman'"> </span><u></u><span style="color:black;background:yellow">Delete the company directory inside /companies</span><u></u><u></u></p><p style="margin-bottom:12pt">this companies dir contains weberp and weberdemo directories, make i delete for both<br />there is not company dir ?<u></u><u></u></p><p> <u></u><u></u></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"> </span><a href="mailto:andrew@couling.org"><span style="font-size:11pt;font-family:'calibri' , sans-serif">andrew@couling.org</span></a><span style="font-size:11pt;font-family:'calibri' , sans-serif"> <</span><a href="mailto:andrew@couling.org"><span style="font-size:11pt;font-family:'calibri' , sans-serif">andrew@couling.org</span></a><span style="font-size:11pt;font-family:'calibri' , sans-serif">> <br /><b>Lähetetty:</b> tiistai 25. helmikuuta 2025 0.46<br /><b>Vastaanottaja:</b> 'For the general discussion of webERP project' <</span><a href="mailto:web-erp-users@lists.sourceforge.net"><span style="font-size:11pt;font-family:'calibri' , sans-serif">web-erp-users@lists.sourceforge.net</span></a><span style="font-size:11pt;font-family:'calibri' , sans-serif">><br /><b>Aihe:</b> Re: [webERP-users] mysql> SET restrict_fk_on_non_standard_key = OFF; </span><u></u><u></u></p></div></div><p> <u></u><u></u></p><p>Procedure for re-installation:<u></u><u></u></p><p> <u></u><u></u></p><p style="margin-left:46.35pt"><u></u>1.<span style="font:7pt 'times new roman'"> </span><u></u>Drop all tables in database<u></u><u></u></p><p style="margin-left:46.35pt"><u></u>2.<span style="font:7pt 'times new roman'"> </span><u></u><span style="color:black;background:yellow">Delete the company directory inside /companies</span><u></u><u></u></p><p style="margin-left:46.35pt"><u></u>3.<span style="font:7pt 'times new roman'"> </span><u></u>Delete config.php<u></u><u></u></p><p style="margin-left:46.35pt"><u></u>4.<span style="font:7pt 'times new roman'"> </span><u></u>Navigate to the site in your browser and the installer should run.<u></u><u></u></p><p> <u></u><u></u></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"> </span><a href="mailto:aulislap@sci.fi"><span style="font-size:11pt;font-family:'calibri' , sans-serif">aulislap@sci.fi</span></a><span style="font-size:11pt;font-family:'calibri' , sans-serif"> <</span><a href="mailto:aulislap@sci.fi"><span style="font-size:11pt;font-family:'calibri' , sans-serif">aulislap@sci.fi</span></a><span style="font-size:11pt;font-family:'calibri' , sans-serif">> <br /><b>Sent:</b> 24 February 2025 13:43<br /><b>To:</b> 'For the general discussion of webERP project' <</span><a href="mailto:web-erp-users@lists.sourceforge.net"><span style="font-size:11pt;font-family:'calibri' , sans-serif">web-erp-users@lists.sourceforge.net</span></a><span style="font-size:11pt;font-family:'calibri' , sans-serif">><br /><b>Subject:</b> Re: [webERP-users] mysql> SET restrict_fk_on_non_standard_key = OFF; </span><u></u><u></u></p></div></div><p> <u></u><u></u></p><p>yes thanx<u></u><u></u></p><p>i have runned command in my wamp mysql console<u></u><u></u></p><p>SET restrict_fk_on_non_standard_key = OFF;<u></u><u></u></p><p><br />but how i resinstall weberp after that, weberp database is not ok after prev error<u></u><u></u></p><p>so must i delete current weberp db and after that run reinstall weberp again<u></u><u></u></p><p>?<u></u><u></u></p><p> <u></u><u></u></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 <</span><a href="mailto:gsavix@gmail.com"><span style="font-size:11pt;font-family:'calibri' , sans-serif">gsavix@gmail.com</span></a><span style="font-size:11pt;font-family:'calibri' , sans-serif">> <br /><b>Lähetetty:</b> maanantai 24. helmikuuta 2025 15.26<br /><b>Vastaanottaja:</b> For the general discussion of webERP project <</span><a href="mailto:web-erp-users@lists.sourceforge.net"><span style="font-size:11pt;font-family:'calibri' , sans-serif">web-erp-users@lists.sourceforge.net</span></a><span style="font-size:11pt;font-family:'calibri' , sans-serif">><br /><b>Aihe:</b> Re: [webERP-users] mysql> SET restrict_fk_on_non_standard_key = OFF; </span><u></u><u></u></p></div><p> <u></u><u></u></p><div><p>after install mysql and before install weberp you must run this command for disable duplicated foreign key validation.<u></u><u></u></p><div><p>then install weberp<u></u><u></u></p></div></div><p> <u></u><u></u></p><div><div><p>On Mon, Feb 24, 2025, 02:45 <<a href="mailto:aulislap@sci.fi">aulislap@sci.fi</a>> wrote:<u></u><u></u></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><u></u><u></u></p></blockquote></div><div><p> <u></u><u></u></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><u></u><u></u></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.</span><a href="https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient"><span style="font-size:10pt;font-family:'arial' , sans-serif;color:#4453ea">www.avast.com</span></a><u></u><u></u></p></td></tr></tbody></table><p> <u></u><u></u></p></div></div></div></blockquote></div><p><u></u> <u></u></p></div></div></div>_______________________________________________<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 /> </blockquote></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}