I'm afraid I do not know how to set up a SQL query tp update the products.
At this point it does not matter what I do to the mass actions, or any limits I changed the limit to 50. All that occurs is I get an endless loop of;
Warning: Unresponsive Script.
A script on this page may be busy, or it may have stopped responding. You can stop the script now, open the script in the debugger, or let the script continue.
Script:
www.mcgheesminiatures.com/media/jui/js/jquery.js
577
When I hit continue, it shortly pops up the message again only with a different line number. I never get a confirmation that the action has been completed.
But a bigger concern is that when I try to click on "Products" in the HikaShop work space, I get the a white page with the following error message:
Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 34147697 bytes) in /home2/mcgheesm/public_html/plugins/system/debug/debug.php on line 1119
So I am not able to even tell if I have products listed on the site.
Somehow I need to clear whatever is in the memory. I have tried to clear my cashe from the Joomla backend. This did not solve my problem, but did cause all of the thumbnails to disssapear from my site.
The same jui script error occurs on the front end of my website when going into the HikaShop section.
None of these errors ocured until I attempted a Mass Action - Delete all products. However, from the start, the mass action did have a limitation of 500 records
I am true clueless about how to resolve these issues. . I will be VERY grateful for any help I can get.
Thanks