Field X doesn't have a default value


(Saqib Ali) #1

Hi ,

We have following errors in our logs:
Error in Piwik (tracker): Error query: SQLSTATE[HY000]: General error: 1364 Field ‘visit_exit_idaction_name’ doesn’t have a default value

Error in Piwik (tracker): Error query: SQLSTATE[HY000]: General error: 1364 Field ‘config_pdf’ doesn’t have a default value

Have read following links but there is not mentioned why this is happening and in which particular scenario:


Do you have any idea what could be the possible reason ? or how to recreate the scenario ?

We have piwik 2.10 and MySQL 5.6 .

Thanks


(Saqib Ali) #2

Hi,

Does piwik cache could be the reason of this error , or any plugin may be ?

From this error :
Error query: SQLSTATE[HY000]: General error: 1364 Field ‘visit_exit_idaction_name’ doesn’t have a default value
It looks somehow piwik was unable to reference the visit_exit_idaction_name from the piwik_log_action table, how could be it possible ?

Thanks