No subcategory images after move from root directory

achamber · #1 11-28-2007, 02:53 AM

Hi All,

I have just moved my site from the root directory to a "/shop" directory. I have updated my config.php file with the below and mostly everything seems to be working fine:

$xcart_web_dir ="/shop";

The problem I am having is that my subcategory images will no longer display. Once you select a subcategory the product images all display correctly, and if you select an individual product, this also displays fine. It just seems to be the subcategory images.

http://www.livelovewed.com.au/shop/home.php?cat=277

I tried re-uploading a few images from the admin area, but this hasn't worked either.

Any suggestions?

Many Thanks

balinor · #2 11-28-2007, 04:00 AM

Did you change your images location in the 'Images Location' area of the admin? You'll also need to run an SQL query to change the path in the database, like these:

update xcart_images
set image_path = replace(image_path,'old','new')

update xcart_icons
set image_path = replace(image_path,'old','new')

update xcart_thumbnails
set image_path = replace(image_path,'old','new')

achamber · #3 11-29-2007, 03:35 AM

Hello,

I ended up just needing to update my subcategories.tpl to reference "/shop/icon.php" rather than just /icon.php

My images are all stored on the database.

Now all works a treat.

Thanks

swifty · #4 05-19-2008, 08:09 AM

I’m having a similar problem, only our shop was moved to another host and none of the product images are showing.

I’m using a file system so I figure it’s a path issue.

balinor · #5 05-19-2008, 08:12 AM

Yes, see the SQL queries I posted above - you'll need to update your db paths to the images.

swifty · #6 05-19-2008, 08:25 AM

Can it be done from the xcart control panel?

balinor · #7 05-19-2008, 08:36 AM

Yes, from the Patch/Upgrade area under the SQL queries. Be careful though, you can make a real mess of things if you don't put the paths in correctly.

swifty · #8 05-19-2008, 09:07 AM

Ok, so I need to put the path to the image in the query like so.

update xcart_thumbnails
set image_path = replace(image_path,'/hsphere/local/home/aftermar/aftermarketparts.com/xcart/files/thumbnails
','/home/afterma1/public_html/xcart/files/thumbnails/')

The old path was already in the box when I switched over the new is the xcart directory minus the files/thumbnails/.