| ||||||||||
Shopping cart software Solutions for online shops and malls | ||||||||||
|
X-Cart Home | FAQ | Forum rules | Calendar | User manuals | Login |
Change Image locations back and forth many times | ||||
|
|
Thread Tools | Search this Thread |
#21
|
|||||||
|
|||||||
What was the old image location and what is the new one?
__________________
Padraic Ryan Ryan Design Studio Professional E-Commerce Development |
|||||||
#22
|
|||||||
|
|||||||
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......
__________________
SURECOM XCART V4.1.8 |
|||||||
#23
|
|||||||
|
|||||||
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.
__________________
Padraic Ryan Ryan Design Studio Professional E-Commerce Development |
|||||||
#24
|
|||||||
|
|||||||
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!!!
__________________
SURECOM XCART V4.1.8 |
|||||||
#25
|
|||||||
|
|||||||
If you are seeing that as the image source, the images are still in the database.
__________________
Padraic Ryan Ryan Design Studio Professional E-Commerce Development |
|||||||
#26
|
|||||||
|
|||||||
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
__________________
SURECOM XCART V4.1.8 |
|||||||
#27
|
|||||||
|
|||||||
The images appear fine to me on your site and the image path appears to be in the file system
__________________
Padraic Ryan Ryan Design Studio Professional E-Commerce Development |
|||||||
#28
|
|||||||
|
|||||||
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.....
__________________
SURECOM XCART V4.1.8 |
|||||||
#29
|
|||||||
|
|||||||
Detailed images are in xcart_images
__________________
Padraic Ryan Ryan Design Studio Professional E-Commerce Development |
|||||||
#30
|
|||||||
|
|||||||
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!!!
__________________
SURECOM XCART V4.1.8 |
|||||||
|
|||
X-Cart forums © 2001-2020
|