RM 1.1 Unknown column 'icon_date' in 'field list'

santamo

santamo

Active member
Deleted addon Waindigo, reinstalled the resource manager (1.1.0)

Zend_Db_Statement_Mysqli_Exception:Mysqli prepare error: Table 'sm42_forum.xf_resource_field' doesn't exist -library/Zend/Db/Statement/Mysqli.php:77
Сгенерирована пользователем:админ,только что
Трассировка стэка
#0 /home/s/sm42/forum.xxx.su/public_html/library/Zend/Db/Statement.php(115): Zend_Db_Statement_Mysqli->_prepare('?????SELECT res...')
#1 /home/s/sm42/forum.xxx.su/public_html/library/Zend/Db/Adapter/Mysqli.php(381): Zend_Db_Statement->__construct(Object(Zend_Db_Adapter_Mysqli), '?????SELECT res...')
#2 /home/s/sm42/forum.xxx.su/public_html/library/Zend/Db/Adapter/Abstract.php(478): Zend_Db_Adapter_Mysqli->prepare('?????SELECT res...')
#3 /home/s/sm42/forum.xxx.su/public_html/library/XenForo/Model.php(219): Zend_Db_Adapter_Abstract->query('?????SELECT res...', Array, 2)
#4 /home/s/sm42/forum.xxx.su/public_html/library/XenResource/Model/ResourceField.php(78): XenForo_Model->fetchAllKeyed('?????SELECT res...', 'field_id')
#5 /home/s/sm42/forum.xxx.su/public_html/library/XenResource/Model/ResourceField.php(55): XenResource_Model_ResourceField->getResourceFields(Array, Array)
#6 /home/s/sm42/forum.xxx.su/public_html/library/XenResource/ControllerPublic/Resource.php(737): XenResource_Model_ResourceField->getResourceFieldsForEdit(15, 0)
#7 /home/s/sm42/forum.xxx.su/public_html/library/XenResource/ControllerPublic/Resource.php(839): XenResource_ControllerPublic_Resource->_getResourceAddOrEditResponse(Array, Array)
#8 /home/s/sm42/forum.xxx.su/public_html/library/XenForo/FrontController.php(337): XenResource_ControllerPublic_Resource->actionAdd()
#9 /home/s/sm42/forum.xxx.su/public_html/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#10 /home/s/sm42/forum.xxx.su/public_html/index.php(13): XenForo_FrontController->run()
#11 {main}
Содержимое запроса
array(3) {
["url"] => string(62) "http://forum.xxx.su/resources/add?resource_category_id=15"
["_GET"] => array(1) {
["resource_category_id"] => string(2) "15"
}
["_POST"] => array(0) {
}
}
 
Sort by date Sort by votes
ALTER TABLE xf_resource
ADD custom_resource_fields MEDIUMBLOB NOT NULL,
ADD prefix_id INT UNSIGNED NOT NULL DEFAULT 0,
ADD icon_date INT UNSIGNED NOT NULL DEFAULT 0,
ADD KEY prefix_id (prefix_id)
---------------------------------------
#1060 - Duplicate column name 'custom_resource_fields'
 
Upvote 0 Downvote
ALTER TABLE xf_resource_category
ADD field_cache MEDIUMBLOB NOT NULL,
DROP allow_submit_user_group_ids,
ADD prefix_cache MEDIUMBLOB NOT NULL COMMENT 'Serialized data from xf_resource_category_prefix, [group_id][prefix_id] => prefix_id',
ADD require_prefix TINYINT UNSIGNED NOT NULL DEFAULT '0',
ADD featured_count SMALLINT UNSIGNED NOT NULL DEFAULT '0'
-------------------------------------
#1091 - Can't DROP 'allow_submit_user_group_ids'; check that column/key exists
 
Upvote 0 Downvote
ysqli prepare error: Unknown column 'custom_resource_fields' in 'field list'
  1. Zend_Db_Statement_Mysqli->_prepare() in Zend/Db/Statement.php at line 115
  2. Zend_Db_Statement->__construct() in Zend/Db/Adapter/Mysqli.php at line 381
  3. Zend_Db_Adapter_Mysqli->prepare() in Zend/Db/Adapter/Abstract.php at line 478
  4. Zend_Db_Adapter_Abstract->query() in Zend/Db/Adapter/Abstract.php at line 574
  5. Zend_Db_Adapter_Abstract->insert() in XenForo/DataWriter.php at line 1612
  6. XenForo_DataWriter->_insert() in XenForo/DataWriter.php at line 1601
  7. XenForo_DataWriter->_save() in XenForo/DataWriter.php at line 1393
  8. XenForo_DataWriter->save() in XenResource/ControllerPublic/Resource.php at line 1085
  9. XenResource_ControllerPublic_Resource->actionSave() in XenForo/FrontController.php at line 337
  10. XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
  11. XenForo_FrontController->run() in /home/s/sm42/forum.xxx.su/public_html/index.php at line 13
 
Upvote 0 Downvote
Yes. Updated RM

Zend_Db_Statement_Mysqli_Exception:Mysqli prepare error: Table 'sm42_forum.xf_resource_field' doesn't exist -library/Zend/Db/Statement/Mysqli.php:77
Сгенерирована пользователем:админ,только что
Трассировка стэка
#0 /home/s/sm42/forum.xx.su/public_html/library/Zend/Db/Statement.php(115): Zend_Db_Statement_Mysqli->_prepare('?????SELECT res...')
#1 /home/s/sm42/forum.xxx.su/public_html/library/Zend/Db/Adapter/Mysqli.php(381): Zend_Db_Statement->__construct(Object(Zend_Db_Adapter_Mysqli), '?????SELECT res...')
#2 /home/s/sm42/forum.xxx.su/public_html/library/Zend/Db/Adapter/Abstract.php(478): Zend_Db_Adapter_Mysqli->prepare('?????SELECT res...')
#3 /home/s/sm42/forum.xxx.su/public_html/library/XenForo/Model.php(219): Zend_Db_Adapter_Abstract->query('?????SELECT res...', Array, 2)
#4 /home/s/sm42/forum.xxx.su/public_html/library/XenResource/Model/ResourceField.php(78): XenForo_Model->fetchAllKeyed('?????SELECT res...', 'field_id')
#5 /home/s/sm42/forum.xxx.su/public_html/library/XenResource/Model/ResourceField.php(55): XenResource_Model_ResourceField->getResourceFields(Array, Array)
#6 /home/s/sm42/forum.xxx.su/public_html/library/XenResource/ControllerPublic/Resource.php(737): XenResource_Model_ResourceField->getResourceFieldsForEdit(32, 0)
#7 /home/s/sm42/forum.xxx.su/public_html/library/XenResource/ControllerPublic/Resource.php(839): XenResource_ControllerPublic_Resource->_getResourceAddOrEditResponse(Array, Array)
#8 /home/s/sm42/forum.xxx.su/public_html/library/XenForo/FrontController.php(337): XenResource_ControllerPublic_Resource->actionAdd()
#9 /home/s/sm42/forum.xxx.su/public_html/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#10 /home/s/sm42/forum.xxx.su/public_html/index.php(13): XenForo_FrontController->run()
#11 {main}
Содержимое запроса
array(3) {
["url"] => string(38) "http://forum.xxx.su/resources/add"
["_GET"] => array(0) {
}
["_POST"] => array(2) {
["resource_category_id"] => string(2) "32"
["_xfToken"] => string(8) "********"
}
}
 
Upvote 0 Downvote
Update MR:

Mysqli prepare error: Unknown column 'icon_date' in 'field list'
Zend_Db_Statement_Mysqli->_prepare() in Zend/Db/Statement.php at line 115
Zend_Db_Statement->__construct() in Zend/Db/Adapter/Mysqli.php at line 381
Zend_Db_Adapter_Mysqli->prepare() in Zend/Db/Adapter/Abstract.php at line 478
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 1612
XenForo_DataWriter->_insert() in XenForo/DataWriter.php at line 1601
XenForo_DataWriter->_save() in XenForo/DataWriter.php at line 1393
XenForo_DataWriter->save() in XenResource/ControllerPublic/Resource.php at line 1085
XenResource_ControllerPublic_Resource->actionSave() in Tinhte/XenTag/XenResource/ControllerPublic/Resource.php at line 28
Tinhte_XenTag_XenResource_ControllerPublic_Resource->actionSave() in XenForo/FrontController.php at line 337
XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
XenForo_FrontController->run() in /home/s/sm42/forum.xxx.su/public_html/index.php at line 13
=======================================================


Uninstall addon Waindigo (custom field):


Mysqli prepare error: Table 'sm42_forum.xf_resource_field' doesn't exist

Zend_Db_Statement_Mysqli->_prepare() in Zend/Db/Statement.php at line 115
Zend_Db_Statement->__construct() in Zend/Db/Adapter/Mysqli.php at line 381
Zend_Db_Adapter_Mysqli->prepare() in Zend/Db/Adapter/Abstract.php at line 478
Zend_Db_Adapter_Abstract->query() in XenForo/Model.php at line 219
XenForo_Model->fetchAllKeyed() in XenResource/Model/ResourceField.php at line 78
XenResource_Model_ResourceField->getResourceFields() in XenResource/Model/ResourceField.php at line 55
XenResource_Model_ResourceField->getResourceFieldsForEdit() in XenResource/ControllerPublic/Resource.php at line 737
XenResource_ControllerPublic_Resource->_getResourceAddOrEditResponse() in Tinhte/XenTag/XenResource/ControllerPublic/Resource.php at line 8
Tinhte_XenTag_XenResource_ControllerPublic_Resource->_getResourceAddOrEditResponse() in XenResource/ControllerPublic/Resource.php at line 839
XenResource_ControllerPublic_Resource->actionAdd() in XenForo/FrontController.php at line 337
XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
XenForo_FrontController->run() in /home/s/sm42/forum.xxx.su/public_html/index.php at line 13
=====================================================

Update MR:

Mysqli prepare error: Table 'sm42_forum.xf_resource_field' doesn't exist

Zend_Db_Statement_Mysqli->_prepare() in Zend/Db/Statement.php at line 115
Zend_Db_Statement->__construct() in Zend/Db/Adapter/Mysqli.php at line 381
Zend_Db_Adapter_Mysqli->prepare() in Zend/Db/Adapter/Abstract.php at line 478
Zend_Db_Adapter_Abstract->query() in XenForo/Model.php at line 219
XenForo_Model->fetchAllKeyed() in XenResource/Model/ResourceField.php at line 78
XenResource_Model_ResourceField->getResourceFields() in XenResource/Model/ResourceField.php at line 55
XenResource_Model_ResourceField->getResourceFieldsForEdit() in XenResource/ControllerPublic/Resource.php at line 737
XenResource_ControllerPublic_Resource->_getResourceAddOrEditResponse() in Tinhte/XenTag/XenResource/ControllerPublic/Resource.php at line 8
Tinhte_XenTag_XenResource_ControllerPublic_Resource->_getResourceAddOrEditResponse() in XenResource/ControllerPublic/Resource.php at line 839
XenResource_ControllerPublic_Resource->actionAdd() in XenForo/FrontController.php at line 337
XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
XenForo_FrontController->run() in /home/s/sm42/forum.xxx.su/public_html/index.php at line 13
==================================================

Install addon Waindigo (custom field):

Mysqli prepare error: Unknown column 'icon_date' in 'field list'
Zend_Db_Statement_Mysqli->_prepare() in Zend/Db/Statement.php at line 115
Zend_Db_Statement->__construct() in Zend/Db/Adapter/Mysqli.php at line 381
Zend_Db_Adapter_Mysqli->prepare() in Zend/Db/Adapter/Abstract.php at line 478
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 1612
XenForo_DataWriter->_insert() in XenForo/DataWriter.php at line 1601
XenForo_DataWriter->_save() in XenForo/DataWriter.php at line 1393
XenForo_DataWriter->save() in XenResource/ControllerPublic/Resource.php at line 1085
XenResource_ControllerPublic_Resource->actionSave() in Tinhte/XenTag/XenResource/ControllerPublic/Resource.php at line 28
Tinhte_XenTag_XenResource_ControllerPublic_Resource->actionSave() in XenForo/FrontController.php at line 337
XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
XenForo_FrontController->run() in /home/s/sm42/forum.xxx.su/public_html/index.php at line 13
============================================================================================




ALTER TABLE xf_resource DROP custom_resource_fields

ALTER TABLE xf_resource_category DROP field_cache

Update MR:


Mysqli prepare error: Unknown column 'custom_resource_fields' in 'field list'
Zend_Db_Statement_Mysqli->_prepare() in Zend/Db/Statement.php at line 115
Zend_Db_Statement->__construct() in Zend/Db/Adapter/Mysqli.php at line 381
Zend_Db_Adapter_Mysqli->prepare() in Zend/Db/Adapter/Abstract.php at line 478
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 1612
XenForo_DataWriter->_insert() in XenForo/DataWriter.php at line 1601
XenForo_DataWriter->_save() in XenForo/DataWriter.php at line 1393
XenForo_DataWriter->save() in XenResource/ControllerPublic/Resource.php at line 1085
XenResource_ControllerPublic_Resource->actionSave() in Tinhte/XenTag/XenResource/ControllerPublic/Resource.php at line 28
Tinhte_XenTag_XenResource_ControllerPublic_Resource->actionSave() in XenForo/FrontController.php at line 337
XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
XenForo_FrontController->run() in /home/s/sm42/forum.xxx.su/public_html/index.php at line 13
===============================================================================

update addon Waindigo (custom field):

Mysqli prepare error: Unknown column 'icon_date' in 'field list'
Zend_Db_Statement_Mysqli->_prepare() in Zend/Db/Statement.php at line 115
Zend_Db_Statement->__construct() in Zend/Db/Adapter/Mysqli.php at line 381
Zend_Db_Adapter_Mysqli->prepare() in Zend/Db/Adapter/Abstract.php at line 478
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 1612
XenForo_DataWriter->_insert() in XenForo/DataWriter.php at line 1601
XenForo_DataWriter->_save() in XenForo/DataWriter.php at line 1393
XenForo_DataWriter->save() in XenResource/ControllerPublic/Resource.php at line 1085
XenResource_ControllerPublic_Resource->actionSave() in Tinhte/XenTag/XenResource/ControllerPublic/Resource.php at line 28
Tinhte_XenTag_XenResource_ControllerPublic_Resource->actionSave() in XenForo/FrontController.php at line 337
XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
XenForo_FrontController->run() in /home/s/sm42/forum.xxx.su/public_html/index.php at line 13
=====================================================================

Update MR:

Mysqli prepare error: Unknown column 'icon_date' in 'field list'
Zend_Db_Statement_Mysqli->_prepare() in Zend/Db/Statement.php at line 115
Zend_Db_Statement->__construct() in Zend/Db/Adapter/Mysqli.php at line 381
Zend_Db_Adapter_Mysqli->prepare() in Zend/Db/Adapter/Abstract.php at line 478
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 1612
XenForo_DataWriter->_insert() in XenForo/DataWriter.php at line 1601
XenForo_DataWriter->_save() in XenForo/DataWriter.php at line 1393
XenForo_DataWriter->save() in XenResource/ControllerPublic/Resource.php at line 1085
XenResource_ControllerPublic_Resource->actionSave() in Tinhte/XenTag/XenResource/ControllerPublic/Resource.php at line 28
Tinhte_XenTag_XenResource_ControllerPublic_Resource->actionSave() in XenForo/FrontController.php at line 337
XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
XenForo_FrontController->run() in /home/s/sm42/forum.agniyoga.su/public_html/index.php at line 13

What can I do else?
 
Last edited:
Upvote 0 Downvote
From the error messages it looks like the XenTag mod is being the cause of the errors. Try to disable/uninstall it and give the upgrader another go.

If it still won''t work then imo it would be best to start a ticket at your customer desk about this.
 
Upvote 0 Downvote
deleted XenTag:

ysqli prepare error: Unknown column 'icon_date' in 'field list'
  1. Zend_Db_Statement_Mysqli->_prepare() in Zend/Db/Statement.php at line 115
  2. Zend_Db_Statement->__construct() in Zend/Db/Adapter/Mysqli.php at line 381
  3. Zend_Db_Adapter_Mysqli->prepare() in Zend/Db/Adapter/Abstract.php at line 478
  4. Zend_Db_Adapter_Abstract->query() in Zend/Db/Adapter/Abstract.php at line 574
  5. Zend_Db_Adapter_Abstract->insert() in XenForo/DataWriter.php at line 1612
  6. XenForo_DataWriter->_insert() in XenForo/DataWriter.php at line 1601
  7. XenForo_DataWriter->_save() in XenForo/DataWriter.php at line 1393
  8. XenForo_DataWriter->save() in XenResource/ControllerPublic/Resource.php at line 1085
  9. XenResource_ControllerPublic_Resource->actionSave() in Waindigo/Tabs/Extend/XenResource/ControllerPublic/Resource.php at line 42
  10. Waindigo_Tabs_Extend_XenResource_ControllerPublic_Resource->actionSave() in XenForo/FrontController.php at line 337
  11. XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
  12. XenForo_FrontController->run() in /home/s/sm42/forum.xxx.su/public_html/index.php at line 13
Maybe - Tabs by Wandigo?

deleted:
updated RM:




Zend_Db_Statement_Mysqli_Exception: Mysqli prepare error: Unknown column 'icon_date' in 'field list' - library/Zend/Db/Statement/Mysqli.php:77
Сгенерирована пользователем: админ, только что
Трассировка стэка
#0 /home/s/sm42/forum.xxx/public_html/library/Zend/Db/Statement.php(115): Zend_Db_Statement_Mysqli->_prepare('INSERT INTO `xf...')
#1 /home/s/sm42/forum.xxx/public_html/library/Zend/Db/Adapter/Mysqli.php(381): Zend_Db_Statement->__construct(Object(Zend_Db_Adapter_Mysqli), 'INSERT INTO `xf...')
#2 /home/s/sm42/forum.xxx/public_html/library/Zend/Db/Adapter/Abstract.php(478): Zend_Db_Adapter_Mysqli->prepare('INSERT INTO `xf...')
#3 /home/s/sm42/forum.xxx/public_html/library/Zend/Db/Adapter/Abstract.php(574): Zend_Db_Adapter_Abstract->query('INSERT INTO `xf...', Array)
#4 /home/s/sm42/forum.xxx/public_html/library/XenForo/DataWriter.php(1612): Zend_Db_Adapter_Abstract->insert('xf_resource', Array)
#5 /home/s/sm42/forum.xxx/public_html/library/XenForo/DataWriter.php(1601): XenForo_DataWriter->_insert()
#6 /home/s/sm42/forum.xxx/public_html/library/XenForo/DataWriter.php(1393): XenForo_DataWriter->_save()
#7 /home/s/sm42/forum.xxx/public_html/library/XenResource/ControllerPublic/Resource.php(1085): XenForo_DataWriter->save()
#8 /home/s/sm42/forum.xxx/public_html/library/XenForo/FrontController.php(337): XenResource_ControllerPublic_Resource->actionSave()
#9 /home/s/sm42/forum.xxx/public_html/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#10 /home/s/sm42/forum.xxx/public_html/index.php(13): XenForo_FrontController->run()
#11 {main}
Содержимое запроса
array(3) {
["url"] => string(39) "http://forum.xxx/resources/save"
["_GET"] => array(0) {
}
["_POST"] => array(15) {
["resource_category_id"] => string(2) "58"
["title"] => string(3) "hhh"
["version_string"] => string(0) ""
["tag_line"] => string(6) "hhhhhh"
["resource_file_type"] => string(4) "file"
["file_hash"] => string(32) "f8fbc9d2ffc8c98ee28d3befbaffe891"
["message_html"] => string(12) "<p>hhh</p>
"
["_xfRelativeResolver"] => string(38) "http://forum.xxx/resources/add"
["attachment_hash"] => string(32) "31bd1cc05f8c7476fb57fd16cef9695a"
["external_url"] => string(0) ""
["alt_support_url"] => string(0) ""
["_xfToken"] => string(8) "********"
["_xfRequestUri"] => string(14) "/resources/add"
["_xfNoRedirect"] => string(1) "1"
["_xfResponseType"] => string(4) "json"
}

Can I upload content, then reinstall first, and then loaded back?
 
Upvote 0 Downvote
Strange - I have deleted the Library by Wandigo, but there is a message indicating that the files are not correct.


In which table should be "column 'icon_date' in 'field list'"? May be self created such a field?


Generally the error remains. Don't know what else I can do.



Zend_Db_Statement_Mysqli_Exception: Mysqli prepare error: Unknown column 'icon_date' in 'field list' - library/Zend/Db/Statement/Mysqli.php:77
Сгенерирована пользователем: админ, 4 мин. назад
Трассировка стэка
#0 /home/s/sm42/forum.xxx.su/public_html/library/Zend/Db/Statement.php(115): Zend_Db_Statement_Mysqli->_prepare('INSERT INTO `xf...')
#1 /home/s/sm42/forum.xxx.su/public_html/library/Zend/Db/Adapter/Mysqli.php(381): Zend_Db_Statement->__construct(Object(Zend_Db_Adapter_Mysqli), 'INSERT INTO `xf...')
#2 /home/s/sm42/forum.xxx.su/public_html/library/Zend/Db/Adapter/Abstract.php(478): Zend_Db_Adapter_Mysqli->prepare('INSERT INTO `xf...')
#3 /home/s/sm42/forum.xxx.su/public_html/library/Zend/Db/Adapter/Abstract.php(574): Zend_Db_Adapter_Abstract->query('INSERT INTO `xf...', Array)
#4 /home/s/sm42/forum.xxx.su/public_html/library/XenForo/DataWriter.php(1612): Zend_Db_Adapter_Abstract->insert('xf_resource', Array)
#5 /home/s/sm42/forum.xxx.su/public_html/library/XenForo/DataWriter.php(1601): XenForo_DataWriter->_insert()
#6 /home/s/sm42/forum.xxx.su/public_html/library/XenForo/DataWriter.php(1393): XenForo_DataWriter->_save()
#7 /home/s/sm42/forum.xxx.su/public_html/library/XenResource/ControllerPublic/Resource.php(1085): XenForo_DataWriter->save()
#8 /home/s/sm42/forum.xxx.su/public_html/library/XenForo/FrontController.php(337): XenResource_ControllerPublic_Resource->actionSave()
#9 /home/s/sm42/forum.xxx.su/public_html/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#10 /home/s/sm42/forum.xxx.su/public_html/index.php(13): XenForo_FrontController->run()
#11 {main}
Содержимое запроса
array(3) {
["url"] => string(39) "http://forum.xxx.su/resources/save"
["_GET"] => array(0) {
}
["_POST"] => array(15) {
["resource_category_id"] => string(2) "58"
["title"] => string(3) "hhh"
["version_string"] => string(0) ""
["tag_line"] => string(6) "hhhhhh"
["resource_file_type"] => string(4) "file"
["file_hash"] => string(32) "41ff51b03f08a6e18c153647bbb83001"
["message_html"] => string(12) "<p>hhh</p>
"
["_xfRelativeResolver"] => string(38) "http://forum.ччч.su/resources/add"
["attachment_hash"] => string(32) "a159e250bfd62d804c082df2870f5e34"
["external_url"] => string(0) ""
["alt_support_url"] => string(0) ""
["_xfToken"] => string(8) "********"
["_xfRequestUri"] => string(14) "/resources/add"
["_xfNoRedirect"] => string(1) "1"
["_xfResponseType"] => string(4) "json"
}
 

Attachments

  • 1111111.webp
    1111111.webp
    25.3 KB · Views: 3
Upvote 0 Downvote
I believe there's an update to Waindigo's mod that helps with the conflicts -- check for a newer version. But generally, if you have a backup (with RM 1.0), uninstall the custom fields add-on before updating the RM to 1.1.
 
Upvote 0 Downvote
I only have a copy of the RM to 1.1. Custom fields I have not added yet.

Deleted addon Waindigo, update RM:

Mysqli prepare error: Table 'sm42_forum.xf_resource_field' doesn't exist

  1. Zend_Db_Statement_Mysqli->_prepare() in Zend/Db/Statement.php at line 115
  2. Zend_Db_Statement->__construct() in Zend/Db/Adapter/Mysqli.php at line 381
  3. Zend_Db_Adapter_Mysqli->prepare() in Zend/Db/Adapter/Abstract.php at line 478
  4. Zend_Db_Adapter_Abstract->query() in XenForo/Model.php at line 219
  5. XenForo_Model->fetchAllKeyed() in XenResource/Model/ResourceField.php at line 78
  6. XenResource_Model_ResourceField->getResourceFields() in XenResource/Model/ResourceField.php at line 55
  7. XenResource_Model_ResourceField->getResourceFieldsForEdit() in XenResource/ControllerPublic/Resource.php at line 737
  8. XenResource_ControllerPublic_Resource->_getResourceAddOrEditResponse() in XenResource/ControllerPublic/Resource.php at line 839
  9. XenResource_ControllerPublic_Resource->actionAdd() in XenForo/FrontController.php at line 337
  10. XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
  11. XenForo_FrontController->run() in /home/s/sm42/forum.xxx.su/public_html/index.php at line 13
 
Last edited:
Upvote 0 Downvote
In the old copy of the XF:1.2.2 RM: 1.0.2 I removed all addons-related resources. Resources worked fine after that. Then updated to version XF: 1.2.3 and MR:1.1.0.
After that I can not add a resource:

Zend_Db_Statement_Mysqli_Exception: Mysqli prepare error: Unknown column 'custom_resource_fields' in 'field list' - library/Zend/Db/Statement/Mysqli.php:77
Сгенерирована пользователем: админ, только что
Трассировка стэка
#0 /home/s/sm42/forum.x.su/public_html/library/Zend/Db/Statement.php(115): Zend_Db_Statement_Mysqli->_prepare('INSERT INTO `xf...')
#1 /home/s/sm42/forum.x.su/public_html/library/Zend/Db/Adapter/Mysqli.php(381): Zend_Db_Statement->__construct(Object(Zend_Db_Adapter_Mysqli), 'INSERT INTO `xf...')
#2 /home/s/sm42/forum.x.su/public_html/library/Zend/Db/Adapter/Abstract.php(478): Zend_Db_Adapter_Mysqli->prepare('INSERT INTO `xf...')
#3 /home/s/sm42/forum.x.su/public_html/library/Zend/Db/Adapter/Abstract.php(574): Zend_Db_Adapter_Abstract->query('INSERT INTO `xf...', Array)
#4 /home/s/sm42/forum.x.su/public_html/library/XenForo/DataWriter.php(1612): Zend_Db_Adapter_Abstract->insert('xf_resource', Array)
#5 /home/s/sm42/forum.x.su/public_html/library/XenForo/DataWriter.php(1601): XenForo_DataWriter->_insert()
#6 /home/s/sm42/forum.x.su/public_html/library/XenForo/DataWriter.php(1393): XenForo_DataWriter->_save()
#7 /home/s/sm42/forum.x.su/public_html/library/XenResource/ControllerPublic/Resource.php(1085): XenForo_DataWriter->save()
#8 /home/s/sm42/forum.x.su/public_html/library/XenForo/FrontController.php(337): XenResource_ControllerPublic_Resource->actionSave()
#9 /home/s/sm42/forum.x.su/public_html/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#10 /home/s/sm42/forum.x.su/public_html/index.php(13): XenForo_FrontController->run()
#11 {main}
Содержимое запроса
array(3) {
["url"] => string(43) "http://www.forum.x.su/resources/save"
["_GET"] => array(0) {
}
["_POST"] => array(18) {
["resource_category_id"] => string(2) "32"
["prefix_id"] => string(1) "1"
["title"] => string(3) "rrr"
["version_string"] => string(0) ""
["tag_line"] => string(3) "rrr"
["resource_file_type"] => string(4) "file"
["file_hash"] => string(32) "04b386e852b1296bfbebd20f765394dc"
["custom_fields"] => array(1) {
["0001"] => string(11) "rrrrrrrrrrr"
}
["custom_fields_shown"] => array(1) {
[0] => string(4) "0001"
}
["message_html"] => string(25) "<p>ааааrrrrrrrr</p>
"
["_xfRelativeResolver"] => string(42) "http://www.forum.x.su/resources/add"
["attachment_hash"] => string(32) "d41386e3434a39f7f55fd5ad83f96dd5"
["external_url"] => string(0) ""
["alt_support_url"] => string(0) ""
["_xfToken"] => string(8) "********"
["_xfRequestUri"] => string(14) "/resources/add"
["_xfNoRedirect"] => string(1) "1"
["_xfResponseType"] => string(4) "json"
}
 
Upvote 0 Downvote
You must log in or register to reply here.

Similar threads

A
  • Question Question
XF 2.2 MySQL statement prepare error [1054]: Unknown column 'font_icon' in 'field list'
Replies
4
Views
274
amsaal
A
K
Unknown column 'poster_date' in 'field list' in src/xf/Db/AbstractStatement.php at line 230
Replies
0
Views
1K
kshefve
K
T
  • Locked
Not a bug Unknown column 'content_type' in 'field list' in src/XF/Db/AbstractStatement.php at line 212
Replies
1
Views
1K
Paul B
P
beaux
  • Solved
RM 2.2 XF\Db\Exception: MySQL statement prepare error [1054]: Unknown column 'xfa_rmmp_conf' in 'field list' in src/XF/Db/AbstractStatement.php at line 230
Replies
4
Views
2K
beaux
beaux
mokhtardz
  • Locked
Not a bug XF\Db\Exception: MySQL statement prepare error [1054]: Unknown column 'seo' in 'field list' in src/XF/Db/AbstractStatement.php at line 228
Replies
1
Views
3K
Paul B
P
Back
Top Bottom