• 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

#1
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 ?
 

Chris D

XenForo developer
Staff member
#2
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'], 0, 65535), true),
The actual fix is slightly different, but this should get you going.
 
#3
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
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
 

Chris D

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

Chris D

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