max_user_connections error

  • Resolved cbacchini

    (@cbacchini)


    5 years, 5 months ago

    I have a site using nextgen gallery and from time to time i get a white screen error with the text I include below.
    The site where the error shows is elenabacchini.com. My provider is InMotion.com.
    I had the error with wordpress 4.x and the problem appeared only when passing from a page of the thumbnails to the next, so I upgraded to 5.2, but the problem now appears in a random way. In particular if I go back and forth from thumbnails to slideshow.
    To recreate the error it is sufficient to go to
    https://elenabacchini.com/photos/nggallery/elenas-photo-album/Zijveld-horse-farm—summer-2018/slideshow
    and try to switch back and forth from slideshow to thumbnails. After some trials the error appears.

    I attach the site settings after the error message

    Can something be done ??

    quote———————-
    “Warning: mysqli_real_connect(): (HY000/1203): User bacchi5_elenawp already has more than ‘max_user_connections’ active connections in /home/bacchi5/public_html/elenabacchini.com/wp-includes/wp-db.php on line 1612

    Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in /home/bacchi5/public_html/elenabacchini.com/wp-includes/wp-db.php on line 1643

    Warning: mysql_connect(): User bacchi5_elenawp already has more than ‘max_user_connections’ active connections in /home/bacchi5/public_html/elenabacchini.com/wp-includes/wp-db.php on line 1643
    User bacchi5_elenawp already has more than ‘max_user_connections’ active connections

    Error establishing a database connection
    This either means that the username and password information in your wp-config.php file is incorrect or we can’t contact the database server at localhost. This could mean your host’s database server is down.

    Are you sure you have the correct username and password?
    Are you sure that you have typed the correct hostname?
    Are you sure that the database server is running?
    If you’re unsure what these terms mean you should probably contact your host. If you still need help you can always visit the WordPress Support Forums.
    unquote————

    Site settings:
    quote—————
    Server Settings

    Operating System : Linux (64 Bit)
    Server : Apache
    Memory usage : 45.89 MByte
    MYSQL Version : 10.2.11-MariaDB-log
    SQL Mode : NO_ENGINE_SUBSTITUTION
    PHP Version : 5.6.39
    PHP Safe Mode : Off
    PHP Allow URL fopen : On
    PHP Memory Limit : 512
    PHP Max Upload Size : 128M
    PHP Max Post Size : 128M
    PCRE Backtracking Limit : 1000000
    PHP Max Script Execute Time : 14400s
    PHP Exif support : Yes (V1.4 )
    PHP IPTC support : Yes
    PHP XML support : Yes
    Graphic Library

    GD Version : bundled (2.1.0 compatible)
    FreeType Support : Yes
    FreeType Linkage : with freetype
    T1Lib Support : No
    GIF Read Support : Yes
    GIF Create Support : Yes
    JPEG Support : Yes
    PNG Support : Yes
    WBMP Support : Yes
    XPM Support : Yes
    XBM Support : Yes
    WebP Support : No
    JIS-mapped Japanese Font Support : No
    unquote ———————————-

    • This topic was modified 5 years, 5 months ago by cbacchini.
    • This topic was modified 5 years, 5 months ago by cbacchini.

    The page I need help with: [log in to see the link]

Viewing 8 replies - 1 through 8 (of 8 total)
  • Plugin Support Mihai Ceban

    (@mihaiimagely)

    5 years, 5 months ago

    Hi @cbacchini,

    I hope that you wouldn’t mind to update the PHP version according the requirements https://www.imagely.com/docs/requirements/ then check again to see if you will bump into the same problem.

    I must also note that I couldn’t replicate the issue even after 10 times of switching from “Show thumbnails” to “Show Slideshow”

    Thread Starter cbacchini

    (@cbacchini)

    5 years, 5 months ago

    I have updated the PHP version to 7.21 in my test site elenatest.bacchini.net.
    You can see the same error in the page
    https://elenatest.bacchini.net/gallery/nggallery/elenas-photo-album/externship-pagosa-springs-2012
    I obtained it by clicking on the link towards the 2nd page and back to the 1st, after 5 or 6 attemps. However, another user had the error happen the first time he entered the page.

    Warning: mysqli_real_connect(): (HY000/1203): User bacchi5_etest already has more than ‘max_user_connections’ active connections in /home/bacchi5/public_html/elenatest/wp-includes/wp-db.php on line 1612
    Now the settings page reports as follows
    ——————————
    Server Settings

    Operating System : Linux (64 Bit)
    Server : Apache
    Memory usage : 35.8 MByte
    MYSQL Version : 10.2.11-MariaDB-log
    SQL Mode : NO_ENGINE_SUBSTITUTION
    PHP Version : 7.2.13
    PHP Safe Mode : Off
    PHP Allow URL fopen : On
    PHP Memory Limit : 512
    PHP Max Upload Size : 128M
    PHP Max Post Size : 128M
    PCRE Backtracking Limit : 1000000
    PHP Max Script Execute Time : 14400s
    PHP Exif support : Yes (V7.2.)
    PHP IPTC support : Yes
    PHP XML support : Yes
    Graphic Library

    GD Version : bundled (2.1.0 compatible)
    FreeType Support : Yes
    FreeType Linkage : with freetype
    GIF Read Support : Yes
    GIF Create Support : Yes
    JPEG Support : Yes
    PNG Support : Yes
    WBMP Support : Yes
    XPM Support : Yes
    XBM Support : Yes
    WebP Support : No
    BMP Support : Yes
    JIS-mapped Japanese Font Support : No

    Plugin Support Mihai Ceban

    (@mihaiimagely)

    5 years, 5 months ago

    Thanks, @cbacchini, but I still cannot replicate the problem myself. Can you please let us know what browser device and OS are you using for the testing?

    Mihai

    Thread Starter cbacchini

    (@cbacchini)

    5 years, 4 months ago

    I have the problem using Windows 10 and Chrome / firefox / edge / opera around the 3rd time I click on the link towards the 2nd page.
    Also the same problem with android / chrome / firefox even before clicking for the 3rd time.
    Same problem with an Iphone and Safari.
    The problems appears randomly, for example now using Opera mini on android I can’t reproduce it.
    I made a video of the problem appearing on Firefox and uploaded it to Youtube here

    gabyimagely

    (@gabyimagely)

    5 years, 4 months ago

    Hello @cbacchini
    This seems directly linked to the configuration or settings of your current WordPress Environment. Could you please contact your hosting provider and let them know of this present problem?

    You might like to check for any existing conflicts with plugins or your theme

    1.- Temporarily deactivate all your plugins except NextGen Gallery.

    2.- Is the problem solved? Then, it was caused by one of your plugins. Please check one by one and find the one causing the problem.

    3.- If the problem is not solved with the deactivation of the plugins, try changing to a standard WordPress theme, it could be a conflict with your current theme.

    Try to remove or delete any plugin that you are not currently using.
    Please let us know how it goes.

    Note: we always recommend performing a full website backup before any troubleshooting.

    Thread Starter cbacchini

    (@cbacchini)

    5 years, 4 months ago

    OK I’m following your suggestions, let’s see what happens

    gabyimagely

    (@gabyimagely)

    5 years, 4 months ago

    Please, keep us posted.

    Thread Starter cbacchini

    (@cbacchini)

    5 years, 4 months ago

    It seems the problem was related to a THEME (sixteen), for which I had not installed the upgraded version.
    I have installed it, verified problems of upgrading and the user_max_connections error does not appear anymore.
    So everything OK now and thanks you for your help!

Viewing 8 replies - 1 through 8 (of 8 total)
  • The topic ‘max_user_connections error’ is closed to new replies.