ID: 17248
Updated by: [EMAIL PROTECTED]
Reported By: [EMAIL PROTECTED]
Status: Feedback
Bug Type: MySQL related
Operating System: Linux Mandrake 8.2
PHP Version: 4.1.2
New Comment:
Sorry, but this is neither short nor looks self-contained (reference to
commonlib.inc). Short is in terms of a few lines, say 10 - 25. If you
can't do that, please provide all necessary files for download (via
http) and add it to the report, thanks.
Previous Comments:
------------------------------------------------------------------------
[2002-05-15 10:57:30] [EMAIL PROTECTED]
I cut the script down and managed to locate the source of the error but
not the reason for this.
-------------------------
<?
require("commonlib.inc");
error_reporting(E_ALL);
$btnSenden = $GLOBALS["btnSenden"];
$btnBearbeiten = $GLOBALS["btnBearbeiten"];
$btnNeuAnlegen = $GLOBALS["btnNeuAnlegen"];
$lstArtLuftfahrzeug = $GLOBALS["lstArtLuftfahrzeug"];
$hidModus = $GLOBALS["hidModus"];
$hidFlugzeug_ID = $GLOBALS["hidFlugzeug_ID"];
$Luftfahrzeug = $GLOBALS["Luftfahrzeug"];
$txtKundenNr = $GLOBALS["txtKundenNr"];
$kdnrClub = $GLOBALS["kdnrClub"];
$hidMusterId = $GLOBALS["hidMusterId"];
// **************
// ** MAIN :-) **
// **************
Create_DB_Connection($verbindung_lfz) OR
ErrorMsg("Luftfahrzeug", "Fehler beim Verbindungsaufbau");
// COMMENT: THIS ONE WORKS AND CAUSES THE FIRST TWO
DEPRECATED-WARNINGS
GetUserData($SID, $row);
$txtKundenNr = $row['KundenNr'];
?>
[ HTML ...]
<?
$statement = "SELECT * from Luftfahrzeuge Where
KundenNr='$txtKundenNr'";
print "DEBUG_lfz: $statement<br>";
if (! $verbindung_lfz)
{
print "Holla, keine Verbindung!<br>";
}
else
{
print "Verbindung ok!<br>";
}
// COMMENT: THIS ONE DOESN'T WORK ANYMORE
SQLExec($statement, $verbindung_lfz, $result_lfz) OR
ErrorMsg("Luftfahrzeug", "Fehler bei der Datenabfrage");
Close_DB_Connection($verbindung_lfz) OR
ErrorMsg("Luftfahrzeug", "Fehler beim Verbindungsabbau");
[...]
?>
-------------------------
I changed SQLExec to
-------------------------
function SQLExec($sqlquery, $viaconnection, &$resultset)
{
$db_base = $GLOBALS["CONST_DB_BASE"];
$retval = 1;
$resultset = mysql_db_query($db_base, $sqlquery,
$viaconnection) or
$retval = 0;
// THIS IS NEW
if ($retval == 0)
{
print "DEBUG: (" . mysql_error() . ")<br>";
}
return $retval;
}
-------------------------
In the snippet above I used SQLData:
-------------------------
function SQLData($resultset)
{
return mysql_fetch_array($resultset);
}
-------------------------
GetUserData does the following:
-------------------------
function GetUserData(&$usersid, &$userrow)
{
$login_ok = 0;
if (streq($usersid, "0"))
{
$login_ok = 0;
}
else
{
Create_DB_Connection($verbindung_getuserdata) OR
ErrorMsg("GetUserData", "Fehler beim
Verbindungsaufbau");
$statement = "SELECT *,
DATE_FORMAT(Faelligkeit_Rechnung,
'%d.%m.%Y') AS DFaelligkeit_Rechnung,
DATE_FORMAT(Verfallsdatum,
'%d.%m.%Y') AS DVerfallsdatum,
DATE_FORMAT(Faelligkeit_Erinnerung1,
'%d.%m.%Y') AS DFaelligkeit_Erinnerung1,
DATE_FORMAT(Faelligkeit_Erinnerung2,
'%d.%m.%Y') AS DFaelligkeit_Erinnerung2,
DATE_FORMAT(Registrierung,
'%d.%m.%Y') AS DRegistrierung,
DATE_FORMAT(DatumMedical, '%d.%m.%Y')
AS DDatumMedical,
DATE_FORMAT(Geburtsdatum, '%d.%m.%Y')
AS DGeburtsdatum
FROM tblKunden, tblSessions
WHERE
(tblKunden.KundenNr=tblSessions.KundenNr) AND
(tblSessions.SessionID='$usersid')";
SQLExec($statement, $verbindung_getuserdata,
$resultset_getuserdata) OR
ErrorMsg("GetUserData", "Fehler beim Ermitteln der
Kundennummer");
if (SQLNumRows($resultset_getuserdata) > 1)
{
ErrorMsg("GetUserData", "Zuviele Eintr�ge in
tblSessions f�r
die aktuelle Kundennummer");
}
elseif (SQLNumRows($resultset_getuserdata) < 1)
{
$usersid = 0;
$login_ok = 0;
}
else
{
$userrow = SQLData($resultset_getuserdata);
$statement = "UPDATE tblSessions SET
LetzterZugriff=NOW()
WHERE SessionID='$usersid'";
SQLExec($statement, $verbindung_getuserdata,
$resultset_getuserdata) OR
ErrorMsg("GetUserData", "Fehler beim Aktualisieren
der
SessionID");
Close_DB_Connection($verbindung_getuserdata) OR
ErrorMsg("GetUserData", "Fehler beim
Verbindungsabbau");
$login_ok = 1;
}
}
return $login_ok;
}
-------------------------
If I don't call GetUserData with PHP 4.1.2, everything works fine.
Remember: The script works with PHP 4.0.3 no matter if I call
GetUserData or not. I would have changed it if it didn't work a year
ago.
Here's the output of the script:
-------------------------
Warning: Undefined index: btnSenden in
/var/www/html/dokumente/mitglieder/mygat24/LFZ_Luftfahrzeug.inc on line
5
Warning: Undefined index: btnBearbeiten in
/var/www/html/dokumente/mitglieder/mygat24/LFZ_Luftfahrzeug.inc on line
6
Warning: Undefined index: btnNeuAnlegen in
/var/www/html/dokumente/mitglieder/mygat24/LFZ_Luftfahrzeug.inc on line
7
Warning: Undefined index: lstArtLuftfahrzeug in
/var/www/html/dokumente/mitglieder/mygat24/LFZ_Luftfahrzeug.inc on line
8
Warning: Undefined index: hidModus in
/var/www/html/dokumente/mitglieder/mygat24/LFZ_Luftfahrzeug.inc on line
9
Warning: Undefined index: hidFlugzeug_ID in
/var/www/html/dokumente/mitglieder/mygat24/LFZ_Luftfahrzeug.inc on line
10
Warning: Undefined index: Luftfahrzeug in
/var/www/html/dokumente/mitglieder/mygat24/LFZ_Luftfahrzeug.inc on line
11
Warning: Undefined index: txtKundenNr in
/var/www/html/dokumente/mitglieder/mygat24/LFZ_Luftfahrzeug.inc on line
12
Warning: Undefined index: kdnrClub in
/var/www/html/dokumente/mitglieder/mygat24/LFZ_Luftfahrzeug.inc on line
14
Warning: Undefined index: hidMusterId in
/var/www/html/dokumente/mitglieder/mygat24/LFZ_Luftfahrzeug.inc on line
16
// COMMENT: THESE TWO ARE FROM GetUserData
DEBUG_SQLExec: query (SELECT *, DATE_FORMAT(Faelligkeit_Rechnung,
'%d.%m.%Y') AS DFaelligkeit_Rechnung, DATE_FORMAT(Verfallsdatum,
'%d.%m.%Y') AS DVerfallsdatum, DATE_FORMAT(Faelligkeit_Erinnerung1,
'%d.%m.%Y') AS DFaelligkeit_Erinnerung1,
DATE_FORMAT(Faelligkeit_Erinnerung2, '%d.%m.%Y') AS
DFaelligkeit_Erinnerung2, DATE_FORMAT(Registrierung, '%d.%m.%Y') AS
DRegistrierung, DATE_FORMAT(DatumMedical, '%d.%m.%Y') AS DDatumMedical,
DATE_FORMAT(Geburtsdatum, '%d.%m.%Y') AS DGeburtsdatum FROM tblKunden,
tblSessions WHERE (tblKunden.KundenNr=tblSessions.KundenNr) AND
(tblSessions.SessionID='643732d72c264e8c996f05bf64725218'))
Warning: mysql_db_query is deprecated; use mysql_select_db() and
mysql_query() instead in /var/www/html/include/functions_database.inc
on line 100
DEBUG_SQLExec: query (UPDATE tblSessions SET LetzterZugriff=NOW() WHERE
SessionID='643732d72c264e8c996f05bf64725218')
Warning: mysql_db_query is deprecated; use mysql_select_db() and
mysql_query() instead in /var/www/html/include/functions_database.inc
on line 100
DEBUG_lfz: SELECT * from Luftfahrzeuge Where KundenNr='10011'
Verbindung ok!
// COMMENT: THE RESULT FROM GetUserData IS OK BECAUSE WE SEE KundenNr
HERE
DEBUG_SQLExec: query (SELECT * from Luftfahrzeuge Where
KundenNr='10011')
// COMMENT: THIS ONE IS FROM THE SQLExec IN THE SCRIPT
Warning: mysql_db_query is deprecated; use mysql_select_db() and
mysql_query() instead in /var/www/html/include/functions_database.inc
on line 100
Warning: 20 is not a valid MySQL-Link resource in
/var/www/html/include/functions_database.inc on line 100
DEBUG: ()
Es ist ein Fehler aufgetreten:
Modul: Luftfahrzeug
Beschreibung: Fehler bei der Datenabfrage:
-------------------------
What I don't understand:
First: mysql_db_query seems to return an error in SQLExec but no
errormessage for mysql_error? If I ignore the warning from SQLExec,
I'll get an error in Close_DB_Connection.
Second: GetUserData uses its own connection (Create, Query, Close) with
unique variable names.
So where's the problem with this:
Create connection A
Create connection B
Query via connection B
Close connection B
Query via connection A
?
Third: Why does it work on 4.0.3 but not on 4.1.2?
Please tell me where I make my mistake. I can't believe this to be a
bug in PHP anymore.
Thanks,
Christian
------------------------------------------------------------------------
[2002-05-15 09:26:47] [EMAIL PROTECTED]
It seems like a bug in your code/logic. Please paste a small,
self-contained example showing the problem. Also make sure you run
everything with error_reporting(E_ALL);
------------------------------------------------------------------------
[2002-05-15 09:19:42] [EMAIL PROTECTED]
Hi!
I just recently switched an application from Debian Woody with PHP
4.0.3 PL1 to Mandrake Linux 8.2 / PHP 4.1.2 (as an RPM out of the box).
The same script that worked fine for over a year now makes trouble on
the new machine:
/* two function definitions */
Create_DB_Connection($verbindung_lfz) OR
ErrorMsg("Module", "connection could not be created");
if ($kdnrClub)
{
/* GetUserData creates its own connection to the db and closes
it after
use */
GetUserData($SID, $row);
[...]
}
[...]
/* some php-code and some db-queries with $verbindung_lfz but
different
$result-vars */
[...]
if (! $verbindung_lfz)
{
print "No connection!<br>";
}
else
{
print "Connection ok!<br>";
}
SQLExec($statement, $verbindung_lfz, $result_lfz) OR
ErrorMsg("Luftfahrzeug", "couldn't get data: " .
mysql_error());
The connection still exists because there is the "Connection ok!"
message. Right after that my SQLExec blows up and gives
Warning: [some number] is not a valid MySQL-Link resource in [...]
Later, the connection can't be closed because it does not exist. But
why does my connection-check work before I call SQLExec?
The SQL-statement is working fine on the console. My query works if I
move it to the beginning of the script after the Create_DB_Connection.
I replaced my wrapping functions with the original functions-calls but
that didn't make a difference.
I've got some kind of framework for my database connections. These are
the used functions in this excerpt:
function Create_DB_connection(&$newconnect)
{
$db_user = $GLOBALS["CONST_DB_USER"];
$db_host = $GLOBALS["CONST_DB_HOST"];
$db_pass = $GLOBALS["CONST_DB_PASS"];
$retval = 1;
$newconnect = mysql_connect($db_host, $db_user, $db_pass) or
$retval = 0;
return $retval;
}
function SQLExec($sqlquery, $viaconnection, &$resultset)
{
$db_base = $GLOBALS["CONST_DB_BASE"];
$retval = 1;
$resultset = mysql_db_query($db_base, $sqlquery,
$viaconnection) or
$retval = 0;
return $retval;
}
So what changed between 4.0.3PL1 und 4.1.2 to cause this behaviour?
There are some more scripts and I'd like to have an idea about what I
should take care of.
Thanks!
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=17248&edit=1
