Web Analytics Made Easy -
StatCounter Mysql Error Messages - CodingForum

Announcement

Collapse
No announcement yet.

Mysql Error Messages

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Mysql Error Messages

    Is there a way to change the way a mysql error message is displayed?
    Example:
    A current mysql error msg:
    Code:
    Warning: mysql_connect(): Can't create a new thread (errno 11). 
    If you are not out of available memory, you can consult the manual for a possible OS-dependent bug in
    hsphere/local/home/ACCOUNT_NAME/MYRANDOMSITE.com/path/to/file.php on line 4
    Is there a way to hide the section that displays my account name?

  • #2
    Using PHP? Then just use the str_replace() function on mysql_error().

    PHP Code:
    echo str_replace('hsphere/local/home/ACCOUNT_NAME/MYRANDOMSITE.com'''mysql_error()); 

    Comment


    • #3
      Originally posted by Fumigator View Post
      Using PHP? Then just use the str_replace() function on mysql_error().

      PHP Code:
      echo str_replace('hsphere/local/home/ACCOUNT_NAME/MYRANDOMSITE.com'''mysql_error()); 
      I tried this but it didn't work.
      PHP Code:
      $connect mysql_connect($dbhost$dbuname$dbpass)
                  or die(
      "Unable to connect to MySql Server");
      $dbselect mysql_select_db($dbname,$connect)
                  or die(
      "Could not select table");
      echo 
      str_replace('/hsphere/local/home/ACCOUNT_NAME/'''mysql_error($connect)); 
      And yes, I did change ACCOUNT_NAME

      Comment


      • #4
        What does "it didn't work" mean? Did your computer implode? Did the jerbil inside die? Did the internet crash?

        The code you posted won't ever get to your echo statement if there is a connection error due to your "or die()" code, so I reckon mysql_error() isn't going to return much if the connection works, so I'm not sure what you're going for there.

        Comment


        • #5
          Originally posted by Fumigator View Post
          What does "it didn't work" mean? Did your computer implode? Did the jerbil inside die? Did the internet crash?

          The code you posted won't ever get to your echo statement if there is a connection error due to your "or die()" code, so I reckon mysql_error() isn't going to return much if the connection works, so I'm not sure what you're going for there.
          When I say it doesn't work, I mean that there was no change in the displayed error message. I tried it with and without the "or die()" code.

          Comment


          • #6
            My first response was off the cuff; now I've thought about it. The function mysql_connect() will display a warning if it fails, which you can completely suppress using the "@" sign just before the function name.
            PHP Code:
            $connect = @mysql_connect($dbhost$dbuname$dbpass); 
            You can leave it like that if you don't need anything at all displayed, or you can now put the str_replace thing in to modify the error message. You may find that mysql_error() itself doesn't show the relative path to the file, which is what you were originally concerned with. (It will display username which you probably don't want either)

            Comment

            Working...
            X