Hi,
Just uploaded loads of products, unfortunately i had the wrong folder set or the images.
does anyone know how to do a sql script to change the image file name from folder1/xxxxxx.jpeg to folder2/xxxxxx.jpeg
i have tried
UPDATE zen_products SET zen_products = REPLACE(products_image, "folder1\", "folder2/");
this just returns a failed message
Results 1 to 2 of 2
Threaded View
-
17 Mar 2010, 01:24 PM #1
New Zenner
- Join Date
- Feb 2009
- Posts
- 21
- Plugin Contributions
- 0
SQL script to change the product image folder?
Similar Threads
-
SQL script to change site wide table widths
By bigstore in forum Templates, Stylesheets, Page LayoutReplies: 2Last Post: 8 Feb 2012, 02:12 AM -
Script for floating the large image over smaller images on product info page
By sjk1000 in forum Templates, Stylesheets, Page LayoutReplies: 4Last Post: 20 Mar 2010, 10:17 PM -
Why do I need to change folder permissions 777 on the folder before install?
By zhshji in forum Installing on a Linux/Unix ServerReplies: 2Last Post: 5 Feb 2010, 01:04 PM -
Want to see the SQL statement of the DB upgrade script.
By artcoder in forum Upgrading from 1.3.x to 1.3.9Replies: 1Last Post: 30 Dec 2007, 10:04 PM
