php nightmare...

chilian

I am moving a website from one server to another, the site is entirely php with a mysql backend.

AFter the move, I am getting the following error:

Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource in /usr/home/vhosts/backmeupmusic.com/httpdocs/query-class.php on line 55
Error:

If I move the site back to the old server, the code works just fine!

The new server is running FreeBSD 4.10. PHP Version 4.3.8 the old server was running Mandrake, with php 4.0.6.

I have checked the php.ini files and made the right configuration changes to reflect the old server php.ini file.

Any help would be appreciated.

tsinka

Hi,

it's hard to guess anything without any code but change your code a little bit. The error message means that something is wrong with the connection and/or the variable holding the connection/link resource.

Example:

  $lnk = mysql_connect("host","user","pass") or die("Connection error: ".mysql_error());

  mysql_select_db("thedb",$lnk) or die("Select DB error: ".mysql_error());

  $sql = "SELECT fieldlist FROM atable WHERE condition";
  $res = mysql_query($sql,$lnk) or die("SQL error: ".mysql_error());

Add mysql_error() function calls. That should display any errors like "access denied" or something like that.

Thomas

chilian

Here is the Code on line 55:

               // Submit query to db
                $mysql_result = mysql_db_query($dbname,$newsql);

            // Check for errors
            if (mysql_errno()) {
                   $errormessage = mysql_error($this->mysql_link);
                   die ("Error: $errormessage");
            }

At the beginning of the script, the guy has this:


class Query {
    // Member vars
    var $mysql_link;

    // Constructor function sets up db link
    function query () {
        include ('dbinfo.php');
        $this->mysql_link = mysql_connect($dbhost,$dbuser,$dbpass);
        // Check for errors
            if (mysql_errno()) {
                    $errormessage = mysql_error($this->mysql_link);
                    die ("Error: $errormessage");
            }
    }

I just dont understand why it gives the error on line 55 when i should be giving in the beginning of the script.

chilian

I guess this would answer all of my questions:

http://us4.php.net/manual/en/function.mysql-db-query.php

Note: This function has been deprecated since PHP 4.0.6. Do not use this function. Use mysql_select_db() and mysql_query() instead.

Thank you for the input!