Help Xengallery Possibly Blocking User Registration?

i just noticed today that i'm getting errors when people are trying to register an account on my message board. i haven't made any changes to either xengallery or anything having to do with user registation, yet im getting the error:

Code:

Zend_Db_Statement_Mysqli_Exception: Mysqli prepare error: Unknown column 'xengallery' in 'field list' - library/Zend/Db/Statement/Mysqli.php:77
Generated By: Unknown Account, A moment ago

not sure why it's complaining about xengallery?

here's the full error:

Code:

Zend_Db_Statement_Mysqli_Exception: Mysqli prepare error: Unknown column 'xengallery' in 'field list' - library/Zend/Db/Statement/Mysqli.php:77
Generated By: Unknown Account, A moment ago
Stack Trace

#0 /srv/www/squattheplanet.com/public_html/library/Zend/Db/Statement.php(115): Zend_Db_Statement_Mysqli->_prepare('INSERT INTO `xf...')
#1 /srv/www/squattheplanet.com/public_html/library/Zend/Db/Adapter/Mysqli.php(381): Zend_Db_Statement->__construct(Object(Zend_Db_Adapter_Mysqli), 'INSERT INTO `xf...')
#2 /srv/www/squattheplanet.com/public_html/library/Zend/Db/Adapter/Abstract.php(478): Zend_Db_Adapter_Mysqli->prepare('INSERT INTO `xf...')
#3 /srv/www/squattheplanet.com/public_html/library/Zend/Db/Adapter/Abstract.php(574): Zend_Db_Adapter_Abstract->query('INSERT INTO `xf...', Array)
#4 /srv/www/squattheplanet.com/public_html/library/XenForo/DataWriter.php(1612): Zend_Db_Adapter_Abstract->insert('xf_user_option', Array)
#5 /srv/www/squattheplanet.com/public_html/library/XenForo/DataWriter.php(1601): XenForo_DataWriter->_insert()
#6 /srv/www/squattheplanet.com/public_html/library/XenForo/DataWriter.php(1393): XenForo_DataWriter->_save()
#7 /srv/www/squattheplanet.com/public_html/library/XenForo/ControllerPublic/Register.php(294): XenForo_DataWriter->save()
#8 /srv/www/squattheplanet.com/public_html/library/XenForo/FrontController.php(337): XenForo_ControllerPublic_Register->actionRegister()
#9 /srv/www/squattheplanet.com/public_html/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#10 /srv/www/squattheplanet.com/public_html/index.php(13): XenForo_FrontController->run()
#11 {main}

Request State

array(3) {
  ["url"] => string(43) "http://squattheplanet.com/register/register"
  ["_GET"] => array(1) {
    ["/register/register"] => string(0) ""
  }
  ["_POST"] => array(12) {
    ["username"] => string(14) "testmefuckyeah"
    ["email"] => string(25) "matthewnderrick@gmail.com"
    ["password"] => string(8) "********"
    ["password_confirm"] => string(8) "********"
    ["dob_month"] => string(1) "1"
    ["dob_day"] => string(2) "01"
    ["dob_year"] => string(4) "1980"
    ["gender"] => string(0) ""
    ["timezone"] => string(19) "America/Los_Angeles"
    ["agree"] => string(1) "1"
    ["_xfToken"] => string(8) "********"
    ["reg_key"] => string(32) "19ef6609342b2cee5afb83672f2cbc14"
  }
}

as you can see from the data above, i tried registering a test account, and was met with an 'unknown server error', and wasn't able to complete registration.

this might be related to something else, but since "xengallery" was coming up, i thought I'd check here first. any advice would be super useful.

 

okay, i've done that, so i'm hoping registrations will be okay from here on out.

there's another major issue here though. it seems that due to this error, everyone that has registered for an account since i installed this plugin (sometime after nov 10th) has had their user accounts corrupted in some way. I already posted the issue with full details here:

http://xenforo.com/community/threads/editing-a-user-takes-me-to-create-new-user-instead.64453/

but the short version is that some of my users are now complaining that xenforo is saying their accounts have been deleted (when in fact upon checking, they have not). and whenever i try to check on someone's account, instead of being taken to the 'edit user' page, i am taken to the 'create new user' page, where i am unable to change any info on their account.

this is affecting around 150-200 accounts that have been created since november 10th. i've attached a few images to show the create new user page:



any help would be awesome, since I have a lot of confused people on my website right now.

 

disabling xengallery has no effect on the user accounts that have been corrupted. ever since i added the xengallery table back into the mysql database as per your instructions, user registrations have been fine. so, my only conclusion is that the missing table caused the user account corruptions.

 

I just wanted to say that I too had the same error:

this was fixed by entering the suggested mysql query.