Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 6 of 6
  1. #1
    New Coder
    Join Date
    Dec 2005
    Posts
    27
    Thanks
    0
    Thanked 0 Times in 0 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
    UE Antagonizer Fumigator's Avatar
    Join Date
    Dec 2005
    Location
    Utah, USA, Northwestern hemisphere, Earth, Solar System, Milky Way Galaxy, Alpha Quadrant
    Posts
    7,691
    Thanks
    42
    Thanked 637 Times in 625 Posts
    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()); 

  • #3
    New Coder
    Join Date
    Dec 2005
    Posts
    27
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Quote 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

  • #4
    UE Antagonizer Fumigator's Avatar
    Join Date
    Dec 2005
    Location
    Utah, USA, Northwestern hemisphere, Earth, Solar System, Milky Way Galaxy, Alpha Quadrant
    Posts
    7,691
    Thanks
    42
    Thanked 637 Times in 625 Posts
    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.

  • #5
    New Coder
    Join Date
    Dec 2005
    Posts
    27
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Quote 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.

  • #6
    UE Antagonizer Fumigator's Avatar
    Join Date
    Dec 2005
    Location
    Utah, USA, Northwestern hemisphere, Earth, Solar System, Milky Way Galaxy, Alpha Quadrant
    Posts
    7,691
    Thanks
    42
    Thanked 637 Times in 625 Posts
    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)


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •