Forums / Addon Admin Tools / Quick Updates plugin [support]

Quick Updates plugin [support]

Results 1 to 20 of 670
26 Jul 2006, 10:58
#1
sicness avatar

sicness

Zen Follower

Join Date:
Apr 2006
Posts:
195
Plugin Contributions:
0

Quick Updates plugin [support]

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 :)
31 Jul 2006, 09:42
#2
ruta avatar

ruta

New Zenner

Join Date:
Jan 2004
Posts:
36
Plugin Contributions:
0

Re: Quick Updates plugin [support]

The same problem...
Any body could help us?
06 Aug 2006, 11:52
#3
sicness avatar

sicness

Zen Follower

Join Date:
Apr 2006
Posts:
195
Plugin Contributions:
0

Re: Quick Updates plugin [support]

any ideas please Im stuck :(
06 Aug 2006, 15:27
#4
merlinpa1969 avatar

merlinpa1969

Totally Zenned

Join Date:
Mar 2004
Posts:
13,031
Plugin Contributions:
1

Re: Quick Updates plugin [support]

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
07 Aug 2006, 09:49
#5
sicness avatar

sicness

Zen Follower

Join Date:
Apr 2006
Posts:
195
Plugin Contributions:
0

Re: Quick Updates plugin [support]

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 ...:schmoll:
07 Aug 2006, 09:51
#6
reesy avatar

reesy

Totally Zenned

Join Date:
Mar 2005
Posts:
535
Plugin Contributions:
3

Re: Quick Updates plugin [support]

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
07 Aug 2006, 09:52
#7
merlinpa1969 avatar

merlinpa1969

Totally Zenned

Join Date:
Mar 2004
Posts:
13,031
Plugin Contributions:
1

Re: Quick Updates plugin [support]

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

DO NOT ADD your prefix to the sql file,
07 Aug 2006, 10:03
#8
sicness avatar

sicness

Zen Follower

Join Date:
Apr 2006
Posts:
195
Plugin Contributions:
0

Re: Quick Updates plugin [support]

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 :blink:
07 Aug 2006, 15:40
#9
sicness avatar

sicness

Zen Follower

Join Date:
Apr 2006
Posts:
195
Plugin Contributions:
0

Re: Quick Updates plugin [support]

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
16 Aug 2006, 00:55
#10
jettrue avatar

jettrue

Totally Zenned

Join Date:
Jan 2005
Posts:
3,651
Plugin Contributions:
2

Re: Quick Updates plugin [support]

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

Thanks!
16 Aug 2006, 02:51
#11
blessisaacola avatar

blessisaacola

Totally Zenned

Join Date:
Feb 2004
Posts:
1,875
Plugin Contributions:
1

Re: Quick Updates plugin [support]

jettrue:

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

Thanks!


Here is the link to the download: http://www.zen-cart.com/index.php?main_page=product_contrib_info&cPath=40_41&products_id=101

Please make sure you read the other thread about this contribution before installing it. This contribution acts possessed at times. :yuck:
16 Aug 2006, 04:08
#12
jettrue avatar

jettrue

Totally Zenned

Join Date:
Jan 2005
Posts:
3,651
Plugin Contributions:
2

Re: Quick Updates plugin [support]

Ah, thanks. People were talking about a download named Quick_updates_v.1.3, the one in the download section is 1.1. Assumed there was a more recent one...
16 Aug 2006, 04:51
#13
blessisaacola avatar

blessisaacola

Totally Zenned

Join Date:
Feb 2004
Posts:
1,875
Plugin Contributions:
1

Re: Quick Updates plugin [support]

jettrue:

Ah, thanks. People were talking about a download named Quick_updates_v.1.3, the one in the download section is 1.1. Assumed there was a more recent one...


Perhaps there is a v1.3 but I am not sure where it is...if you find it and it's more stable please post a link here as I having being holding off due to all the issues with the current one. I thought that V1.3 was to imply compatibility with ZC 1.3. On the surface the mod installs find and everything looks good until you try to use it and it start messing up columns, descriptions and things like that.
16 Aug 2006, 13:12
#14
jettrue avatar

jettrue

Totally Zenned

Join Date:
Jan 2005
Posts:
3,651
Plugin Contributions:
2

Re: Quick Updates plugin [support]

BlessIsaacola:

Perhaps there is a v1.3 but I am not sure where it is...if you find it and it's more stable please post a link here as I having being holding off due to all the issues with the current one. I thought that V1.3 was to imply compatibility with ZC 1.3. On the surface the mod installs find and everything looks good until you try to use it and it start messing up columns, descriptions and things like that.


That's what I thought at first too, but then I saw this post:
http://www.zen-cart.com/forum/showpost.php?p=209150&postcount=4

Where she specifically spells out the 1.3 filename. I've posted in that thread to see if anyone has it for download. She mentioned zenportali which seems to be down.
16 Aug 2006, 15:47
#15
blessisaacola avatar

blessisaacola

Totally Zenned

Join Date:
Feb 2004
Posts:
1,875
Plugin Contributions:
1

Re: Quick Updates plugin [support]

Jettrue, you won't believe this, there is actually a v1.3 out there because I have a copy I downloaded to my computer. It still has problem but if you want it I'd be glad to email it to you if you want to send me a PM with your email address.
17 Aug 2006, 05:27
#16
jettrue avatar

jettrue

Totally Zenned

Join Date:
Jan 2005
Posts:
3,651
Plugin Contributions:
2

Re: Quick Updates plugin [support]

Isaacola -- what issues are you having with this?

I updated the sql file, which fixes the problem the original poster and others are having. Here is the coorect 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');

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 the commercial margin be activated or not ?', 566, 18, '2003-06-04 05:19:08', '2003-06-04 05:17:05', NULL, 'zen_cfg_select_option(array(''true'', ''false''),');


With these fixes, it now seems to work, unless people are noticing other issues?
17 Aug 2006, 12:27
#17
blessisaacola avatar

blessisaacola

Totally Zenned

Join Date:
Feb 2004
Posts:
1,875
Plugin Contributions:
1

Re: Quick Updates plugin [support]

Jettrue, thanks for posting the update. I have not try it with the new SQL you provide so I will report back when I try it. Prior to your fix, the biggest problem I was experiencing is that it was truncating the product description and it's not because I set any limit for the maximum description to display. It was messing up the descriptions for the products.

I will apply your fix and give it a go again.

Thanks!
17 Aug 2006, 14:52
#18
jettrue avatar

jettrue

Totally Zenned

Join Date:
Jan 2005
Posts:
3,651
Plugin Contributions:
2

Re: Quick Updates plugin [support]

BlessIsaacola:

Jettrue, thanks for posting the update. I have not try it with the new SQL you provide so I will report back when I try it. Prior to your fix, the biggest problem I was experiencing is that it was truncating the product description and it's not because I set any limit for the maximum description to display. It was messing up the descriptions for the products.

I will apply your fix and give it a go again.

Thanks!


The problem with that is that the description field was using a textbox instead of a textarea. I guess perhaps with zen there is a limit of 1024 characters for a text box? Anyway, you have to go to admin/quick_updates and change this:

if(QUICKUPDATES_DISPLAY_DESCRIPTION == 'true')if(QUICKUPDATES_MODIFY_DESCRIPTION == 'true')echo "<td class=\"smallText\" align=\"center\"><input type=\"textbox\" size=\"45\" name=\"product_new_description[".$products['products_id']."]\" value=\"".str_replace("\"",""",$products['products_description'])."\"></td>\n";//else echo "<td class=\"smallText\" align=\"left\">".$products['products_name']."</td>\n";}else{ echo "<td class=\"smallText\" align=\"left\">";}


to this:
if(QUICKUPDATES_DISPLAY_DESCRIPTION == 'true')if(QUICKUPDATES_MODIFY_DESCRIPTION == 'true')echo "<td class=\"smallText\" align=\"center\"><textarea wrap=\"soft\" cols=\"35%\" rows=\"5\" name=\"product_new_description[".$products['products_id']."]\" >" .str_replace("\"",""",$products['products_description'])."</textarea></td>\n";//else echo "<td class=\"smallText\" align=\"left\">".$products['products_name']."</td>\n";}else{ echo "<td class=\"smallText\" align=\"left\">"
17 Aug 2006, 15:20
#19
blessisaacola avatar

blessisaacola

Totally Zenned

Join Date:
Feb 2004
Posts:
1,875
Plugin Contributions:
1

Re: Quick Updates plugin [support]

Thank you so much Jettrue!:thumbsup:
22 Aug 2006, 16:04
#20
a_berezin avatar

a_berezin

Deceased

Join Date:
Aug 2004
Posts:
1,782
Plugin Contributions:
4

Re: Quick Updates plugin [support]

Moving to this Thread.

kelvyn:

Well, there is this contribution, but as you can see, there are problems with it.
Plus the fact that you can't filter by category.

The problem for Zen Cart is that the customer side is fine (checkout excepted) but the admin side is hell if you have over a few products. I need to be able to delete or add or move or update more than one product at a time. Easypopulate is OK for half of this, but as for moving products, it takes TOO many clicks!


Very dirty coded module.:down: It is a lot of errors and discrepancies, bad html-code, problems with security.
I did not rewrite it. Simply cleaned.

Download and test.