Quick Updates plugin [support]

frank18:

Thanks a zillion, will try this on a local install sometime later tonite (weather is too nice now, need to take my dog for a run on the beach...)

cool.. let me know how you make out..

DivaVocals:

cool.. let me know how you make out..

Thumbs up :thumbsup::thumbsup: on all counts!

On a local 1.5.3 clone I did an upgrade 2.06 > 2.08 as per the (old) instructions plus deleting the 2 files mentioned in my earlier post, namely

admin/includes/functions/extra_functions/quick_updates_functions.php
admin/includes/functions/extra_functions/reg_quick_updates.php

If they are not deleted then you get 2 entries of 'Quick Updates' in Admin > Catalog

Just a minor bit: noted that in the file

admin/includes/languages/english/quick_updates.php

line 24 still shows version 2.07

Did a test run with products priced by attributes (quantity discounts) and all prices update as expected!

Great job Diva!

Cheers / Frank

frank18:

Thumbs up :thumbsup::thumbsup: on all counts!

On a local 1.5.3 clone I did an upgrade 2.06 > 2.08 as per the (old) instructions plus deleting the 2 files mentioned in my earlier post, namely

admin/includes/functions/extra_functions/quick_updates_functions.php
admin/includes/functions/extra_functions/reg_quick_updates.php

If they are not deleted then you get 2 entries of 'Quick Updates' in Admin > Catalog

Just a minor bit: noted that in the file

admin/includes/languages/english/quick_updates.php

line 24 still shows version 2.07

Did a test run with products priced by attributes (quantity discounts) and all prices update as expected!

Great job Diva!

Cheers / Frank
You're welcome.. I can only take credit for writing up the spec and testing.. The heavy lifting was executed by an an awesome community member!!:laugh:

Installed v2.06a to ZC1.5.1. Generally work as should but in some point stopping update data. For example I trying change sort orders for products in large directory. After two-three saves it stopping change the data. Is it any solution?

Thanks

ksivv:

Installed v2.06a to ZC1.5.1. Generally work as should but in some point stopping update data. For example I trying change sort orders for products in large directory. After two-three saves it stopping change the data. Is it any solution?

Thanks

1. Check out the Runtime Configuration section of the PHP manual - post_max_size and max_input_vars.

2. If you are using Suhosin with Hardened PHP, check suhosin.post.max_vars and suhosin.request.max_vars.

3. Better use ajax editors ;)

Error report,Please help me out

I installed quick_updates-v2.06a with zen-cat 1.54,both install no problem. it's works.

In our admin>catalog>quick updates page,we have a red message
“Quick Updates Configuration Keys Not installed. Please install your configuration by clicking Install”
But when I clicked the install,got a blank page with "WARNING: An Error occurred, please refresh the page and try again."

So then I go to my logs to check the problem,I copy the debug message here:

[05-Feb-2015 03:14:37 America/New_York] PHP Warning: mysql_insert_id(): Access denied for user 'root'@'localhost' (using password: NO) in /home/playscom/public_html/demo/admin/includes/functions/extra_functions/quick_updates_functions.php on line 40
[05-Feb-2015 03:14:37 America/New_York] PHP Warning: mysql_insert_id(): A link to the server could not be established in /home/playscom/public_html/demo/elocin2/includes/functions/extra_functions/quick_updates_functions.php on line 40
[05-Feb-2015 03:14:37 America/New_York] PHP Fatal error: 1064:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE configuration_group_id =' at line 1 :: UPDATE zen_configuration_group SET sort_order = WHERE configuration_group_id = ==> (as called by) /home/playscom/public_html/demo/admin/includes/functions/extra_functions/quick_updates_functions.php on line 41 <== in /home/playscom/public_html/demo/includes/classes/db/mysql/query_factory.php on line 155

paranoia:

Error report,Please help me out

I installed quick_updates-v2.06a with zen-cat 1.54,both install no problem. it's works.

In our admin>catalog>quick updates page,we have a red message
“Quick Updates Configuration Keys Not installed. Please install your configuration by clicking Install”
But when I clicked the install,got a blank page with "WARNING: An Error occurred, please refresh the page and try again."

So then I go to my logs to check the problem,I copy the debug message here:

[05-Feb-2015 03:14:37 America/New_York] PHP Warning: mysql_insert_id(): Access denied for user 'root'@'localhost' (using password: NO) in /home/playscom/public_html/demo/admin/includes/functions/extra_functions/quick_updates_functions.php on line 40
[05-Feb-2015 03:14:37 America/New_York] PHP Warning: mysql_insert_id(): A link to the server could not be established in /home/playscom/public_html/demo/elocin2/includes/functions/extra_functions/quick_updates_functions.php on line 40
[05-Feb-2015 03:14:37 America/New_York] PHP Fatal error: 1064:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE configuration_group_id =' at line 1 :: UPDATE zen_configuration_group SET sort_order = WHERE configuration_group_id = ==> (as called by) /home/playscom/public_html/demo/admin/includes/functions/extra_functions/quick_updates_functions.php on line 41 <== in /home/playscom/public_html/demo/includes/classes/db/mysql/query_factory.php on line 155Haven't had time to look at updating/testing this to work with Zen Cart v1.5.4 at all.. and I never really got around to submitting the last version to the downloads either.. my bad I get a moment I'll see if I can SEE what the issue is..

DivaVocals's Avatar ,Nice to you once again. Thanks for your quick reply:smile:

paranoia:

DivaVocals's Avatar ,Nice to you once again. Thanks for your quick reply:smile:

This is why I tell folks to READ through the support threads.. :smile: I get flak for it, but it is the truth..

if you look at the TOP of this page you will see a quote from a previous post which eludes to deleting the file that the error message you got complained about.. I don't have time to download it and look at this right now, but are you UPGRADING this module from an older version of it?? If so I KNOW I included instructions in the readme to remove it..

Finally (and in the name of WHY you should read through the support thread) in that same post at the TOP of this page we are discussing a NEW version of this module.. if you page back you'll find the link to it..

Don't suppose anybody encountered this error at all with the 2.07 version?:-

1136:Column count doesn't match value count at row 1 :: INSERT INTO zen_configuration  VALUES 

I got a similar issue with another module, so I know it is not common and doesn't happen to everyone. Namely the RMA module. Thanks in advance for an pointers. I get the 'warning: errors' almost blank admin page. I got the above error snippet from a error log. If I deleted the auto loader file in the release I can use the admin as normal.

Thanks for your help,When I readed all information in this support threads,fixed this problem,but now have 2 of "quick updated" tag in my admin>catalog dropdown.

Do you know how was that happen?

DivaVocals:

This is why I tell folks to READ through the support threads.. :smile: I get flak for it, but it is the truth..

if you look at the TOP of this page you will see a quote from a previous post which eludes to deleting the file that the error message you got complained about.. I don't have time to download it and look at this right now, but are you UPGRADING this module from an older version of it?? If so I KNOW I included instructions in the readme to remove it..

Finally (and in the name of WHY you should read through the support thread) in that same post at the TOP of this page we are discussing a NEW version of this module.. if you page back you'll find the link to it..

Thanks for your help,When I readed all information in this support threads,fixed this problem,but now have 2 of "quick updated" tag in my admin>catalog dropdown.

Do you know how was that happen?

I also have 2 quick updates links under catalog

Background
I’m working on an update “new_store” for zen-cart 1.5.4, using the latest quick updates version downloaded from DivaVocals’ Github. My current live store is on the same server using quick updates 2.06 working on zen-cart 1.5.1.

I have tried everything, including deleting all quick updates files (on the new_store) indicated in the instructions, and this thread, and when that did not work, manually deleting every quick updates file in the “new_store”, manually running the uninstall SQL (the uninstall button is inoperable) and re-uploading the mod and still have the two links. Before people say read the thread, I did delete the three files indicated in the instructions, and these two files:

admin/includes/functions/extra_functions/quick_updates_functions.php
admin/includes/functions/extra_functions/reg_quick_updates.php

One final thing. When I manually deleted all files, and manually ran the uninstall SQL, even when I started over, there was no install button, I uploaded all files, and quick updates appeared. No install link to click. It appears to be working fine, except I have 2 links. Is there a fix to remove the two links?

paranoia:

Thanks for your help,When I readed all information in this support threads,fixed this problem,but now have 2 of "quick updated" tag in my admin>catalog dropdown.

Do you know how was that happen?

The double entry is caused by two separate database entries, which are identical except for the sort order. In my case, in updating from another version, all files were deleted, but the uninstall script did not remove the database table. So you need to delete the earlier entry.

backup your zen cart database
go to cpanel »» phpmyadmin »» click on the database »» click zen_admin_pages »» click browse

you should find two entries (not necessarily on the same page) like this:
quick_updates_catalog BOX_CATALOG_QUICK_UPDATES

one had 'configuration', 'Y', 103 (the old version)
the other had 'configuration', 'Y', 1010 (the beta version from divavocals' GitHub)

Delete the entry that has the earlier module version, (103) table, and the extra entry in the admin will disappear. This link gives an explanation of the admin table:
http://www.zen-cart.com/content.php?327-Adding-a-menu-item-to-the-v1-5-0-admin

It’s pretty shocking that a month has passed since you posted, and no one could help with this issue. I’m not sure what’s happened to this forum.

Two identical entries were for the catalog for quick updates, and both had different sort orders.

zen_admin_pages

I searched the files on my computer for the older version, and it had a sort order of 103. The other entry in the phpmyadmin had an entry of 1010, so I deleted the 103 entry, and the table was removed from the admin.

paranoia:

Thanks for your help,When I readed all information in this support threads,fixed this problem,but now have 2 of "quick updated" tag in my admin>catalog dropdown.

Do you know how was that happen?

The double entry is caused by two separate database entries, which are identical except for the sort order. In my case, in updating from another version, all files were deleted, but the uninstall script did not remove the database table. So you need to delete the earlier entry.

backup your zen cart database
go to cpanel »» phpmyadmin »» click on the database »» click zen_admin_pages »» click browse

you should find two entries (not necessarily on the same page) like this:
quick_updates_catalog BOX_CATALOG_QUICK_UPDATES

one had 'configuration', 'Y', 103 (the old version)
the other had 'configuration', 'Y', 1010 (the beta version from divavocals' GitHub)

Delete the entry that has the earlier module version, (103) table, and the extra entry in the admin will disappear. This link gives an explanation of the admin table:
http://www.zen-cart.com/content.php?327-Adding-a-menu-item-to-the-v1-5-0-admin

It’s pretty shocking that a month has passed since you posted, and no one could help with this issue. I’m not sure what’s happened to this forum.

sadie:

It’s pretty shocking that a month has passed since you posted, and no one could help with this issue. I’m not sure what’s happened to this forum.Has it been a month?? Hmmm.. Shocking eh??:no:

What happened?? Okay well speaking only for myself here.. I've been busy.. Busy with paying projects.. too busy with projects that actually help put food on my table to in fact to get back to troubleshooting something I maintain when I have FREE time..

Thanks for sharing the issue, and you're posting the solution here will help others.. I'll test what went wrong in the uninstaller and make the changes accordingly.. When my FREE time permits.. In the meantime the beauty of Github is ANYONE can do this and send me a pull request, and I can incorporate the fix into the master repo..

Just installed Quick updates on my server, everything runs great but there's a broken image above the uninstall Quick Update link on the upper right hand corner of the page. It appears to simply point to my /image/ directory, which it's not browsable for security reasons.

What exactly is supposed to be at this location, and how can I "fix" it?
Attached image for reference.
Server is ZC 1.5.5a, Quick updates v.2.07

Thanks.

chibipaw:

Just installed Quick updates on my server, everything runs great but there's a broken image above the uninstall Quick Update link on the upper right hand corner of the page. It appears to simply point to my /image/ directory, which it's not browsable for security reasons.

What exactly is supposed to be at this location, and how can I "fix" it?
Attached image for reference.
Server is ZC 1.5.5a, Quick updates v.2.07

Thanks.

In the image your heading shows v.2.06 but you are stating that you are using v.2.07.

Did you recently upgrade from 2.06 to 2.07? If so, are all the new files uploaded?

Odd. I just pulled whatever the using the "download latest" on July 25th. The zip file is actually labeled quick_updates-v2.07.zip. Perhaps some of the definitions in the package itself hasn't been updated, which it's rather common actually. But I notice there's now a 2.07b. I'll update to that and see if it'll go away, and the version number would be correct in that package..

frank18:

In the image your heading shows v.2.06 but you are stating that you are using v.2.07.

Did you recently upgrade from 2.06 to 2.07? If so, are all the new files uploaded?

Updated to v2.07b, got rid of that weird broken image box.

However, someone done did goofed on admin/includes/languages/english/quick_updates.php .
in line 24 it reads:
define('HEADING_TITLE', 'Quick Updates - v2.06');

So plugged in a silly definition into mine.

Cheers.

frank18:

In the image your heading shows v.2.06 but you are stating that you are using v.2.07.

Did you recently upgrade from 2.06 to 2.07? If so, are all the new files uploaded?