[PHP-DB] Problem with INSERT after software upgrade From: Jarle Aase (jgaa <email protected>)
Date: 07/15/00

I'm having some problems with INSERT queries after a software upgrade (from
Debain Linux Potato to Woody, causing mysql and php to be upgraded as well).

Current versions:

   Debian GNU Linux "Woody" / kernel 2.2.17
   MySQL 3.23.21-beta (Debian v. 10.8)
   PHP Version 4.0.1pl2
   Apache/1.3.12

The following error show the problem:

   Warning: MySQL: Unable to save result set in lib/lib.php on line 23

   SQL ERROR
   INSERT INTO Session (UserID, LoginTime, HitCount, RemoteHost, Referer)
   VALUES (1, NOW(), 1, '193.91.161.12:2792', '')
   result=

The data is inserted into the database, but if I call mysql_insert_id() just
after the insertion, I just get a 0 (zero) back. Everything worked perefcty
well yesterday (until my harddisk suddenly believed that it was a dorbell,
and had to be replaced...)

The function that displays the error looks like this (SELECT queries works
perfectly well, so the global variables seems to be ok).

Function DoSQL($SQL)
{
        global $db, $DbName;

        $result = mysql_db_query($DbName, $SQL, $db);
        if ($result == false)
        {
                echo("<P id=error>SQL ERROR<br>$SQL<BR>result=$result</P>");
                echo mysql_error();
        }

        return $result;
}

Any help, tips and suggestions are wery welcome :)

(I've fund a number of queries on the same problem on deja, but no
solution).

Jarle 

--
Jarle Aase                      email: jgaa <email protected>
Author of freeware.             http://www.jgaa.com
(War FTP Daemon)                news:alt.comp.jgaa

<<< no need to argue - just kill'em all! >>>

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-db-unsubscribe <email protected>
For additional commands, e-mail: php-db-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>