Page 1 of 2 12 LastLast
Results 1 to 10 of 15

Thread: Database error

  1. #1
    emailgirls
    Guest

    Unhappy Database error

    Hi, I get the following error when working with the control panel.

    Warning: mysql_pconnect(): Too many connections in /home/emailgir/public_html/friends/inc/db.inc.php on line 20

    Warning: mysql_select_db(): Too many connections in /home/emailgir/public_html/friends/inc/db.inc.php on line 29

    Warning: mysql_select_db(): A link to the server could not be established in /home/emailgir/public_html/friends/inc/db.inc.php on line 29

    Warning: mysql_select_db(): Too many connections in /home/emailgir/public_html/friends/inc/db.inc.php on line 29

    Warning: mysql_select_db(): A link to the server could not be established in /home/emailgir/public_html/friends/inc/db.inc.php on line 29
    Error
    Database activation failed


    I keep going to my web site contol panel and clicking the repair option, then its ok for awhile, then starts again after being log on to the admin panel for about 15 minutes.

    How can I correct this?

    Niņa
    Last edited by emailgirls; 12-06-2005 at 09:54 PM.

  2. #2
    alliera
    Guest

    Default

    Hi,

    Do you have access to the mysql console? You'll have to increase the max_connections setting of mysql (default is 100, maximum recommended without optimisations is 1000). The following will increase this value for the running instance (enter at the mysql prompt, I guess you could enter it at the "enter SQL" option at phpmyadmin as well):

    SET GLOBAL max_connections=1000

    To make the change permanent (so it will survive a restart of the mysql daemon), you need to add this line in /etc/my.cnf (don't know where this is on Windows):

    max_connections=1000

    /ken

  3. #3
    emailgirls
    Guest

    Thumbs up SET GLOBAL max_connections=1000

    Hi Ken,

    Success! I located the /etc/my.cnf by going through my online web host control panel, clicking on file management, finding the etc directory, then my.cnf and updated the sttings. The connection is great and no more database errors so far.

    I am very thankful for people like yourself for being here.

    Wishing you all the best!

    Niņa

  4. #4
    Administrator Smoge's Avatar
    Join Date
    Mar 2005
    Posts
    6,634
    Blog Entries
    5

    Default

    Hi,

    This is ok - but perhaps it is better to disable pconnect.

    Search modmysite for pconnect to find threads about this.

    Smoge
    ModMySite Administrator

    Problems? Questions? Need modifications or other help with your site?

    Open A Ticket , Send Us An Email Or Give Us A Telephone Call +1 518-632-4152.

  5. #5
    emailgirls
    Guest

    Default Database Error

    Hi Smoge, thank you for addressing my database error issue. Yes, I will search the pcconnect topics to find out how to disable it.

    Thank you so much for your assistance.

    Cheryll

  6. #6

    Join Date
    Sep 2006
    Posts
    431

    Default Somedy take my wife, PLEASE !!

    Its 4am. I just woke up to the sound of "clicks" in my email. It went non stop for about ten minutes. I ended up with over 700 error messages in my mail box. (I use Dolphin 5.2)

    As I tried to go to my website, the only thing that would show up was a blank screen that said "Database Activation Failed".

    Once the emails stopped, everything went back to normal. My site is back up and running fine. Anyone have any clues?

    btw, I did a search for pcconnect and pc connect and it came up with nothing

    Thanks for your help. I need to sleep a full night, one of these days lol

  7. #7
    Administrator Smoge's Avatar
    Join Date
    Mar 2005
    Posts
    6,634
    Blog Entries
    5

    Default

    Hi,

    It's "pconnect" not "pcconnect" as emailgirls mentioned.

    Try a search on "pconnect".

    Rob
    ModMySite Administrator

    Problems? Questions? Need modifications or other help with your site?

    Open A Ticket , Send Us An Email Or Give Us A Telephone Call +1 518-632-4152.

  8. #8
    birkenstam's Avatar
    Join Date
    Mar 2006
    Posts
    205

    Default

    hi, i just got the same error 5 minutes ago igot 365 mail like this once below


    Error in /imctrl.php: Access denied for user 'nobody'@'localhost' (using password: NO)
    imctrl.php is this instan messanger? as i tried to chat to a person that was online but not full memebr so she could not use the instant messanger.

    and i also tried to send her message by mail and instant, but she as said before was not full member so she could not recive.

    is this maybe a bug or something?

    after that i got all the error mails


    anyone have any clues on this?

    crazy i still get this error mail every 5 min is not stopping.


    regards anders
    Last edited by birkenstam; 10-03-2006 at 06:21 AM.

  9. #9
    Administrator Smoge's Avatar
    Join Date
    Mar 2005
    Posts
    6,634
    Blog Entries
    5

    Default

    All ok now? Or still a problem.

    You guys are not giving me enough information to be able to make any further comments about your posts.

    Smoge
    ModMySite Administrator

    Problems? Questions? Need modifications or other help with your site?

    Open A Ticket , Send Us An Email Or Give Us A Telephone Call +1 518-632-4152.

  10. #10
    birkenstam's Avatar
    Join Date
    Mar 2006
    Posts
    205

    Default

    Hi smoge,

    sorry for the delay. i still have the problem i just tested it agian. if i open im messeanger up and see a person there and try to send a message i get hundreds of mail like this
    Error in /imctrl.php: Access denied for user 'nobody'@'localhost' (using password: NO)
    and i also get the error message.

    Regards anders

Page 1 of 2 12 LastLast

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Help... Database error...
    By destintonight in forum General Troubleshooting
    Replies: 1
    Last Post: 10-21-2008, 08:37 PM
  2. Database access error after database upload
    By sanne in forum Database
    Replies: 1
    Last Post: 06-03-2007, 06:49 AM
  3. database error
    By damo2550 in forum General Troubleshooting
    Replies: 1
    Last Post: 03-14-2007, 08:43 AM
  4. Database Error
    By DiabloD in forum Database
    Replies: 2
    Last Post: 12-26-2006, 09:59 AM
  5. Database Error
    By jholzy in forum General Troubleshooting
    Replies: 1
    Last Post: 08-16-2005, 07:15 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
  •