From vb 4.1.0 Import problems

[Sisterhood]

i come from vb 4.1.1 to xenforo


Importer to xenforo ok BUT the last import Attachment


Server Error

Mysqli statement execute error : Out of range value adjusted for column 'attach_count' at row 1

1. Zend_Db_Statement_Mysqli->_execute() in Zend/Db/Statement.php at line 292
2. Zend_Db_Statement->execute() in Zend/Db/Adapter/Abstract.php at line 479
3. Zend_Db_Adapter_Abstract->query() in XenForo/Model/Import.php at line 1016
4. XenForo_Model_Import->importPostAttachment() in XenForo/Importer/vBulletin4.php at line 3518
5. XenForo_Importer_vBulletin4->_makeAttachment() in XenForo/Importer/vBulletin4.php at line 2161
6. XenForo_Importer_vBulletin4->stepAttachments() in XenForo/Importer/Abstract.php at line 77
7. XenForo_Importer_Abstract->runStep() in XenForo/ControllerAdmin/Import.php at line 161
8. XenForo_ControllerAdmin_Import->_runStep() in XenForo/ControllerAdmin/Import.php at line 105
9. XenForo_ControllerAdmin_Import->actionImport() in XenForo/FrontController.php at line 310
10. XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 132
11. XenForo_FrontController->run() in /usr/www/users/xxx/xen/admin.php at line 13

 

[Jake Bunce]

It looks like the xf_post.attach_count field is overflowing.

I think that field represents the number of attachments in a post. Does your vB4 forum have a post with lots of attachments? xf_post.attach_count can accept counts up to 65535.

 

[Sisterhood]

yes is a big forums with many many attachments....and now?

#0 /usr/www/users/xxx/xen/library/Zend/Db/Statement.php(292): Zend_Db_Statement_Mysqli->_execute(Array)
#1 /usr/www/users/xxx/xen/library/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#2 /usr/www/users/xxx/xen/library/XenForo/Model/Import.php(1016): Zend_Db_Adapter_Abstract->query('????UPDATE xf_p...', '56529')
#3 /usr/www/users/xxxx/xen/library/XenForo/Importer/vBulletin4.php(3518): XenForo_Model_Import->importPostAttachment(9872, 'Bellevue - Bil...', '/usr/www/users/...', '7375', '56529', 1251792220, Array)
#4 /usr/www/users/xxxx/xen/library/XenForo/Importer/vBulletin4.php(2161): XenForo_Importer_vBulletin4->_makeAttachment(Array, Array)
#5 /usr/www/users/xxx/xen/library/XenForo/Importer/Abstract.php(77): XenForo_Importer_vBulletin4->stepAttachments(9865, Array)
#6 /usr/www/users/xxx/xen/library/XenForo/ControllerAdmin/Import.php(161): XenForo_Importer_Abstract->runStep(Object(XenForo_ControllerAdmin_Import), Object(XenForo_ImportSession), 'attachments', 9865, Array)
#7 /usr/www/users/xxx/xen/library/XenForo/ControllerAdmin/Import.php(105): XenForo_ControllerAdmin_Import->_runStep(Object(XenForo_Importer_vBulletin4), Object(XenForo_ImportSession), 'attachments', 9865, Array)
#8 /usr/www/users/xxx/xen/library/XenForo/FrontController.php(310): XenForo_ControllerAdmin_Import->actionImport()
#9 /usr/www/users/xxx/xen/library/XenForo/FrontController.php(132): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#10 /usr/www/users/xxx/xen/admin.php(13): XenForo_FrontController->run()
#11 {main}

 

[Sisterhood]

the stuff help not in beta

 

[Paul B]

You could try changing the xf_post.attach_count to smallint(6).

I'll check with Mike if this will cause any issues.

Edit: Apparently that won't help, Mike's looking into it though.

 

[Mike]

You have a single post with 65000 attachments? Wow... You could change the column to int (instead of smallint).

 

[Sisterhood]

someone from the team login on my board (ftp) and help me? I wanted to open 1.1 my forums with xenForo. please

 

[Jake Bunce]

someone from the team login on my board (ftp) and help me? I wanted to open 1.1 my forums with xenForo. please

I would do as Mike suggests and change the definition of the xf_post.attach_count field in the database. You can do this using a program like phpmyadmin. Or run this query on your database to make the change:

ALTER TABLE xf_post MODIFY attach_count INT UNSIGNED NOT NULL DEFAULT 0

 

[Sisterhood]

Jake

Works!!! Thank you very very much!!!!!!!!! Perfect!

 

[Vincent]

vBulletin is the only board running vBulletin 4.1.1, are they finally turning it xenForo?

Or are you a Beta-Tester?

 

[Sisterhood]

) sorry mean 4.1


http://www.kirmesforum.de

 

[Sadik B]

Wow a single post with more than 65535 attachments! Could you share the link to that? Now that would be something to see...

 

[Dean]

) sorry mean 4.1

and now my big boards is running with xenforo bye bye vbulletin

kirmesforum.de

I was confused as well, I'll change the title (4.1.1 -> 4.1.0) to avoid confusion.

 

[Vincent]

Wow a single post with more than 65535 attachments! Could you share the link to that? Now that would be something to see...

He just uploaded all the files on his computer
Including the Windows ones