Re: [PHP-DB] debugging pg_connect

I suspect that PostgreSQL would log anything related to a network connection problem if the error logging level was set correctly. If you don't see any of those perhaps it is a networking issue. You might need to try an ethernet capture tool like Wireshark or perhaps something like tcpflow.

[PHP-DB] debugging pg_connect

Hello, since we upgraded to the latest php and PostgreSQL - we started to get frequent pg_connect() errors. What is sure is that they are not caused by insufficient connections - PostgreSQL reports 100 connections available and less than 10 used when the pg_connect fails. pg_last_error() and

Re: [PHP-DB] Debugging

On think I'm looking to figure out is how much it takes for an http process to connect. On Dec 2, 2005, at 3:17 PM, Benjamin Adams wrote: Can anyone give me an ideas or ways for me to find out a problem on my website? Its either the Invision power boards code, apache config or MySQL config

Re: [PHP-DB] Debugging

zend studio client/server work hand in hand and are the best debugging tools i have found ;) install zend studio server on the web server and use the zend studio client locally to debug. -- Joseph Crawford Jr. Zend Certified Engineer Codebowl Solutions, Inc. 1-802-671-2021 [EMAIL PROTECTED]

[PHP-DB] Debugging

Can anyone give me an ideas or ways for me to find out a problem on my website? Its either the Invision power boards code, apache config or MySQL config. I'm having trouble figuring out which one is causing the problems, can someone lead me to some good tips or programs to help me figure th

[PHP-DB] debugging / help required urgently.

Hi, I have a MAJOR problem with PHP mail() function, one that is odd and very frustrating as I have no idea what is causing it. I have used the one script to send emails out in the past and they have been sucessfully sent out, but as of a few days ago and now they are bouncing, some are actually

Re: [PHP-DB] Debugging/monitoring traffic to MySQL

On 7/18/02 8:30 PM, "Clive Bruton" <[EMAIL PROTECTED]> wrote: > Is there a way to see the traffic between PHP and MySQL, ie see the > statements/raw data that is sent between the two processes. > > I've tried running the MYSQL client, but there doesn't seem to be any > obvious command to do this

Re: [PHP-DB] Debugging/monitoring traffic to MySQL

On the MySQL server (could be the same machine) start mysql with -l arguement. Which enables connection and query logging.. YOu can just sit there and tail -f the server.log file to see all the querys/connections being executed in realtime... good look reading anything on a busy server ;) O

[PHP-DB] Debugging/monitoring traffic to MySQL

Is there a way to see the traffic between PHP and MySQL, ie see the statements/raw data that is sent between the two processes. I've tried running the MYSQL client, but there doesn't seem to be any obvious command to do this. Some other terminal process? I'm running MacOS X. TIA. -- Clive

Re: [PHP-DB] debugging?

Your $sql already contains a mysql_query. Why are you running it against it again, unless you have changed something. If $sql only contains your delete statement(without calling mysql_query), then do not put quotes around $sql,$dbh Otherwise, come back with what $sql and $dbh are assigned to

Re: [PHP-DB] debugging?

Ok jas > Ok now that I can see the error message how can I fix it... the syntax looks > correct and the error I am recieving is as follows > > You have an error in your SQL syntax near '= 'id'' at line 1 > > And this is my statement, > $sql = mysql_query("DELETE FROM $table_name WHERE $id =

Re: [PHP-DB] debugging?

Ok now that the sql statement is working I am getting an error on my result function... here is the result function $result = mysql_query("$sql, $dbh") or die(mysql_error()); and here is the error I am recieving You have an error in your SQL syntax near '1, 1' at line 1 I dont know enough about ph

Re: [PHP-DB] debugging?

Here is what your delete statement should look like: $sql = mysql_query("DELETE FROM $table_name WHERE id = '$id'",$dbh) or die(mysql_error()); Note the field name without the $ in front of it and the variable you are comparing it to with the $. One other note, in your table, you have id as a

Re: [PHP-DB] debugging?

Ok now that I can see the error message how can I fix it... the syntax looks correct and the error I am recieving is as follows You have an error in your SQL syntax near '= 'id'' at line 1 And this is my statement, $sql = mysql_query("DELETE FROM $table_name WHERE $id = 'id'",$dbh) or die(my

Re: [PHP-DB] debugging?

jas, Try this: - Remove the @, it suppresses the error - change die("Could not execute query, please try again later"); to die(mysql_error()); $sql = mysql_query("DELETE FROM $table_name WHERE $id = 'id'",$dbh) or die(mysql_error()); olinux --- jas <[EMAIL PROTECTED]> wrote: > Can someone tel

[PHP-DB] debugging?

Can someone tell me how I can find out why I am getting errors executing queries when I try to delete items from a table? I have 2 files... file 1. - Queries database, displays results with option to delete record using a check box, code is as follows... Current Inventory"; $count = -1; while ($