Fixed (1.2 Beta 5) Paid Subscription Error

[0ptima]

Got the following error when importing paid subscriptions from VB 3.8

Server Error

Mysqli statement execute error : Out of range value adjusted for column 'length_amount' 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 1612
XenForo_DataWriter->_insert() in XenForo/DataWriter.php at line 1601
XenForo_DataWriter->_save() in XenForo/DataWriter.php at line 1393
XenForo_DataWriter->save() in XenForo/Model/Import.php at line 591
XenForo_Model_Import->_importData() in XenForo/Model/Import.php at line 969
XenForo_Model_Import->importUserUpgradeDefinition() in XenForo/Importer/vBulletin.php at line 1477
XenForo_Importer_vBulletin->stepPaidSubscriptions() in XenForo/Importer/Abstract.php at line 77
XenForo_Importer_Abstract->runStep() in XenForo/ControllerAdmin/Import.php at line 180
XenForo_ControllerAdmin_Import->_runStep() in XenForo/ControllerAdmin/Import.php at line 232
XenForo_ControllerAdmin_Import->_startStep() in XenForo/ControllerAdmin/Import.php at line 175
XenForo_ControllerAdmin_Import->actionStartStep() in XenForo/FrontController.php at line 337
XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
XenForo_FrontController->run() in /home/public_html/xf/admin.php at line 13

 

[Mike]

Just out of curiosity, did you have a subscription length with a number value > 255? What did you set?

Our structure only supports a max of 255 for that, so it will have to be capped (which is now fixed).

 

[0ptima]

I remember vaguely changing the length of the description of the paid sub shown to the user (IE I added more info on what they were getting). Could that be the issue?

 

[Jeremy]

Yes. XenForo only supports 255 characters in their paid subscriptions.

 

[Mike]

No, not the data -- the length of the subscription itself. Did you enter it as "365 days" instead of "1 year", for example?

 

[0ptima]

Yes, it is set to 365 days. Do I need to update it on VB or can XF convert it?

 

[Mike]

It would be capped to 255 days in XF - you want 1 year.

 

[0ptima]

Thanks, I will look into fixing this on my end before converting.