berthz Posted October 6, 2008 Share Posted October 6, 2008 I have installed the ultra pics contrib, which by the way works like a charm. However there are a couple of thousand products in my store, and when clicking the enlarge button of a product image the lightbox opens but does not show a picture. This is quite obvious because I have not defined the enlarge picture for all the products (they were already there when I installed the contribution). The only thing I want to do is to have ultra pics open the product image that is already set for all the products. I guess the only way to do so is to copy the contents of the products_image column into the products_image_med. Is there a simple command that copies the content from one column into the other and also taking the product_id into consideration? It will save me loads of time. I am using a mysql database and phpmyadmin, so it shouldnt be too much of a problem to execute the command. Thanks in advance. Link to comment Share on other sites More sharing options...
Gauravs Posted October 6, 2008 Share Posted October 6, 2008 Following should set you up for copying columns in the same database Update <TableName> SET products_image_med = products_image Best Regards,Gaurav Link to comment Share on other sites More sharing options...
berthz Posted October 6, 2008 Author Share Posted October 6, 2008 Following should set you up for copying columns in the same database Update <TableName> SET products_image_med = products_image Great! That did the job. Thanks! I do wonder why that update command isnt included in the ultra pics standard installation... Link to comment Share on other sites More sharing options...
Gauravs Posted October 6, 2008 Share Posted October 6, 2008 Take the lead, create a modified version and get credit for contribution :) Cheers Best Regards,Gaurav Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.