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

Not a Bug Data too long for column 'album_description' at row 1

Discussion in 'Media Gallery Resolved Bugs' started by Bahrainfalcon, Nov 17, 2014.

  1. Bahrainfalcon

    Bahrainfalcon Member

    Hello,

    Importer from XFR User Albums

    Server Error

    Mysqli statement execute error : Data too long for column 'album_description' at row 1

    Zend_Db_Statement_Mysqli->_execute() in Zend/Db/Statement.php at line 297
    Zend_Db_Statement->execute() in Zend/Db/Adapter/Abstract.php at line 479
    Zend_Db_Adapter_Abstract->query() in Zend/Db/Adapter/Abstract.php at line 574
    Zend_Db_Adapter_Abstract->insert() in XenForo/DataWriter.php at line 1624
    XenForo_DataWriter->_insert() in XenForo/DataWriter.php at line 1613
    XenForo_DataWriter->_save() in XenForo/DataWriter.php at line 1405
    XenForo_DataWriter->save() in XenGallery/Model/Importers.php at line 26
    XenGallery_Model_Importers->importAlbum() in XenGallery/Importer/XFRUserAlbums.php at line 299
    XenGallery_Importer_XFRUserAlbums->_importAlbum() in XenGallery/Importer/XFRUserAlbums.php at line 199
    XenGallery_Importer_XFRUserAlbums->stepAlbums() in XenForo/Importer/Abstract.php at line 97
    XenForo_Importer_Abstract->runStep() in XenForo/ControllerAdmin/Import.php at line 187
    XenForo_ControllerAdmin_Import->_runStep() in XenForo/ControllerAdmin/Import.php at line 239
    XenForo_ControllerAdmin_Import->_startStep() in XenForo/ControllerAdmin/Import.php at line 182
    XenForo_ControllerAdmin_Import->actionStartStep() in XenForo/FrontController.php at line 347
    XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
    XenForo_FrontController->run() in /home/username/public_html/admin.php at line 13

    How can I fix this Errors ?
     
  2. Chris D

    Chris D XenForo Developer Staff Member

    If you are comfortable editing a line of PHP, then the fix that should work is in this file:

    library/XenGallery/Importer/XFRUserAlbums.php

    Find this line of code:
    PHP:
    'album_description' => XenForo_Helper_String::bbCodeStrip($album['description'], true),
    Change it to:
    PHP:
    'album_description' => XenForo_Helper_String::bbCodeStrip(substr($album['description'], 065535), true),
    The actual fix is slightly different, but this should get you going.
     
  3. Bahrainfalcon

    Bahrainfalcon Member

    Nothing Change, @Chris D



    Server Error
    Mysqli statement execute error : Data too long for column 'album_description' at row 1

    1. Zend_Db_Statement_Mysqli->_execute() in Zend/Db/Statement.php at line 297
    2. Zend_Db_Statement->execute() in Zend/Db/Adapter/Abstract.php at line 479
    3. Zend_Db_Adapter_Abstract->query() in Zend/Db/Adapter/Abstract.php at line 574
    4. Zend_Db_Adapter_Abstract->insert() in XenForo/DataWriter.php at line 1624
    5. XenForo_DataWriter->_insert() in XenForo/DataWriter.php at line 1613
    6. XenForo_DataWriter->_save() in XenForo/DataWriter.php at line 1405
    7. XenForo_DataWriter->save() in XenGallery/Model/Importers.php at line 26
    8. XenGallery_Model_Importers->importAlbum() in XenGallery/Importer/XFRUserAlbums.php at line 597
    9. XenGallery_Importer_XFRUserAlbums->_importAlbum() in XenGallery/Importer/XFRUserAlbums.php at line 397
    10. XenGallery_Importer_XFRUserAlbums->stepAlbums() in XenForo/Importer/Abstract.php at line 97
    11. XenForo_Importer_Abstract->runStep() in XenForo/ControllerAdmin/Import.php at line 187
    12. XenForo_ControllerAdmin_Import->_runStep() in XenForo/ControllerAdmin/Import.php at line 239
    13. XenForo_ControllerAdmin_Import->_startStep() in XenForo/ControllerAdmin/Import.php at line 182
    14. XenForo_ControllerAdmin_Import->actionStartStep() in XenForo/FrontController.php at line 347
    15. XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
    16. XenForo_FrontController->run() in /home/username/public_html/admin.php at line 13
     
  4. Bahrainfalcon

    Bahrainfalcon Member

    Dear @Chris D
    Importer from vBulletin Version 3.8.7 Error

    Server Error
    Mysqli statement execute error : Data too long for column 'album_description' at row 1

    1. Zend_Db_Statement_Mysqli->_execute() in Zend/Db/Statement.php at line 297
    2. Zend_Db_Statement->execute() in Zend/Db/Adapter/Abstract.php at line 479
    3. Zend_Db_Adapter_Abstract->query() in Zend/Db/Adapter/Abstract.php at line 574
    4. Zend_Db_Adapter_Abstract->insert() in XenForo/DataWriter.php at line 1624
    5. XenForo_DataWriter->_insert() in XenForo/DataWriter.php at line 1613
    6. XenForo_DataWriter->_save() in XenForo/DataWriter.php at line 1405
    7. XenForo_DataWriter->save() in XenGallery/Model/Importers.php at line 26
    8. XenGallery_Model_Importers->importAlbum() in XenGallery/Importer/vBulletin38x.php at line 331
    9. XenGallery_Importer_vBulletin38x->_importAlbum() in XenGallery/Importer/vBulletin38x.php at line 297
    10. XenGallery_Importer_vBulletin38x->stepAlbums() in XenForo/Importer/Abstract.php at line 97
    11. XenForo_Importer_Abstract->runStep() in XenForo/ControllerAdmin/Import.php at line 187
    12. XenForo_ControllerAdmin_Import->_runStep() in XenForo/ControllerAdmin/Import.php at line 239
    13. XenForo_ControllerAdmin_Import->_startStep() in XenForo/ControllerAdmin/Import.php at line 182
    14. XenForo_ControllerAdmin_Import->actionStartStep() in XenForo/FrontController.php at line 347
    15. XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
    16. XenForo_FrontController->run() in /home/username/public_html/admin.php at line 13
     
  5. Chris D

    Chris D XenForo Developer Staff Member

    I contacted you via your earlier ticket a few hours ago. There's not much more I can do without access to FTP and your Admin CP so please respond to the ticket.
     
  6. Bahrainfalcon

    Bahrainfalcon Member

    @Chris D, Have you received the details?
     
  7. Chris D

    Chris D XenForo Developer Staff Member

    The version of the database tables looks like it was from an older version of the Gallery.

    I have fixed the issue for you, though, and will respond to the ticket shortly with more information.
     

Share This Page