[Gambas-user] What "Cannot read information about table mi_table_name" means?
Jorge Carrión
shordi at ...626...
Thu Nov 6 12:21:39 CET 2014
Yes, I do the .Commit, but the error and charset change is produced in
.Create line and the charset change in Insert line without errors...
Now I'm doing a Class inherited of Connection who get around the error...
hope it works without too much changes on my finished buggys develepments
:-)
Regards
2014-11-06 11:46 GMT+01:00 Fabien Bodard <gambas.fr at ...626...>:
> Heva you trying hcon.commit ?after the update.
> Le 6 nov. 2014 10:53, "Jorge Carrión" <shordi at ...626...> a écrit :
>
> > Correcting mysef:
> >
> > Yesterday it works in home, this morning it doesn't work in office. Isn't
> > enough repeat the .Create line. Is necesary to close and re-open the
> > connection:
> >
> >
> > Public Sub hlog(tipo As String, detalle As String)
> >
> > Dim r As Result
> > Dim s As String
> >
> > s = Replace(detalle, "'", "\\'")
> > s = Replace(s, "\"", "\\\"")
> >
> > Try r = hconn.Create("ad_hlog")
> > If Error Then
> > r = Null
> > hconn.close
> > hconn.open
> > r = hconn.Create("ad_hlog")
> > Endif
> >
> > r!tipo = tipo
> > r!detalle = s
> > r!usr = mComun.usuario.nick
> > r!fmod = Now()
> > r.Update
> >
> > End
> >
> > 2014-11-05 11:40 GMT+01:00 Jorge Carrión <shordi at ...626...>:
> >
> > > Ron:
> > > Your Cº is ugly but almost all Spanish names wear á, é, í, ó or ú
> > > characters... You can imagine what a names list is... :D :D
> > >
> > > I think this is a bug.
> > >
> > > I've modified the function in this way:
> > >
> > > Public Sub hlog(tipo As String, detalle As String)
> > >
> > > Dim r As Result
> > > Dim s As String
> > >
> > > s = Replace(detalle, "'", "\\'")
> > > s = Replace(s, "\"", "\\\"")
> > >
> > > Try r = datos.Create("ad_hlog")
> > > If Error Then
> > > r = Null
> > > r = datos.Create("ad_hlog")
> > > Endif
> > >
> > > r!tipo = tipo
> > > r!detalle = s
> > > r!usr = mComun.usuario.nick
> > > r!fmod = Now()
> > > r.Update
> > >
> > > End
> > >
> > > Simply setting the result as null (trying to free the "non allocated")
> > and
> > > repite the .Create and .... all works fine.
> > >
> > > Regards.
> > >
> > >
> > > 2014-11-05 11:17 GMT+01:00 Ron <ron at ...1740...>:
> > >
> > >> I have seen maybe something similar twice when running my project.
> > >> On 3.6.1 (maybe also 3.6.0) all of a sudden the character set seem to
> > >> have been switched/resetted.
> > >>
> > >> I see it because a lot of my fields contains °C symbols, when the
> > >> issue with occurs it is displayed as seen in attachment and ofcourse
> > >> the queries/check fails/don't match anymore. My tables are using
> > >> latin1 default charset.
> > >>
> > >> Only restarting the program resolved the issue.
> > >>
> > >> I can reproduce it by restarting mysql server between/during queries.
> > >> Of course this is normal for this to go wrong, but I remember that
> > >> there was a bugfix with regards to re-selecting correct charset when
> > >> this happens/connection issues arise.
> > >>
> > >> During the two times I have seen the issue, my mysql server wasn't
> > >> being restarted, and I had enough resources on my develpment machine.
> > >> So I'm not sure what happened, and why the recovered connections
> > >> behave differently.
> > >>
> > >> Maybe this issue can be looked into..
> > >>
> > >>
> > >> Regards,
> > >> Ron.
> > >>
> > >> 2014-11-05 10:39 GMT+01:00 Jorge Carrión <shordi at ...626...>:
> > >> > With MySQL I have this function to log certains operations on a
> table
> > >> named
> > >> > ad_hlog:
> > >> >
> > >> > (The connection is named datos and is a public variable that remains
> > >> opened
> > >> > during project execution.)
> > >> >
> > >> > Public Sub hlog(tipo As String, detalle As String)
> > >> >
> > >> > Dim r As Result
> > >> > Dim s As String
> > >> >
> > >> > detalle = Replace(detalle, "'", "\\'")
> > >> > detalle = Replace(detalle, "\"", "\\\"") 'the string detalle can
> > >> > contains ' and " characters
> > >> > ' Old_code: this two commented lines makes eventualy that
> charset
> > >> of
> > >> > database be changed without message or warning at all
> > >> > ' s = "insert into ad_hlog (tipo, detalle, usr,fmod) values
> > ('" &
> > >> > tipo & "', '" & detalle & "', '" & mComun.usuario.nick & "', " &
> > >> "now()" &
> > >> > ")"
> > >> > ' datos.Exec(s)
> > >> >
> > >> > ' New code: the next line produces the "Cannot read information
> > >> about
> > >> > table ad_hlog" and changes the charset and produces allocation non
> > >> freed at
> > >> > end of execution
> > >> > r = datos.Create("ad_hlog")
> > >> > r!tipo = tipo
> > >> > r!detalle = detalle
> > >> > r!usr = mComun.usuario.nick
> > >> > r!fmod = Now()
> > >> > r.Update
> > >> >
> > >> > End
> > >> >
> > >> > This occurs seemingly random. Works fine several times and suddenly
> > all
> > >> is
> > >> > wrong.
> > >> > Apparently something is wrong on connection because the table
> > >> definition is
> > >> > very simple and I can't see anything erroneous:
> > >> >
> > >> > CREATE TABLE IF NOT EXISTS `ad_hlog` (
> > >> > `idhlog` int(8) unsigned NOT NULL AUTO_INCREMENT,
> > >> > `tipo` varchar(50) NOT NULL,
> > >> > `detalle` mediumtext NOT NULL,
> > >> > `usr` varchar(20) NOT NULL,
> > >> > `fmod` datetime NOT NULL,
> > >> > KEY `id` (`idhlog`)
> > >> > ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2567 ;
> > >> >
> > >> > That situation are driven me crazy since a lot of time....
> > >> > I guess that once the problem isolated, I can get around it, but it
> > >> seems
> > >> > to me a bug....
> > >> >
> > >> > Regards
> > >> >
> > >>
> >
> ------------------------------------------------------------------------------
> > >> > _______________________________________________
> > >> > Gambas-user mailing list
> > >> > Gambas-user at lists.sourceforge.net
> > >> > https://lists.sourceforge.net/lists/listinfo/gambas-user
> > >>
> > >>
> > >>
> >
> ------------------------------------------------------------------------------
> > >>
> > >> _______________________________________________
> > >> Gambas-user mailing list
> > >> Gambas-user at lists.sourceforge.net
> > >> https://lists.sourceforge.net/lists/listinfo/gambas-user
> > >>
> > >>
> > >
> >
> >
> ------------------------------------------------------------------------------
> > _______________________________________________
> > Gambas-user mailing list
> > Gambas-user at lists.sourceforge.net
> > https://lists.sourceforge.net/lists/listinfo/gambas-user
> >
>
> ------------------------------------------------------------------------------
> _______________________________________________
> Gambas-user mailing list
> Gambas-user at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/gambas-user
>
More information about the User
mailing list