member profile error

not for all memebers
this one work fine: http://www.tunitech.net/forum/members/hotliner.103/

and another thing: most of my members are in the guest group
rolleyes.png
 
Is this a final/working installation or is it just testing at the moment?

If possible it would be good if you could do the IPB to vB import again and check/update the users and groups there before importing to XenForo.
 
i still have the vb copy, the same user profile is loading just fine and members are not in the guest group as it is the case with xf
ps: this is a live version, i need a quick solution !
 
Error Info​
Zend_Db_Statement_Mysqli_Exception: Mysqli statement execute error : Out of range value adjusted for column 'dob_day' at row 1 - library/Zend/Db/Statement/Mysqli.php:214
Generated By: Unknown Account, Yesterday at 4:15 PM
Stack Trace​
#0 /home/tunitech/domains/tunitech.net/public_html/xft2/library/Zend/Db/Statement.php(297): Zend_Db_Statement_Mysqli->_execute(Array) #1 /home/tunitech/domains/tunitech.net/public_html/xft2/library/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array) #2 /home/tunitech/domains/tunitech.net/public_html/xft2/library/Zend/Db/Adapter/Abstract.php(574): Zend_Db_Adapter_Abstract->query('INSERT INTO `xf...', Array) #3 /home/tunitech/domains/tunitech.net/public_html/xft2/library/XenForo/DataWriter.php(1500): Zend_Db_Adapter_Abstract->insert('xf_user_profile', Array) #4 /home/tunitech/domains/tunitech.net/public_html/xft2/library/XenForo/DataWriter.php(1489): XenForo_DataWriter->_insert() #5 /home/tunitech/domains/tunitech.net/public_html/xft2/library/XenForo/DataWriter.php(1291): XenForo_DataWriter->_save() #6 /home/tunitech/domains/tunitech.net/public_html/xft2/library/XenForo/Model/Import.php(415): XenForo_DataWriter->save() #7 /home/tunitech/domains/tunitech.net/public_html/xft2/library/XenForo/Importer/vBulletin.php(859): XenForo_Model_Import->importUser(4, Array, '') #8 /home/tunitech/domains/tunitech.net/public_html/xft2/library/XenForo/Importer/vBulletin.php(678): XenForo_Importer_vBulletin->_importUser(Array, Array) #9 /home/tunitech/domains/tunitech.net/public_html/xft2/library/XenForo/Importer/vBulletin.php(469): XenForo_Importer_vBulletin->_importOrMergeUser(Array, Array) #10 /home/tunitech/domains/tunitech.net/public_html/xft2/library/XenForo/Importer/Abstract.php(77): XenForo_Importer_vBulletin->stepUsers(0, Array) #11 /home/tunitech/domains/tunitech.net/public_html/xft2/library/XenForo/ControllerAdmin/Import.php(161): XenForo_Importer_Abstract->runStep(Object(XenForo_ControllerAdmin_Import), Object(XenForo_ImportSession), 'users', 0, Array) #12 /home/tunitech/domains/tunitech.net/public_html/xft2/library/XenForo/ControllerAdmin/Import.php(213): XenForo_ControllerAdmin_Import->_runStep(Object(XenForo_Importer_vBulletin), Object(XenForo_ImportSession), 'users', 0, Array) #13 /home/tunitech/domains/tunitech.net/public_html/xft2/library/XenForo/ControllerAdmin/Import.php(156): XenForo_ControllerAdmin_Import->_startStep(Object(XenForo_Importer_vBulletin), Object(XenForo_ImportSession), 'users', Array) #14 /home/tunitech/domains/tunitech.net/public_html/xft2/library/XenForo/FrontController.php(310): XenForo_ControllerAdmin_Import->actionStartStep() #15 /home/tunitech/domains/tunitech.net/public_html/xft2/library/XenForo/FrontController.php(132): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch)) #16 /home/tunitech/domains/tunitech.net/public_html/xft2/admin.php(13): XenForo_FrontController->run() #17 {main}
Request State​
array(3) { ["url"] => string(56) "http://www.tunitech.net/xft2/admin.php?import/start-step" ["_GET"] => array(1) { ["import/start-step"] => string(0) "" } ["_POST"] => array(3) { ["options"] => array(2) { ["mergeEmail"] => string(1) "1" ["_dummy"] => string(1) "1" } ["step"] => string(5) "users" ["_xfToken"] => string(53) "1,1298474136,a5e108e5dff016efe3eb0422f1a0cb289250a0d9" } }
 
That's the wrong error - it's from the importer issue that you reported. There *should* be a more recent one.

If not, add this to library/config.php:

$config['debug'] = true;

And go to the profile that errors for more info. (Remove the line after.)
 
That's spawned from the same error as before. Try these queries:

UPDATE xf_user_profile SET dob_month = 12 WHERE dob_month > 12;
UPDATE xf_user_profile SET dob_month = 1 WHERE dob_month < 1;
UPDATE xf_user_profile SET dob_day = 31 WHERE dob_day > 31;
UPDATE xf_user_profile SET dob_day = 1 WHERE dob_day < 1;

The fixes I make for the import issue will prevent this from occurring.
 
That would've occurred in your initial IPB to vB conversion, so it's not trivial to change after the fact except by editing the users in the admin CP.
 
Top Bottom