Request Mysqli statement execute error : Field 'atp_attachment_extensions' doesn't have a default value

[compuzones]

Mysqli statement execute error : Field 'atp_attachment_extensions' doesn't have a default value

    Zend_Db_Statement_Mysqli->_execute() in Zend/Db/Statement.php at line 297
    Zend_Db_Statement->execute() in Zend/Db/Adapter/Abstract.php at line 479
    Zend_Db_Adapter_Abstract->query() in Zend/Db/Adapter/Abstract.php at line 574
    Zend_Db_Adapter_Abstract->insert() in XenForo/DataWriter.php at line 1638
    XenForo_DataWriter->_insert() in XenForo/DataWriter.php at line 1627
    XenForo_DataWriter->_save() in XenForo/DataWriter.php at line 1419
    XenForo_DataWriter->save() in XenForo/ControllerAdmin/Forum.php at line 129
    XenForo_ControllerAdmin_Forum->actionSave() in XFA/ExtendedCover/Extends/XenForo/ControllerAdmin/Forum.php at line 52
    XFA_ExtendedCover_Extends_XenForo_ControllerAdmin_Forum->actionSave() in LiamW/ThreadSolutions/Extend/ControllerAdmin/Forum.php at line 14
    LiamW_ThreadSolutions_Extend_ControllerAdmin_Forum->actionSave() in XenForo/FrontController.php at line 351
    XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
    XenForo_FrontController->run() in /home/nulledco/public_html/admin.php at line 13

I hope someone can help me ..
I want to create a node but get this error message ..
its causes and how to fix?
thanks

 

[cuonghv]

It's coming from third parties addon. U should try disable all addon and create node again.

 

[compuzones]

okay .. thanks .. I again tried to disable all the add ons on my forums ..

 

[compuzones]

Mysqli statement execute error : Field 'atp_attachment_extensions' doesn't have a default value

    Zend_Db_Statement_Mysqli->_execute() in Zend/Db/Statement.php at line 297
    Zend_Db_Statement->execute() in Zend/Db/Adapter/Abstract.php at line 479
    Zend_Db_Adapter_Abstract->query() in Zend/Db/Adapter/Abstract.php at line 574
    Zend_Db_Adapter_Abstract->insert() in XenForo/DataWriter.php at line 1638
    XenForo_DataWriter->_insert() in XenForo/DataWriter.php at line 1627
    XenForo_DataWriter->_save() in XenForo/DataWriter.php at line 1419
    XenForo_DataWriter->save() in XenForo/ControllerAdmin/Forum.php at line 129
    XenForo_ControllerAdmin_Forum->actionSave() in XenForo/FrontController.php at line 351
    XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
    XenForo_FrontController->run() in /home/nulledco/public_html/admin.php at line 13

I've disable all the add ons and try to create a new node ...
getting the same error ..
is there another way?

 

[cuonghv]

Hum, cause Mysql don't allow 'insert' or 'update' command with empty field where the schema doesn’t have a default value set.
You can add the sql_mode line to your system MySQL config at /etc/my.cnf

[mysqld]
sql_mode =""

Save the file and restart Mysql

 

[compuzones]

if I use cpanel hosting account how can one add in file mysql ..

 

[dcstylexf]

if I use cpanel hosting account how can one add in file mysql ..

go to myphpadmin, bro!

 

[compuzones]

go to myphpadmin, bro!

ah ha ... if I do not understand mysql problems .. can you give me an example screenshot to change it in phpmyadmin ?