Re: Broken code: mysql++ not seeing my tables

[Jason Barnes]

> Jason Barnes wrote:
> > 	Hi!  I used mysql++ to write a web application to display a
> > particular database.  It worked great.
> > 	However, when I upgraded my underlying system from FreeBSD
> > 4-STABLE to FreeBSD 5.2.1 and rebuilt the MySQL client, server, and
> > mysql++, and recompiled my code, it no longer works.
> > 	Here's the problem:  when I make a query, "select * from
> > planettable", I get the error, " Error: Query was empty ".  When I access
> > this table from mysql on the command line, though, it works fine, as it
> > does when I use the PERL mysql interface.  Furthermore, selecting from
> > misspelled and non-existant tables gives the same result.  For some
> > reason, mysql++ must not be seeing the tables, or my database, properly, I
> > guess.
> > 	If anyone has any insight as to what might be wrong, or what I
> > might be able to try to fix the problem, I would be very thankful for any
> > help you could provide.  Thanks for your time everyone,
> >
> > 				- Jason Barnes
> >
>
>
> This looks most likely like a mismatch between include files and library.
>
> Rebuild once more our C API and mysql++ but make sure that includes and
> libs come from 100 % the same version.

	Okay, I just rebuilt the mysql server, client, and mysql++ to
versions:

mysql-server-4.0.18_1
mysql-client-4.0.18_1
mysql++-1.7.9_2

	However, unfortunately the problem is unchanged.  The connection
works fine, but no tables seem to be found, based on the fact that a
select * from each of them and those that I know don't exist all come up
"Error: Query was empty".
	Thank you so much for your help on this, I apreciate any further
clues that might occur to anyone.  Thanks,

				- J