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

[Ron]

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
-------------- next part --------------
A non-text attachment was scrubbed...
Name: charset.png
Type: image/png
Size: 1264 bytes
Desc: not available
URL: <http://lists.gambas-basic.org/pipermail/user/attachments/20141105/b736011e/attachment.png>