Support » Plugin: Dynamic Widgets » Mysql strict mode error

  • Resolved kevindstanley


    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.


Viewing 1 replies (of 1 total)
  • Plugin Author Qurl


    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

Viewing 1 replies (of 1 total)
  • The topic ‘Mysql strict mode error’ is closed to new replies.