• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

member profile error

Brogan

XenForo moderator
Staff member
#4
It sounds like the data wasn't imported correctly.

Was it a vB import or from another forum software?
 

Brogan

XenForo moderator
Staff member
#6
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.
 

majdi

Well-known member
#7
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 !
 

majdi

Well-known member
#9
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" } }
 

Mike

XenForo developer
Staff member
#10
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.)
 

Mike

XenForo developer
Staff member
#12
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.
 

Mike

XenForo developer
Staff member
#15
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.