[Phplib-users] MySql losing connection
Brought to you by:
nhruby,
richardarcher
|
From: Leandro N. <lea...@ho...> - 2002-05-03 16:15:40
|
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
|