1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

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

Discussion in 'Resource Manager Support' started by santamo, Nov 16, 2013.

  1. 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) {
    }
    }
     
  2. Jeremy

    Jeremy XenForo Moderator Staff Member

    Did you reinstall or attempt to upgrade?
     
  3. santamo

    santamo Active Member

    upgrade - there are content
     
  4. Jeremy

    Jeremy XenForo Moderator Staff Member

  5. santamo

    santamo Active Member

    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'
     
  6. Jeremy

    Jeremy XenForo Moderator Staff Member

    Than you shouldn't be getting the error above. Have you retested?
     
  7. santamo

    santamo Active Member

    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
     
  8. santamo

    santamo Active Member

    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
     
  9. Jeremy

    Jeremy XenForo Moderator Staff Member

    Why are you attempting to drop tables?
     
  10. santamo

    santamo Active Member

    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) "********"
    }
    }
     
  11. borbole

    borbole Well-Known Member

    This is a strange error because the field reported as missing seems to exists as per your previous post when you attempted to recreate it.
     
  12. santamo

    santamo Active Member

    I am nub. Well. I have copy. Now I shall backup.
     
  13. santamo

    santamo Active Member

    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: Nov 17, 2013
  14. borbole

    borbole Well-Known Member

    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.
     
  15. santamo

    santamo Active Member

    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?
     
  16. santamo

    santamo Active Member

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

    Attached Files:

  17. Mike

    Mike XenForo Developer Staff Member

    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.
     
  18. santamo

    santamo Active Member

    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: Nov 17, 2013
  19. santamo

    santamo Active Member

    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"
    }
     
  20. Jeremy

    Jeremy XenForo Moderator Staff Member

    What is your process for upgrading?
     

Share This Page