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

Hybrid View

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

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

    Might I suggest installing lat9's MyDebug Backtrace: http://www.zen-cart.com/downloads.php?do=file&id=1879

    It should provide a better indication of the origin of the error rather than just starting at the query_factory.
    ZC Installation/Maintenance Support <- Site
    Contribution for contributions welcome...

  2. #2
    Join Date
    Aug 2007
    Posts
    67
    Plugin Contributions
    0

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

    Quote Originally Posted by mc12345678 View Post
    Might I suggest installing lat9's MyDebug Backtrace: http://www.zen-cart.com/downloads.php?do=file&id=1879

    It should provide a better indication of the origin of the error rather than just starting at the query_factory.
    Hi, Thanks I installed it and got this:
    [15-Mar-2015 11:42:16 America/Denver] #1 mysqli_connect() called at [/home2/latexinn/public_html/154/includes/classes/db/mysql/query_factory.php:62]
    #2 queryFactory->connect() called at [/home2/latexinn/public_html/154/includes/classes/class.phpbb.php:32]
    #3 phpBB->phpBB() called at [/home2/latexinn/public_html/154/includes/autoload_func.php:79]
    #4 require(/home2/latexinn/public_html/154/includes/autoload_func.php) called at [/home2/latexinn/public_html/154/includes/application_top.php:158]
    #5 require(/home2/latexinn/public_html/154/includes/application_top.php) called at [/home2/latexinn/public_html/154/index.php:26]

    [15-Mar-2015 11:42:16 America/Denver] PHP Warning: mysqli_connect(): (28000/1045): Access denied for user 'cwrealey'@'localhost' (using password: NO) in /home2/latexinn/public_html/154/includes/classes/db/mysql/query_factory.php on line 62
    [15-Mar-2015 11:42:16 America/Denver] #1 mysqli_connect() called at [/home2/latexinn/public_html/154/includes/classes/db/mysql/query_factory.php:62]
    #2 queryFactory->connect() called at [/home2/latexinn/public_html/154/includes/classes/class.phpbb.php:32]
    #3 phpBB->phpBB() called at [/home2/latexinn/public_html/154/includes/autoload_func.php:79]
    #4 require(/home2/latexinn/public_html/154/includes/autoload_func.php) called at [/home2/latexinn/public_html/154/includes/application_top.php:158]
    #5 require(/home2/latexinn/public_html/154/includes/application_top.php) called at [/home2/latexinn/public_html/154/index.php:26]

    [15-Mar-2015 11:42:16 America/Denver] #1 mysqli_connect() called at [/home2/latexinn/public_html/154/includes/classes/db/mysql/query_factory.php:62]
    #2 queryFactory->connect() called at [/home2/latexinn/public_html/154/includes/classes/class.phpbb.php:32]
    #3 phpBB->phpBB() called at [/home2/latexinn/public_html/154/includes/autoload_func.php:79]
    #4 require(/home2/latexinn/public_html/154/includes/autoload_func.php) called at [/home2/latexinn/public_html/154/includes/application_top.php:158]
    #5 require(/home2/latexinn/public_html/154/includes/application_top.php) called at [/home2/latexinn/public_html/154/index.php:26]

    [15-Mar-2015 11:42:16 America/Denver] #1 mysqli_connect() called at [/home2/latexinn/public_html/154/includes/classes/db/mysql/query_factory.php:62]
    #2 queryFactory->connect() called at [/home2/latexinn/public_html/154/includes/classes/class.phpbb.php:32]
    #3 phpBB->phpBB() called at [/home2/latexinn/public_html/154/includes/autoload_func.php:79]
    #4 require(/home2/latexinn/public_html/154/includes/autoload_func.php) called at [/home2/latexinn/public_html/154/includes/application_top.php:158]
    #5 require(/home2/latexinn/public_html/154/includes/application_top.php) called at [/home2/latexinn/public_html/154/index.php:26]

    [15-Mar-2015 11:42:16 America/Denver] #1 mysqli_connect() called at [/home2/latexinn/public_html/154/includes/classes/db/mysql/query_factory.php:62]
    #2 queryFactory->connect() called at [/home2/latexinn/public_html/154/includes/classes/class.phpbb.php:32]
    #3 phpBB->phpBB() called at [/home2/latexinn/public_html/154/includes/autoload_func.php:79]
    #4 require(/home2/latexinn/public_html/154/includes/autoload_func.php) called at [/home2/latexinn/public_html/154/includes/application_top.php:158]
    #5 require(/home2/latexinn/public_html/154/includes/application_top.php) called at [/home2/latexinn/public_html/154/index.php:26]

    [15-Mar-2015 11:42:16 America/Denver] #1 mysqli_connect() called at [/home2/latexinn/public_html/154/includes/classes/db/mysql/query_factory.php:62]
    #2 queryFactory->connect() called at [/home2/latexinn/public_html/154/includes/classes/class.phpbb.php:32]
    #3 phpBB->phpBB() called at [/home2/latexinn/public_html/154/includes/autoload_func.php:79]
    #4 require(/home2/latexinn/public_html/154/includes/autoload_func.php) called at [/home2/latexinn/public_html/154/includes/application_top.php:158]
    #5 require(/home2/latexinn/public_html/154/includes/application_top.php) called at [/home2/latexinn/public_html/154/index.php:26]

    [15-Mar-2015 11:42:16 America/Denver] #1 mysqli_connect() called at [/home2/latexinn/public_html/154/includes/classes/db/mysql/query_factory.php:62]
    #2 queryFactory->connect() called at [/home2/latexinn/public_html/154/includes/classes/class.phpbb.php:32]
    #3 phpBB->phpBB() called at [/home2/latexinn/public_html/154/includes/autoload_func.php:79]
    #4 require(/home2/latexinn/public_html/154/includes/autoload_func.php) called at [/home2/latexinn/public_html/154/includes/application_top.php:158]
    #5 require(/home2/latexinn/public_html/154/includes/application_top.php) called at [/home2/latexinn/public_html/154/index.php:26]

    [15-Mar-2015 11:42:16 America/Denver] #1 mysqli_connect() called at [/home2/latexinn/public_html/154/includes/classes/db/mysql/query_factory.php:62]
    #2 queryFactory->connect() called at [/home2/latexinn/public_html/154/includes/classes/class.phpbb.php:32]
    #3 phpBB->phpBB() called at [/home2/latexinn/public_html/154/includes/autoload_func.php:79]
    #4 require(/home2/latexinn/public_html/154/includes/autoload_func.php) called at [/home2/latexinn/public_html/154/includes/application_top.php:158]
    #5 require(/home2/latexinn/public_html/154/includes/application_top.php) called at [/home2/latexinn/public_html/154/index.php:26]

    [15-Mar-2015 11:42:16 America/Denver] #1 mysqli_connect() called at [/home2/latexinn/public_html/154/includes/classes/db/mysql/query_factory.php:62]
    #2 queryFactory->connect() called at [/home2/latexinn/public_html/154/includes/classes/class.phpbb.php:32]
    #3 phpBB->phpBB() called at [/home2/latexinn/public_html/154/includes/autoload_func.php:79]
    #4 require(/home2/latexinn/public_html/154/includes/autoload_func.php) called at [/home2/latexinn/public_html/154/includes/application_top.php:158]
    #5 require(/home2/latexinn/public_html/154/includes/application_top.php) called at [/home2/latexinn/public_html/154/index.php:26]

    [15-Mar-2015 11:42:16 America/Denver] #1 mysqli_connect() called at [/home2/latexinn/public_html/154/includes/classes/db/mysql/query_factory.php:62]
    #2 queryFactory->connect() called at [/home2/latexinn/public_html/154/includes/classes/class.phpbb.php:32]
    #3 phpBB->phpBB() called at [/home2/latexinn/public_html/154/includes/autoload_func.php:79]
    #4 require(/home2/latexinn/public_html/154/includes/autoload_func.php) called at [/home2/latexinn/public_html/154/includes/application_top.php:158]
    #5 require(/home2/latexinn/public_html/154/includes/application_top.php) called at [/home2/latexinn/public_html/154/index.php:26]

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

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

    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.

  4. #4
    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.

  5. #5
    Join Date
    Sep 2009
    Location
    Stuart, FL
    Posts
    13,942
    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?

  6. #6
    Join Date
    Sep 2009
    Location
    Stuart, FL
    Posts
    13,942
    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?

  7. #7
    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

  8. #8
    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...

  9. #9
    Join Date
    Sep 2009
    Location
    Stuart, FL
    Posts
    13,942
    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.

  10. #10
    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...

 

 
Page 1 of 2 12 LastLast

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