[Gambas-user] MySQL language problems

[Jorge Carrión]

Ok. I've changed the my.cnf but... the original value was 30... Isn't too
big the 2147483 value? That value in seconds means more than 24 days. I've
set it to 10800, what means 3 hours. Time enough to inactivitie of any
user... I guess.

Don't know if it's effective. I will try and tell you. Thank you very much.

Regards


2013/2/27 Ron <ron at ...1740...>

> 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 <gambas.fr at ...626...>
> >
> >> It look like a quote problem
> >> Le 26 févr. 2013 22:09, "M. Cs." <mohareve at ...626...> 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 <shordi at ...626...>
> >>>
> >>>> 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
> >>>> Gambas-user at lists.sourceforge.net
> >>>> 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
> >>> Gambas-user at lists.sourceforge.net
> >>> 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
> >> Gambas-user at lists.sourceforge.net
> >> 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
> >> Gambas-user at lists.sourceforge.net
> >> 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
> Gambas-user at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/gambas-user
>