• Toll-free  888-665-8637
  • International  +1 717-220-0012
Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

michael_b
#1 Posted : Monday, September 11, 2017 9:05:08 AM(UTC)
michael_b

Rank: Member

Joined: 2/3/2010(UTC)
Posts: 27

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.
Aaron
#2 Posted : Monday, September 11, 2017 9:25:21 AM(UTC)
Aaron

Rank: Administration

Joined: 4/2/2004(UTC)
Posts: 2,029
United States
Location: Hummelstown, PA

Thanks: 6 times
Was thanked: 114 time(s) in 109 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
michael_b
#3 Posted : Monday, September 11, 2017 10:02:30 AM(UTC)
michael_b

Rank: Member

Joined: 2/3/2010(UTC)
Posts: 27

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.

©2017 Develisys. All rights reserved.
  • Toll-free  888-665-8637
  • International  +1 717-220-0012