BV Commerce Forum
»
BV Commerce Support
»
Development
»
Error updating Products using 'Product Batch Edit'
Rank: Member
Joined: 2/3/2010(UTC)
Posts: 68
Thanks: 5 times
|
I'm trying to change 'Product Template' to one of my Manufacturer. When I go to Catalog --- > 'Product Batch Edit' and Select one of my Manufacturer ---> change the 'Product Template' to BVc2013 and click Preview, I'm getting the attached error. Audit Log Error: Conversion from type 'DBNull' to type 'String' is not valid. michael_b attached the following image(s):  error.JPG (153kb) downloaded 1 time(s).You cannot view/download attachments. Try to login or register.
|
|
|
|
|
|
Rank: Administration
Joined: 4/2/2004(UTC) Posts: 2,393 ![United States]( "United States") Location: Hummelstown, PA Thanks: 6 times
Was thanked: 163 time(s) in 158 post(s)
|
It looks like you might have some bad data in your database. Specifically you may have some product records with a null CustomProperties field (i.e. bvc_Product.CustomProperties). Take a backup of your database (for safety) and then run the query below to clean it up: Code:
UPDATE bvc_Product
SET CustomProperties = '<?xml version="1.0" encoding="utf-16"?> <ArrayOfCustomProperty xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" />'
WHERE CustomProperties = '' OR CustomProperties IS NULL
|
Aaron Sherrick
BV Commerce
Toll-free 888-665-8637 - Int'l +1 717-220-0012 |
|
|
|
|
|
Rank: Member
Joined: 2/3/2010(UTC)
Posts: 68
Thanks: 5 times
|
That helped and fixed the issue. Thank you!
|
|
|
|
|
|
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.