member profile error

Brogan

XenForo moderator
Staff member
Is this for all members?

Is there anything in the ACP server error log or the apache log?
 

Brogan

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

Was it a vB import or from another forum software?
 

Brogan

XenForo moderator
Staff member
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
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
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
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
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
Additionally, take that debug mode line out. You don't want to leave it on a production server. :)
 

Mike

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