PhotoPost Community - View Single Post

Chuck S · February 22nd, 2006, 08:27 PM

MySQL 5.0 and higher have a strict mode that is currenty incompatible with a number of queries in PhotoPost products. The Windows Installer from MySQL.com enables this strict mode by default.

In Layman's terms MySQL in strict mode can not allow query inserts with null values to be entered.

Workaround

There are several workarounds

1. Replace in my.ini the current sql-mode line with sql-mode="MYSQL40"
2. Start MySQL with the option --sql-mode="MYSQL40"
3. Execute the query SET GLOBAL sql_mode='MYSQL40'

MySQL needs to be restarted before changes in my.ini have an effect. My.ini can be found in the MySQL installation directory or the Windows directory, depending on your configuration.

February 22nd, 2006, 08:27 PM	#1 (permalink)
Chuck S Photopost Developer Verified Customer Join Date: Jun 2002 Location: Abingdon,MD Posts: 66,744	Mysql 5 Compatibility MySQL 5.0 and higher have a strict mode that is currenty incompatible with a number of queries in PhotoPost products. The Windows Installer from MySQL.com enables this strict mode by default. In Layman's terms MySQL in strict mode can not allow query inserts with null values to be entered. Workaround There are several workarounds 1. Replace in my.ini the current sql-mode line with sql-mode="MYSQL40" 2. Start MySQL with the option --sql-mode="MYSQL40" 3. Execute the query SET GLOBAL sql_mode='MYSQL40' MySQL needs to be restarted before changes in my.ini have an effect. My.ini can be found in the MySQL installation directory or the Windows directory, depending on your configuration. __________________ Photopost Developer and Support Engineer Please do not PM me for support or sales questions. Thank you for your understanding. Last edited by Chuck S; February 22nd, 2006 at 10:58 PM.