modTemplateVar: Attempt to set NOT NULL field type to NULL

☆ A M B ☆
721 Posts

rx2 Reply #1, 12 years, 8 months ago

Getting this error (in the log) a lot since an upgrade from 2.2.0 to 2.2.10.

How does one track the source of this error?

This question has been answered by [email protected]. See the first response.

☆ A M B ☆
24,524 Posts

sottwell Reply #2, 12 years, 8 months ago

Check your server's PHP and MySQL error logs. They may have more specific information.

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

discuss.answer

23 Posts

audioroger Reply #3, 12 years, 8 months ago

You may want to check your MIGX syntax, I had this issue before and it turned out that a MIGX TV didn't have the "inputTV" set.

☆ A M B ☆
721 Posts

rx2 Reply #4, 12 years, 8 months ago

That was it, effectively. Though I had the "inputTV" value, there was a typo. Instead of feeddate I had feedate but this was a field the client never used anyway.

Answered modTemplateVar: Attempt to set NOT NULL field type to NULL