Page 1 of 3 123 LastLast
Results 1 to 10 of 25
  1. #1
    Join Date
    Mar 2008
    Location
    Brampton, Cumbria, United Kingdom, United Kingdom
    Posts
    816
    Plugin Contributions
    2

    Default mysqli_connect(): (HY000/2002): No such file or directory

    I keep getting the same error in my log files
    [01-Aug-2015 22:27:16 Europe/London] PHP Warning: mysqli_connect(): (HY000/2002): No such file or directory in /homepages/20/d503465712/htdocs/shops/mainshop/includes/classes/db/mysql/query_factory.php on line 62
    Line 62
    Code:
    $this->link = mysqli_connect($zf_host, $zf_user, $zf_password);
    . This line is displayed 10 times per log file and in a 24 hour period I am getting 2,000 plus log files.

    Is there a way of putting a back trace on to find out what is causing the problem?
    Learning Fast.
    Eden Craft Supplies

  2. #2
    Join Date
    Jan 2004
    Posts
    66,373
    Blog Entries
    7
    Plugin Contributions
    274

    Default Re: mysqli_connect(): (HY000/2002): No such file or directory

    Is the store working fine otherwise? Or is the site completely down?

    If the site is completely down, then the problem is likely that your hosting company's MySQL connection is unreliable, and perhaps its configuration is set to use a 'socket' which is not functioning properly.
    .

    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.

  3. #3
    Join Date
    Mar 2008
    Location
    Brampton, Cumbria, United Kingdom, United Kingdom
    Posts
    816
    Plugin Contributions
    2

    Default Re: mysqli_connect(): (HY000/2002): No such file or directory

    Quote Originally Posted by DrByte View Post
    Is the store working fine otherwise? Or is the site completely down?

    If the site is completely down, then the problem is likely that your hosting company's MySQL connection is unreliable, and perhaps its configuration is set to use a 'socket' which is not functioning properly.
    As far as I can work out everything else is fine.
    Learning Fast.
    Eden Craft Supplies

  4. #4
    Join Date
    Jul 2012
    Posts
    16,734
    Plugin Contributions
    17

    Default Re: mysqli_connect(): (HY000/2002): No such file or directory

    Quote Originally Posted by adb34 View Post
    I keep getting the same error in my log files Line 62
    Code:
    $this->link = mysqli_connect($zf_host, $zf_user, $zf_password);
    . This line is displayed 10 times per log file and in a 24 hour period I am getting 2,000 plus log files.

    Is there a way of putting a back trace on to find out what is causing the problem?
    Don't know if it will provide any more useful information, but there is lat9's mydebug backtrace plugin that might offer somethng...
    ZC Installation/Maintenance Support <- Site
    Contribution for contributions welcome...

  5. #5
    Join Date
    Mar 2008
    Location
    Brampton, Cumbria, United Kingdom, United Kingdom
    Posts
    816
    Plugin Contributions
    2

    Default Re: mysqli_connect(): (HY000/2002): No such file or directory

    Quote Originally Posted by mc12345678 View Post
    Don't know if it will provide any more useful information, but there is lat9's mydebug backtrace plugin that might offer somethng...
    I have downloaded the plugin by Lat9 and will give it a go.

    To who ever changed the subject: Thanks I could not think of a subject title. I sat for 5 mins thinking of one.
    Learning Fast.
    Eden Craft Supplies

  6. #6
    Join Date
    Mar 2008
    Location
    Brampton, Cumbria, United Kingdom, United Kingdom
    Posts
    816
    Plugin Contributions
    2

    Default Re: mysqli_connect(): (HY000/2002): No such file or directory

    I have installed the plugin and have the following;
    [02-Aug-2015 11:01:55 Europe/London] #1 mysqli_connect() called at [/homepages/20/d503465712/htdocs/shops/mainshop/includes/classes/db/mysql/query_factory.php:62]
    #2 queryFactory->connect() called at [/homepages/20/d503465712/htdocs/shops/mainshop/includes/classes/class.phpbb.php:32]
    #3 phpBB->phpBB() called at [/homepages/20/d503465712/htdocs/shops/mainshop/includes/autoload_func.php:79]
    #4 require(/homepages/20/d503465712/htdocs/shops/mainshop/includes/autoload_func.php) called at [/homepages/20/d503465712/htdocs/shops/mainshop/includes/application_top.php:158]
    #5 require(/homepages/20/d503465712/htdocs/shops/mainshop/includes/application_top.php) called at [/homepages/20/d503465712/htdocs/shops/mainshop/index.php:26]
    Learning Fast.
    Eden Craft Supplies

  7. #7
    Join Date
    Sep 2009
    Location
    Stuart, FL
    Posts
    12,495
    Plugin Contributions
    88

    Default Re: mysqli_connect(): (HY000/2002): No such file or directory

    Check the value in Configuration->My Store->Enable phpBB linkage? ... if you're not associating a phpBB forum with your site, this value should be set to false.

    Did you do a fresh install or upgrade an existing site?

  8. #8
    Join Date
    Mar 2008
    Location
    Brampton, Cumbria, United Kingdom, United Kingdom
    Posts
    816
    Plugin Contributions
    2

    Default Re: mysqli_connect(): (HY000/2002): No such file or directory

    Quote Originally Posted by lat9 View Post
    Did you do a fresh install or upgrade an existing site?
    It was an upgrade over v1.5.3 with no changes prior to the upgrade. I have changed the status of Enable phpBB linkage? to False.
    Learning Fast.
    Eden Craft Supplies

  9. #9
    Join Date
    Mar 2008
    Location
    Brampton, Cumbria, United Kingdom, United Kingdom
    Posts
    816
    Plugin Contributions
    2

    Default Re: mysqli_connect(): (HY000/2002): No such file or directory

    Quote Originally Posted by lat9 View Post
    Check the value in Configuration->My Store->Enable phpBB linkage? ... if you're not associating a phpBB forum with your site, this value should be set to false.
    The problem was being generated by the link being set to 'True'. Might be worth the while to put this somewhere for others to find, possibility with the FAQs?
    Learning Fast.
    Eden Craft Supplies

  10. #10
    Join Date
    Sep 2009
    Location
    Stuart, FL
    Posts
    12,495
    Plugin Contributions
    88

    Default Re: mysqli_connect(): (HY000/2002): No such file or directory

    Right, the reason I asked initially is that yours is not the first report of that phpBB-related configuration setting magically getting set to "true" on the upgrade. I'm not a big fan of magic.

 

 
Page 1 of 3 123 LastLast

Similar Threads

  1. Replies: 30
    Last Post: 15 Apr 2016, 10:36 PM
  2. Replies: 10
    Last Post: 11 Feb 2016, 10:30 PM
  3. Warning: shipping::No such file or directory in..
    By kittycat in forum General Questions
    Replies: 1
    Last Post: 3 Jul 2008, 01:58 PM
  4. error: No such file or directory in
    By Joseph Heinen in forum General Questions
    Replies: 2
    Last Post: 5 Jun 2008, 03:55 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
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR