[Phplib-users] MySql losing connection

[Leandro N. <lea...@ho...>]

Hello all,

I am using Db_Sql class of Phplib-7.4-pre1 with MySQL 3.23.34a for an 
application in php and "very often" when I am executing a query like this:

$db->query("SELECT id,subject FROM A.table ORDER BY mdate DESC LIMIT 10");

Then I get this error:

MySQL Error: 2013 (Lost connection to MySQL server during query)

The table has about 4000 rows and field sizes not so big too.

I don't have the exactly idea if this is a problem with the DB class or 
MySql. I had used this DB for other applications without phplib classes 
before and I never had this problem, maybe just coincidence, I HOPE SO, .. 
Someone here have any idea of what it can be. I am almost praying :)

This error persist until I go via phpMyAdmin 2.2.5 and refresh a few times 
the database where the error occurs by clicking in the database name 
(sometimes one refresh-click is not enough), then the application returns to 
work for an inconstant time until the same error happen again, sometimes not 
in the same query with other tables too.

I already looked phplib, mysql manuals, change variables, buffers sizes, 
table types, etc and nothing yet. ;((

Thanks a lot for any possible help,
Leandro Nery
Astalavista Group Team

_________________________________________________________________
O MSN Photos é o modo mais fácil de compartilhar e imprimir suas fotos: 
http://photos.msn.com/support/worldwide.aspx