Mysqli statement execute error : Out of range value for column 'expiry_date' 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/Model/UserChangeTemp.php at line 79
- XenForo_Model_UserChangeTemp->applyTempUserChange() in XenProduct/Model/Cart.php at line521
- XenProduct_Model_Cart->convertCartToLicenses() in XenProduct/ControllerPublic/Product.php at line590
- XenProduct_ControllerPublic_Product->actionConvertCart() in XenForo/FrontController.php at line347
- XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
- XenForo_FrontController->run() in /path/to/community/index.php at line 13
It's actually XenForo code throwing that error.
What was the expiry date of their order?
Discounts are tricky, but you could try setting the license_price in the xenproduct_license table and unit_price in the xenproduct_cart_item table.
license_price is what they paid, unit_price is what the original price was.
Valid from is the date they purchased.
Set it to 50 years or something like that. The field will be an unsigned INT so it will have a limit. The current time plus 100 years would exceed the value allowed on that field.This was my first attempt at converting, so I grabbed one from this week. It was a lifetime license - no expiration date - which I set to 100 years.
Do whatever is easier for you. Either populate the correct value now, or later.The sale prices varied. Would it be easier to convert then change the license_price in the database?
"Valid from" is more accurate. Who's to say it was actually "purchased"? It may have been a free product. When talking about licenses, they have a start date and an end date, usually valid from and valid to are ... validOK. As an idea "Purchased Date" or "Date of Purchase" ... might add clarity.
Will try.Set it to 50 years or something like that. The field will be an unsigned INT so it will have a limit. The current time plus 100 years would exceed the value allowed on that field.
OKDo whatever is easier for you. Either populate the correct value now, or later.
"Valid from" is more accurate. Who's to say it was actually "purchased"? It may have been a free product. When talking about licenses, they have a start date and an end date, usually valid from and valid to are ... valid
I think you should be able to set the product support duration to 0 I believe that would force it to never expire.This was my first attempt at converting, so I grabbed one from this week. It was a lifetime license - no expiration date - which I set to 100 years. [Clarification: I set the 100 years in the product item information]
I think you should be able to set the product support duration to 0 I believe that would force it to never expire.
Also, I just remembered that you could probably set the expiry date to 0 to make it permanent rather than setting a high number.
If your permissions are setup properly you should have an Edit Product button next to the "Add New Version" button.How do I edit a product description? I'm not updating the product to a new version but want to improve the description. There is 'add product' and 'add update' but I don't see an 'edit product.'
How do I edit a 'features' area? I'm not updating the product to a new version but want to change which bullet items are shown in the front.
Changed phrase xenproduct_products_tab to change navigation tab wording. Is there a better way?
When viewing a product you should see an Edit Product in the top right.
If you don't, then check permissions..
Run analyze permissions on yourself to make certain as well as trying a default style.
We use essential cookies to make this site work, and optional cookies to enhance your experience.