Disable MySQL Strict Mode

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
...	...	...	...	...	...