php-windows Digest 10 Nov 2004 14:27:57 -0000 Issue 2463

Topics (messages 24951 through 24955):

Unknown: 2 result set(s) not freed
        24951 by: G�n G�ksu

Shell Script error
        24952 by: Rui Francisco
        24953 by: Luis Moreira

Re: [PHP] Shell Script error
        24954 by: Angelo Zanetti
        24955 by: Rui Francisco

Administrivia:

To subscribe to the digest, e-mail:
        [EMAIL PROTECTED]

To unsubscribe from the digest, e-mail:
        [EMAIL PROTECTED]

To post to the list, e-mail:
        [EMAIL PROTECTED]


----------------------------------------------------------------------
--- Begin Message ---
Hello,

I am fairly new to mysql. My appologies if this question is lame to you.
I have stiff not figured a way to fix the following errors appearing in my box.

Warning: Unknown: 2 result set(s) not freed. Use mysql_free_result to free 
result sets which were requested using mysql_query() in Unknown on line 0

And

Warning: Unknown: 1 result set(s) not freed. Use mysql_free_result to free 
result sets which were requested using mysql_query() in Unknown on line 0

I get these errors under phpmyadmin.

I have not run new code on the server yet.
I imagine this is something setup related.

A picture of the main page is attached (if this list supports attachments).

Any help will be very much appreciated.

Thank you.
Gün. :)

--- End Message ---
--- Begin Message ---
Hi,

I have a small problem with a PHP script with Pear DB

The problem is the following: I'm creating a shell script in  PHP that
access one interbase database.

The problem is that if i run it on a webserver the script run correctly
but if i runit in the command line it reports one error (DB Error:
connect failed).

Does anybody know what is the problem ?

Thanks in advance
Rui Francisco

--- End Message ---
--- Begin Message --- I am not exactly an expert on PEAR, but if the error says "connect failed", you are not reaching the DBand/or the server were it resides.
Check the way you are connecting :


- Is the server named correctly ?
- If the access is authenticated, are you using the correct username/password ?
- Do you have enough rights to access the DB ?
- Are you accessing the correct table ?



Luis

Rui Francisco wrote:

Hi,

I have a small problem with a PHP script with Pear DB

The problem is the following: I'm creating a shell script in  PHP that
access one interbase database.

The problem is that if i run it on a webserver the script run correctly
but if i runit in the command line it reports one error (DB Error:
connect failed).

Does anybody know what is the problem ?

Thanks in advance
Rui Francisco


--- End Message ---
--- Begin Message ---
well maybe you are trying to connect to localhost which could be fine
for the server but not from commandline... send more info.

>>> Rui Francisco <[EMAIL PROTECTED]> 11/10/2004 2:06:09 PM >>>
Hi,

I have a small problem with a PHP script with Pear DB

The problem is the following: I'm creating a shell script in  PHP that
access one interbase database.

The problem is that if i run it on a webserver the script run
correctly
but if i runit in the command line it reports one error (DB Error:
connect failed).

Does anybody know what is the problem ?

Thanks in advance
Rui Francisco

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php 

--------------------------------------------------------------------
Disclaimer 
This e-mail transmission contains confidential information,
which is the property of the sender.
The information in this e-mail or attachments thereto is 
intended for the attention and use only of the addressee. 
Should you have received this e-mail in error, please delete 
and destroy it and any attachments thereto immediately. 
Under no circumstances will the Cape Technikon or the sender 
of this e-mail be liable to any party for any direct, indirect, 
special or other consequential damages for any use of this e-mail.
For the detailed e-mail disclaimer please refer to 
http://www.ctech.ac.za/polic or call +27 (0)21 460 3911

--- End Message ---
--- Begin Message ---

Its a simple script

$_SERVER['utilizador']='user';
$_SERVER['pass']='pass';
$_SERVER['host']='localhost or IP address';
$_SERVER['db_name']='c:/path/dbname.fdb';

include_once('DB.php');

$dsn="ibase://".$_SERVER['utilizador'].":".$_SERVER['pass']."@".$_SERVER['host']."/".$_SERVER['db_name'];

   $ligacaoBD=DB::connect($dsn);
   if (DB::isError($ligacaoBD)) {
       die($ligacaoBD->getMessage());
   }

The user has admin right on the database, and the database doesn't implement security measures like Mysql for access from other hosts.

The problem is that if i run the script on the browser it works, but on the command line on Windows machine it doesn't work

Thanks in advance
Rui Francisco

Angelo Zanetti wrote:

well maybe you are trying to connect to localhost which could be fine
for the server but not from commandline... send more info.



Rui Francisco <[EMAIL PROTECTED]> 11/10/2004 2:06:09 PM >>>


Hi,

I have a small problem with a PHP script with Pear DB

The problem is the following: I'm creating a shell script in  PHP that
access one interbase database.

The problem is that if i run it on a webserver the script run
correctly
but if i runit in the command line it reports one error (DB Error:
connect failed).

Does anybody know what is the problem ?

Thanks in advance
Rui Francisco





--
Rui Francisco - [EMAIL PROTECTED]
FCCN - Funda��o para a Computa��o Cient�fica Nacional
Av. Brasil, 101 1700-066 Lisboa - Portugal
Tel: +351 218440100 Fax: +351 218472167
-----------------------------------------------------

--- End Message ---

Reply via email to