| ||||||||||
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 |
#11
|
|||||||
|
|||||||
Yep, same format, just change it to xcart_images and xcart_icons
__________________
Padraic Ryan Ryan Design Studio Professional E-Commerce Development |
|||||||
#12
|
|||||||
|
|||||||
Do I need to change the image location in the Admin in X-cart after the DB update?
__________________
__________________ x-cart: 4.1.8 X-cart Affiliate X-cart configurator X-cart AOS X-cart image magnifier |
|||||||
#13
|
|||||||
|
|||||||
Change it before...but it usually doesn't make the change to the DB, which is why I used that SQL query
__________________
Padraic Ryan Ryan Design Studio Professional E-Commerce Development |
|||||||
#14
|
|||||||
|
|||||||
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
__________________
SURECOM XCART V4.1.8 |
|||||||
#15
|
|||||||
|
|||||||
You need to enter it exactly as I have posted above:
update xcart_thumbnails set image_path = replace(image_path,'/store/','/')
__________________
Padraic Ryan Ryan Design Studio Professional E-Commerce Development |
|||||||
#16
|
|||||||
|
|||||||
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 ???
__________________
SURECOM XCART V4.1.8 |
|||||||
#17
|
|||||||
|
|||||||
Well, are you moving from the store/ directory to the root directory? Because that is what that query is for...
__________________
Padraic Ryan Ryan Design Studio Professional E-Commerce Development |
|||||||
#18
|
|||||||
|
|||||||
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???
__________________
SURECOM XCART V4.1.8 |
|||||||
#19
|
|||||||
|
|||||||
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.
__________________
Padraic Ryan Ryan Design Studio Professional E-Commerce Development |
|||||||
#20
|
|||||||
|
|||||||
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???
__________________
SURECOM XCART V4.1.8 |
|||||||
|
|||
X-Cart forums © 2001-2020
|