Quick Updates plugin [support]

Quick Update 2.03b is generating the following error:```php
1054 Unknown column 'p.products.epier' 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 products p LEFT JOIN products_description pd ON (p.products_id = pd.products_id and pd.language_id = '1') LEFT JOIN manufacturers m ON (p.manufacturers_id = m.manufacturers_id) LEFT JOIN products_to_categories p2c ON (p.products_id = p2c.products_id) order by p.products_id DESC limit 0, 20]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

It appears that one of the files included in this distribution assumes everyone is using epier which obviously is not the case. It probably wouldn't be a bad idea when packaging a contribution to use the standard Zen Cart stock and apply the changes to that as supposed to a custom file that may already include code changes for other contribution.

Thanks!

It would be great if you can please provide this contribution without support/integration with epier. The assumption that every user of Quick Updates wants epier is faulty.

Thanks!

If you are going to use v2.03b, you need to also ALTER TABLE to add the correct ePier fields to the products. If you aren't using ePier, do not use version "b", instead, use "a" or just 2.03. In fact 2.03b does not provide UPC/ISBN support and is therefore not an upgrade to 2.03a.

Also, as stated in the post directly above you, by removing the # on the correct line in the installation SQL, you can install the ePier field and avoid SQL errors. From our conversation in the UPC/ISBN thread, you should be using 2.03a.

BlessIsaacola:

It would be great if you can please provide this contribution without support/integration with epier. The assumption that every user of Quick Updates wants epier is faulty.

Thanks!

There is no assumption. V2.03b is only available from my website and not available from the downloads section. It was created solely for the purpose of supporting the ePier Generator.

However, v2.03a is available both on my website and in the downloads section and SQL errors will occur if not using those fields. Therefore, it is recommended that users run the ALTER TABLE lines regardless of whether or not they are going to input information into those fields or revert back to v2.03 which has the same functionality but without UPC/ISBN support.

numinix:

There is no assumption. V2.03b is only available from my website and not available from the downloads section. It was created solely for the purpose of supporting the ePier Generator.

However, v2.03a is available both on my website and in the downloads section and SQL errors will occur if not using those fields. Therefore, it is recommended that users run the ALTER TABLE lines regardless of whether or not they are going to input information into those fields or revert back to v2.03 which has the same functionality but without UPC/ISBN support.

Ah, believe it or not, some of us actually frequent your site for your mods more than the download section. Simply for the fact that updates are available sooner on your site before it becomes available on ZC download section.

To avoid confusion you might want to put a disclaimer in the readme file or on your site that v2.03b is ONLY for users of ePier. I will downgrade accordingly.

Thanks!

I'll look into it when I have time. There is no SQl errors as long as the user runs the ALTER TABLE lines which are commented out by default. It will work just the same as the original 2.03 but with an additional ePier field which the user can ignore.

I'm currently working on an eBay CSV creator that is taking up all of my time.

I have installed QU 2.03a on to ZC 1.3.7.1.

I had some problems as I had not yet installed the UPC/ISBN mod. Prior to installing the UPC/ISBN mod I was getting an error when access the QuickUpdates page but from memory the QuickUpdates configuration menu was working.

I have now installed the UPC/ISBN mod and the QuickUpdates page is working but I can not get the configuration page up. The Configuration menu is there but when I click on it I get Quick Updates page with now options. The page displays and is formated and even has the table headings but no options.

I have tried rerunning, deleting and rerunning the SQL entries. I even tried re-uploading all the files although even wiht my very basic knowledge I was pretty sure it is an SQL problem.

Would appreciate any help you can give. Thanks

Run this to uninstall the SQL:

 
SELECT @quick_updates_id:=configuration_group_id
FROM configuration_group WHERE configuration_group_title="Quick Updates";
DELETE FROM configuration WHERE configuration_group_id=@quick_updates_id;
DELETE FROM configuration_group WHERE configuration_group_id=@quick_updates_id;

Then cut and paste this in to install:

 
SET @t4=0;
SELECT (@t4:=configuration_group_id) as t4 
FROM configuration_group
WHERE configuration_group_title= 'Quick Updates';
DELETE FROM configuration WHERE configuration_group_id = @t4;
DELETE FROM configuration_group WHERE configuration_group_id = @t4;
INSERT INTO configuration_group VALUES ('', 'Quick Updates', 'Set Quick Updates Options', '1', '1');
UPDATE configuration_group SET sort_order = last_insert_id() WHERE configuration_group_id = last_insert_id();
SET @t4=0;
SELECT (@t4:=configuration_group_id) as t4 
FROM configuration_group
WHERE configuration_group_title= 'Quick Updates';
INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES
('', 'Display the ID.', 'QUICKUPDATES_DISPLAY_ID', 'true', 'Enable/Disable the products id displaying', @t4, 1, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),'),
('', 'Display the thumbnail.', 'QUICKUPDATES_DISPLAY_THUMBNAIL', 'true', 'Enable/Disable the products thumbnail displaying', @t4, 2, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),'),
('', 'Modify the model.', 'QUICKUPDATES_MODIFY_MODEL', 'true', 'Enable/Disable the products model displaying and modification', @t4, 3, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),'),
('', 'Modify the UPC.', 'QUICKUPDATES_MODIFY_UPC', 'true', 'Enable/Disable the products UPC displaying and modification', @t4, 4, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),'),
('', 'Modify the ISBN.', 'QUICKUPDATES_MODIFY_ISBN', 'true', 'Enable/Disable the products ISBN displaying and modification', @t4, 5, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),'),
('', 'Modify the name.', 'QUICKUPDATES_MODIFY_NAME', 'true', 'Enable/Disable the products name editing', @t4, 6, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),'),
('', 'Modify the Description.', 'QUICKUPDATES_MODIFY_DESCRIPTION', 'true', 'Enable/Disable the displaying and modification of products description', @t4, 7, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),'),
('', 'Modify the status of the products.', 'QUICKUPDATES_MODIFY_STATUS', 'true', 'Allow/Disallow the Status displaying and modification', @t4, 8, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),'),
('', 'Modify the weight of the products.', 'QUICKUPDATES_MODIFY_WEIGHT', 'true', 'Allow/Disallow the Weight displaying and modification?', @t4, 9, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),'),
('', 'Modify the quantity of the products.', 'QUICKUPDATES_MODIFY_QUANTITY', 'true', 'Allow/Disallow the quantity displaying and modification', @t4, 10, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),'),
('', 'Modify the manufacturer of the products.', 'QUICKUPDATES_MODIFY_MANUFACTURER', 'false', 'Allow/Disallow the Manufacturer displaying and modification', @t4, 11, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),'),
('', 'Modify the class of tax of the products.', 'QUICKUPDATES_MODIFY_TAX', 'false', 'Allow/Disallow the Class of tax displaying and modification', @t4, 12, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),'),
('', 'Modify the category.', 'QUICKUPDATES_MODIFY_CATEGORY', 'true', 'Enable/Disable the products category modify', @t4, 13, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),'),
('', 'Display price with all included of tax.', 'QUICKUPDATES_DISPLAY_TVA_OVER', 'true', 'Enable/Disable the displaying of the Price with all tax included when your mouse is over a product', @t4, 20, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),'),
('', 'Display the link towards the products information page.', 'QUICKUPDATES_DISPLAY_PREVIEW', 'false', 'Enable/Disable the display of the link towards the products information page ', @t4, 30, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),'),
('', 'Display the link towards the page where you will be able to edit the product.', 'QUICKUPDATES_DISPLAY_EDIT', 'true', 'Enable/Disable the display of the link towards the page where you will be able to edit the product', @t4, 31, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),'),
('', 'Activate or desactivate the commercial margin.', 'QUICKUPDATES_ACTIVATE_COMMERCIAL_MARGIN', 'true', 'Do you want that the commercial margin be activate or not ?', @t4, 40, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),'),
('', 'Modify the sort order.', 'QUICKUPDATES_MODIFY_SORT_ORDER', 'true', 'Enable/Disable the products sort order modify', @t4, 14, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),'),
('', 'Use popup edit.', 'QUICKUPDATES_MODIFY_DESCRIPTION_POPUP', 'true', 'Enable/Disable using popup edit link to description editing', @t4, 14, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),');

If that doesn't work for you then it's something external to this module. Furthermore, my update is very minor and only adds the UPC and ISBN.

btw, there is an error in the SQL. I accidentally entered the UPC/ISBN twice. This can be fixed by deleting the last two lines in the SQL and ending the new last line with a semi-colon ;

I've already dealt with this issue previously if you had just read the posts since the release of 2.03a. I will no longer provide support for this issue. I will release a patch when I have the chance.

Thanks numinix. I managed to get it working although I am still not sure what I did. Just repeat and test. ok.

Never look a gift horse in the mouth;-)

After update to new version, i see this problem:

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 handicraproducts p LEFT JOIN handicraproducts_description pd ON (p.products_id = pd.products_id and pd.language_id = '1') LEFT JOIN handicramanufacturers m ON (p.manufacturers_id = m.manufacturers_id) LEFT JOIN handicraproducts_to_categories p2c ON (p.products_id = p2c.products_id) order by p.products_id DESC limit 0, 20]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

Anyone know how to fix?

Hi All,

currently using: v2.03

Has anyone tried to add the "Product Qty Minimum" and "Product Qty Units" to Quick Updates? Would be very useful for those of use that price by EA but sell in cases.

I looked in the .php code, but it isn't a "simple" fix - lol.

need to add:
products_quantity_order_min and products_quantity_order_units

any suggestions on how to start, or anyone else has done this mod would really be appreciated.

Thanks!

-cj

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:

 
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.

numinix:

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.

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

Thanks!

kimsonvu:

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.

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