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

[Bahrainfalcon]

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]

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:

'album_description' => XenForo_Helper_String::bbCodeStrip($album['description'], true),

Change it to:

'album_description' => XenForo_Helper_String::bbCodeStrip(substr($album['description'], 0, 65535), true),

The actual fix is slightly different, but this should get you going.

 

[Bahrainfalcon]

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

 

[Bahrainfalcon]

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]

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.

 

[Bahrainfalcon]

@Chris D, Have you received the details?

 

[Chris D]

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.