Page 2 of 2 FirstFirst 12
Results 11 to 20 of 20
  1. #11
    Join Date
    Aug 2007
    Posts
    67
    Plugin Contributions
    0

    Default Re: PHP Warning: mysqli_connect(): (28000/1045)

    Quote Originally Posted by lat9 View Post
    Look in your /includes/configure.php file. There's a constant there named DIR_WS_PHPBB.

    Look in the folder that that constant specifies; there's a file named config.php (the phpBB configuration file). The credentials for the phpBB database are parsed out of that file, which apparently has invalid database information.
    This is what I got: define('DIR_WS_PHPBB', '/');

    // * DIR_FS_* = Filesystem directories (local/physical)
    //the following path is a COMPLETE path to your Zen Cart files. eg: /var/www/vhost/accountname/public_html/store/
    define('DIR_FS_CATALOG', '/home2/latexinn/public_html/154/');
    I could not find a folder names store, zen cart sits in the 154 folder but the only config file is in the includes folder or in admin.

  2. #12
    Join Date
    Sep 2009
    Location
    Stuart, FL
    Posts
    13,949
    Plugin Contributions
    96

    Default Re: PHP Warning: mysqli_connect(): (28000/1045)

    Do you even have a phpBB installation for your store? What's your setting for Configuration->My Store->Enable phpBB Linkage?

  3. #13
    Join Date
    Sep 2009
    Location
    Stuart, FL
    Posts
    13,949
    Plugin Contributions
    96

    Default Re: PHP Warning: mysqli_connect(): (28000/1045)

    This sounds like the same issue posted by DivaVocals (http://www.zen-cart.com/showthread.p...o-db-for-it%29). Perhaps your Enable phpBB Linkage? setting is set to true?

  4. #14
    Join Date
    Aug 2007
    Posts
    67
    Plugin Contributions
    0

    Default Re: PHP Warning: mysqli_connect(): (28000/1045)

    Quote Originally Posted by lat9 View Post
    Look in your /includes/configure.php file. There's a constant there named DIR_WS_PHPBB.

    Look in the folder that that constant specifies; there's a file named config.php (the phpBB configuration file). The credentials for the phpBB database are parsed out of that file, which apparently has invalid database information.
    Here is what I get: define('DIR_WS_PHPBB', '/');

    // * DIR_FS_* = Filesystem directories (local/physical)
    //the following path is a COMPLETE path to your Zen Cart files. eg: /var/www/vhost/accountname/public_html/store/
    define('DIR_FS_CATALOG', '/home2/latexinn/public_html/154/');
    I could not find a store folder or if it means the zen cart folder is 154, In 154 the config file is of course in the includes folder and the database info is correct on this file
    Thanks

  5. #15
    Join Date
    Jul 2012
    Posts
    16,817
    Plugin Contributions
    17

    Default Re: PHP Warning: mysqli_connect(): (28000/1045)

    Quote Originally Posted by tbokich View Post
    Here is what I get: define('DIR_WS_PHPBB', '/');

    // * DIR_FS_* = Filesystem directories (local/physical)
    //the following path is a COMPLETE path to your Zen Cart files. eg: /var/www/vhost/accountname/public_html/store/
    define('DIR_FS_CATALOG', '/home2/latexinn/public_html/154/');
    I could not find a store folder or if it means the zen cart folder is 154, In 154 the config file is of course in the includes folder and the database info is correct on this file
    Thanks
    The issue as lat9 is trying to lead you to is now identified not to be a file issue, but now is a database issue. In your old store, even though you may not have had phpBB installed, it was activated before upgrading the database... Now in zC 1.5.4 the software goes out and tries to do something based on that setting and stops working...

    Now you need to change the setting in the database so that it doesn't go out and do that... Not at a computer to specifically identify the sql that will specifically solve the problem.
    ZC Installation/Maintenance Support <- Site
    Contribution for contributions welcome...

  6. #16
    Join Date
    Sep 2009
    Location
    Stuart, FL
    Posts
    13,949
    Plugin Contributions
    96

    Default Re: PHP Warning: mysqli_connect(): (28000/1045)

    Quote Originally Posted by mc12345678 View Post
    The issue as lat9 is trying to lead you to is now identified not to be a file issue, but now is a database issue. In your old store, even though you may not have had phpBB installed, it was activated before upgrading the database... Now in zC 1.5.4 the software goes out and tries to do something based on that setting and stops working...

    Now you need to change the setting in the database so that it doesn't go out and do that... Not at a computer to specifically identify the sql that will specifically solve the problem.
    There's no SQL to run, you simply go to the admin's Configuration->My Store->Enable phpBB Linkage? setting. If it's true, set it to false.

    If it's already set to false, then there's something else afoot.

  7. #17
    Join Date
    Jul 2012
    Posts
    16,817
    Plugin Contributions
    17

    Default Re: PHP Warning: mysqli_connect(): (28000/1045)

    Quote Originally Posted by lat9 View Post
    There's no SQL to run, you simply go to the admin's Configuration->My Store->Enable phpBB Linkage? setting. If it's true, set it to false.

    If it's already set to false, then there's something else afoot.
    Yeah, sorry. If I had taken a moment to realize that the issue did not prevent admin access, I would have approached my response differently...the sql is taken care of by ZC when making the selection described above.
    ZC Installation/Maintenance Support <- Site
    Contribution for contributions welcome...

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

    Default Re: PHP Warning: mysqli_connect(): (28000/1045)

    I am also having a similar problem
    Code:
    [25-Mar-2015 09:59:54 UTC] PHP Warning: mysqli_connect(): (HY000/2002): No such file or directory in
     /homepages/20/d503465712/htdocs/xxxx/xxxx/includes/classes/db/mysql/query_factory.php on line 62
    I am using v1.5.4 template Carlisle Fresh
    Learning Fast.
    Eden Craft Supplies

  9. #19
    Join Date
    Jan 2004
    Posts
    66,446
    Plugin Contributions
    81

    Default Re: PHP Warning: mysqli_connect(): (28000/1045)

    Quote Originally Posted by adb34 View Post
    I am also having a similar problem
    Code:
    [25-Mar-2015 09:59:54 UTC] PHP Warning: mysqli_connect(): (HY000/2002): No such file or directory in
     /homepages/20/d503465712/htdocs/xxxx/xxxx/includes/classes/db/mysql/query_factory.php on line 62
    I am using v1.5.4 template Carlisle Fresh
    When did this problem start? How does that compare with when you first started using v1.5.3 or 1.5.4? Did your hosting company do any upgrades just before this problem started?

    I suspect mysqli.default_socket is incorrectly configured in your server's php.ini ... which is something your hosting company must fix.
    .

    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.

  10. #20
    Join Date
    Aug 2007
    Posts
    67
    Plugin Contributions
    0

    Default Re: PHP Warning: mysqli_connect(): (28000/1045)

    Quote Originally Posted by lat9 View Post
    There's no SQL to run, you simply go to the admin's Configuration->My Store->Enable phpBB Linkage? setting. If it's true, set it to false.

    If it's already set to false, then there's something else afoot.
    Very smart person it fixed it in a flash. I have had similar problems though I could not track it down for the last two years. Hostmonster is the server and we have been fighting over space for all this time. Unless you are checking the log folder there is no other indication for this until you hosting company threatens to shut you off because you file count is to high. Thank you so much for your help
    T

 

 
Page 2 of 2 FirstFirst 12

Similar Threads

  1. Replies: 10
    Last Post: 11 Feb 2016, 10:30 PM
  2. Replies: 9
    Last Post: 11 Dec 2015, 11:35 PM
  3. v153 PHP Warning: mysqli_connect(): (28000/1045)
    By vanhorn_s in forum General Questions
    Replies: 29
    Last Post: 17 Sep 2015, 04:40 PM
  4. Replies: 1
    Last Post: 30 Sep 2013, 07:39 PM
  5. Replies: 8
    Last Post: 19 Sep 2012, 03:37 AM

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