5 messages in com.mysql.lists.plusplusRe: Broken code: mysql++ not seeing ...
FromSent OnAttachments
Jason Barnes17 May 2004 15:17 
Sinisa Milivojevic18 May 2004 10:18 
Jason Barnes18 May 2004 15:57 
Sinisa Milivojevic21 May 2004 06:36 
Jason Barnes28 May 2004 15:48 
Subject:Re: Broken code: mysql++ not seeing my tables
From:Jason Barnes (jbar@c3po.barnesos.net)
Date:05/18/2004 03:57:59 PM
List:com.mysql.lists.plusplus

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