Got it working. I was looking at different line then what you referring to.
Printable View
Got it working. I was looking at different line then what you referring to.
Change all occurrences of (NULL, to ( in the following section:
Code:(NULL, 'Display the ID.', 'QUICKUPDATES_DISPLAY_ID', 'true', 'Enable/Disable the products id displaying', ".$group_id.", '1', NULL, NOW(), NULL, 'zen_cfg_select_option(array(\"true\", \"false\"),'),
(NULL, 'Display the thumbnail.', 'QUICKUPDATES_DISPLAY_THUMBNAIL', 'true', 'Enable/Disable the products thumbnail displaying', ".$group_id.", '2', NULL, NOW(), NULL, 'zen_cfg_select_option(array(\"true\", \"false\"),'),
(NULL, 'Modify the model.', 'QUICKUPDATES_MODIFY_MODEL', 'true', 'Enable/Disable the products model displaying and modification', ".$group_id.", '3', NULL, NOW(), NULL, 'zen_cfg_select_option(array(\"true\", \"false\"),'),
(NULL, 'Modify the name.', 'QUICKUPDATES_MODIFY_NAME', 'true', 'Enable/Disable the products name editing', ".$group_id.", '4', NULL, NOW(), NULL, 'zen_cfg_select_option(array(\"true\", \"false\"),'),
(NULL, 'Modify the Description.', 'QUICKUPDATES_MODIFY_DESCRIPTION', 'true', 'Enable/Disable the displaying and modification of products description', ".$group_id.", '5', NULL, NOW(), NULL, 'zen_cfg_select_option(array(\"true\", \"false\"),'),
(NULL, 'Modify the status of the products.', 'QUICKUPDATES_MODIFY_STATUS', 'true', 'Allow/Disallow the Status displaying and modification', ".$group_id.", '6', NULL, NOW(), NULL, 'zen_cfg_select_option(array(\"true\", \"false\"),'),
(NULL, 'Modify the weight of the products.', 'QUICKUPDATES_MODIFY_WEIGHT', 'true', 'Allow/Disallow the Weight displaying and modification?', ".$group_id.", '7', NULL, NOW(), NULL, 'zen_cfg_select_option(array(\"true\", \"false\"),'),
(NULL, 'Modify the quantity of the products.', 'QUICKUPDATES_MODIFY_QUANTITY', 'true', 'Allow/Disallow the quantity displaying and modification', ".$group_id.", '8', NULL, NOW(), NULL, 'zen_cfg_select_option(array(\"true\", \"false\"),'),
(NULL, 'Modify the manufacturer of the products.', 'QUICKUPDATES_MODIFY_MANUFACTURER', 'false', 'Allow/Disallow the Manufacturer displaying and modification', ".$group_id.", '9', NULL, NOW(), NULL, 'zen_cfg_select_option(array(\"true\", \"false\"),'),
(NULL, 'Modify the class of tax of the products.', 'QUICKUPDATES_MODIFY_TAX', 'false', 'Allow/Disallow the Class of tax displaying and modification', ".$group_id.", '10', NULL, NOW(), NULL, 'zen_cfg_select_option(array(\"true\", \"false\"),'),
(NULL, 'Modify the category.', 'QUICKUPDATES_MODIFY_CATEGORY', 'true', 'Enable/Disable the products category modify', ".$group_id.", '11', NULL, NOW(), NULL, 'zen_cfg_select_option(array(\"true\", \"false\"),'),
(NULL, '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', ".$group_id.", '20', NULL, NOW(), NULL, 'zen_cfg_select_option(array(\"true\", \"false\"),'),
(NULL, 'Display the link towards the products information page.', 'QUICKUPDATES_DISPLAY_PREVIEW', 'false', 'Enable/Disable the display of the link towards the products information page ', ".$group_id.", '30', NULL, NOW(), NULL, 'zen_cfg_select_option(array(\"true\", \"false\"),'),
(NULL, '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', ".$group_id.", '31', NULL, NOW(), NULL, 'zen_cfg_select_option(array(\"true\", \"false\"),'),
(NULL, 'Activate or desactivate the commercial margin.', 'QUICKUPDATES_ACTIVATE_COMMERCIAL_MARGIN', 'true', 'Do you want that the commercial margin be activate or not ?',".$group_id.", '40', NULL, NOW(), NULL, 'zen_cfg_select_option(array(\"true\", \"false\"),'),
(NULL, 'Modify the sort order.', 'QUICKUPDATES_MODIFY_SORT_ORDER', 'true', 'Enable/Disable the products sort order modify', ".$group_id.", '12', NULL, NOW(), NULL, 'zen_cfg_select_option(array(\"true\", \"false\"),'),
(NULL, 'Use popup edit.', 'QUICKUPDATES_MODIFY_DESCRIPTION_POPUP', 'true', 'Enable/Disable using popup edit link to description editing', ".$group_id.", '13', NULL, NOW(), NULL, 'zen_cfg_select_option(array(\"true\", \"false\"),') ");
} elseif (substr($project,0,3) == "1.5") {
$db->Execute("INSERT INTO ".TABLE_CONFIGURATION_GROUP." (configuration_group_id, configuration_group_title, configuration_group_description , sort_order, visible) VALUES ('Quick Updates', 'Quick Updates Configuration', '1', '1')");
$group_id = $db->Insert_ID();
$db->Execute("UPDATE ".TABLE_CONFIGURATION_GROUP." SET sort_order = ".$group_id." WHERE configuration_group_id = ".$group_id);
zen_register_admin_page('quick_updates_config', 'BOX_CATALOG_QUICK_UPDATES','FILENAME_CONFIGURATION', 'gID='.$group_id, 'configuration', 'Y', 103);
$db->Execute("INSERT INTO ".TABLE_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
(NULL, 'Display the ID.', 'QUICKUPDATES_DISPLAY_ID', 'true', 'Enable/Disable the products id displaying', ".$group_id.", '1', NULL, NOW(), NULL, 'zen_cfg_select_option(array(\"true\", \"false\"),'),
(NULL, 'Display the thumbnail.', 'QUICKUPDATES_DISPLAY_THUMBNAIL', 'true', 'Enable/Disable the products thumbnail displaying', ".$group_id.", '2', NULL, NOW(), NULL, 'zen_cfg_select_option(array(\"true\", \"false\"),'),
(NULL, 'Modify the model.', 'QUICKUPDATES_MODIFY_MODEL', 'true', 'Enable/Disable the products model displaying and modification', ".$group_id.", '3', NULL, NOW(), NULL, 'zen_cfg_select_option(array(\"true\", \"false\"),'),
(NULL, 'Modify the name.', 'QUICKUPDATES_MODIFY_NAME', 'true', 'Enable/Disable the products name editing', ".$group_id.", '4', NULL, NOW(), NULL, 'zen_cfg_select_option(array(\"true\", \"false\"),'),
(NULL, 'Modify the Description.', 'QUICKUPDATES_MODIFY_DESCRIPTION', 'true', 'Enable/Disable the displaying and modification of products description', ".$group_id.", '5', NULL, NOW(), NULL, 'zen_cfg_select_option(array(\"true\", \"false\"),'),
(NULL, 'Modify the status of the products.', 'QUICKUPDATES_MODIFY_STATUS', 'true', 'Allow/Disallow the Status displaying and modification', ".$group_id.", '6', NULL, NOW(), NULL, 'zen_cfg_select_option(array(\"true\", \"false\"),'),
(NULL, 'Modify the weight of the products.', 'QUICKUPDATES_MODIFY_WEIGHT', 'true', 'Allow/Disallow the Weight displaying and modification?', ".$group_id.", '7', NULL, NOW(), NULL, 'zen_cfg_select_option(array(\"true\", \"false\"),'),
(NULL, 'Modify the quantity of the products.', 'QUICKUPDATES_MODIFY_QUANTITY', 'true', 'Allow/Disallow the quantity displaying and modification', ".$group_id.", '8', NULL, NOW(), NULL, 'zen_cfg_select_option(array(\"true\", \"false\"),'),
(NULL, 'Modify the manufacturer of the products.', 'QUICKUPDATES_MODIFY_MANUFACTURER', 'false', 'Allow/Disallow the Manufacturer displaying and modification', ".$group_id.", '9', NULL, NOW(), NULL, 'zen_cfg_select_option(array(\"true\", \"false\"),'),
(NULL, 'Modify the class of tax of the products.', 'QUICKUPDATES_MODIFY_TAX', 'false', 'Allow/Disallow the Class of tax displaying and modification', ".$group_id.", '10', NULL, NOW(), NULL, 'zen_cfg_select_option(array(\"true\", \"false\"),'),
(NULL, 'Modify the category.', 'QUICKUPDATES_MODIFY_CATEGORY', 'true', 'Enable/Disable the products category modify', ".$group_id.", '11', NULL, NOW(), NULL, 'zen_cfg_select_option(array(\"true\", \"false\"),'),
(NULL, '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', ".$group_id.", '20', NULL, NOW(), NULL, 'zen_cfg_select_option(array(\"true\", \"false\"),'),
(NULL, 'Display the link towards the products information page.', 'QUICKUPDATES_DISPLAY_PREVIEW', 'false', 'Enable/Disable the display of the link towards the products information page ', ".$group_id.", '30', NULL, NOW(), NULL, 'zen_cfg_select_option(array(\"true\", \"false\"),'),
(NULL, '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', ".$group_id.", '31', NULL, NOW(), NULL, 'zen_cfg_select_option(array(\"true\", \"false\"),'),
(NULL, 'Activate or desactivate the commercial margin.', 'QUICKUPDATES_ACTIVATE_COMMERCIAL_MARGIN', 'true', 'Do you want that the commercial margin be activate or not ?',".$group_id.", '40', NULL, NOW(), NULL, 'zen_cfg_select_option(array(\"true\", \"false\"),'),
(NULL, 'Modify the sort order.', 'QUICKUPDATES_MODIFY_SORT_ORDER', 'true', 'Enable/Disable the products sort order modify', ".$group_id.", '12', NULL, NOW(), NULL, 'zen_cfg_select_option(array(\"true\", \"false\"),'),
(NULL, 'Use popup edit.', 'QUICKUPDATES_MODIFY_DESCRIPTION_POPUP', 'true', 'Enable/Disable using popup edit link to description editing', ".$group_id.", '13', NULL, NOW(), NULL, 'zen_cfg_select_option(array(\"true\", \"false\"),') ");
} else { // unsupported version
// i should do something here!
}
}
can't get this to install.. i'm using zen 1.5.5a and when i click on 'install' in the admin i get the error 'WARNING: An Error occurred, please refresh the page and try again.'. please see screen shot for my admin of 'quick updates'..Attachment 16613
Check your error logs for details on what the error actually is.Quote:
Originally Posted by lidlchris
here is what i see:Quote:
Originally Posted by jeking
[26-Aug-2016 11:58:57 America/Chicago] PHP Fatal error: 1136:Column count doesn't match value count at row 1 :: INSERT INTO configuration_group (configuration_group_id, configuration_group_title, configuration_group_description , sort_order, visible) VALUES ('Quick Updates', 'Quick Updates Configuration', '1', '1') ==> (as called by) /home4/csicatalog/public_html/MYADMIN/includes/functions/extra_functions/quick_updates_functions.php on line 39 <== in /home4/csicatalog/public_html/includes/classes/db/mysql/query_factory.php on line 167
fixed it.. there was a bug in /quick/updates/functions.php..
line 39 was:
$db->Execute("INSERT INTO ".TABLE_CONFIGURATION_GROUP." (configuration_group_id, configuration_group_title, configuration_group_description , sort_order, visible) VALUES ('Quick Updates', 'Quick Updates Configuration', '1', '1')");
and i changed it to
$db->Execute("INSERT INTO ".TABLE_CONFIGURATION_GROUP." (configuration_group_id, configuration_group_title, configuration_group_description , sort_order, visible) VALUES ('43','Quick Updates', 'Quick Updates Configuration', '1', '1')"); the '43' for configuration_group_id was the next number available in that table.
Installed this plugin and all is working, except it doubles my sales tax rate and I can not figure out how to stop that.
Any suggestions?
Anyone!!!!
Hi
Works perfectly on 1.5.5b - one question though, how can we adjust it to not show product description - the descriptions on our site are quite long and won't need changing via Quick Updates. Having description showing on Quick Updates means scrolling across the screen to get to the other fields.
Many thanks
Mark
thanks this helped, also on 1.55a i had to change toQuote:
Originally Posted by lidlchris
i think this just uses the next configuration_group_id rather than needing to knowPHP Code:$db->Execute("INSERT INTO ".TABLE_CONFIGURATION_GROUP." (configuration_group_id, configuration_group_title, configuration_group_description , sort_order, visible) VALUES ('','Quick Updates', 'Quick Updates Configuration', '1', '1')");