We launched new forums in March 2019—join us there. In a hurry for help with your website? Get Help Now!
    • 13792
    • 8 Posts
    Good Afternoon,

    I am getting this error message when I try to save a resource created with a template:

    [2010-09-14 15:45:57] (ERROR @ /connectors/element/tv.php) modTemplateVarTemplate: Attempt to set NOT NULL field rank to NULL

    Could anyone point me in the right direction for this? I tried searching for the error message on the forums and didn’t find anything.

    Thanks!
    John
      • 28042 ☆ A M B ☆
      • 24,524 Posts
      Sounds like a database with strict mode, and a table with a field set to NOT NULL but no default value.
        Studying MODX in the desert - http://sottwell.com
        Tips and Tricks from the MODX Forums and Slack Channels - http://modxcookbook.com
        Join the Slack Community - http://modx.org
        • 13792
        • 8 Posts
        found the problem, not sure of the solution.

        I have a template variable that when it is blank it is causing the save not to happen. i do not see a place to make a template variable optional, is there such a thing?

        Thanks!
        John