[Gambas-user] What "Cannot read information about table mi_table_name" means?

[Jorge Carrión]

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
>
>