[Gambas-user] Error : MySQL

[Nigel Gerrard]

Leo,

Okay I missed something when adding the multitable ability within the
driver...not realising that . is a valid character in field names.
Attached is a diff file that should be applied:

cd ./src/lib/db/mysql
copy the attachment main.c.diff to this area.
patch main.c main.c.diff

Now recompile:
make

change to root:
make install

I'll get Benoit to update the distribution.

Nigel

On Wed, 2004-07-21 at 14:01, Leo Barnhoorn wrote:
> On Wednesday 21 July 2004 14:28, Nigel Gerrard wrote:
> > Leo,
> >
> > Is 192.168.1.11 the same as the localhost or are you trying to connect to a
> > different server?
> >
> This IP 192.168.1.11 is from the computer i'am working on, this is a user on 
> IP 192.168.1.1 with MySQL Server, so i can connect to it.
> 
> But GRANTS for leobarn at ...40... on MySQL on IP 192.168.1.1 is no problem i 
> get the information.
> 
> >
> > Does the user exist?
> >
> The user exist, with Gambas version 0.94a no problem to get the GRANTS for 
> user leobarn at ...539...
> 
> >
> > Either use the Gambas Database Manager to check that leobarn at ...539...
> > is there or
> > from mysql: select host, user from mysql.user.
> >
> The user is there also with Gambas Database Manager, when i do the query with 
> the Gambas Database Manager also een error.
> 
> >
> > If it is, then let me know. I am currently not in a position to link to a
> > service running on another
> > server at the moment.
> No problem for that, if you have time.
> 
> >
> > Nigel
> 
> Regards,
> Leo.
> 
> 
> >
> > ----- Original Message -----
> > From: "Leo Barnhoorn" <leo.barnhoorn at ...246...>
> > To: <gambas-user at lists.sourceforge.net>
> > Sent: Wednesday, July 21, 2004 11:59 AM
> > Subject: [Gambas-user] Error : MySQL
> >
> > > Hello Nigel,
> > >
> > > I have a error on a query i do:
> > >
> > > Unknown field: Grants for leobarn at ...539...
> > >
> > > If i run the query SHOW GRANTS FOR leobarn at ...40... this works fine.
> > > If i run the query SHOW GRANTS FOR leobarn at ...539... then gives the
> >
> > error.
> >
> > > user at ...40... works fine.
> > > user at ...540... numbers gives a error.
> > >
> > > Do you have a solution for me.
> > >
> > > Regards,
> > > Leo.

-------------- next part --------------
A non-text attachment was scrubbed...
Name: main.c.diff
Type: text/x-patch
Size: 415 bytes
Desc: not available
URL: <http://lists.gambas-basic.org/pipermail/user/attachments/20040721/bfb31d74/attachment.bin>