so i upgraded to 1.3.2, i add the main picture under data, then i save it.. go to image, add a picture.. filename 8248248.jpg for example, i save and it shows it.. then if i click add image, upload a second image, the second image, no matter what the filename will remove the first image from the list (but image will remain on the server)
i'm terrible at explaining myself but pretty much what this means is that i have to add all additional images at once or else it will remove it.
406243 Query DELETE FROM product_option WHERE product_id = '72'
406243 Query DELETE FROM product_option_description WHERE product_id = '72'
406243 Query DELETE FROM product_option_value WHERE product_id = '72'
406243 Query DELETE FROM product_option_value_description WHERE product_id = '72'
406243 Query DELETE FROM product_discount WHERE product_id = '72'
406243 Query DELETE FROM product_special WHERE product_id = '72'
406243 Query DELETE FROM product_image WHERE product_id = '72'
406243 Query INSERT INTO product_image SET product_id = '72', image = '1.jpg'
406243 Query INSERT INTO product_image SET product_id = '72', image = '2.jpg'
406243 Query DELETE FROM product_to_download WHERE product_id = '72'
406243 Query DELETE FROM product_to_category WHERE product_id = '72'
406243 Query DELETE FROM product_related WHERE product_id = '72'
406243 Query DELETE FROM url_alias WHERE query = 'product_id=72'
406243 Query INSERT INTO url_alias SET query = 'product_id=72', keyword = 'Watch'
406243 Quit
that's a log, why is it doing this ?
1.2.8, added two pictures to a fresh install under apple cinema, clicked save and exited out.
406381 Query DELETE FROM product_option WHERE product_id = '42'
406381 Query DELETE FROM product_option_description WHERE product_id = '42'
406381 Query DELETE FROM product_option_value WHERE product_id = '42'
406381 Query DELETE FROM product_option_value_description WHERE product_id = '42'
406381 Query DELETE FROM product_discount WHERE product_id = '42'
406381 Query INSERT INTO product_discount SET product_id = '42', quantity = '3', discount = '10'
406381 Query DELETE FROM product_special WHERE product_id = '42'
406381 Query INSERT INTO product_special SET product_id = '42', price = '100', date_start = '2009-03-01', date_end = '2009-03-31'
406381 Query DELETE FROM product_image WHERE product_id = '42'
406381 Query INSERT INTO product_image SET product_id = '42', image = '1.jpg'
406381 Query INSERT INTO product_image SET product_id = '42', image = '2.jpg'
406381 Query DELETE FROM product_to_download WHERE product_id = '42'
406381 Query DELETE FROM product_to_category WHERE product_id = '42'
406381 Query INSERT INTO product_to_category SET product_id = '42', category_id = '28'
406381 Query DELETE FROM product_related WHERE product_id = '42'
406381 Query INSERT INTO product_related SET product_id = '42', related_id = '47'
406381 Query INSERT INTO product_related SET product_id = '42', related_id = '28'
406381 Query INSERT INTO product_related SET product_id = '42', related_id = '41'
406381 Query INSERT INTO product_related SET product_id = '42', related_id = '40'
1.2.8, came back, saw the two pictures, clicked add image, picked 3.jpg and uploaded
406385 Query DELETE FROM product_option WHERE product_id = '42'
406385 Query DELETE FROM product_option_description WHERE product_id = '42'
406385 Query DELETE FROM product_option_value WHERE product_id = '42'
406385 Query DELETE FROM product_option_value_description WHERE product_id = '42'
406385 Query DELETE FROM product_discount WHERE product_id = '42'
406385 Query INSERT INTO product_discount SET product_id = '42', quantity = '3', discount = '10'
406385 Query DELETE FROM product_special WHERE product_id = '42'
406385 Query INSERT INTO product_special SET product_id = '42', price = '100', date_start = '2009-03-01', date_end = '2009-03-31'
406385 Query DELETE FROM product_image WHERE product_id = '42'
406385 Query INSERT INTO product_image SET product_id = '42', image = '1.jpg'
406385 Query INSERT INTO product_image SET product_id = '42', image = '2.jpg'
406385 Query INSERT INTO product_image SET product_id = '42', image = '3.jpg'
406385 Query DELETE FROM product_to_download WHERE product_id = '42'
406385 Query DELETE FROM product_to_category WHERE product_id = '42'
406385 Query INSERT INTO product_to_category SET product_id = '42', category_id = '28'
406385 Query DELETE FROM product_related WHERE product_id = '42'
406385 Query INSERT INTO product_related SET product_id = '42', related_id = '47'
406385 Query INSERT INTO product_related SET product_id = '42', related_id = '28'
406385 Query INSERT INTO product_related SET product_id = '42', related_id = '41'
406385 Query INSERT INTO product_related SET product_id = '42', related_id = '40'
406385 Quit
compared to the previous when adding two pictures:
406414 Query DELETE FROM product_description WHERE product_id = '73'
406414 Query INSERT INTO product_description SET product_id = '73', language_id = '1', name = 'test2', meta_description = '', description = ''
406414 Query DELETE FROM product_option WHERE product_id = '73'
406414 Query DELETE FROM product_option_description WHERE product_id = '73'
406414 Query DELETE FROM product_option_value WHERE product_id = '73'
406414 Query DELETE FROM product_option_value_description WHERE product_id = '73'
406414 Query DELETE FROM product_discount WHERE product_id = '73'
406414 Query DELETE FROM product_special WHERE product_id = '73'
406414 Query DELETE FROM product_image WHERE product_id = '73'
406414 Query INSERT INTO product_image SET product_id = '73', image = '1.jpg'
406414 Query INSERT INTO product_image SET product_id = '73', image = '2.jpg'
406414 Query DELETE FROM product_to_download WHERE product_id = '73'
406414 Query DELETE FROM product_to_category WHERE product_id = '73'
406414 Query DELETE FROM product_related WHERE product_id = '73'
406414 Query DELETE FROM url_alias WHERE query = 'product_id=73'
406414 Quit
going back and clicking add image under the 2nd picture:
406422 Query DELETE FROM product_description WHERE product_id = '73'
406422 Query INSERT INTO product_description SET product_id = '73', language_id = '1', name = 'test2', meta_description = '', description = ''
406422 Query DELETE FROM product_option WHERE product_id = '73'
406422 Query DELETE FROM product_option_description WHERE product_id = '73'
406422 Query DELETE FROM product_option_value WHERE product_id = '73'
406422 Query DELETE FROM product_option_value_description WHERE product_id = '73'
406422 Query DELETE FROM product_discount WHERE product_id = '73'
406422 Query DELETE FROM product_special WHERE product_id = '73'
406422 Query DELETE FROM product_image WHERE product_id = '73'
406422 Query INSERT INTO product_image SET product_id = '73', image = '3.jpg'
406422 Query DELETE FROM product_to_download WHERE product_id = '73'
406422 Query DELETE FROM product_to_category WHERE product_id = '73'
406422 Query DELETE FROM product_related WHERE product_id = '73'
406422 Query DELETE FROM url_alias WHERE query = 'product_id=73'
406422 Quit
it removed 1.jpg and 2.jpg
thanks
406381 Query DELETE FROM product_option WHERE product_id = '42'
406381 Query DELETE FROM product_option_description WHERE product_id = '42'
406381 Query DELETE FROM product_option_value WHERE product_id = '42'
406381 Query DELETE FROM product_option_value_description WHERE product_id = '42'
406381 Query DELETE FROM product_discount WHERE product_id = '42'
406381 Query INSERT INTO product_discount SET product_id = '42', quantity = '3', discount = '10'
406381 Query DELETE FROM product_special WHERE product_id = '42'
406381 Query INSERT INTO product_special SET product_id = '42', price = '100', date_start = '2009-03-01', date_end = '2009-03-31'
406381 Query DELETE FROM product_image WHERE product_id = '42'
406381 Query INSERT INTO product_image SET product_id = '42', image = '1.jpg'
406381 Query INSERT INTO product_image SET product_id = '42', image = '2.jpg'
406381 Query DELETE FROM product_to_download WHERE product_id = '42'
406381 Query DELETE FROM product_to_category WHERE product_id = '42'
406381 Query INSERT INTO product_to_category SET product_id = '42', category_id = '28'
406381 Query DELETE FROM product_related WHERE product_id = '42'
406381 Query INSERT INTO product_related SET product_id = '42', related_id = '47'
406381 Query INSERT INTO product_related SET product_id = '42', related_id = '28'
406381 Query INSERT INTO product_related SET product_id = '42', related_id = '41'
406381 Query INSERT INTO product_related SET product_id = '42', related_id = '40'
1.2.8, came back, saw the two pictures, clicked add image, picked 3.jpg and uploaded
406385 Query DELETE FROM product_option WHERE product_id = '42'
406385 Query DELETE FROM product_option_description WHERE product_id = '42'
406385 Query DELETE FROM product_option_value WHERE product_id = '42'
406385 Query DELETE FROM product_option_value_description WHERE product_id = '42'
406385 Query DELETE FROM product_discount WHERE product_id = '42'
406385 Query INSERT INTO product_discount SET product_id = '42', quantity = '3', discount = '10'
406385 Query DELETE FROM product_special WHERE product_id = '42'
406385 Query INSERT INTO product_special SET product_id = '42', price = '100', date_start = '2009-03-01', date_end = '2009-03-31'
406385 Query DELETE FROM product_image WHERE product_id = '42'
406385 Query INSERT INTO product_image SET product_id = '42', image = '1.jpg'
406385 Query INSERT INTO product_image SET product_id = '42', image = '2.jpg'
406385 Query INSERT INTO product_image SET product_id = '42', image = '3.jpg'
406385 Query DELETE FROM product_to_download WHERE product_id = '42'
406385 Query DELETE FROM product_to_category WHERE product_id = '42'
406385 Query INSERT INTO product_to_category SET product_id = '42', category_id = '28'
406385 Query DELETE FROM product_related WHERE product_id = '42'
406385 Query INSERT INTO product_related SET product_id = '42', related_id = '47'
406385 Query INSERT INTO product_related SET product_id = '42', related_id = '28'
406385 Query INSERT INTO product_related SET product_id = '42', related_id = '41'
406385 Query INSERT INTO product_related SET product_id = '42', related_id = '40'
406385 Quit
compared to the previous when adding two pictures:
406414 Query DELETE FROM product_description WHERE product_id = '73'
406414 Query INSERT INTO product_description SET product_id = '73', language_id = '1', name = 'test2', meta_description = '', description = ''
406414 Query DELETE FROM product_option WHERE product_id = '73'
406414 Query DELETE FROM product_option_description WHERE product_id = '73'
406414 Query DELETE FROM product_option_value WHERE product_id = '73'
406414 Query DELETE FROM product_option_value_description WHERE product_id = '73'
406414 Query DELETE FROM product_discount WHERE product_id = '73'
406414 Query DELETE FROM product_special WHERE product_id = '73'
406414 Query DELETE FROM product_image WHERE product_id = '73'
406414 Query INSERT INTO product_image SET product_id = '73', image = '1.jpg'
406414 Query INSERT INTO product_image SET product_id = '73', image = '2.jpg'
406414 Query DELETE FROM product_to_download WHERE product_id = '73'
406414 Query DELETE FROM product_to_category WHERE product_id = '73'
406414 Query DELETE FROM product_related WHERE product_id = '73'
406414 Query DELETE FROM url_alias WHERE query = 'product_id=73'
406414 Quit
going back and clicking add image under the 2nd picture:
406422 Query DELETE FROM product_description WHERE product_id = '73'
406422 Query INSERT INTO product_description SET product_id = '73', language_id = '1', name = 'test2', meta_description = '', description = ''
406422 Query DELETE FROM product_option WHERE product_id = '73'
406422 Query DELETE FROM product_option_description WHERE product_id = '73'
406422 Query DELETE FROM product_option_value WHERE product_id = '73'
406422 Query DELETE FROM product_option_value_description WHERE product_id = '73'
406422 Query DELETE FROM product_discount WHERE product_id = '73'
406422 Query DELETE FROM product_special WHERE product_id = '73'
406422 Query DELETE FROM product_image WHERE product_id = '73'
406422 Query INSERT INTO product_image SET product_id = '73', image = '3.jpg'
406422 Query DELETE FROM product_to_download WHERE product_id = '73'
406422 Query DELETE FROM product_to_category WHERE product_id = '73'
406422 Query DELETE FROM product_related WHERE product_id = '73'
406422 Query DELETE FROM url_alias WHERE query = 'product_id=73'
406422 Quit
it removed 1.jpg and 2.jpg
thanks
fixed by daniel for anyone who can't find the other post
http://forum.opencart.com/viewtopic.php?f=20&t=5770
http://forum.opencart.com/viewtopic.php?f=20&t=5770
Who is online
Users browsing this forum: No registered users and 65 guests