I am geeting error : Error saving record. MySQL Error(1364): Field 'num' doesn't have a default value.

6 posts by 2 authors in: Forums > CMS Builder
Last Post: March 13, 2024   (RSS)

By qhaqan - March 10, 2024

I have downloaded latest cms and installed it, I have created a sections pages with few fields but I am getting below error:

Error saving record. MySQL Error(1364): Field 'num' doesn't have a default value.

How can I fix it? in which file I have make changes. Please advice

text

By Dave - March 11, 2024

Hi qhagan, 

I haven't seen that error before.  Can you let me know the steps to reproduce it or fill out a second-level support request and we'll check it out for you? 

https://www.interactivetools.com/support/request/

Thanks!

Dave Edis - Senior Developer
interactivetools.com

By qhaqan - March 12, 2024

Hello,

When i try to create any new record it through this error, Like pages - when I try to create new record in page section it through - Error saving record. MySQL Error(1364): Field 'num' doesn't have a default value. as javascript alert

text

By qhaqan - March 13, 2024

I have shared my admin login. please look into it and let me know

thanks!

text

By Dave - March 13, 2024

Hi qhaqan, 

Thanks, I've replied by email.  There seem to be some differences with the MySQL setup on the server in question.

I'll continue working with you over email to resolve it.  

I'm going to close this forum thread for now and post back if there's an issue or fix that might affect other people.

Thanks!

Dave Edis - Senior Developer
interactivetools.com