I need to empty all product images can someone provide me with an empty code. I do not want to remove products_image from the table just empty all the images assigned. Thank you!
Results 1 to 5 of 5
-
8 Sep 2010, 11:45 PM #1
Totally Zenned
- Join Date
- Feb 2008
- Posts
- 569
- Plugin Contributions
- 0
SQL Code to Empty All Product Images?
-
Re: SQL Code to Empty All Product Images?
Why ?
.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole
Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.
-
9 Sep 2010, 03:35 AM #3
New Zenner
- Join Date
- Jan 2010
- Posts
- 4
- Plugin Contributions
- 0
Re: SQL Code to Empty All Product Images?
Hi,
Need help i can't load pictures keep on getting this error message --
Warning: move_uploaded_file() [function.move-uploaded-file]: Unable to move '/tmp/phpdtKEK9' to '/home/xclusive/public_html/images/1.jpeg' in /home/xclusive/public_html/admin/includes/classes/upload.php on line 112
can anyone help please.thanks
-
9 Sep 2010, 03:41 AM #4
Totally Zenned
- Join Date
- Feb 2008
- Posts
- 569
- Plugin Contributions
- 0
Re: SQL Code to Empty All Product Images?
Please start your own thread so you can get further assistance. Your issue has nothing to do with the thread.
Originally Posted by xclusive supplies
Hello DrByte, I use a program to upload all my products at once and I accidently assigned the wrong images to the products. There is 40,000 plus products. Some of the products do not have images. So it is not showing the "no image" picture" when I accidently assigned an image for them. Some the images files do not exist. I want to remove all the assigned images (datatable: products-->products_images) Empty that part and then upload the correct image names to the products. Originally Posted by DrByte
-
Re: SQL Code to Empty All Product Images?
SQL:
BEWARE: That's a destructive command, and is irreversible. Be sure to make backups first.Code:update products set products_image = '';
.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole
Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.
Similar Threads
-
v139h SQL code to populate a wholesale column as a percentage of the product price.
By ilmarchez in forum Setting Up Categories, Products, AttributesReplies: 3Last Post: 17 Jul 2015, 10:57 PM -
why all the sql use $db->bindVars , can not put vars directly in sql string?
By linjuming in forum General QuestionsReplies: 3Last Post: 17 Oct 2012, 02:13 AM -
Additional Product Images - Add title below all images
By sports guy in forum All Other Contributions/AddonsReplies: 0Last Post: 22 Dec 2011, 05:54 AM -
Product Select SQL Code
By gregger in forum General QuestionsReplies: 2Last Post: 30 Jul 2010, 11:50 AM -
Product Images Problem.? All images are Large?
By jeffhardy in forum Templates, Stylesheets, Page LayoutReplies: 2Last Post: 10 Apr 2009, 10:50 PM
Bookmarks