From: Warren Young
Date: May 31 2006 8:30am
Subject: Re: commands out of sync
List-Archive: http://lists.mysql.com/plusplus/5705
Message-Id: <447D5423.6070909@etr-usa.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Marinus Karel tenNapel wrote:
> 
> Commands out of sync; you can't run this command now
> 
> Does anybody know why this error shows up?

Yes.  You're trying to execute a query while you have unconsumed rows 
from a previous query.  You must consume all returned rows from a query 
before you can issue another one.  This is a C API issue, not a MySQL++ 
one.  You can find info about it in the MySQL reference manual.