If you have access to mysql conf you can also extend the timeout value of the server
Change wait_timeout parameter value to prevent database connection lost. Add this to the [mysqld] section of the config file $ sudo vi /etc/mysql/my.conf wait_timeout = 2147483 $ sudo /etc/init.d/mysql restart Regards, Ron. > Well... with Gambas2 I have the problem that my Mysql server, cut by > time-out the conexions after a few minutes of no activities. The users > complains that, so, y develop this module that re-open the connection if > there is an error. > Usually I call the functions inside passing a sql string like "select * > from mytable" etc. Never a complicated sql sentence. > I can't see nothing wrong. In fact work fine in Gambas2. > (Writing this post I realize thar I don't know if that question (cuts by > time-out) are still a problem in Gambas3)... > > Any suggestion will be appreciate. > > Regards > > > 2013/2/27 Fabien Bodard <[email protected]> > >> It look like a quote problem >> Le 26 févr. 2013 22:09, "M. Cs." <[email protected]> a écrit : >> >>> What kind of syntax are you using to communicate with the database? Give >> us >>> some example, please. >>> >>> Csaba >>> >>> 2013/2/26 Jorge Carrión <[email protected]> >>> >>>> I have a serious problem with mysql server. I'm developing a proyect in >>>> gambas 3.4 on linuxmint 13 maya against a Mysql 5.0.96 server. >>>> >>>> All works fine but randomly all characters non english (á é í ñ, etc >> I'm >>>> spanish) are miss interpreted. You can work half hour with application >>>> without problem at all and suddenly all gridview lists an all fields >> are >>>> wrong. >>>> >>>> Reset de program and some times all runs fine again, some times wrong >>>> characters are recorded in database. >>>> >>>> The collate of Mysql is utf8-general-ci and the charset is >> ut8-general-ci >>>> too. >>>> >>>> I can't isolate the error... >>>> >>>> Any suggest? >>>> >>>> Regards >>>> >>>> >> ------------------------------------------------------------------------------ >>>> Everyone hates slow websites. So do we. >>>> Make your web apps faster with AppDynamics >>>> Download AppDynamics Lite for free today: >>>> http://p.sf.net/sfu/appdyn_d2d_feb >>>> _______________________________________________ >>>> Gambas-user mailing list >>>> [email protected] >>>> https://lists.sourceforge.net/lists/listinfo/gambas-user >>>> >>> >> ------------------------------------------------------------------------------ >>> Everyone hates slow websites. So do we. >>> Make your web apps faster with AppDynamics >>> Download AppDynamics Lite for free today: >>> http://p.sf.net/sfu/appdyn_d2d_feb >>> _______________________________________________ >>> Gambas-user mailing list >>> [email protected] >>> https://lists.sourceforge.net/lists/listinfo/gambas-user >>> >> ------------------------------------------------------------------------------ >> Everyone hates slow websites. So do we. >> Make your web apps faster with AppDynamics >> Download AppDynamics Lite for free today: >> http://p.sf.net/sfu/appdyn_d2d_feb >> _______________________________________________ >> Gambas-user mailing list >> [email protected] >> https://lists.sourceforge.net/lists/listinfo/gambas-user >> >> >> >> ------------------------------------------------------------------------------ >> Everyone hates slow websites. So do we. >> Make your web apps faster with AppDynamics >> Download AppDynamics Lite for free today: >> http://p.sf.net/sfu/appdyn_d2d_feb >> >> >> _______________________________________________ >> Gambas-user mailing list >> [email protected] >> https://lists.sourceforge.net/lists/listinfo/gambas-user ------------------------------------------------------------------------------ Everyone hates slow websites. So do we. Make your web apps faster with AppDynamics Download AppDynamics Lite for free today: http://p.sf.net/sfu/appdyn_d2d_feb _______________________________________________ Gambas-user mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/gambas-user
