Social Connect (for Facebook and Twitter) [Deleted]

Hi @Chris D - I recently deleted this add-on and I am getting these errors:

@Brogan locked the thread immediately and wanted me to post here before I could say that I was not sure this is the cause. Anyway, do you have any idea? I tried repairing the database and errors still come up on registration.

Code:
Zend_Db_Statement_Mysqli_Exception: Mysqli prepare error: Unknown column 'social_tokens' in 'field list' - library/Zend/Db/Statement/Mysqli.php:77
Generated By: Unknown Account, A moment ago
Stack Trace
#0 /home/queee/public_html/forums/library/Zend/Db/Statement.php(115): Zend_Db_Statement_Mysqli->_prepare('INSERT INTO `xf...')
#1 /home/queee/public_html/forums/library/Zend/Db/Adapter/Mysqli.php(381): Zend_Db_Statement->__construct(Object(Zend_Db_Adapter_Mysqli), 'INSERT INTO `xf...')
#2 /home/queee/public_html/forums/library/Zend/Db/Adapter/Abstract.php(478): Zend_Db_Adapter_Mysqli->prepare('INSERT INTO `xf...')
#3 /home/queee/public_html/forums/library/Zend/Db/Adapter/Abstract.php(574): Zend_Db_Adapter_Abstract->query('INSERT INTO `xf...', Array)
#4 /home/queee/public_html/forums/library/XenForo/DataWriter.php(1638): Zend_Db_Adapter_Abstract->insert('xf_user', Array)
#5 /home/queee/public_html/forums/library/XenForo/DataWriter.php(1627): XenForo_DataWriter->_insert()
#6 /home/queee/public_html/forums/library/XenForo/DataWriter.php(1419): XenForo_DataWriter->_save()
#7 /home/queee/public_html/forums/library/XenForo/ControllerPublic/Register.php(416): XenForo_DataWriter->save()
#8 /home/queee/public_html/forums/library/UserEss/ControllerPublic/Register.php(68): XenForo_ControllerPublic_Register->actionRegister()
#9 /home/queee/public_html/forums/library/XenForo/FrontController.php(351): UserEss_ControllerPublic_Register->actionRegister()
#10 /home/queee/public_html/forums/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#11 /home/queee/public_html/forums/index.php(13): XenForo_FrontController->run()
#12 {main}
Request State
array(3) {
  ["url"] => string(52) "http://que-ee.com/forums/index.php?register/register"
  ["_GET"] => array(1) {
    ["register/register"] => string(0) ""
  }
  ["_POST"] => array(14) {
    ["username"] => string(0) ""
    ["0916d8d4c238cc0c6f043bf070af7316"] => string(8) "TestTest"
    ["1135acf2c10b764fafbad03a1e8bd3d4"] => string(17) "dddyack@yahoo.com"
    ["b5aa15f973009b02ca645cb6512289d3"] => string(4) "male"
    ["dob_month"] => string(1) "7"
    ["dob_day"] => string(2) "24"
    ["dob_year"] => string(4) "1966"
    ["17183252833b6588b53f8253031e033b"] => array(1) {
      ["nzk2yjuzy2u"] => string(0) ""
    }
    ["custom_fields_shown"] => array(1) {
      [0] => string(11) "nzk2yjuzy2u"
    }
    ["c8f03f0db27ac9e1815d5270a8301a83"] => string(16) "America/New_York"
    ["g-recaptcha-response"] => string(974) "03AHJ_VutlF5qnYk1G64t4BZQKORpeoUfIhukivL8qHLyIBcIuPppQyy7nZde8PRktc0FsIxuRacRjDq-OM6MwcPColERmBUkVglRV5Ay6nEl1kLugPEnkQlI7j2-bAn_iD_SzyT3K1RuA-3fv7hALrCvgeG-gUFft5W-6qtLD8PycoT-uzMH-EMbf-DWl6qxirF3asCCJqSO1U323FQ_AcaCtR_9wGxxC6A8rXE774xjPEbneKL5GBQDrCMwuthfs1oyHp5Bjk36aYC_N_J8L79DDOdWf24J2bRPhTUxV0oLm-u_x3HkEaiUW43_AsphatGYSEsP5TdZY3qh6kCqgUoUsdPv3lELwCWq6chyrosfyb7nTI1F9Cs3PLciVs4uVXc3HHDXhk_jHMiWxgaApQ5CJIi4-OduUVQX7TJAVtm_2rEYq0r3ubaFCSgTqqXWc0mXmlxjxhEB4quBLijx1RVWRBkPdV593L9t2On6Nu1-FUI3NoR-fdEvFch7iFTyY722d2x9jcSQ0nq6uMNQpFK11eLNWkRDq6m_ONvcUPn2mb4ICpYdxpGyaj3AwsFmASPkTm1uQjbzjCZqvmWldXO2_3DhcW-tu7JxVAloiw6StV6DrqEPo_gVA_skt2Lrnc58fLcWBX5GEx01L5FRRHSJsO8i_dVMNuhTbeZq6V4pdtQ-breIos_9gPkn0WTiU2oOUQX-GI7eX7nKcsG2dnDXDJEb0eJtrxixtWKdGuXFJnp4w47ZDzqYZVq0fWZHOUo5oSTnohtm6nVKE4mlZh9qSZ831ty9PaiRPa_sEX9Y9dJuwuoMtRFjYOS-UGk7kU_dvtELCOE1ICXw81g3ujAw--NlTp6job_CHovD9a0c9m1lR1o7pZNS8g-7cXDsjMDWfj7OHKPf21rnStftMtAj-g4sl26fwiVRoYQ27JN4JgqS7qI_Ga7tBtPCtOWiJBjrQfMucmd_t"
    ["agree"] => string(1) "1"
    ["_xfToken"] => string(8) "********"
    ["reg_key"] => string(32) "796b53ce4bedc7ebb6bc855d96d7f6c1"
  }
}
 
As he should :)

Is the add-on still showing in the list of installed add-ons in your Admin CP?

It seems to me like it's still running code from the add-on.

Thanks for the quick response. Yah, I understand - just trying to get all the info out there about it. :)

We figured it out by looking at others who had the same problem (errors on the forum). We also had the Friend Inviter add-on installed and it used this field and didn't like the uninstall of Social Connect. When we disable friend inviter we can register again.
 
Last edited:
Aha. Yeah run this query:
Code:
ALTER TABLE xf_user ADD social_tokens mediumblob NULL AFTER warning_points

That should enable you to re-enable the FI add-on.
 
Probably not especially feasible. It was supported and maintained up to XF 1.3 and I suspect that the number of API changes since would require it to be a total rewrite, and that’s not something I would do for XF 1.5 at this stage.

You’d be better looking for an alternative.
 
Top Bottom