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

Cannot Reproduce Error when Import forum vb

Discussion in 'Resolved Bug Reports' started by doobbe, Oct 25, 2010.

  1. doobbe

    doobbe Member

    I can't import from vb 3.8 to XF.

    Server Error

    Mysqli statement execute error : Incorrect string value: '\xA3v v' for column 'signature' at row 1

    1. Zend_Db_Statement_Mysqli->_execute() in C:\xampplite\htdocs\dev\xen\vibe\library\Zend\Db\Statement.php at line 292
    2. Zend_Db_Statement->execute() in C:\xampplite\htdocs\dev\xen\vibe\library\Zend\Db\Adapter\Abstract.php at line 468
    3. Zend_Db_Adapter_Abstract->query() in C:\xampplite\htdocs\dev\xen\vibe\library\Zend\Db\Adapter\Abstract.php at line 546
    4. Zend_Db_Adapter_Abstract->insert() in C:\xampplite\htdocs\dev\xen\vibe\library\XenForo\DataWriter.php at line 1490
    5. XenForo_DataWriter->_insert() in C:\xampplite\htdocs\dev\xen\vibe\library\XenForo\DataWriter.php at line 1479
    6. XenForo_DataWriter->_save() in C:\xampplite\htdocs\dev\xen\vibe\library\XenForo\DataWriter.php at line 1287
    7. XenForo_DataWriter->save() in C:\xampplite\htdocs\dev\xen\vibe\library\XenForo\Model\Import.php at line 391
    8. XenForo_Model_Import->importUser() in C:\xampplite\htdocs\dev\xen\vibe\library\XenForo\Importer\vBulletin.php at line 841
    9. XenForo_Importer_vBulletin->_importUser() in C:\xampplite\htdocs\dev\xen\vibe\library\XenForo\Importer\vBulletin.php at line 660
    10. XenForo_Importer_vBulletin->_importOrMergeUser() in C:\xampplite\htdocs\dev\xen\vibe\library\XenForo\Importer\vBulletin.php at line 458
    11. XenForo_Importer_vBulletin->stepUsers() in C:\xampplite\htdocs\dev\xen\vibe\library\XenForo\Importer\Abstract.php at line 77
    12. XenForo_Importer_Abstract->runStep() in C:\xampplite\htdocs\dev\xen\vibe\library\XenForo\ControllerAdmin\Import.php at line 161
    13. XenForo_ControllerAdmin_Import->_runStep() in C:\xampplite\htdocs\dev\xen\vibe\library\XenForo\ControllerAdmin\Import.php at line 105
    14. XenForo_ControllerAdmin_Import->actionImport() in C:\xampplite\htdocs\dev\xen\vibe\library\XenForo\FrontController.php at line 303
    15. XenForo_FrontController->dispatch() in C:\xampplite\htdocs\dev\xen\vibe\library\XenForo\FrontController.php at line 132
    16. XenForo_FrontController->run() in C:\xampplite\htdocs\dev\xen\vibe\admin.php at line 13
  2. doobbe

    doobbe Member

    Resolved! Delete all user signature, run this query:
    UPDATE usertextfield SET signature='';
  3. Dean

    Dean Well-Known Member

    Did you have anything strange in the signatures?

    (ours converted ok I believe, text only)
  4. doobbe

    doobbe Member

    I have +150k member with special characters in signatures
    Now with error :( :
    Mysqli statement execute error : Incorrect string value: '\xF4\x97\xAF\xB6j' for column 'custom_title' at row 1
  5. doobbe

    doobbe Member

    Resolved! Delete all user usertitle, run this query:
    UPDATE user SET usertitle='';
  6. Dean

    Dean Well-Known Member

    hmmm... I would look at these fields in the database:

    sigparsed & sigpic

    edit: I missed the 'title' error in the code box, thought you were still having trouble with sigs.

    What language is your forum?
  7. doobbe

    doobbe Member

    I use Englisgh for default language but username/usertitle post/content etc.. have vietnamese character.

    Dean likes this.
  8. Dean

    Dean Well-Known Member

    Thanks, that information may help someone else in the future (in case someone else has the same problem).
  9. Mike

    Mike XenForo Developer Staff Member

    The second error is already fixed, but I don't see how the first error could happen unless the error message was manually manipulated. What's shown isn't a valid UTF-8 character, but I can see that the signature is clearly converted to UTF-8.

Share This Page