Results 1 to 7 of 7
  1. 30 Jul 2020, 06:53 PM #1
    akjnashville
    akjnashville is offline New Zenner
    Join Date
    Oct 2019
    Location
    Nashville TN
    Posts
    15
    Plugin Contributions
    0

    image problem Freezing Error when updating certain current products

    v1.5.6c
    Server OS: Linux 3.10.0-693.17.1.2.ELK.el6.x86_64
    PHP File Uploads: OnUpload Max Size: 256M
    PHP Memory Limit: 256M
    POST Max Size: 260M
    Database Engine: MySQL 5.6.41-84.1
    HTTP Server: Apache
    PHP Version: 7.1.14 (Zend: 3.1.0)

    Ever since ive updated to this version ive had random products constantly freeze if I try to update the description or price.

    here's an example that I screen recorded:
    https://youtu.be/BAwNrvFUlng
    Reply With Quote Reply With Quote
  2. 30 Jul 2020, 07:01 PM #2
    DrByte's Avatar
    DrByte
    DrByte is offline Sensei
    Join Date
    Jan 2004
    Posts
    66,373
    Blog Entries
    7
    Plugin Contributions
    274

    Default Re: Freezing Error when updating certain current products

    By "freeze" do you mean "the form never submits"?

    I wonder if perhaps the HTML in your product descriptions is broken (or opens/closes new forms) and is breaking the preview screen such that the form-button isn't actually usable.

    Are there any errors in the logs directory? https://docs.zen-cart.com/user/troub...ng/debug_logs/
    .

    Zen Cart - putting the dream of business ownership within reach of anyone!
    Donate to: DrByte directly or to the Zen Cart team as a whole

    Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
    Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.
    Reply With Quote Reply With Quote
  3. 30 Jul 2020, 07:36 PM #3
    akjnashville
    akjnashville is offline New Zenner
    Join Date
    Oct 2019
    Location
    Nashville TN
    Posts
    15
    Plugin Contributions
    0

    Default Re: Freezing Error when updating certain current products

    correct the form doesn't submit the page just sits there.... The last log is from yesterday:

    Code:
    [29-Jul-2020 12:12:21 America/Chicago] Request URI: /index.php?main_page=index&r_link=%2F3824-c-1824_76_241_1264%2F3824-x-314-socket-head-black-oxide-p-12626&currency=EUR, IP address: 114.119.162.42
#1  mysqli_connect() called at [/home3/polishdb/public_html/includes/classes/db/mysql/query_factory.php:64]
#2  queryFactory->connect() called at [/home3/polishdb/public_html/includes/init_includes/init_database.php:24]
#3  require(/home3/polishdb/public_html/includes/init_includes/init_database.php) called at [/home3/polishdb/public_html/includes/autoload_func.php:48]
#4  require(/home3/polishdb/public_html/includes/autoload_func.php) called at [/home3/polishdb/public_html/includes/application_top.php:170]
#5  require(/home3/polishdb/public_html/includes/application_top.php) called at [/home3/polishdb/public_html/index.php:26]
--> PHP Warning: mysqli_connect(): (HY000/1040): Too many connections in /home3/polishdb/public_html/includes/classes/db/mysql/query_factory.php on line 64.

[29-Jul-2020 12:12:21 America/Chicago] Request URI: /index.php?main_page=index&r_link=%2F3824-c-1824_76_241_1264%2F3824-x-314-socket-head-black-oxide-p-12626&currency=EUR, IP address: 114.119.162.42
#1  mysqli_connect() called at [/home3/polishdb/public_html/includes/classes/db/mysql/query_factory.php:64]
#2  queryFactory->connect() called at [/home3/polishdb/public_html/includes/init_includes/init_database.php:24]
#3  require(/home3/polishdb/public_html/includes/init_includes/init_database.php) called at [/home3/polishdb/public_html/includes/autoload_func.php:48]
#4  require(/home3/polishdb/public_html/includes/autoload_func.php) called at [/home3/polishdb/public_html/includes/application_top.php:170]
#5  require(/home3/polishdb/public_html/includes/application_top.php) called at [/home3/polishdb/public_html/index.php:26]
--> PHP Warning: mysqli_connect(): (HY000/1040): Too many connections in /home3/polishdb/public_html/includes/classes/db/mysql/query_factory.php on line 64.

[29-Jul-2020 12:12:21 America/Chicago] Request URI: /index.php?main_page=index&r_link=%2F3824-c-1824_76_241_1264%2F3824-x-314-socket-head-black-oxide-p-12626&currency=EUR, IP address: 114.119.162.42
#1  mysqli_connect() called at [/home3/polishdb/public_html/includes/classes/db/mysql/query_factory.php:64]
#2  queryFactory->connect() called at [/home3/polishdb/public_html/includes/init_includes/init_database.php:24]
#3  require(/home3/polishdb/public_html/includes/init_includes/init_database.php) called at [/home3/polishdb/public_html/includes/autoload_func.php:48]
#4  require(/home3/polishdb/public_html/includes/autoload_func.php) called at [/home3/polishdb/public_html/includes/application_top.php:170]
#5  require(/home3/polishdb/public_html/includes/application_top.php) called at [/home3/polishdb/public_html/index.php:26]
--> PHP Warning: mysqli_connect(): (HY000/1040): Too many connections in /home3/polishdb/public_html/includes/classes/db/mysql/query_factory.php on line 64.

[29-Jul-2020 12:12:21 America/Chicago] Request URI: /index.php?main_page=index&r_link=%2F3824-c-1824_76_241_1264%2F3824-x-314-socket-head-black-oxide-p-12626&currency=EUR, IP address: 114.119.162.42
#1  mysqli_connect() called at [/home3/polishdb/public_html/includes/classes/db/mysql/query_factory.php:64]
#2  queryFactory->connect() called at [/home3/polishdb/public_html/includes/init_includes/init_database.php:24]
#3  require(/home3/polishdb/public_html/includes/init_includes/init_database.php) called at [/home3/polishdb/public_html/includes/autoload_func.php:48]
#4  require(/home3/polishdb/public_html/includes/autoload_func.php) called at [/home3/polishdb/public_html/includes/application_top.php:170]
#5  require(/home3/polishdb/public_html/includes/application_top.php) called at [/home3/polishdb/public_html/index.php:26]
--> PHP Warning: mysqli_connect(): (HY000/1040): Too many connections in /home3/polishdb/public_html/includes/classes/db/mysql/query_factory.php on line 64.

[29-Jul-2020 12:12:21 America/Chicago] Request URI: /index.php?main_page=index&r_link=%2F3824-c-1824_76_241_1264%2F3824-x-314-socket-head-black-oxide-p-12626&currency=EUR, IP address: 114.119.162.42
#1  mysqli_connect() called at [/home3/polishdb/public_html/includes/classes/db/mysql/query_factory.php:64]
#2  queryFactory->connect() called at [/home3/polishdb/public_html/includes/init_includes/init_database.php:24]
#3  require(/home3/polishdb/public_html/includes/init_includes/init_database.php) called at [/home3/polishdb/public_html/includes/autoload_func.php:48]
#4  require(/home3/polishdb/public_html/includes/autoload_func.php) called at [/home3/polishdb/public_html/includes/application_top.php:170]
#5  require(/home3/polishdb/public_html/includes/application_top.php) called at [/home3/polishdb/public_html/index.php:26]
--> PHP Warning: mysqli_connect(): (HY000/1040): Too many connections in /home3/polishdb/public_html/includes/classes/db/mysql/query_factory.php on line 64.

[29-Jul-2020 12:12:21 America/Chicago] Request URI: /index.php?main_page=index&r_link=%2F3824-c-1824_76_241_1264%2F3824-x-314-socket-head-black-oxide-p-12626&currency=EUR, IP address: 114.119.162.42
#1  mysqli_connect() called at [/home3/polishdb/public_html/includes/classes/db/mysql/query_factory.php:64]
#2  queryFactory->connect() called at [/home3/polishdb/public_html/includes/init_includes/init_database.php:24]
#3  require(/home3/polishdb/public_html/includes/init_includes/init_database.php) called at [/home3/polishdb/public_html/includes/autoload_func.php:48]
#4  require(/home3/polishdb/public_html/includes/autoload_func.php) called at [/home3/polishdb/public_html/includes/application_top.php:170]
#5  require(/home3/polishdb/public_html/includes/application_top.php) called at [/home3/polishdb/public_html/index.php:26]
--> PHP Warning: mysqli_connect(): (HY000/1040): Too many connections in /home3/polishdb/public_html/includes/classes/db/mysql/query_factory.php on line 64.

[29-Jul-2020 12:12:21 America/Chicago] Request URI: /index.php?main_page=index&r_link=%2F3824-c-1824_76_241_1264%2F3824-x-314-socket-head-black-oxide-p-12626&currency=EUR, IP address: 114.119.162.42
#1  mysqli_connect() called at [/home3/polishdb/public_html/includes/classes/db/mysql/query_factory.php:64]
#2  queryFactory->connect() called at [/home3/polishdb/public_html/includes/init_includes/init_database.php:24]
#3  require(/home3/polishdb/public_html/includes/init_includes/init_database.php) called at [/home3/polishdb/public_html/includes/autoload_func.php:48]
#4  require(/home3/polishdb/public_html/includes/autoload_func.php) called at [/home3/polishdb/public_html/includes/application_top.php:170]
#5  require(/home3/polishdb/public_html/includes/application_top.php) called at [/home3/polishdb/public_html/index.php:26]
--> PHP Warning: mysqli_connect(): (HY000/1040): Too many connections in /home3/polishdb/public_html/includes/classes/db/mysql/query_factory.php on line 64.

[29-Jul-2020 12:12:21 America/Chicago] Request URI: /index.php?main_page=index&r_link=%2F3824-c-1824_76_241_1264%2F3824-x-314-socket-head-black-oxide-p-12626&currency=EUR, IP address: 114.119.162.42
#1  mysqli_connect() called at [/home3/polishdb/public_html/includes/classes/db/mysql/query_factory.php:64]
#2  queryFactory->connect() called at [/home3/polishdb/public_html/includes/init_includes/init_database.php:24]
#3  require(/home3/polishdb/public_html/includes/init_includes/init_database.php) called at [/home3/polishdb/public_html/includes/autoload_func.php:48]
#4  require(/home3/polishdb/public_html/includes/autoload_func.php) called at [/home3/polishdb/public_html/includes/application_top.php:170]
#5  require(/home3/polishdb/public_html/includes/application_top.php) called at [/home3/polishdb/public_html/index.php:26]
--> PHP Warning: mysqli_connect(): (HY000/1040): Too many connections in /home3/polishdb/public_html/includes/classes/db/mysql/query_factory.php on line 64.

[29-Jul-2020 12:12:21 America/Chicago] Request URI: /index.php?main_page=index&r_link=%2F3824-c-1824_76_241_1264%2F3824-x-314-socket-head-black-oxide-p-12626&currency=EUR, IP address: 114.119.162.42
#1  mysqli_connect() called at [/home3/polishdb/public_html/includes/classes/db/mysql/query_factory.php:64]
#2  queryFactory->connect() called at [/home3/polishdb/public_html/includes/init_includes/init_database.php:24]
#3  require(/home3/polishdb/public_html/includes/init_includes/init_database.php) called at [/home3/polishdb/public_html/includes/autoload_func.php:48]
#4  require(/home3/polishdb/public_html/includes/autoload_func.php) called at [/home3/polishdb/public_html/includes/application_top.php:170]
#5  require(/home3/polishdb/public_html/includes/application_top.php) called at [/home3/polishdb/public_html/index.php:26]
--> PHP Warning: mysqli_connect(): (HY000/1040): Too many connections in /home3/polishdb/public_html/includes/classes/db/mysql/query_factory.php on line 64.

[29-Jul-2020 12:12:21 America/Chicago] Request URI: /index.php?main_page=index&r_link=%2F3824-c-1824_76_241_1264%2F3824-x-314-socket-head-black-oxide-p-12626&currency=EUR, IP address: 114.119.162.42
#1  mysqli_connect() called at [/home3/polishdb/public_html/includes/classes/db/mysql/query_factory.php:64]
#2  queryFactory->connect() called at [/home3/polishdb/public_html/includes/init_includes/init_database.php:24]
#3  require(/home3/polishdb/public_html/includes/init_includes/init_database.php) called at [/home3/polishdb/public_html/includes/autoload_func.php:48]
#4  require(/home3/polishdb/public_html/includes/autoload_func.php) called at [/home3/polishdb/public_html/includes/application_top.php:170]
#5  require(/home3/polishdb/public_html/includes/application_top.php) called at [/home3/polishdb/public_html/index.php:26]
--> PHP Warning: mysqli_connect(): (HY000/1040): Too many connections in /home3/polishdb/public_html/includes/classes/db/mysql/query_factory.php on line 64.
    Reply With Quote Reply With Quote
  4. 30 Jul 2020, 07:49 PM #4
    swguy's Avatar
    swguy
    swguy is offline Administrator
    Join Date
    Feb 2006
    Location
    Tampa Bay, Florida
    Posts
    9,684
    Plugin Contributions
    123

    Default Re: Freezing Error when updating certain current products

    [29-Jul-2020 12:12:21 America/Chicago] Request URI: /index.php?main_page=index&r_link=%2F3824-c-1824_76_241_1264%2F3824-x-314-socket-head-black-oxide-p-12626&currency=EUR, IP address: 114.119.162.42
    PHP Warning: mysqli_connect(): (HY000/1040): Too many connections

    This has nothing to do with your actions in admin - your site is being flooded with traffic (likely fake).
    That Software Guy. My Store: Zen Cart Modifications
    Available for hire - See my ad in Services
    Plugin Moderator, Documentation Curator, Chief Cook and Bottle-Washer.
    Do you benefit from Zen Cart? Then please support the project.
    Reply With Quote Reply With Quote
  5. 30 Jul 2020, 07:59 PM #5
    akjnashville
    akjnashville is offline New Zenner
    Join Date
    Oct 2019
    Location
    Nashville TN
    Posts
    15
    Plugin Contributions
    0

    Default Re: Freezing Error when updating certain current products

    SO if I copy and paste the description in and out of it it works which is strange because im putting it back in there..... Do you think theres an easier way to fix it? or just copy and paste each one.
    Reply With Quote Reply With Quote
  6. 30 Jul 2020, 08:41 PM #6
    DrByte's Avatar
    DrByte
    DrByte is offline Sensei
    Join Date
    Jan 2004
    Posts
    66,373
    Blog Entries
    7
    Plugin Contributions
    274

    Default Re: Freezing Error when updating certain current products

    Quote Originally Posted by akjnashville View Post
    SO if I copy and paste the description in and out of it it works which is strange because im putting it back in there..... Do you think theres an easier way to fix it? or just copy and paste each one.
    Given that you said it only happens with certain products, I suggest just fixing those few products manually.
    .

    Zen Cart - putting the dream of business ownership within reach of anyone!
    Donate to: DrByte directly or to the Zen Cart team as a whole

    Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
    Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.
    Reply With Quote Reply With Quote
  7. 11 Jun 2021, 02:50 AM #7
    akjnashville
    akjnashville is offline New Zenner
    Join Date
    Oct 2019
    Location
    Nashville TN
    Posts
    15
    Plugin Contributions
    0

    Default Re: Freezing Error when updating certain current products

    Hey Zen Friends, Im still working on this. We have 11,432 products in our store. and keeping up with price increases has been tough. I recently found the quick updates plug-in and it is amazing! the only problem is if there is one product of the page that has this issue, I cant update the pricing. it will just load the page again and none of the prices I just did will update. Im almost certain it has to do with what's going on here. With this many product it hard to pinpoint it. Do you think theres anyway to clean up the description text on all the products? or make them all plain text, not sure what the best solution would be at this point but its beginning to become unmanageable and could really use some help. thank you
    Reply With Quote Reply With Quote
 

 
« Previous Thread | Next Thread »

Similar Threads

  1. 403 Forbidden error when updating product
    By pinixdesign in forum Setting Up Categories, Products, Attributes
    Replies: 28
    Last Post: 27 Mar 2012, 05:10 AM
  2. blank screen when updating products
    By zubenubi in forum General Questions
    Replies: 5
    Last Post: 2 Jul 2010, 04:14 AM
  3. HTTP 406 Error when updating any products
    By oxxyfx in forum General Questions
    Replies: 3
    Last Post: 26 Oct 2009, 07:40 AM
  4. MySQL error when updating order status
    By spretswell in forum General Questions
    Replies: 7
    Last Post: 10 Sep 2006, 10:59 AM
  5. Error when updating shipping methods...
    By audradh in forum General Questions
    Replies: 3
    Last Post: 23 Jul 2006, 06:12 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR
Content and Graphics Copyright (c) 2003 - 2024 Zen Ventures, LLC - all rights reserved
Zen Cart® is a Registered Trademark of Zen Ventures, LLC