Quick Updates plugin [support]

[chadderuski]

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.

[Moebiusenterprises]

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]

[numinix]

Run the lines in the SQL file to alter the products table with the products_upc and products_isbn columns:

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; 

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.

[Moebiusenterprises]

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.

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.

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?

[Moebiusenterprises]

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.

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:
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.

[Moebiusenterprises]

Apparently one of the files didn't upload correctly, as it is now working fine after re-uploading.

Thanks!

[Moebiusenterprises]

After update to new version, i see this problem:



Anyone know how to fix?

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.

[Moebiusenterprises]

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')]

[paulm]

Is there something about the Quick Updates mod that might interfere with copying product attributes via the attributes controller?

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.
(and it is very likely that the error is caused by "the attributes controller" itself, combined with your MySQL version or settings)

[kimsonvu]

I have small issue:

If i put link to image , when i use quick update 1.3 .It will like this :




How to fix this problem?

It is ok with detail don't have open link or image don't have link to open!



Sory about my English skill.