WordPress.org

Ready to get started?Download WordPress

Forums

Dynamic Widgets
[resolved] Mysql strict mode error (2 posts)

  1. kevindstanley
    Member
    Posted 1 year ago #

    Hi I am running a wordpress site and it is hosted on Microsoft Azure as a website and the mysql is a linked resource.

    I am using 'Dynamic Widgets' and getting this error
    "WARNING STRICT sql mode in effect. Dynamic Widgets might not work correctly. Please disable STRICT sql mode."

    The error causes the data to not actually save even though it says it does, but I checked the DB and it does not.

    I have read how to fix it, unfortunately the database sql mode cannot be changed on Azure hosted sites. Is there anything I can do to make this plugin compatible with the strict mode that is set?

    I am familiar with php, so that wouldn't be a problem, I just don't know where to start on this problem.

    Thanks,
    Kevin

    http://wordpress.org/extend/plugins/dynamic-widgets/

  2. Qurl
    Member
    Plugin Author

    Posted 1 year ago #

    I'm sorry. MySQL strict mode ensures MySQL does not truncate or otherwise modify data to conform to an underlying data type, when an incompatible value is inserted into that type.

    Because of the dynamic nature of Dynamic Widgets and the way it's programmed it can -as you already noticed- insert a different data type or perform a tuncation in the database table.

    One thing you could try is changing the name column in de dynamic_widgets table to allow a NULL value and default to NULL:
    ALTER TABLE [prefix]dynamic_widgets CHANGE name name VARCHAR( 40 ) NULL DEFAULT NULL

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic