Bug Mysqli prepare error: Unknown column 'criteria' in 'field list'

[Nirjonadda]

Error Info
Zend_Db_Statement_Mysqli_Exception: Mysqli prepare error: Unknown column 'criteria' in 'field list' - library/Zend/Db/Statement/Mysqli.php:77
Generated By: Nirjon, Today at 2:06 AM
Stack Trace

#0 /home/nadda/public_html/library/Zend/Db/Statement.php(115): Zend_Db_Statement_Mysqli->_prepare('UPDATE xf_dbtec...')
#1 /home/nadda/public_html/library/Zend/Db/Adapter/Mysqli.php(381): Zend_Db_Statement->__construct(Object(Zend_Db_Adapter_Mysqli), 'UPDATE xf_dbtec...')
#2 /home/nadda/public_html/library/Zend/Db/Adapter/Abstract.php(478): Zend_Db_Adapter_Mysqli->prepare('UPDATE xf_dbtec...')
#3 /home/nadda/public_html/library/DBTech/Mail/Application/Database.php(668): Zend_Db_Adapter_Abstract->query('UPDATE xf_dbtec...')
#4 /home/nadda/public_html/library/DBTech/Mail/Application/Database.php(367): DBTech_Mail_Application_Database->query('UPDATE xf_dbtec...', Array, 'query_write')
#5 /home/nadda/public_html/library/DBTech/Mail/Application/DataManager.php(400): DBTech_Mail_Application_Database->update('dbtech_mail_new...', Array, 'newsletterid = ...', Array)
#6 /home/nadda/public_html/library/DBTech/Mail/Application/DataManager.php(363): DBTech_Mail_Application_DataManager->_update()
#7 /home/nadda/public_html/library/DBTech/Mail/Application/DataManager.php(238): DBTech_Mail_Application_DataManager->_save()
#8 /home/nadda/public_html/library/DBTech/Mail/ActionAdmin/Newsletter.php(231): DBTech_Mail_Application_DataManager->save()
#9 /home/nadda/public_html/library/DBTech/Mail/Application/Core.php(333): DBTech_Mail_ActionAdmin_Newsletter->actionUpdate()
#10 /home/nadda/public_html/library/DBTech/Mail/XenForo/ControllerAdmin/Mail.php(32): DBTech_Mail_Application_Core->runAction()
#11 /home/nadda/public_html/library/XenForo/FrontController.php(351): DBTech_Mail_XenForo_ControllerAdmin_Mail->actionIndex()
#12 /home/nadda/public_html/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#13 /home/nadda/public_html/admin.php(13): XenForo_FrontController->run()
#14 {main}

Request State

array(3) {
["url"] => string(58) "http://www.nirmoladda.com/admin.php?dbtech-mail/newsletter"
["_GET"] => array(1) {
["dbtech-mail/newsletter"] => string(0) ""
}
["_POST"] => array(9) {
["newsletter"] => array(9) {
["title"] => string(10) "Newsletter"
["introduction"] => string(0) ""
["active"] => string(1) "0"
["default_frequency"] => string(1) "1"
["onlypublic"] => string(1) "1"
["enableprediction"] => string(1) "1"
["numlatest"] => string(2) "-1"
["sortorder"] => string(4) "date"
["criteria"] => array(2) {
["last_activity"] => array(2) {
[0] => string(1) "0"
[1] => string(1) "0"
}
["total_posts"] => array(2) {
[0] => string(1) "0"
[1] => string(1) "0"
}
}
}
["action"] => string(6) "update"
["newsletterid"] => string(1) "1"
["_xfToken"] => string(8) "********"
["_xfRequestUri"] => string(62) "/admin.php?dbtech-mail/newsletter&action=modify&newsletterid=1"
["_xfNoRedirect"] => string(1) "1"
["_xfResponseType"] => string(4) "json"
["do"] => string(10) "newsletter"
["id"] => int(0)
}
}

 

[Fillip H.]

				ALTER TABLE `xf_dbtech_mail_newsletter`
					ADD `criteria` mediumblob

will resolve that

 

[Nirjonadda]

Can I import xml to fixing on this issue?

 

[Fillip H.]

No, the fix will not be in the release product until Monday's update.

 

[DragonByte Technologies]

Hello Nirjonadda,

This ticket has now been closed with the status Fixed.

We hope your issue or question has been addressed to your satisfaction. If not, please feel free to re-open it by clicking this link.

If you have any further issues or questions, please feel free to start a new support ticket via the button at the top of every page.

Thank you!