What was the old image location and what is the new one?

The old image location was /hsphere/local/home/realsecu/testxcart.co.uk/images_icons the new location is /hsphere/local/home/realsecu/realsecurity.co.uk/images_icons

so the only part thats changed is the testcart.co.uk to realsecurity.co.uk......

That's why the query didn't work for you. Here's one that should:

update xcart_thumbnails
set image_path = replace(image_path,'testcart.co.uk','realsecurity. co.uk')

See how that works? It is essentially a find and replace query...first one is the old one, second one is the new one.

just ran this and same results 0 lines effected??? really strange, the image source on properties and view source i can see in view source it shows src="/image.php?productid=7" width="80" alt="Epson STYLUS 880/880I Colour" border="0">

when looking at image properties the path is set to http://www.realsecurity.co.uk/image.php?productid=6 whether this helps or not!!!

If you are seeing that as the image source, the images are still in the database.

But in admin i have selected file, and set the location for thumbnails, icons, and detailed images. If i goto products and add image it appears on the site and goes into the foler location!!! but no images, or icons appear on the website, so there is no images in the database, but its calling database as the location then!!!! i have looked into the database for xcart_thummbnails and the location is infact set at testcart.co.uk ??? how can i change this to realsecurity.co.uk,i know this query you have mentioned but its not changing anything??? very strange

The images appear fine to me on your site and the image path appears to be in the file system

hi, gave up with the query idea, ive gone into database and MANUALLY changes each part of the path that had testcart.co.uk with realsecurity.co.uk, it hasnt all changed yet, havnt done detailed images cant find this in the database anywhere>>>> i have found also there is lots of sample database items in there wich wastes space, gona look on the forum to see how to clean all that out!!! many thnks for your help.....

Detailed images are in xcart_images

Hi, yeh i worked that out earlier, it seems to be ok now, although the database as a alot of junk init from the standard xcart installation, is there not a way to clean the database and remove everything thats not needed!!!