XF 1.5 Which AddOn causes the error

Wasserlasser

Active member
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
 

Wasserlasser

Active member
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
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.
 

Wasserlasser

Active member
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
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.
 

Wasserlasser

Active member
You mean all (not just the three here) AddOns?
If you mean only the three, then I have already done it and the error still shows :-(
 

Wasserlasser

Active member
@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
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.
 

Wasserlasser

Active member
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
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.
 

Wasserlasser

Active member
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"
}
}
 

Wasserlasser

Active member
Where would I find said field in the code and which AddOn would cause this as there is no more reference to anything.
 

Mike

XenForo developer
Staff member
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