Quick Updates plugin [support]

[sicness]

Link to Quick Updates Plugin: https://www.zen-cart.com/downloads.php?do=file&id=26


I tried to install Quick Updates 1.3 but i had a problem with MySQL query.
configuration key is already exist.
I thought is it good idea to add my DB prefix for zen cart to the sql query there is somethink different wrong ?

Here I Uploaded an attachment screenshot which describes more better then my words



Im using Zen Cart 1.3.0.2
Win 2003 adv server R2

Radoslav
Thanks to any help :)

[ruta]

The same problem...
Any body could help us?

[sicness]

any ideas please Im stuck

[Merlinpa1969]

Ok coupla things,
when you use an sql file through the zen cart sql utility you do NOT need to add the prefix, it will be added automatically.
your tables probably look like
zen_zen_table name

[sicness]

10x for the quick one

my DB prefix is "zen"

i set my

# Fix certain PHP values

<IfModule mod_php4.c>
php_value session.use_trans_sid 0
php_value register_globals 1
php_flag register_globals on
</IfModule>

# to turn off register_globals
# php_value register_globals 0

nothing ...

[Reesy]

Run the sql line by line to insert the values that way.
If some of it already exists you will find out this way, and if it doesnt then it will add it.
I had the same problem with the above and eventually added it all by doing it a line at a time.
Good luck

[Merlinpa1969]

OK what I am saying,
use the sql updater in the zen cart admin,

DO NOT ADD your prefix to the sql file,

[sicness]

this is update sql file

INSERT INTO configuration_group (`configuration_group_id`, `configuration_group_title`, `configuration_group_description`, `sort_order`, `visible`) VALUES ('300', 'Quick Updates', 'Here you can configure what you will be able to modify in Quick Updates.', '300', '1');
1062 Duplicate entry '300' for key 1
in:
[INSERT INTO zenconfiguration_group (configuration_group_id, configuration_group_title, configuration_group_description, sort_order, visible) VALUES ('300', 'Quick Updates', 'Here you can configure what you will be able to modify in Quick Updates.', '300', '1');]
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.

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 model.', 'QUICKUPDATES_DISPLAY_MODEL', 'true', 'Enable/Disable the model displaying', 300, 1, '2003-06-04 05:04:11', '2003-06-04 04:18:06', NULL, 'zen_cfg_select_option(array('true', 'false'),'),
('', 'Modify the model.', 'QUICKUPDATES_MODIFY_MODEL', 'false', 'Allow/Disallow the model modification', 300, 2, '2003-06-04 05:04:07', '2003-06-04 04:25:57', NULL, 'zen_cfg_select_option(array('true', 'false'),'),
('', 'Display the name.', 'QUICKUPDATES_DISPLAY_NAME', 'true', 'Enable/Disable the name displaying', 300, 3, '2003-06-04 05:04:11', '2003-06-04 04:18:06', NULL, 'zen_cfg_select_option(array('true', 'false'),'),
('', 'Modify the name of the products.', 'QUICKUPDATES_MODIFY_NAME', 'false', 'Allow/Disallow the name modification?', 300, 4, '2003-06-04 05:04:01', '2003-06-04 04:30:31', NULL, 'zen_cfg_select_option(array('true', 'false'),'),
('', 'Display the Description.', 'QUICKUPDATES_DISPLAY_DESCRIPTION', 'true', 'Enable/Disable the displaying of description', 300, 5, '2003-06-04 05:04:11', '2003-06-04 04:18:06', NULL, 'zen_cfg_select_option(array('true', 'false'),'),
('', 'Modify the description of the products.', 'QUICKUPDATES_MODIFY_DESCRIPTION', 'true', 'Allow/Disallow the Description modification?', 300, 6, '2003-06-04 05:04:01', '2003-06-04 04:30:31', NULL, 'zen_cfg_select_option(array('true', 'false'),'),
('', 'Modify the status of the products.', 'QUICKUPDATES_DISPLAY_STATUS', 'true', 'Allow/Disallow the Status displaying and modification', 300, 7, '2003-06-04 05:07:11', '2003-06-04 05:00:58', NULL, 'zen_cfg_select_option(array('true', 'false'),'),
('', 'Modify the weight of the products.', 'QUICKUPDATES_DISPLAY_WEIGHT', 'true', 'Allow/Disallow the Weight displaying and modification?', 300, 8, '2003-06-04 05:06:44', '2003-06-04 04:33:16', NULL, 'zen_cfg_select_option(array('true', 'false'),'),
('', 'Modify the quantity of the products.', 'QUICKUPDATES_DISPLAY_QUANTITY', 'true', 'Allow/Disallow the quantity displaying and modification', 300, 9, '2003-06-04 05:06:48', '2003-06-04 04:34:34', 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', 300, 10, '2003-06-04 05:06:57', '2003-06-04 04:37:40', 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', 300, 11, '2003-06-04 05:06:40', '2003-06-04 04:31:53', 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', 300, 12, '2003-06-04 05:07:02', '2003-06-04 04:38:45', 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 ', 300, 14, '2003-06-04 05:19:13', '2003-06-04 05:15:50', 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', 300, 15, '2003-06-04 05:19:08', '2003-06-04 05:17:05', NULL, 'zen_cfg_select_option(array('true', 'false'),'),
('', 'Display the manufacturer.', 'QUICKUPDATES_DISPLAY_MANUFACTURER', 'false', 'Do you want just display the manufacturer ?', 300, 16, '2003-06-04 05:19:08', '2003-06-04 05:17:05', NULL, 'zen_cfg_select_option(array('true', 'false'),'),
('', 'Display the tax.', 'QUICKUPDATES_DISPLAY_TAX', 'true', 'Do you want just display the tax ?', 300, 17, '2003-06-04 05:19:08', '2003-06-04 05:17:05', 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 ?', 300, 18, '2003-06-04 05:19:08', '2003-06-04 05:17:05', NULL, 'zen_cfg_select_option(array('true', 'false'),');

Error Failed: 1
Error ERROR: Cannot insert configuration_key "" because it already exists
Warning Note: 1 statements ignored. See "upgrade_exceptions" table for additional details.

this is the uppgrade sql file

I cant get it

[sicness]

Ok I found a salution throught the PHPMYADMIN

In the query file
for the configuration table I added my DB prefix and it worked.

I mean it executed the query without any problem :))]



THanks for all ur attention and help
sorry for being such a pain :))

Thanks
Radoslav


Also I want to thanks to the creator :)) good job

[jettrue]

Can some one point me to the download link for Quick Updates 1.3? I can't find it.

Thanks!