Yep, same format, just change it to xcart_images and xcart_icons

Do I need to change the image location in the Admin in X-cart after the DB update?

Change it before...but it usually doesn't make the change to the DB, which is why I used that SQL query :)

image_path = replace(image_path,'/store/','/'
 

image_path = replace(image_path,'/store/','/' i have entered this into sql and it fails with errors is there something else to add or am i just being thick???? i have no idea about sql, i have an image directory i use for icons,thumbnails and detailed images, dont store in database as files is much better. where would one one enter the new details in this query???
any help much appreciated,


darren


realsecurity

You need to enter it exactly as I have posted above:

update xcart_thumbnails
set image_path = replace(image_path,'/store/','/')

Just copied and pasted update xcart_thumbnails set image_path = replace(image_path,'/store/','/') into sql query box run and it didnt change anything stated 0 rows effected ???

Well, are you moving from the store/ directory to the root directory? Because that is what that query is for...

Entered excatly as stated and it hasnt done anything other then state 0 lines effected when run the query!!!! what else can be done to get this resolved???

Yes, but the question is are you moving the site from the store to the root directory? Because you will have to alter that query if you are doing anything other than that.

Basically on the same server using the SAME database i have moved folders, the server i have has upto 6 directories 6 domains. i have treated it as a change server as i have copied and pasted all files from one directory to another, i have changed image loaction in admin, and config is changed to new domain, img src left to "" now when going to realsecurity.co.uk it displays no images other then skin imgs.???? reallybaffled as to whats wrong???