RM 1.2 Showing server errors when eiditng resource

PAPPACLART · Dec 1, 2015

Hello Updated to Xenforo 1.5.2 recently and yesterday updated the resource manager to the latest version.

When editing the resource itself or the resource icon I get the below errors. I did have waindigo resource icon plugin but I have disabled it. Do not know if it makes a difference but the server the site is hosted on was migrated from a Plesk panel to Cpanel.

Any suggestions would be great. Thanks in advance

Server Error (When editing resource Icon)
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 632
Zend_Db_Adapter_Abstract->update() in XenForo/DataWriter.php at line 1640
XenForo_DataWriter->_update() in XenForo/DataWriter.php at line 1609
XenForo_DataWriter->_save() in XenForo/DataWriter.php at line 1405
XenForo_DataWriter->save() in XenResource/Model/Resource.php at line 1432
XenResource_Model_Resource->applyResourceIcon() in XenResource/Model/Resource.php at line 1338
XenResource_Model_Resource->uploadResourceIcon() in XenResource/ControllerPublic/Resource.php at line 1348
XenResource_ControllerPublic_Resource->actionIcon() in XenForo/FrontController.php at line 351
XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
XenForo_FrontController->run() in /home/gtarena/public_html/community/index.php at line 13

Server Error (When editing resource only)
Mysqli prepare error: Table 'ryanacock_xenforo.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 792
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 930
XenResource_ControllerPublic_Resource->actionEdit() in XenForo/FrontController.php at line 351
XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
XenForo_FrontController->run() in /home/gtarena/public_html/community/index.php at line 13

Chris D · Dec 1, 2015

As long as you're certain you actually ran the RM upgrade...

The upgrade likely failed to create all of the fields required due to having add-ons which had already added columns of the same name.

Run these queries separately in phpMyAdmin or similar - some of them may already exist.

Code:

ALTER TABLE xf_resource
   ADD custom_resource_fields MEDIUMBLOB NOT NULL

Code:

ALTER TABLE xf_resource
   ADD prefix_id INT UNSIGNED NOT NULL DEFAULT 0,

Code:

ALTER TABLE xf_resource
   ADD icon_date INT UNSIGNED NOT NULL DEFAULT 0

Code:

ALTER TABLE xf_resource
   ADD KEY prefix_id (prefix_id)

Code:

CREATE TABLE IF NOT EXISTS `xf_resource_field` (
   field_id VARBINARY(25) NOT NULL,
   display_group VARCHAR(25) NOT NULL DEFAULT 'above_info',
   display_order INT UNSIGNED NOT NULL DEFAULT 1,
   field_type VARCHAR(25) NOT NULL DEFAULT 'textbox',
   field_choices BLOB NOT NULL,
   match_type VARCHAR(25) NOT NULL DEFAULT 'none',
   match_regex VARCHAR(250) NOT NULL DEFAULT '',
   match_callback_class VARCHAR(75) NOT NULL DEFAULT '',
   match_callback_method VARCHAR(75) NOT NULL DEFAULT '',
   max_length INT UNSIGNED NOT NULL DEFAULT 0,
   required TINYINT UNSIGNED NOT NULL DEFAULT 0,
   display_template TEXT NOT NULL,
   PRIMARY KEY (field_id),
   KEY display_group_order (display_group, display_order)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8

PAPPACLART · Dec 1, 2015

I for sure ran the upgrade correctly.

Thanks I will give that a go, though not to familiar with phpMyAdmin, but I have ran a queries before though it was a while ago.

Can't I just run the upgrade again or is that not advisable?

Thanks for your very quick response it is much appreciated

Paul B · Dec 1, 2015

Installer queries are set to fail silently, so the only way to do it is to manually run them.

PAPPACLART · Dec 1, 2015

Thanks @Brogan

PAPPACLART · Dec 1, 2015

To run query, I am guessing select correct database, click on the SQL tab, paste code in there then run it?

Chris D · Dec 1, 2015

Yep, should be pretty much it. Though first, I should have said earlier, please take a back up

PAPPACLART · Dec 1, 2015

Of all the messing around I have done with my sites and all the times I have broken them I have never taken a back up prior to doing updates and the like. I some how work out how to fix them lol I will take your advice though as my luck will soon run out haha

Thanks guys

PAPPACLART · Dec 7, 2015

I can now upload icons so that half worked thanks

Some of the SQL entries that you suggested I run did not work.

when editing the resource it now shows the below. Also I checked the table 'ryanacock_xenforo.xf_resource_field_category' does not exist in my database. Do I just create the Table or do I need some more code also?

Server Error
Mysqli prepare error: Table 'ryanacock_xenforo.xf_resource_field_category' 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 794
XenResource_ControllerPublic_Resource->_getResourceAddOrEditResponse() in XenResource/ControllerPublic/Resource.php at line 932
XenResource_ControllerPublic_Resource->actionEdit() in XenForo/FrontController.php at line 351
XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
XenForo_FrontController->run() in /home/gtarena/public_html/community/index.php at line 13

Chris D · Dec 7, 2015

This query should create it for you:

Code:

CREATE TABLE IF NOT EXISTS xf_resource_field_category (
    field_id VARBINARY(25) NOT NULL,
    resource_category_id INT NOT NULL,
    PRIMARY KEY (field_id, resource_category_id),
    KEY resource_category_id (resource_category_id)
) ENGINE = InnoDB CHARACTER SET utf8 COLLATE utf8_general_ci

PAPPACLART · Dec 8, 2015

Thanks @Chris D

Executed the above.

Now I have this error?

Mysqli prepare error: Table 'ryanacock_xenforo.xf_resource_field_value' 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 794
XenResource_ControllerPublic_Resource->_getResourceAddOrEditResponse() in XenResource/ControllerPublic/Resource.php at line 932
XenResource_ControllerPublic_Resource->actionEdit() in XenForo/FrontController.php at line 351
XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
XenForo_FrontController->run() in /home/gtarena/public_html/community/index.php at line 13

Not sure how long this tennis game will go on for lol

Really appreciate your help

Edit

these are some of the server errors that are showing up.

Chris D · Dec 8, 2015

Some of these will probably fail and that's fine:

Code:

ALTER TABLE xf_resource_category
   ADD field_cache MEDIUMBLOB NOT NULL

Code:

ALTER TABLE xf_resource_category
   DROP allow_submit_user_group_ids

Code:

ALTER TABLE xf_resource_category
   ADD prefix_cache MEDIUMBLOB NOT NULL COMMENT 'Serialized data from xf_resource_category_prefix, [group_id][prefix_id] => prefix_id'

Code:

ALTER TABLE xf_resource_category
   ADD require_prefix TINYINT UNSIGNED NOT NULL DEFAULT '0'

Code:

ALTER TABLE xf_resource_category
   ADD featured_count SMALLINT UNSIGNED NOT NULL DEFAULT '0'

And finally:

Code:

CREATE TABLE IF NOT EXISTS xf_resource_field_value (
   resource_id INT UNSIGNED NOT NULL,
   field_id VARBINARY(25) NOT NULL,
   field_value MEDIUMTEXT NOT NULL,
   PRIMARY KEY (resource_id, field_id),
   KEY field_id (field_id)
) ENGINE = InnoDB CHARACTER SET utf8 COLLATE utf8_general_ci

Mike · Dec 8, 2015

Are you sure you actually "upgraded" the RM? What version is it showing in the control panel? It appears that none of the upgrade steps have actually run.

PAPPACLART · Dec 8, 2015

Wow that worked

Thank-You very much, great support

Edit

Yes it shows 1.2.2

RM 1.2 Showing server errors when eiditng resource

PAPPACLART

Active member

Chris D

XenForo developer

PAPPACLART

Active member

Paul B

XenForo moderator

PAPPACLART

Active member

PAPPACLART

Active member

Chris D

XenForo developer

PAPPACLART

Active member

PAPPACLART

Active member

Chris D

XenForo developer

PAPPACLART

Active member

Chris D

XenForo developer

Mike

XenForo developer

PAPPACLART

Active member

Similar threads

We value your privacy