[Kirk Fitzgerald]

Originally Posted by Ted S

We can fix this with a simple query...

update pf_product set mainphoto = replace(mainphoto, '\\productphotos\\', 'productphotos/');
update pf_product set mainphoto_thumb = replace(mainphoto_thumb, '\\productphotos\\', 'productphotos/');
update pf_product set mainphoto_small = replace(mainphoto_small, '\\productphotos\\', 'productphotos/');

Or something along those lines depending on your current image paths.

[Note: to replace \ you must escape it with another \ thus \\]

What a star, I used this:

update pf_product set mainphoto = replace(mainphoto, '\\productphotos\\', 'productphotos/');
update pf_product set mainphoto_thumb = replace(mainphoto_thumb, '\\productphotos\\', 'productphotos/');
update pf_product set mainphoto_small = replace(mainphoto_small, '\\productphotos\\', 'productphotos/');

and everything is fine, just had to re-upload an image for the one I changed earlier and it's working properly now.

Thank you Ted.