We launched new forums in March 2019—join us there. In a hurry for help with your website? Get Help Now!
MODX Community Forums Archive

Website Down... Nothing but errors.. UPDATE: Host's MYSQL Problem

    • 82
    • 17 Posts
    2ndMile Reply #1, 18 years, 6 months ago
    www.myvantagepointfilm.com

    Edit: I should mention that the site was running fine for a week. Then this. I did not change any of the config files.

    On the front end getting:
    « MODx Parse Error »

MODx encountered the following error while attempting to parse the requested resource:
« Failed to select the database 'modx'! »
 
Parser timing
  MySQL:	0.0000 s	(0 Requests)
  PHP:	0.0377 s	 
  Total:	0.0377 s	 
Error while inserting event log into database.


    When trying to log into the manager I am getting the log in screen but when I enter the username and password I get this in the pop-up:
    <br />
<b>Warning</b>:  mysql_num_rows(): supplied argument is not a valid MySQL result resource in <b>/hermes/web10/b833/moo.vantagepoint/manager/includes/settings.inc.php</b> on line <b>10</b><br />
<br />
<b>Warning</b>:  mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in <b>/hermes/web10/b833/moo.vantagepoint/manager/includes/settings.inc.php</b> on line <b>11</b><br />
<br />
<b>Warning</b>:  mysql_num_rows(): supplied argument is not a valid MySQL result resource in <b>/hermes/web10/b833/moo.vantagepoint/manager/processors/login.processor.php</b> on line <b>72</b><br />
Incorrect username or password entered!


    Running:

    Server Platform: Debian
    MySQL Version: 5.0.45
    PHP Version: 5.2.2

    Help please!


      • 4310
      • 2,310 Posts
      bunk58 Reply #2, 18 years, 6 months ago
      Best guess is there’s something wrong in your manager/includes/config.inc.php file.
      Mine looks like this:
      <?php
/**
 *	MODx Configuration file
 */
$database_type = 'mysql';
$database_server = 'localhost';
$database_user = 'myname';
$database_password = 'mypassword';
$database_connection_charset = 'latin1';
$dbase = '`nameofdatabase`';
$table_prefix = 'modx_';
        • 82
        • 17 Posts
        2ndMile Reply #3, 18 years, 6 months ago
        That is what the beginning of mine looks like as well.
          • 4310
          • 2,310 Posts
          bunk58 Reply #4, 18 years, 6 months ago
          Your site was back up a minute ago, then down again.
          Could be your host having issues with their MySQL service.
            • 82
            • 17 Posts
            2ndMile Reply #5, 18 years, 6 months ago
            Really? Hmm.... I will contact them.

            If anybody has any other ideas, lay them on me.
              • 4310
              • 2,310 Posts
              bunk58 Reply #6, 18 years, 6 months ago
              The sites back up again!
                • 82
                • 17 Posts
                2ndMile Reply #7, 18 years, 6 months ago
                It looks like this this the case. I have alerted my host and they "seem" to be working on it.

                Thanks Bunk!

                This discussion is closed to further replies. Keep calm and carry on.