XF 1.5 Which AddOn causes the error

#1
Hi,

I have an error and it shows several AddOns in the list.
I deactivated all of them and still have the error. How would I get the exact cause of the error?

Thanks
 
#3
Fehlermeldung des Servers
Fehlerinformation
Zend_Db_Statement_Mysqli_Exception: Mysqli statement execute error : Field 'mm_date' doesn't have a default value - library/Zend/Db/Statement/Mysqli.php:214
Generiert durch: Wasserlasser, Vor 13 Minuten
Stapelverfolgung
#0 /www/htdocs/w00e34a8/library/Zend/Db/Statement.php(297): Zend_Db_Statement_Mysqli->_execute(Array)
#1 /www/htdocs/w00e34a8/library/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#2 /www/htdocs/w00e34a8/library/Zend/Db/Adapter/Abstract.php(574): Zend_Db_Adapter_Abstract->query('INSERT INTO `xf...', Array)
#3 /www/htdocs/w00e34a8/library/XenForo/DataWriter.php(1638): Zend_Db_Adapter_Abstract->insert('xf_resource_cat...', Array)
#4 /www/htdocs/w00e34a8/library/XenForo/DataWriter.php(1627): XenForo_DataWriter->_insert()
#5 /www/htdocs/w00e34a8/library/XenForo/DataWriter.php(1419): XenForo_DataWriter->_save()
#6 /www/htdocs/w00e34a8/library/XenResource/ControllerAdmin/Category.php(160): XenForo_DataWriter->save()
#7 /www/htdocs/w00e34a8/library/ThemesCorp/MMDRM/ControllerAdmin/Category.php(16): XenResource_ControllerAdmin_Category->actionSave()
#8 /www/htdocs/w00e34a8/library/XFA/RMMultipleLanguages/Extends/XenResource/ControllerAdmin/Category.php(58): ThemesCorp_MMDRM_ControllerAdmin_Category->actionSave()
#9 /www/htdocs/w00e34a8/library/XFA/ExtendedCover/Extends/XenResource/ControllerAdmin/Category.php(58): XFA_RMMultipleLanguages_Extends_XenResource_ControllerAdmin_Category->actionSave()
#10 /www/htdocs/w00e34a8/library/XenForo/FrontController.php(351): XFA_ExtendedCover_Extends_XenResource_ControllerAdmin_Category->actionSave()
#11 /www/htdocs/w00e34a8/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#12 /www/htdocs/w00e34a8/admin.php(13): XenForo_FrontController->run()
#13 {main}
Benötigter Status
array(3) {
["url"] => string(62) "http://www.wasserlasser.com/admin.php?resource-categories/save"
["_GET"] => array(1) {
["resource-categories/save"] => string(0) ""
}
["_POST"] => array(20) {
["category_title"] => string(3) "NHL"
["category_description"] => string(21) "Trikots der NHL Teams"
["parent_category_id"] => string(2) "11"
["display_order"] => string(2) "65"
["minimum_messages"] => string(1) "3"
["minimum_messages_days"] => string(2) "60"
["allow_local"] => string(1) "1"
["min_tags"] => string(1) "1"
["thread_node_id"] => string(1) "8"
["forum_id"] => array(1) {
[1] => string(2) "51"
}
["thread_prefix_id"] => string(2) "27"
["available_fields"] => array(2) {
[0] => string(6) "Roster"
[1] => string(9) "Ersteller"
}
["available_prefixes"] => array(1) {
[0] => string(2) "10"
}
["require_prefix"] => string(1) "1"
["xfa_ec_default_cover"] => string(0) ""
["attachment_hash"] => string(32) "5bc841df56659f8515d1c071a0a2fa8c"
["_xfToken"] => string(8) "********"
["_xfRequestUri"] => string(34) "/admin.php?resource-categories/add"
["_xfNoRedirect"] => string(1) "1"
["_xfResponseType"] => string(4) "json"
}
}
 

Brogan

XenForo moderator
Staff member
#4
The error is actually caused by the add-on being disabled.

Something to do with mm_date - it looks like ThemesCorp/MMDRM, whatever that is.
 
#5
No matter if this AddOn is enabled or disabled, I still get the error.

At the same time, I am getting this error as well

Fehlerinformation

ErrorException: Undefined index: resource_category_id - library/XFA/RMMultipleLanguages/Extends/XenResource/ControllerAdmin/Category.php:24
Generiert durch: Wasserlasser, Vor 33 Minuten
Stapelverfolgung
#0 /www/htdocs/w00e34a8/library/XFA/RMMultipleLanguages/Extends/XenResource/ControllerAdmin/Category.php(24): XenForo_Application::handlePhpError(8, 'Undefined index...', '/www/htdocs/w00...', 24, Array)
#1 /www/htdocs/w00e34a8/library/XFA/ExtendedCover/Extends/XenResource/ControllerAdmin/Category.php(22): XFA_RMMultipleLanguages_Extends_XenResource_ControllerAdmin_Category->_getCategoryAddEditResponse(Array)
#2 /www/htdocs/w00e34a8/library/XenResource/ControllerAdmin/Category.php(105): XFA_ExtendedCover_Extends_XenResource_ControllerAdmin_Category->_getCategoryAddEditResponse(Array)
#3 /www/htdocs/w00e34a8/library/XenForo/FrontController.php(351): XenResource_ControllerAdmin_Category->actionAdd()
#4 /www/htdocs/w00e34a8/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#5 /www/htdocs/w00e34a8/admin.php(13): XenForo_FrontController->run()
#6 {main}
Benötigter Status
array(3) {
["url"] => string(61) "http://www.wasserlasser.com/admin.php?resource-categories/add"
["_GET"] => array(1) {
["resource-categories/add"] => string(0) ""
}
["_POST"] => array(0) {
}
}

 

Brogan

XenForo moderator
Staff member
#6
Enable all add-ons again and disable them one at a time until the error appears.

That will identify the add-on causing it.

Otherwise you will have to post on the respective add-on threads to determine which add-on that field is from.
 
#8
@Brogan
Here is the info with all of them disabled

Fehlermeldung des Servers
Fehlerinformation
Zend_Db_Statement_Mysqli_Exception: Mysqli statement execute error : Field 'mm_date' doesn't have a default value - library/Zend/Db/Statement/Mysqli.php:214
Generiert durch: Wasserlasser, Vor einem Moment
Stapelverfolgung
#0 /www/htdocs/w00e34a8/library/Zend/Db/Statement.php(297): Zend_Db_Statement_Mysqli->_execute(Array)
#1 /www/htdocs/w00e34a8/library/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#2 /www/htdocs/w00e34a8/library/Zend/Db/Adapter/Abstract.php(574): Zend_Db_Adapter_Abstract->query('INSERT INTO `xf...', Array)
#3 /www/htdocs/w00e34a8/library/XenForo/DataWriter.php(1638): Zend_Db_Adapter_Abstract->insert('xf_resource_cat...', Array)
#4 /www/htdocs/w00e34a8/library/XenForo/DataWriter.php(1627): XenForo_DataWriter->_insert()
#5 /www/htdocs/w00e34a8/library/XenForo/DataWriter.php(1419): XenForo_DataWriter->_save()
#6 /www/htdocs/w00e34a8/library/XenResource/ControllerAdmin/Category.php(160): XenForo_DataWriter->save()
#7 /www/htdocs/w00e34a8/library/XenForo/FrontController.php(351): XenResource_ControllerAdmin_Category->actionSave()
#8 /www/htdocs/w00e34a8/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#9 /www/htdocs/w00e34a8/admin.php(13): XenForo_FrontController->run()
#10 {main}
Benötigter Status
array(3) {
["url"] => string(62) "http://www.wasserlasser.com/admin.php?resource-categories/save"
["_GET"] => array(1) {
["resource-categories/save"] => string(0) ""
}
["_POST"] => array(15) {
["category_title"] => string(3) "NHL"
["category_description"] => string(21) "Trikots der NHL Teams"
["parent_category_id"] => string(2) "11"
["display_order"] => string(2) "65"
["allow_local"] => string(1) "1"
["min_tags"] => string(1) "1"
["thread_node_id"] => string(1) "8"
["thread_prefix_id"] => string(2) "27"
["available_fields"] => array(2) {
[0] => string(6) "Roster"
[1] => string(9) "Ersteller"
}
["available_prefixes"] => array(1) {
[0] => string(2) "10"
}
["require_prefix"] => string(1) "1"
["_xfToken"] => string(8) "********"
["_xfRequestUri"] => string(34) "/admin.php?resource-categories/add"
["_xfNoRedirect"] => string(1) "1"
["_xfResponseType"] => string(4) "json"
}
}
 

Brogan

XenForo moderator
Staff member
#9
As I have said, the error is caused by an (incorrectly coded) add-on which is disabled.

You need to enable all add-ons and disable them one at a time to identify which one is causing it.

Failing that, you will need to contact the authors of the add-ons you are using for further support and troubleshooting.
 
#10
OK, I had one AddOn that was disabled. I enabled it and tested it.
The error was still there.

Then I disabled the other three one at a time and tested it.

I always got an error. Here are the three errors

Zend_Db_Statement_Mysqli_Exception: Mysqli statement execute error : Field 'mm_date' doesn't have a default value - library/Zend/Db/Statement/Mysqli.php:214
Generiert durch: Wasserlasser, Vor 3 Minuten
Stapelverfolgung

#0 /www/htdocs/w00e34a8/library/Zend/Db/Statement.php(297): Zend_Db_Statement_Mysqli->_execute(Array)
#1 /www/htdocs/w00e34a8/library/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#2 /www/htdocs/w00e34a8/library/Zend/Db/Adapter/Abstract.php(574): Zend_Db_Adapter_Abstract->query('INSERT INTO `xf...', Array)
#3 /www/htdocs/w00e34a8/library/XenForo/DataWriter.php(1638): Zend_Db_Adapter_Abstract->insert('xf_resource_cat...', Array)
#4 /www/htdocs/w00e34a8/library/XenForo/DataWriter.php(1627): XenForo_DataWriter->_insert()
#5 /www/htdocs/w00e34a8/library/XenForo/DataWriter.php(1419): XenForo_DataWriter->_save()
#6 /www/htdocs/w00e34a8/library/XenResource/ControllerAdmin/Category.php(160): XenForo_DataWriter->save()
#7 /www/htdocs/w00e34a8/library/ThemesCorp/MMDRM/ControllerAdmin/Category.php(16): XenResource_ControllerAdmin_Category->actionSave()
#8 /www/htdocs/w00e34a8/library/XFA/RMMGCatLayout/Extends/ControllerAdmin/ResourceCategory.php(15): ThemesCorp_MMDRM_ControllerAdmin_Category->actionSave()
#9 /www/htdocs/w00e34a8/library/XFA/ExtendedCover/Extends/XenResource/ControllerAdmin/Category.php(58): XFA_RMMGCatLayout_Extends_ControllerAdmin_ResourceCategory->actionSave()
#10 /www/htdocs/w00e34a8/library/XenForo/FrontController.php(351): XFA_ExtendedCover_Extends_XenResource_ControllerAdmin_Category->actionSave()
#11 /www/htdocs/w00e34a8/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#12 /www/htdocs/w00e34a8/admin.php(13): XenForo_FrontController->run()
#13 {main}


#0 /www/htdocs/w00e34a8/library/Zend/Db/Statement.php(297): Zend_Db_Statement_Mysqli->_execute(Array)
#1 /www/htdocs/w00e34a8/library/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#2 /www/htdocs/w00e34a8/library/Zend/Db/Adapter/Abstract.php(574): Zend_Db_Adapter_Abstract->query('INSERT INTO `xf...', Array)
#3 /www/htdocs/w00e34a8/library/XenForo/DataWriter.php(1638): Zend_Db_Adapter_Abstract->insert('xf_resource_cat...', Array)
#4 /www/htdocs/w00e34a8/library/XenForo/DataWriter.php(1627): XenForo_DataWriter->_insert()
#5 /www/htdocs/w00e34a8/library/XenForo/DataWriter.php(1419): XenForo_DataWriter->_save()
#6 /www/htdocs/w00e34a8/library/XenResource/ControllerAdmin/Category.php(160): XenForo_DataWriter->save()
#7 /www/htdocs/w00e34a8/library/XFA/RMMultipleLanguages/Extends/XenResource/ControllerAdmin/Category.php(58): XenResource_ControllerAdmin_Category->actionSave()
#8 /www/htdocs/w00e34a8/library/XFA/RMMGCatLayout/Extends/ControllerAdmin/ResourceCategory.php(15): XFA_RMMultipleLanguages_Extends_XenResource_ControllerAdmin_Category->actionSave()
#9 /www/htdocs/w00e34a8/library/XFA/ExtendedCover/Extends/XenResource/ControllerAdmin/Category.php(58): XFA_RMMGCatLayout_Extends_ControllerAdmin_ResourceCategory->actionSave()
#10 /www/htdocs/w00e34a8/library/XenForo/FrontController.php(351): XFA_ExtendedCover_Extends_XenResource_ControllerAdmin_Category->actionSave()
#11 /www/htdocs/w00e34a8/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#12 /www/htdocs/w00e34a8/admin.php(13): XenForo_FrontController->run()
#13 {main}

#0 /www/htdocs/w00e34a8/library/Zend/Db/Statement.php(297): Zend_Db_Statement_Mysqli->_execute(Array)
#1 /www/htdocs/w00e34a8/library/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#2 /www/htdocs/w00e34a8/library/Zend/Db/Adapter/Abstract.php(574): Zend_Db_Adapter_Abstract->query('INSERT INTO `xf...', Array)
#3 /www/htdocs/w00e34a8/library/XenForo/DataWriter.php(1638): Zend_Db_Adapter_Abstract->insert('xf_resource_cat...', Array)
#4 /www/htdocs/w00e34a8/library/XenForo/DataWriter.php(1627): XenForo_DataWriter->_insert()
#5 /www/htdocs/w00e34a8/library/XenForo/DataWriter.php(1419): XenForo_DataWriter->_save()
#6 /www/htdocs/w00e34a8/library/XenResource/ControllerAdmin/Category.php(160): XenForo_DataWriter->save()
#7 /www/htdocs/w00e34a8/library/ThemesCorp/MMDRM/ControllerAdmin/Category.php(16): XenResource_ControllerAdmin_Category->actionSave()
#8 /www/htdocs/w00e34a8/library/XFA/RMMultipleLanguages/Extends/XenResource/ControllerAdmin/Category.php(58): ThemesCorp_MMDRM_ControllerAdmin_Category->actionSave()
#9 /www/htdocs/w00e34a8/library/XFA/RMMGCatLayout/Extends/ControllerAdmin/ResourceCategory.php(15): XFA_RMMultipleLanguages_Extends_XenResource_ControllerAdmin_Category->actionSave()
#10 /www/htdocs/w00e34a8/library/XenForo/FrontController.php(351): XFA_RMMGCatLayout_Extends_ControllerAdmin_ResourceCategory->actionSave()
#11 /www/htdocs/w00e34a8/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#12 /www/htdocs/w00e34a8/admin.php(13): XenForo_FrontController->run()
#13 {main}
You said it is caused by an incorrectly coded AddOn which is disabled. Since I only had one disabled, that should be the one, correct?
 

Brogan

XenForo moderator
Staff member
#11
At this point it's probably better if you contact the authors of the add-ons - they will be able to identify which one it is from the field name.
 
#12
All other AddOns have been uninstalled and still an error. Back to Xenforo :)

Fehlermeldung des Servers
Fehlerinformation
Zend_Db_Statement_Mysqli_Exception: Mysqli statement execute error : Field 'mm_date' doesn't have a default value - library/Zend/Db/Statement/Mysqli.php:214
Generiert durch: Wasserlasser, Vor einem Moment
Stapelverfolgung
#0 /www/htdocs/w00e34a8/library/Zend/Db/Statement.php(297): Zend_Db_Statement_Mysqli->_execute(Array)
#1 /www/htdocs/w00e34a8/library/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#2 /www/htdocs/w00e34a8/library/Zend/Db/Adapter/Abstract.php(574): Zend_Db_Adapter_Abstract->query('INSERT INTO `xf...', Array)
#3 /www/htdocs/w00e34a8/library/XenForo/DataWriter.php(1638): Zend_Db_Adapter_Abstract->insert('xf_resource_cat...', Array)
#4 /www/htdocs/w00e34a8/library/XenForo/DataWriter.php(1627): XenForo_DataWriter->_insert()
#5 /www/htdocs/w00e34a8/library/XenForo/DataWriter.php(1419): XenForo_DataWriter->_save()
#6 /www/htdocs/w00e34a8/library/XenResource/ControllerAdmin/Category.php(160): XenForo_DataWriter->save()
#7 /www/htdocs/w00e34a8/library/XenForo/FrontController.php(351): XenResource_ControllerAdmin_Category->actionSave()
#8 /www/htdocs/w00e34a8/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#9 /www/htdocs/w00e34a8/admin.php(13): XenForo_FrontController->run()
#10 {main}
Benötigter Status
array(3) {
["url"] => string(58) "http://wasserlasser.com/admin.php?resource-categories/save"
["_GET"] => array(1) {
["resource-categories/save"] => string(0) ""
}
["_POST"] => array(15) {
["category_title"] => string(3) "NHL"
["category_description"] => string(21) "Trikots der NHL Teams"
["parent_category_id"] => string(2) "11"
["display_order"] => string(2) "65"
["allow_local"] => string(1) "1"
["min_tags"] => string(1) "1"
["thread_node_id"] => string(1) "8"
["thread_prefix_id"] => string(2) "27"
["available_fields"] => array(2) {
[0] => string(6) "Roster"
[1] => string(9) "Ersteller"
}
["available_prefixes"] => array(1) {
[0] => string(2) "10"
}
["require_prefix"] => string(1) "1"
["_xfToken"] => string(8) "********"
["_xfRequestUri"] => string(34) "/admin.php?resource-categories/add"
["_xfNoRedirect"] => string(1) "1"
["_xfResponseType"] => string(4) "json"
}
}
 

Mike

XenForo developer
Staff member
#15
You would need to search the code for references to "mm_date". If that doesn't turn anything up, it would likely be something left by an add-on that you have subsequently uninstalled.
 
Top