Hey All! Well, it turned out not to be too difficult after all. Was able to get working in about 20 minutes or so!
All I really did was copy the format of the weight field. Pretty easy after all.
Printable View
Hey All! Well, it turned out not to be too difficult after all. Was able to get working in about 20 minutes or so!
All I really did was copy the format of the weight field. Pretty easy after all.
ok, what have I done wrong? When I try to use Quick Updates, I get an error:
1054 Unknown column 'p.products_upc' in 'field list'
in:
[select p.products_id, p.products_type, p.products_image, p.products_model, pd.products_name, p.products_status, p.products_upc, p.products_isbn, p.products.epier, p.products_weight, p.products_quantity, p.manufacturers_id, p.products_price, p.products_tax_class_id, p.products_date_added, p.products_last_modified, p.products_date_available, p.products_quantity_order_min, p.products_quantity_order_units, p.products_priced_by_attribute, p.product_is_free, p.product_is_call, p.products_quantity_mixed, p.product_is_always_free_shipping, pd.products_description, p.products_quantity_order_max, p.products_sort_order, p.master_categories_id, m.manufacturers_name, p2c.categories_id from zen_products p LEFT JOIN zen_products_description pd ON (p.products_id = pd.products_id and pd.language_id = '1') LEFT JOIN zen_manufacturers m ON (p.manufacturers_id = m.manufacturers_id) LEFT JOIN zen_products_to_categories p2c ON (p.products_id = p2c.products_id) order by p.products_id DESC limit 0, 20]
Run the lines in the SQL file to alter the products table with the products_upc and products_isbn columns:
Moebiusenterprises, I'm going to give you a tip for your survival here in the forum. Always read a thread before posting as this was covered previously. I also announce all version numbers in my threads so you can quickly scan the thread for the relevant information regarding that version.PHP Code:ALTER TABLE products ADD products_upc varchar(32) NULL default NULL after products_model;
ALTER TABLE products ADD products_isbn varchar(32) NULL default NULL after products_upc;
Ok. I do make every attempt to find a solution to what I'm experiencing before I post for help... one of the reasons why after 2 years I've just passed 100 posts.Quote:
Originally Posted by numinix
I'd already run the particular code patch you suggested, and am still getting that error... hence why I looked for help here as apparently I'd missed something somewhere. I take it that's the only possible cause of the error I'm getting?
Ok folks, my apologies. I'm actually getting a different error now:Quote:
Originally Posted by Moebiusenterprises
1109 Unknown table 'p.products' in field list
in:
[select p.products_id, p.products_type, p.products_image, p.products_model, pd.products_name, p.products_status, p.products_upc, p.products_isbn, p.products.epier, p.products_weight, p.products_quantity, p.manufacturers_id, p.products_price, p.products_tax_class_id, p.products_date_added, p.products_last_modified, p.products_date_available, p.products_quantity_order_min, p.products_quantity_order_units, p.products_priced_by_attribute, p.product_is_free, p.product_is_call, p.products_quantity_mixed, p.product_is_always_free_shipping, pd.products_description, p.products_quantity_order_max, p.products_sort_order, p.master_categories_id, m.manufacturers_name, p2c.categories_id from zen_products p LEFT JOIN zen_products_description pd ON (p.products_id = pd.products_id and pd.language_id = '1') LEFT JOIN zen_manufacturers m ON (p.manufacturers_id = m.manufacturers_id) LEFT JOIN zen_products_to_categories p2c ON (p.products_id = p2c.products_id) order by p.products_id DESC limit 0, 20]
Obviously, this isn't the UPC error that I originally had posted. My sincere apologies for the confusion.
Apparently one of the files didn't upload correctly, as it is now working fine after re-uploading.
Thanks!
Had the same issue myself, figured out that a file apparently hadn't uploaded properly. Try re-uploading your files, as that fixed it for me.Quote:
Originally Posted by kimsonvu
Didn't find this mentioned on the thread...
Is there something about the Quick Updates mod that might interfere with copying product attributes via the attributes controller?
When I attempt to do this, I get the following error:
1136 Column count doesn't match value count at row 1
in:
[insert into zen_products_attributes values (0, '677', '10', '207', '0.0000', '+', '1', '0', '0', '+', '0', '0', '1', '', '1', '0.0000', '0.0000', '0.0000', '0.0000', '0.0000', '', '', '0.0000', '0', '0.0000', '0', '0')]
I don't know what "the attributes controller" is, but I am (99.99%) sure the error you posted is not related to quick updates.Quote:
Originally Posted by Moebiusenterprises
(and it is very likely that the error is caused by "the attributes controller" itself, combined with your MySQL version or settings)
I have small issue:
If i put link to image , when i use quick update 1.3 .It will like this :
http://www.handicraft-vn.com/gallery...mage+issue.JPG
How to fix this problem?
It is ok with detail don't have open link or image don't have link to open!
http://www.handicraft-vn.com/gallery...age+issue2.JPG
Sory about my English skill.