1.2 beta: Updating user leads to mysqlli errors

[Alpha1]

When I try to update a user, I am getting this error:

The following error occurred:
Mysqli prepare error: Unknown column 'comment.comment_id_id' in 'on clause'

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 XenGallery/Model/Comment.php at line 181
5. XenGallery_Model_Comment->batchUpdateLikeUser() in XenGallery/LikeHandler/Comment.php at line 47
6. XenGallery_LikeHandler_Comment->batchUpdateContentUser() in XenForo/Model/User.php at line 2503
7. XenForo_Model_User->changeContentUser() in XenForo/DataWriter/User.php at line 886
8. XenForo_DataWriter_User->_postSave() in XenForo/DataWriter.php at line 1392
9. XenForo_DataWriter->save() in XenForo/ControllerAdmin/User.php at line 510
10. XenForo_ControllerAdmin_User->actionSave() in XenForo/FrontController.php at line 335
11. XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 132
12. XenForo_FrontController->run() in /public_html/forum/admin.php at line 13

Error 5 and 6 seem to be related to XMG.

 

[Digital Doctor]

Database issue ?
http://xenforo.com/community/thread...own-column-thread-user_id-in-on-clause.29611/
http://xenforo.com/community/threads/unknown-column-user-user_id-in-on-clause.24947/
http://xenforo.com/community/threads/unknown-column-custom_fields-in-field-list.20936/

 

[Paul B]

This is a know bug fixed in beta 2.

Edit: Misread the backtrace, it's an XMG bug. I have informed Chris.

 

[Mike Edge]

Also seeing a lot of internal 500 errors that a refresh of the browser seems to fix.

 

[Digital Doctor]

When I try to update a user, I am getting this error:

The following error occurred:
Mysqli prepare error: Unknown column 'comment.comment_id_id' in 'on clause

Zend_Db_Adapter_Abstract->query() in XenGallery/Model/Comment.php at line 181
XenGallery_Model_Comment->batchUpdateLikeUser() in XenGallery/LikeHandler/Comment.php at line 47
XenGallery_LikeHandler_Comment->batchUpdateContentUser() in XenForo/Model/User.php at line 2503

-seems to be related to XMG.

XenGallery_Model_Comment gave this hit.

 

[Alpha1]

I do not have post ratings installed.

 

[Mike Edge]

I do not have post ratings installed.

xen gallery, not post rating

 

[Digital Doctor]

xmg

Chris Deeming updated Xen Media Gallery with a new update entry:

This update resolves an issue with updating user records in XenForo 1.2 Beta 1.



Read the rest of this update entry...

 

[Alpha1]

The XMG update fixes it.

xen gallery, not post rating

DigitalDoctor linked to a conflict between XMG and the post ratings addon.