Question groups addon breaks xf media gallery

moshbit

Member
Okay, so I've added an album category to the groups addon, but when i click on the 'save media' button i get the following error:

Code:
Mysqli prepare error: Unknown column 'social_group_id' 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 /home/nginx/domains/squattheplanet.com/public/internal_data/proxy_classes/XenForo_DataWriter__1490640306.php at line 1638
XFProxy_XenForo_DataWriter->_insert() in /home/nginx/domains/squattheplanet.com/public/internal_data/proxy_classes/XenForo_DataWriter__1490640306.php at line 1627
XFProxy_XenForo_DataWriter->_save() in /home/nginx/domains/squattheplanet.com/public/internal_data/proxy_classes/XenForo_DataWriter__1490640306.php at line 1419
XFProxy_XenForo_DataWriter->save() in XenGallery/ControllerPublic/Media.php at line 3195
XenGallery_ControllerPublic_Media->_associateAttachmentsAndMedia() in XenGallery/ControllerPublic/Media.php at line 2988
XenGallery_ControllerPublic_Media->actionSaveMedia() in Nobita/Teams/XenGallery/ControllerPublic/Media.php at line 81
Nobita_Teams_XenGallery_ControllerPublic_Media->actionSaveMedia() in XenForo/FrontController.php at line 351
XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
XenForo_FrontController->run() in /home/nginx/domains/squattheplanet.com/public/index.php at line 13

and when i navigate to my xfmg addon i get what appears to be the same error:

Code:
An exception occurred: Mysqli prepare error: Unknown column 'media.social_group_id' in 'on clause' in /home/nginx/domains/squattheplanet.com/public/library/Zend/Db/Statement/Mysqli.php on line 77

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 Nobita/Teams/XenGallery/Model/Comment.php at line 106
Nobita_Teams_XenGallery_Model_Comment->getCommentsForBlockOrFeed() in XenGallery/Callback.php at line 119
XenGallery_Callback::getCommentsForBlock() in XenForo/Template/Abstract.php at line 330
XenForo_Template_Abstract->callTemplateCallback() in /home/nginx/domains/squattheplanet.com/public/internal_data/templates/S.87,L.3,xengallery_category_wrapper.php at line 139
include() in XenForo/Template/Abstract.php at line 260
XenForo_Template_Abstract->_renderInternal() in XenForo/Template/Abstract.php at line 191
XenForo_Template_Abstract->render() in XenForo/Template/Public.php at line 110
XenForo_Template_Public->render() in XenForo/ViewRenderer/HtmlPublic.php at line 124
XenForo_ViewRenderer_HtmlPublic->renderContainer() in XenForo/FrontController.php at line 639
XenForo_FrontController->renderView() in XenForo/FrontController.php at line 158
XenForo_FrontController->run() in /home/nginx/domains/squattheplanet.com/public/index.php at line 13

so i am unable to upload images to group albums or view my gallery in xf. disabling the groups addon is the only thing that will let me use the xfmg again. what can i do to fix this?
 
Please manual run the following query will address the problem.
Code:
ALTER TABLE xengallery_media ADD COLUMN social_group_id int unsigned not null default 0
Code:
ALTER TABLE xengallery_media ADD INDEX social_group_id (social_group_id)
 
Please manual run the following query will address the problem.
Code:
ALTER TABLE xengallery_media ADD COLUMN social_group_id int unsigned not null default 0
Code:
ALTER TABLE xengallery_media ADD INDEX social_group_id (social_group_id)
Nobita
okay, i did that but it says zero rows affected. is that normal? output:

Code:
MariaDB [squattheplanet]> ALTER TABLE xengallery_media ADD COLUMN social_group_id int unsigned not null default 0
    -> ;
Query OK, 0 rows affected (0.04 sec)
Records: 0  Duplicates: 0  Warnings: 0

MariaDB [squattheplanet]> ALTER TABLE xengallery_media ADD INDEX social_group_id (social_group_id)
    -> ;
Query OK, 0 rows affected (0.01 sec)
Records: 0  Duplicates: 0  Warnings: 0

MariaDB [squattheplanet]> exit
 
Back
Top