Zen Cart Logo
Forums / Addon Admin Tools / Quick Updates plugin [support]

Quick Updates plugin [support]

Views: 180,415

Results 601 to 620 of 670
29 Jul 2016, 12:29 AM
#601
jeking avatar

jeking

Totally Zenned

Join Date:
Oct 2005
Location:
Chicago, IL USA
Posts:
1,592
Plugin Contributions:
0

Quick Updates plugin [support]

For reference, there is an updated version on GitHub that does fix this issue as well as a few others
https://github.com/DivaVocals/zen_QuickUpdates

4 Aug 2016, 9:31 PM
#602
dspeak35640 avatar

dspeak35640

New Zenner

Join Date:
Dec 2015
Location:
Alabama
Posts:
51
Plugin Contributions:
0

Re: Quick Updates plugin [support]

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.

4 Aug 2016, 11:52 PM
#603
jeking avatar

jeking

Totally Zenned

Join Date:
Oct 2005
Location:
Chicago, IL USA
Posts:
1,592
Plugin Contributions:
0

Re: Quick Updates plugin [support]

dspeak35640:

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?

5 Aug 2016, 4:59 PM
#604
dspeak35640 avatar

dspeak35640

New Zenner

Join Date:
Dec 2015
Location:
Alabama
Posts:
51
Plugin Contributions:
0

Re: Quick Updates plugin [support]

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

5 Aug 2016, 6:34 PM
#605
dspeak35640 avatar

dspeak35640

New Zenner

Join Date:
Dec 2015
Location:
Alabama
Posts:
51
Plugin Contributions:
0

Re: Quick Updates plugin [support]

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

5 Aug 2016, 6:50 PM
#606
dbltoe avatar

dbltoe

Totally Zenned

Join Date:
Jan 2004
Location:
N of San Antonio TX
Posts:
9,767
Plugin Contributions:
9

Re: Quick Updates plugin [support]

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

5 Aug 2016, 7:32 PM
#607
lat9 avatar

lat9

Administrator

Join Date:
Sep 2009
Location:
Stuart, FL
Posts:
14,067
Plugin Contributions:
56

Re: Quick Updates plugin [support]

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

INSERT INTO zc_configuration_group ([B]configuration_group_id, [/B]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".

5 Aug 2016, 7:38 PM
#608
dspeak35640 avatar

dspeak35640

New Zenner

Join Date:
Dec 2015
Location:
Alabama
Posts:
51
Plugin Contributions:
0

Re: Quick Updates plugin [support]

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

5 Aug 2016, 8:27 PM
#609
dbltoe avatar

dbltoe

Totally Zenned

Join Date:
Jan 2004
Location:
N of San Antonio TX
Posts:
9,767
Plugin Contributions:
9

Re: Quick Updates plugin [support]

gotta get new trifocals:blush:

13 Aug 2016, 5:09 PM
#610
jsarwar avatar

jsarwar

Zen Follower

Join Date:
Jul 2012
Posts:
347
Plugin Contributions:
0

Re: Quick Updates plugin [support]

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

13 Aug 2016, 5:33 PM
#611
lat9 avatar

lat9

Administrator

Join Date:
Sep 2009
Location:
Stuart, FL
Posts:
14,067
Plugin Contributions:
56

Re: Quick Updates plugin [support]

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

INSERT INTO zen_configuration_group ([B]configuration_group_id,[/B] 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')
13 Aug 2016, 7:47 PM
#612
jsarwar avatar

jsarwar

Zen Follower

Join Date:
Jul 2012
Posts:
347
Plugin Contributions:
0

Re: Quick Updates plugin [support]

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 
    } 
}
?>
13 Aug 2016, 7:55 PM
#613
jsarwar avatar

jsarwar

Zen Follower

Join Date:
Jul 2012
Posts:
347
Plugin Contributions:
0

Re: Quick Updates plugin [support]

Got it working. I was looking at different line then what you referring to.

13 Aug 2016, 7:57 PM
#614
lat9 avatar

lat9

Administrator

Join Date:
Sep 2009
Location:
Stuart, FL
Posts:
14,067
Plugin Contributions:
56

Re: Quick Updates plugin [support]

Change all occurrences of (NULL, to ( in the following section:

        (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!
    } 
}
26 Aug 2016, 5:00 PM
#615
lidlchris avatar

lidlchris

Zen Follower

Join Date:
Feb 2013
Posts:
345
Plugin Contributions:
0

Re: Quick Updates plugin [support]

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

26 Aug 2016, 5:05 PM
#616
jeking avatar

jeking

Totally Zenned

Join Date:
Oct 2005
Location:
Chicago, IL USA
Posts:
1,592
Plugin Contributions:
0

Re: Quick Updates plugin [support]

lidlchris:

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.

26 Aug 2016, 6:14 PM
#617
lidlchris avatar

lidlchris

Zen Follower

Join Date:
Feb 2013
Posts:
345
Plugin Contributions:
0

Re: Quick Updates plugin [support]

jeking:

Check your error logs for details on what the error actually is.

here is what i see:

[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

26 Aug 2016, 6:57 PM
#618
lidlchris avatar

lidlchris

Zen Follower

Join Date:
Feb 2013
Posts:
345
Plugin Contributions:
0

Re: Quick Updates plugin [support]

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.

2 Sep 2016, 12:34 AM
#619
resqjoc avatar

resqjoc

New Zenner

Join Date:
Jan 2015
Posts:
19
Plugin Contributions:
0

Re: Quick Updates plugin [support]

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?

8 Oct 2016, 7:33 PM
#620
resqjoc avatar

resqjoc

New Zenner

Join Date:
Jan 2015
Posts:
19
Plugin Contributions:
0

Re: Quick Updates plugin [support]

Anyone!!!!