Working connection... not working? (Advanced)

redna379

Hi.
I'm experiencing an impossible problem, here.
I made a very complex script, which works fine (it's HERE)

It has tons of modules, and obviously a config file which opens the db connection.
But there is one, and only one, module having strange troubles.

$query is just a simple INSERT INTO command. But it does not inserts anything.
I only obtain... nothing. Neither an error from the server!

This is the part of the code i'm talking about, with my testing addons:

if (!mysql_ping($conn)) {
		echo "SORRY, WE HAVE PROBLEMS PINGING THE DATABASE. Please retry later";
		return;
	}
	echo " 1-- ".$conn." --<br>";
	$result_check=mysql_query($query,$conn);
	if (!$result_check) {
		echo " 2-- ".$conn." --<br>";
		echo "SORRY, WE HAVE PROBLEMS WITH THE DATABASE.<br>Please retry later<br>".mysql_error();
		return;
	}

And there is a ini_set('error_reporting', E_ALL); command on top of script.
Well: the output i obtain is:

1-- Resource id #10 --
2-- Resource id #10 --
SORRY, WE HAVE PROBLEMS WITH THE DATABASE.
Please retry later

mysql_ping gave no errors.
But one line below, no more? Moreover, mysql_error outputs nothing. And query not executed, of course.

I really don't know what to think, the same connection is used to perform similar things everywhere and it works. Only here it has this problem.

Extra1: there are no mysql_close commands anywhere here.
Extra2: the insert into syntax is correct and works if executed from within phpmyadmin.
Extra3: I'm running php 5.0.4 and MySQL 4.1.14 on Fedora Core 4, fully updated

Any idea/suggestion? I can't see a way out, right now...

Many thanx in advance.

thorpe

mysql_error never returns anything because you never get up to it. remove the call to return and you might see something.

also... what is a module? do you meen a function... what? did you pass $conn into this function?

Roger_Ramjet

So:

you have a connection: no ping error message AND message 1 shows the resource no

your query fails: message 2

The fact that A query works elsewhere means nothing. Most time you are not running the same query in your script. The only way to check a $query is to echo it to the screen and then copy paste the exect text displayed into your phpmyadmin or whatever.

So go and read Debugging 101

redna379

I already tryied without returns, but nothing is shown anyhow.

About modules...
There is an index file, which includes:
a config file (which also opens the DB connection)
a function file (with mysql command inside which works fine)
modules (files to be included in the "working part" of the script)

Just an include, anyhow.
The script giving problem is a simple bug signalation form.
Once submitted, it executes the code shown to insert sent data in DB.

The way it works is calling index (with config and functions) + variables to tell index what to do.

If you want to see the error, here is the "querystinged form" of the call:

EDIT: Buggy link removed

if you try it, you can see only the "sorry" message (i removed the echo $conn test commands).
Variables means:

dosendcard: just to tell the script it's insert time
action: the module to be included
s r c px py hlangs: just vars from the original FORM
referenceurl: where the user came from, if available
sender: the email address of the sender
testo: the signalation itself

I have to add that everything around this error works. The site uses mysql everywhere, even the text are stored in DB to create a multilanguage system.
So, if you see the texts, the DB works.

redna379

Roger Ramjet wrote:
So:

you have a connection: no ping error message AND message 1 shows the resource no

your query fails: message 2

The fact that A query works elsewhere means nothing. Most time you are not running the same query in your script. The only way to check a $query is to echo it to the screen and then copy paste the exect text displayed into your phpmyadmin or whatever.

So go and read Debugging 101

redna379 wrote:
Extra2: the insert into syntax is correct and works if executed from within phpmyadmin.

I did it. And the query works fine, if pasted in phpmyadmin as echoed from the script.

redna379

Almost fixed!
I made a little workaraound.
It's a function that can be called before those damned queries.
And it works 😃

function connection_fixer() {
	global $DB_host,$DB_login,$DB_password,$DB_database,$conn;
	$testquery='a simple and fast test query here...';
	$result_check=mysql_query($testquery,$conn);
	if (!$result_check) {
		echo "reconnecting...";
		$conn = mysql_connect($DB_host,$DB_login,$DB_password);
		if (!$conn) {
			echo "Error while connecting to DB Server: " . mysql_error();
			return;
		}
		if (!mysql_select_db($DB_database)) {
			echo "Error selecting the database: " . mysql_error();
			return;
		}
		return $conn;
	}
}