Problems with mssql functions on IIS PHP 5.4.24

Results 1 to 12 of 12
  1. #1
    Enthusiast Trickst3r is offline
    MemberRank
    Feb 2012 Join Date
    48Posts

    Problems with mssql functions on IIS PHP 5.4.24

    Hallo Zusammen :D

    Mein Problem ist folgendes:

    Ich benutze einen Patcher, welcher auch hier im Forum veröffentlicht wurde. Dieser benutzt die Login.php ~ Soweit so gut ... Bis hierhin funktioniert alles. Der Patcher logt sich ein, meldet dann allerdings direkt Fehlercode 500 - Interner Serverfehler

    Da ich PHP 5.4.24 benutze, funktioniert ja keine mssql_connect() Funktion mehr. Leider hab ich keine Ahnung von wo ich eine PHP Version unter 5.3 bekommen kann bzw wie ich diese in IIS einbinde

    Laut einigen Foren muss ich mysql_connect verwenden, was allerdings auch nicht funktioniert. Dann meldet sogar die Login.php, dass die Verbindung zur Datenbank fehlgeschlagen ist.

    Alle Dateien und Ordner sind in der Firewall freigegeben, die Ports auch....


    Ich würde Euch echt um Hilfe bitten da ich mittlerweile seit 3 Tagen mit nem' Kumpel zusammen versuche, dieses Problem zu beheben :/ :D



    und hier ist der Fehlerlog der PHP.exe

    [27-Feb-2014 14:52:45 Europe/Belgrade] PHP Fatal error: Call to undefined function mssql_connect() in C:\inetpub\wwwroot\patcher\Download\Login.php on line 13


    Ich benutze übrigens alle richtigen Extensions für PHP (IIS, PHPManager) für den SQL Server





    English:


    So, I'm having a problem.

    I'm using a patcher which was also published in this forum. It uses the normal Login.php. So far so good, but when the Patcher logs in, a error appears: ERRORCODE 500 - Internal Server Error

    I'm using IIS 7.5 with PHP Manager on Version 5.4.24

    The SQL Extensions are all installed correctly.

    This error is written in the php.log file:

    [27-Feb-2014 14:52:45 Europe/Belgrade] PHP Fatal error: Call to undefined function mssql_connect() in C:\inetpub\wwwroot\patcher\Download\Login.php on line 13

    Since I tried out mysql_connect, the Login.php responsed that the DB Connection has failed.





    MSSQL is not shown ~ We recoded the login.php to sql_functions() but the error keeps the same.
    Last edited by Trickst3r; 27-02-14 at 06:49 PM.


  2. #2
    Alpha Member Cyndaquil is offline
    MemberRank
    Mar 2012 Join Date
    EnglandLocation
    2,137Posts

    Re: Probleme mit IIS und PHP Funktionen des Patchers

    This is an English Forum. Please post in English.

  3. #3
    Enthusiast Trickst3r is offline
    MemberRank
    Feb 2012 Join Date
    48Posts

    Re: Probleme mit IIS und PHP Funktionen des Patchers

    I'm sorry for that. I just edited the post in both languages. Hopes that ok.

  4. #4
    LETS REACH 666 POSTS?!!!! ImNotSatan is offline
    MemberRank
    Apr 2013 Join Date
    google.devLocation
    573Posts

    Re: Probleme mit IIS und PHP Funktionen des Patchers

    Quote Originally Posted by Trickst3r View Post
    I'm sorry for that. I just edited the post in both languages. Hopes that ok.
    Did you download PHP?

  5. #5
    Enthusiast Trickst3r is offline
    MemberRank
    Feb 2012 Join Date
    48Posts

    Re: Probleme mit IIS und PHP Funktionen des Patchers

    I installed the PHP Manager with Microsofts' Web Platform Installer

  6. #6
    -.- NextIdea is offline
    MemberRank
    Nov 2012 Join Date
    343Posts

    Re: Probleme mit IIS und PHP Funktionen des Patchers

    Please edit also the topic name.

    And why is it so hard to read what the error says. And even when you Google that error it says very clearly whats wrong.
    Enable MSSQL extension.

  7. #7
    Enthusiast Trickst3r is offline
    MemberRank
    Feb 2012 Join Date
    48Posts

    Re: Probleme mit IIS und PHP Funktionen des Patchers

    Its enabled.

  8. #8
    -.- NextIdea is offline
    MemberRank
    Nov 2012 Join Date
    343Posts

    Re: Problems with mssql functions on IIS PHP 5.4.24

    Then the module fails to load. And you must find out why.
    Check error log, it should say what went wrong.


    To check which extensions are loaded write to a new php page ("phpinfo.php") this:
    PHP Code:
    <?php
    phpinfo
    ();
    ?>

  9. #9
    Enthusiast Trickst3r is offline
    MemberRank
    Feb 2012 Join Date
    48Posts

    Re: Problems with mssql functions on IIS PHP 5.4.24

    We now fixed the mssql_connection error, we just installed 5.3.26. The function errors are now gone but the Internal Server Error 500 is still appearing. Gonna check patcher source now again

    - - - Updated - - -

    Ok, kinda strange. The patcher doenst even redirect to our Login.php. "Website is not available" .... dafuq is going on :D

    - - - Updated - - -

    Dim Login As String() = wc.DownloadString("http://ip:81/patcher/Download/Login.php?Username=" & TextBox1.Text & "&Password=" & passMD5.ToLower()).Split("#")
    wc.Dispose()


    This is the line where the ERROR 500 comes from. The login succeeds but I guess the Patcher doesnt get a answer from the webserver.


    I removed our IP for saftey reasons :D

  10. #10
    A man of no consequence LordDemonMan is offline
    LegendRank
    Apr 2005 Join Date
    Hell, 8th CrclLocation
    2,338Posts

    Re: Problems with mssql functions on IIS PHP 5.4.24

    Dearest members, please refrain from going personal for petty reasons (or for any whatsoever)

  11. #11
    Enthusiast Trickst3r is offline
    MemberRank
    Feb 2012 Join Date
    48Posts

    Re: Problems with mssql functions on IIS PHP 5.4.24

    Quote Originally Posted by LordDemonMan View Post
    Dearest members, please refrain from going personal for petty reasons (or for any whatsoever)

    Sorry for that, but hating ppl like this.

    #Back to topic

  12. #12
    Enthusiast Trickst3r is offline
    MemberRank
    Feb 2012 Join Date
    48Posts

    Re: Problems with mssql functions on IIS PHP 5.4.24

    #CloseRequest

    Problem fixed.


    The Login.php isn't coded correctly. One thing is, there is missing MD5 function in the password query


    The second thing is, the Login.php sets the LoginState on "success", but the Patcher looks for "OK", so either change the LoginState in the PHP to "OK" or tell the Patcher to search for LoginState "success"

    If somebody needs a more detailed help, u can send me a PM.



Advertisement