https://wiki.freenetis.org/index.php?action=history&feed=atom&title=Instalace_na_MySQL_5.7_a_vy%C5%A1%C5%A1%C3%AD 2026-05-13T11:30:36Z Historie editací této stránky MediaWiki 1.30.0 https://wiki.freenetis.org/index.php?title=Instalace_na_MySQL_5.7_a_vy%C5%A1%C5%A1%C3%AD&diff=2299&oldid=prev 2018-12-27T15:08:50Z

<p></p> <table class="diff diff-contentalign-left" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr style="vertical-align: top;" lang="cs"> <td colspan="2" style="background-color: white; color:black; text-align: center;">← Starší verze</td> <td colspan="2" style="background-color: white; color:black; text-align: center;">Verze z 27. 12. 2018, 15:08</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l1" >Řádek 1:</td> <td colspan="2" class="diff-lineno">Řádek 1:</td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">'''UPOZORNĚNÍ: Toto nastavení není nutné pro MariaDB! Pokud instalujete na Debian nemělo by být nutné provádět níže popsanou změnu konfigurace.'''</ins></div></td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"></ins></div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>Pro instalaci na MySQL 5.7 a vyšší je nutné v konfiguraci MySQL nastavit:</div></td><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>Pro instalaci na MySQL 5.7 a vyšší je nutné v konfiguraci MySQL nastavit:</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td></tr> </table>

Dzolo https://wiki.freenetis.org/index.php?title=Instalace_na_MySQL_5.7_a_vy%C5%A1%C5%A1%C3%AD&diff=2298&oldid=prev 2018-05-24T20:16:37Z

<p></p> <table class="diff diff-contentalign-left" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr style="vertical-align: top;" lang="cs"> <td colspan="2" style="background-color: white; color:black; text-align: center;">← Starší verze</td> <td colspan="2" style="background-color: white; color:black; text-align: center;">Verze z 24. 5. 2018, 20:16</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l3" >Řádek 3:</td> <td colspan="2" class="diff-lineno">Řádek 3:</td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>&lt;pre&gt;</div></td><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>&lt;pre&gt;</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>[mysqld]</div></td><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>[mysqld]</div></td></tr> <tr><td class='diff-marker'>−</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>sql_mode=&quot;STRICT_TRANS_TABLES<del class="diffchange diffchange-inline">,NO_ZERO_IN_DATE,NO_ZERO_DATE</del>,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION<del class="diffchange diffchange-inline">&quot;</del></div></td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>sql_mode=&quot;STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>&lt;/pre&gt;</div></td><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>&lt;/pre&gt;</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td></tr> </table>

Dzolo https://wiki.freenetis.org/index.php?title=Instalace_na_MySQL_5.7_a_vy%C5%A1%C5%A1%C3%AD&diff=2235&oldid=prev 2018-01-31T14:12:02Z

<p>Quimi přesunul stránku <a href="/index.php?title=Instalace_na_MySQL_5.7_a_vy%C3%85%C2%A1%C3%85%C2%A1%C3%83%C2%AD&amp;action=edit&amp;redlink=1" class="new" title="Instalace na MySQL 5.7 a vyšší (stránka neexistuje)">Instalace na MySQL 5.7 a vyšší</a> na <a href="/index.php/Instalace_na_MySQL_5.7_a_vy%C5%A1%C5%A1%C3%AD" title="Instalace na MySQL 5.7 a vyšší">Instalace na MySQL 5.7 a vyšší</a> bez založení přesměrování</p> <table class="diff diff-contentalign-left" data-mw="interface"> <tr style="vertical-align: top;" lang="cs"> <td colspan="1" style="background-color: white; color:black; text-align: center;">← Starší verze</td> <td colspan="1" style="background-color: white; color:black; text-align: center;">Verze z 31. 1. 2018, 14:12</td> </tr><tr><td colspan="2" style="text-align: center;" lang="cs"><div class="mw-diff-empty">(Žádný rozdíl)</div> </td></tr></table>

Quimi https://wiki.freenetis.org/index.php?title=Instalace_na_MySQL_5.7_a_vy%C5%A1%C5%A1%C3%AD&diff=2203&oldid=prev 2017-01-04T15:46:14Z

<p>Založena nová stránka: Pro instalaci na MySQL 5.7 a vyšší je nutné v konfiguraci MySQL nastavit: &lt;pre&gt; [mysqld] sql_mode=&quot;STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_...</p> <p><b>Nová stránka</b></p><div>Pro instalaci na MySQL 5.7 a vyšší je nutné v konfiguraci MySQL nastavit:<br /> <br /> &lt;pre&gt;<br /> [mysqld]<br /> sql_mode=&quot;STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION&quot;<br /> &lt;/pre&gt;<br /> <br /> == Migrace databáze ==<br /> <br /> Pokud migrujete databázi na MySQL 5.7 a vyšší z nižší verze a používali jste v minulosti FreeenetIS ve verzi 1.1.19 a nižší, pak je nutné provést před migrací následující SQL dotaz nad databází:<br /> <br /> &lt;pre&gt;<br /> update address_points set gps=NULL where gps = '';<br /> &lt;/pre&gt;</div>

Dzolo