freelanceprogrammers.org Forum Index » Perl

View previous topic :: View next topic
Post new topic   Reply to topic

DBI loses connection after time


View user's profile Post To page top
josegarciaju... Posted: Sun Mar 27, 2005 6:33 am


Joined: 07 Mar 2005

Posts: 6
DBI loses connection after time
hi
i have an tcp/ip server with DBI ::mysql database connection

Its works perfectly, but after certain time ( sometimes hours,
sometimes a day, sometimes without no one query in database) its loses
connection, aparentely as no reason, with following message :
DBD::mysql::st execute warning: at imserverd.pl line 155, <GEN2> line
1.

code:
153 $sqlcmd="select * from usuarios where email=`$user`";
154 $sql = $dbh->prepare($sqlcmd);
155 $sql->execute();

remembering: database exists and is acessible, program works, and
crash suddenly :(

anyone know how i can solve this ?

regards,
rocco siffred
Reply with quote
Send private message
Post new topic Reply to topic
Display posts from previous:   
freelanceprogrammers.org Forum Index » Perl
 

All times are GMT
Page 1 of 1
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
Freelace Website Designer - Customer web design and software building.
Booking Calendar - reservation calendar script
Land Surveying - total station instruments and equipments
China Wholesale - Electronics Products
Character Studio - Tutorials and Help