Quick Updates plugin [support]

[jeking]

I am using Zencart V1.54.

I tried installing the latest version. When I click install to configure, I get Warning: error occurred. I can go back to the quick update page, but things are missing such as product name.

I went to github and downloaded vdr 2.08. This caused even a worse situation. I had to go in and remove the updated database files, and remove the autoloader to be able to get back into my admin. Also noticed on github it said version 2.08 last updated 2 years ago.

Really would like to get this thing working correctly.

Need more information to be of any help. When you installed the first time, did you check your 'logs' folder. What was the error message? What other plugins have you installed on your store?

[dspeak35640]

Here is what my log showed. I x'd out site info.

[05-Aug-2016 16:45:23 UTC] PHP Fatal error: 1136:Column count doesn't match value count at row 1 :: INSERT INTO zc_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) /home/xxxxxxx/xxxxxx/xxxxxxx/includes/functions/extra_functions/quick_updates_functions.php on line 39 <== in /home/xxxxxxxxx/public_html/includes/classes/db/mysql/query_factory.php on line 155

[dspeak35640]

I am guessing from this it has something to do with the database not being updated properly.

[dbltoe]

It's trying to give a sort order that is already in use. You can try to change the sort order to something like 40 and see if that works.
BACKUP FIRST!

INSERT INTO zc_configuration_group (configuration_group_id, configuration_group_title, configuration_group_description , sort_order, visible) VALUES ('Quick Updates', 'Quick Updates Configuration', '1', '1')

becomes

INSERT INTO zc_configuration_group (configuration_group_id, configuration_group_title, configuration_group_description , sort_order, visible) VALUES ('Quick Updates', 'Quick Updates Configuration', '40', '1')

[lat9]

The issue is the "over-specification" of the table's fields:

INSERT INTO zc_configuration_group (configuration_group_id, configuration_group_title, configuration_group_description , sort_order, visible) VALUES ('Quick Updates', 'Quick Updates Configuration', '1', '1')

mySQL is complaining because the statement specifies 5 fields to be updated, but only provided values for 4.

Change that statement to:

INSERT INTO zc_configuration_group (configuration_group_title, configuration_group_description , sort_order, visible) VALUES ('Quick Updates', 'Quick Updates Configuration', '1', '1')

and you should be "all better".

[dspeak35640]

That was it!!! Thank you so very much Lat9. It installed correctly now and looks good. Thank you, thank you, thank you.

[dbltoe]

gotta get new trifocals

[jsarwar]

I am getting the same error:

PHP Fatal error:  1136:Column count doesn't match value count at row 1 :: INSERT INTO zen_configuration_group (configuration_group_id, configuration_group_title, configuration_group_description , sort_order, visible) VALUES ('Quick Updates', 'Quick Updates Configuration', '1', '1')

I tried 2 solutions mentioned above but it did not work. Any idea how to fix it?

I have the file which came with latest module version and ZC 1.5.3

[lat9]

The error you posted indicates that you haven't removed the configuration_group_id field name from the SQL:

INSERT INTO zen_configuration_group (configuration_group_id, configuration_group_title, configuration_group_description , sort_order, visible) VALUES ('Quick Updates', 'Quick Updates Configuration', '1', '1')

As I indicated above, just remove the highlighted field (that doesn't have a value) and the query will work just fine:

INSERT INTO zen_configuration_group (configuration_group_title, configuration_group_description , sort_order, visible) VALUES ('Quick Updates', 'Quick Updates Configuration', '1', '1')

[jsarwar]

I don't see configuration_group_id in insert line. I manually added configuration_group_id but still same error. File I got from module is and getting error:

<?php/**
 * @package admin
 * @copyright Copyright 2003-2006 Zen Cart Development Team
 * @copyright Portions Copyright 2003 osCommerce
 * @license http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0
 * @version $Id: copy_to_confirm.php 3380 2006-04-06 05:12:45Z drbyte $
 */
if (!defined('IS_ADMIN_FLAG')) {
  die('Illegal Access');
}


function install_quick_updates() {
    global $db;
    $project = PROJECT_VERSION_MAJOR.'.'.PROJECT_VERSION_MINOR;
    if ( (substr($project,0,5) == "1.3.8") || (substr($project,0,5) == "1.3.9") ) {
        $db->Execute("INSERT INTO ".TABLE_CONFIGURATION_GROUP." (configuration_group_title, configuration_group_description , sort_order, visible) VALUES ('Quick Updates', 'Quick Updates Configuration', '1', '1')");
        $group_id = mysql_insert_id();
        $db->Execute("UPDATE ".TABLE_CONFIGURATION_GROUP." SET sort_order = ".$group_id." WHERE configuration_group_id = ".$group_id);
        $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\"),') ");
    } 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!
    } 
}


function remove_quick_updates() {
    global $db;
    $project = PROJECT_VERSION_MAJOR.'.'.PROJECT_VERSION_MINOR;
    if ( (substr($project,0,5) == "1.3.8") || (substr($project,0,5) == "1.3.9") ) {
        $sql = "SELECT configuration_group_id FROM ".TABLE_CONFIGURATION_GROUP." WHERE configuration_group_title = 'Quick Updates' LIMIT 1";
        $result = $db->Execute($sql);
        if (mysql_num_rows($result)) { 
            $group_id =  mysql_fetch_array($result);
            $db->Execute("DELETE FROM ".TABLE_CONFIGURATION." WHERE configuration_group_id = ".$group_id[0]);
            $db->Execute("DELETE FROM ".TABLE_CONFIGURATION_GROUP." WHERE configuration_group_id = ".$group_id[0]);
        }
    } elseif (substr($project,0,3) == "1.5") {
        $sql = "SELECT configuration_group_id FROM ".TABLE_CONFIGURATION_GROUP." WHERE configuration_group_title = 'Quick Updates' LIMIT 1";
        $result = $db->Execute($sql);
        if ($result->RecordCount() > 0) { 
            $group_id =  $result->fields['configuration_group_id'];
            $db->Execute("DELETE FROM ".TABLE_CONFIGURATION." WHERE configuration_group_id = ".$group_id);
            $db->Execute("DELETE FROM ".TABLE_CONFIGURATION_GROUP." WHERE configuration_group_id = ".$group_id);
            $db->Execute("DELETE FROM ".TABLE_ADMIN_PAGES." WHERE page_key = 'quick_updates'");
            $db->Execute("DELETE FROM ".TABLE_ADMIN_PAGES." WHERE page_key = 'quick_updates_config'");
        }
    } else { // unsupported version 
    } 
}
?>