Re: [Sqlrelay-discussion] bind pear php module

[David M. <dav...@fi...>]

Looks like there's a stray debug command left over from testing.

Edit sqlrelay.php, look for sqlrcon_debugOn() and remove the line.

I think also I put the identity variable in the wrong class.  Remove it
from the DB_sqlrelay_cursor class (around line 33) and add it to the
DB_sqlrelay class (around line 52) and see if that doesn't fix it.

Dave
dav...@fi...

On Fri, 2005-06-10 at 14:42 +0200, david forums wrote:
> Hello
> 
> After my last email, I recompile the rpm myself, even if I meet some  
> difficulties, I could get a new "sql_relay.so", with works fine.
> 
> But using "sqlrelay.php" pear module, I get the following output :
> Result Set Buffer Size: 100 Connecting to listener... Unix socket:  
> /tmp/MyPostgres.socket Authenticating with listener : pgTest:test No  
> authentication error. Must Not Reconnect. Authenticating with connection :  
> pgTest:test No authentication error. Sending Query: select  
> nextval('public.mySequence') Length: 35 Requesting a new cursor. Sending 0  
> Input Bind Variables: Sending Output Bind Variables: Send Column Info: yes  
> Skipping and Fetching row to get: 99 Skipping 0 rows Fetching 100 rows  
> Checking For An Error... none. Getting Cursor ID... Cursor ID: 0 Previous  
> result set was not suspended. Parsing Column Info Actual row count: 1  
> Affected row count: 0 Column count: 1 "nextval","20", 8 (0,0) NOT NULL  
> Receiving Output Bind Values: Parsing Data "4", Got end of result set.
> Warning: Missing argument 2 for DB_sqlrelay_cursor::DB_sqlrelay_cursor()  
> in /usr/share/pear/DB/sqlrelay.php on line 36
> Aborting Result Set For Cursor: 0 Deallocated cursor
> Notice: Undefined variable: identity in /usr/share/pear/DB/sqlrelay.php on  
> line 278
> Identifying... postgresql
> Notice: Undefined variable: identity in /usr/share/pear/DB/sqlrelay.php on  
> line 297
> 
> Notice: Undefined variable: identity in /usr/share/pear/DB/sqlrelay.php on  
> line 297
> 
> Notice: Undefined variable: identity in /usr/share/pear/DB/sqlrelay.php on  
> line 297
> 
> Notice: Undefined variable: identity in /usr/share/pear/DB/sqlrelay.php on  
> line 297
> 
> Notice: Undefined variable: identity in /usr/share/pear/DB/sqlrelay.php on  
> line 297
> 
> Notice: Undefined variable: identity in /usr/share/pear/DB/sqlrelay.php on  
> line 297
> Result Set Buffer Size: 100
> Notice: Undefined variable: connection in /usr/share/pear/DB/sqlrelay.php  
> on line 204
> Sending Query: INSERT INTO myTable (id,libelle,lid) VALUES  
> (:id,:libelle,:lid) Length: 74 Requesting a new cursor. Sending 3 Input  
> Bind Variables: id(4:STRING)=1(1) libelle(9:STRING)=Monsieur(8)  
> lid(4:STRING)=4(1) Sending Output Bind Variables: Send Column Info: yes  
> Skipping and Fetching row to get: 99 Skipping 0 rows Fetching 100 rows  
> Checking For An Error...
> Aborting Result Set For Cursor: 0 Deallocated cursor
> Fatal error: Uncaught exception 'Exception' with message 'DB Error:  
> unknown error' in my.class.php5:251 Stack trace: #0 my.class.php5(251):  
> my::save() #1 other.php5(23): other->save() #2 {main} thrown in  
> my.class.php5 on line 251
> 
> Ending Session Deallocated connection
> 
> 
> 
> 
> Is it normal ???
> 
> Could you help please
> 
> david
> 
> 
> -------------------------------------------------------
> This SF.Net email is sponsored by: NEC IT Guy Games.  How far can you shotput
> a projector? How fast can you ride your desk chair down the office luge track?
> If you want to score the big prize, get to know the little guy.  
> Play to win an NEC 61" plasma display: http://www.necitguy.com/?r=20
> _______________________________________________
> Sqlrelay-discussion mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
>