MySQL Lists are EOL. Please join:

List:MySQL++« Previous MessageNext Message »
From:Martin Gallwey Date:January 15 2013 10:34pm
Subject:Re: MySQL++ Query Loop : Commands Out of Sync?
View as plain text  
Commands out of sync doesn't mean mysqlpp thinks you are executing the
commands simultaneously, it is an error from MySQL itself:

This stand-alone program of mine works fine:

#include <mysql++/mysql++.h>
#include <mysql++/query.h>
#include <iostream>
using namespace mysqlpp;
using namespace std;
int main ()
    Connection* g_pConnection = NULL;
    g_pConnection = new Connection(...);

    mysqlpp::Query query = g_pConnection->query();
    const char *drop_q[] = {"DROP TABLE if exists `t1`;", "DROP TABLE if
exists `t2`", "DROP TABLE if exists `t3`"};
    const char *queries[] = {"CREATE TABLE t1 ( `id` int(11) NOT NULL );",
"CREATE TABLE t2 ( `id` int(11) NOT NULL );", "CREATE TABLE t3 (`id`
int(11) NOT NULL )"};
    const char *tables[] = {"t1", "t2", "t3"};
    // sz = is the size of "queries"
    for (size_t i = 0; i < sizeof queries / sizeof queries[0]; ++i)
        if ( true ) //!tableExists(tables[i]))
            cout << "Executing " << i << ", query: " << drop_q[i]
<< endl;
            query << drop_q[i];
            cout << "Executing " << i << ", query: " << queries[i]
<< endl;
            query << queries[i];

So I suspect the problem is in your tableExists function which isn't
included in your email or pastebin. You could just change your queries to

On 15 January 2013 21:23, Jordan Hewitt <jordannh@stripped> wrote:

> Here is my code:
> MySQL returns with: Commands out of sync; you can't run this command now
> t1 is created, but t2 is not.  For some reason MySQL++ thinks I'm
> running the queries simultaneously.
> Even if I do the following, I still get the error:
>   * Replace remove lines19-21
>   * After the if(!tableExists) {...} block, add the following lines:
>     query = NULL;
>     delete query;
>     query = connection.query();
> If I do nothing to query, I still get the same error.  Any ideas?  I may
> just go with the native MySQL.
> Thanks.

MySQL++ Query Loop : Commands Out of Sync?Jordan Hewitt15 Jan
  • Re: MySQL++ Query Loop : Commands Out of Sync?Warren Young15 Jan
    • Re: MySQL++ Query Loop : Commands Out of Sync?Warren Young16 Jan
  • Re: MySQL++ Query Loop : Commands Out of Sync?Martin Gallwey15 Jan
    • Re: MySQL++ Query Loop : Commands Out of Sync?Jordan Hewitt16 Jan