Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

Internal server error with mysqli and no log entry

Discussion in 'General Discussion' started by Arara, Apr 5, 2011.

  1. Arara

    Arara Registered

    Joined:
    Mar 25, 2011
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    51
    I have trouble with a new php application. Everytime it queries a simple SELECT with mysqli prepared statements (to be exact it crashes at the bind_result line) i only get an internal server error. Wouldn't be so bad if i could find a line in any of the log-files (including CPanel >> Error Log). How can i enable logging of 500 errors in cpanel/whm?

    Thx for any help
     
    #1 Arara, Apr 5, 2011
    Last edited: Apr 5, 2011
  2. cPanelJared

    cPanelJared Technical Analyst

    Joined:
    Feb 25, 2010
    Messages:
    1,835
    Likes Received:
    20
    Trophy Points:
    143
    Location:
    Houston, TX
    cPanel Access Level:
    Root Administrator
    Errors from a PHP application on one of your sites would not be written to a cPanel log. Instead, they would be written to an Apache log. Try looking in /usr/local/apache/logs/error_log and /usr/local/apache/logs/suphp_log while using a Web browser to access the PHP application.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #2 cPanelJared, Apr 5, 2011
  3. Arara

    Arara Registered

    Joined:
    Mar 25, 2011
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    51
    Both logs contain nothing useful. In /usr/local/apache/logs/error_log are only old entries which have nothing to do with the page access and /usr/local/apache/logs/suphp_log shows only a line (for the page access) like "[Tue Apr 05 09:16:19 2011] [info] Executing "/path/to/the/script.php" as UID 503, GID 500".
     
    #3 Arara, Apr 5, 2011
  4. cPanelJared

    cPanelJared Technical Analyst

    Joined:
    Feb 25, 2010
    Messages:
    1,835
    Likes Received:
    20
    Trophy Points:
    143
    Location:
    Houston, TX
    cPanel Access Level:
    Root Administrator
    It appears that the script is executing correctly, and an error is happening while the script is executing. The script's developer would be the best resource for an application-specific error like this, but it is possible that other users may have some helpful suggestions.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #4 cPanelJared, Apr 5, 2011
  5. Arara

    Arara Registered

    Joined:
    Mar 25, 2011
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    51
    Problem is i am the developer. And i'm out of ideas. I have reduced the script to a minimal version which is almost the same as the examples at php.net. It is also working on a local webserver. If i replace mysqli with the pdo equivalent it works. I have also asked in another forum specialized on php and they say the code is correct. So my last hope was to find a log file with some informations.
     
    #5 Arara, Apr 5, 2011
  6. cPanelTristan

    cPanelTristan Quality Assurance Analyst
    Staff Member

    Joined:
    Oct 2, 2010
    Messages:
    7,608
    Likes Received:
    32
    Trophy Points:
    238
    Location:
    somewhere over the rainbow
    cPanel Access Level:
    Root Administrator
    You could enable logging for the application itself to write to an error_log on the account? I'm not entirely certain you will end up with any logging for this otherwise.

    Have you tried executing the script via command line to see if you have any errors there?

    My main wonder about MySQLi and the script is that it might be exceeding some memory limitation. Do you have any RLimitMEM settings in httpd.conf file? Do you have sufficient memory_limit set in /usr/local/lib/php.ini file?

    Code:
    grep -i rlimit /usr/local/apache/conf/httpd.conf
grep -i memory_limit /usr/local/lib/php.ini
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #6 cPanelTristan, Apr 5, 2011
  7. Arara

    Arara Registered

    Joined:
    Mar 25, 2011
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    51
    I will check this. And for the sql handling i switch to the pdo drivers. Seems to have some advantages.
    Thanks for your help.
     
    #7 Arara, Apr 5, 2011
(You must log in or sign up to post here.)
Loading...
Similar Threads - Internal server error
  1. Q309

    500 Internal Server Error: UID of script smaller than min_uid

    Q309, Jul 23, 2018, in forum: EasyApache
    Replies:
    2
    Views:
    66
    cPanelLauren
    Jul 23, 2018
  2. Franklin237

    500 Internal Server Error

    Franklin237, May 10, 2018, in forum: General Discussion
    Replies:
    1
    Views:
    600
    cPanelLauren
    May 11, 2018
  3. KrishPCM

    More than 9 Word limit in URL alias raising 500 internal server error

    KrishPCM, Mar 1, 2018, in forum: General Discussion
    Replies:
    1
    Views:
    232
    cPanelMichael
    Mar 1, 2018
  4. kay9

    SOLVED Removing site publisher causes 500 internal server error

    kay9, Feb 12, 2018, in forum: General Discussion
    Replies:
    2
    Views:
    457
    cPanelMichael
    Feb 14, 2018
  5. Ahmed Hany

    500 Internal Server Error

    Ahmed Hany, Dec 11, 2017, in forum: General Discussion
    Replies:
    6
    Views:
    2,070
    cPanelMichael
    Jan 23, 2018

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Accept Learn More...
    Dismiss Notice