Difference between revisions of "Disable MySQL Strict Mode"

From TNG_Wiki
Jump to: navigation, search
(added version of mod for TNG 10.1.3)
(Sites using this mod)
Line 102: Line 102:
 
| V11.0.0.2
 
| V11.0.0.2
 
| TNG 11.0
 
| TNG 11.0
 +
| EN
 +
|-
 +
| [https://www.craxford-family.co.uk/ Extended Craxford Family Web Site]
 +
| Alan Craxford
 +
| Mod installed to enable the website to run in the latest Wampserver 64 (which has MySQL 5.7 built in) on my Windows 10 PC
 +
| V10.0.1.1
 +
| TNG 10.1.3
 
| EN
 
| EN
 
|-
 
|-

Revision as of 12:27, 4 April 2017

Obsolete The Disable MySQL Strict Mode is obsolete with TNG V11.0.2.


Restricted Downloads of Disable MySQL Strict Mode are restricted to logged in users. If you do not have a user account on the TNG Wiki use the Request Account link to request a user account Restricted


Disable MySQL Strict Mode
Summary Allows TNG to run correctly when MySQL Strict Mode is enabled (MySQL 5.7)
Validation Database access mod validation not attempted
Mod Updated {{{mod_last_update}}}
Download link For
TNG 11.0.1
disable_mysql_strict_mode_v11.0.1.2.zip
For
TNG 11.0
disable_mysql_strict_mode_v11.0.0.2.zip
For
TNG 10.1.3
Disable_mysql_strict_mode_v10.1.3.1.zip
Download stats View Download Stats
Author(s) Ken Roy
Homepage Disable MySQL Strict Mode (This page)
Mod Support TNG Community Forums
Contact Developer
Latest Mod 11.0.1.2 for TNG V11.0.1
11.0.0.2 for TNG v11.0.0
10.1.3.1 for TNG 10.1.3
Min TNG V 11.0.0
Max TNG V 11.0.1
Files modified
tngconnect.php
Related Mods
Notes


Purpose of the Mod

MySQL 5.7 implements Strict Mode which does not allow zeros to be used in dates nor does it allow data truncation.

The Disable MySQL Strict Mode mod was created to disable the MySQL Strict Mode so that users did not need to request that their hosting service disable it.

The mod further adds the error message from the SQL Query failure whenever possible.

Developer

Mod Developer is Ken Roy from code implemented in TNG 11.0.2


Revision History

Version Date Contents
v11.0.1.2 28 September 2016 Separated the Disable MySQL Strict Mode in TNG v11.0 and v11.0.1, since the previously posted mod v11.0.0.1 did not install on TNG v11.0.0.


If you installed v11.0.0.1 on TNG V11.0.1, you don't need to install this version. If you download it, extract it and place the extracted .cfg file in your mods folder it will show as installed. You can then delete the v11.0.0.1 version to avoid confusion.

v11.0.0.1 15 September 2016 Added changes made in TNG v11.0.2 to disable MySQL Strict Mode in TNG v11.0 and v11.0.1


Requirements

  • a working TNG installation.
  • a backup of your TNG admin_export.php and admin_gedcom2.php files or access to your original TNG installation package.

Automated Installation Requirements

  1. Download the appropriate mod configuration file as shown in the summary in the upper right corner of the page
  2. Unzip the private_notes_for_admins zip file to your mods folder
  3. Follow the normal automated installation for Mod Manager, as shown in the example Mod Manager - Installing Config Files to install the private_notes_for_admins.cfg.

In the event of a problem

  • Try using the Mod Manager Remove capability
  • copy your backup admin_export.php and admin_gedcom2.php files to your base TNG directory


Related Links

See the MySQL_Strict_Issues in the Troubleshooting category

Sites using this mod

If you download this mod, please add your TNG site to the table below:

URL User Note Mod-Version TNG-Version User-language
Our Roy and Boucher Family Ken Roy Developed the mod to provide the capability to disable MySQL Strict Mode on TNG 10.1 through 11.0.2 V11.0.0.1 TNG 11.0.1 test environment EN, FR
Hannaway & Byrnes Family Pages Peter Hannaway Installed by Ken Roy to allow GEDCOM import on MySQL 5.6 running in Strict Mode V11.0.0.2 TNG 11.0 EN
Extended Craxford Family Web Site Alan Craxford Mod installed to enable the website to run in the latest Wampserver 64 (which has MySQL 5.7 built in) on my Windows 10 PC V10.0.1.1 TNG 10.1.3 EN
... ... ... ... ... ...