@TeaCommerce support, is this something that's likely to cause "bad voodoo" elsewhere in the TC Codebase? - This was the only way I could see to fix the error.
I think your fix is perfectly fine and would likely be what we would have suggested. I personally have hit this problem before in other JSON based property editors such as Nested Content or Stacked Content and have raised this a few times with HQ.
Not sure if it has been upped in Core by default yet, but the only other option for us would be to modify the table for you in an install script, but I'd rather not be tweaking Core tables from our solution.
I'll try and look into this again to see if there has been any changes in Core around using ntext for data type values, but in the meantime the fix you've applied is more than ok.
Variant Property Type - Database Type Change?
I ran into a problem using the Variant Property type, whereby the node would not save at all.
I looked at the Logs, and it appeared that the JSON generated was too long to be saved to the DB.
To "Fix" this I changed a table in the Umbraco DB
@TeaCommerce support, is this something that's likely to cause "bad voodoo" elsewhere in the TC Codebase? - This was the only way I could see to fix the error.
Hey Paul,
I think your fix is perfectly fine and would likely be what we would have suggested. I personally have hit this problem before in other JSON based property editors such as Nested Content or Stacked Content and have raised this a few times with HQ.
Not sure if it has been upped in Core by default yet, but the only other option for us would be to modify the table for you in an install script, but I'd rather not be tweaking Core tables from our solution.
I'll try and look into this again to see if there has been any changes in Core around using ntext for data type values, but in the meantime the fix you've applied is more than ok.
Matt
is working on a reply...