Change Image locations back and forth many times
 

I changed the Image Location from database to file system successfully. But I need to change them back to database. Is this a problem?

What if I want to change them back from database to file system again afterwards? Is there any issue with that?

Thanks

Why would you want the images in the DB?

I am moving the shop from /shop to the root directory. Based on earlier suggestions, the steps are to move images to DB first, then move all files, then move images back to file system. That is what I am doing, but I am not sure if there is any issue with this.

Ahh. I don't usually recommend that method as it renames all of the files (which will hurt your SEO image names), but if that is the way you want to do it you can switch them back and forth as many times as you wan t.

What do you recommend to move the store to root?

I don't like this method either.

Because the root directory is much more search engine friendly and visually appealing.

Yes, that is why I am moving the store.
But is there a better way to do this?

I just move the files to the root, update config.php and run an SQL query to update the image path in the database, similar to this:

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

thanks!
do I run the sql for icon and detailed image as well?

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???

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!!!