Results 1 to 12 of 12
  1. #1

    MYSQL Error HELP!!

    I'm installing a program called easyestimates..

    It wants me to put all the files in my web directory so I could goto

    mydomain/install.php

    When I goto install.php and it prompts me for user/pass

    I get the error

    Fatal Error: Call to undefined mysql connect() in directory

    Anyone know anything about this error?

  2. #2
    Join Date
    Mar 2004
    Location
    New Jersey
    Posts
    793
    It's not connecting to your database. I've never used easyestimates, but I would imagine you have to edit some file and change a username/password setting to match your database settings. Try opening install.php in a text editor and see if that's where you need to place them.

  3. #3
    Join Date
    Dec 2004
    Location
    Downers Grove, IL
    Posts
    174
    Fatal Error: Call to undefined mysql connect() in directory
    Is that an exact quote of the error or did you type that in yourself?

    It appears that the mysql_connect() function is undefined. Possibly because mysql support was not included in your PHP build. Ask your host to include the --with-mysql option.
    SolidState - Open Source Billing Solution for Web Hosts

  4. #4
    I'm hosting is here locally.. what do I need to do? I'm inthe server room now

  5. #5
    Join Date
    Dec 2004
    Location
    Downers Grove, IL
    Posts
    174
    I'm assuming Unix/Linux here. I've never done PHP in Windows, so my guess is as good as yours, but I'm sure you can find out from the manual.

    If you're building PHP from source make sure you give the --with-mysql option when you run ./configure. If you installed from a package, contact your vendor and find out if they have any support packages for MySQL support in PHP.
    SolidState - Open Source Billing Solution for Web Hosts

  6. #6
    Join Date
    Mar 2004
    Location
    New Jersey
    Posts
    793
    If colklink is correct then like he said, you'll have to recompile with mysql included. Most hosts do usually include that however, which is strange. Is this your own personal server or shared? Is easyestimates a product that includes support? Might want to check with them before you start as well.

  7. #7
    Here is my exact error
    Fatal error: Call to undefined function mysql_connect() in D:\inetpub\wwwroot\Vioplex\easyestimates\install.php on line 8

  8. #8
    Join Date
    Mar 2004
    Location
    New Jersey
    Posts
    793
    Ah ha! This is a windows system using IIS. Do you know if you have mySQL installed on it?

  9. #9
    yes I installed it myself in alil bit ago

  10. #10
    Here is the code that I'm getting a error on

  11. #11
    <?php
    if (!isset($_SERVER['PHP_AUTH_USER'])) {
    header('WWW-Authenticate: Basic realm="EasyEstimates Install"');
    header('HTTP/1.0 401 Unauthorized');
    echo 'Logon cancelled';
    exit;
    } else {
    $Link_ID = mysql_connect("localhost", $_SERVER['PHP_AUTH_USER'], $_SERVER['PHP_AUTH_PW']);
    if ($Link_ID) {
    echo("<p>connect ok</p>");
    mysql_close($Link_ID);
    echo("<script>window.location='install2.php';</script>");
    }
    else {
    unset ($_SERVER['PHP_AUTH_PW']);
    unset ($_SERVER['PHP_AUTH_USER']);
    session_destroy();
    echo("<script>window.location='installfail.htm';</script>");
    exit;
    }
    }
    //-EasyEstimates is the property of Sizzling Web Design, a subsidiary of -->
    //<!--Sizzling Video International and can only be used with permission.-->
    //<!-- Please visit www.SizzlingWebDesign.com for more information -->
    //<!-- Copyright 2004 All rights reserved -->
    ?>

  12. #12
    Join Date
    Mar 2004
    Location
    New Jersey
    Posts
    793
    Originally posted by PPloesser
    yes I installed it myself in alil bit ago
    Hi. As colklink said a bit ago, PHP is not recognizing that mySQL is installed. What you'll have to do is re-install PHP on the box with mySQL support activated. With a Windows box, I believe the binary packages have mySQL built in already. Since you just installed mySQL I would guess that PHP is not configured to use it yet.

    Check out this for more help on installing PHP properly:
    http://www.php.net/manual/en/install.windows.iis.php

Posting Permissions

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