Databases
StackOverflow2013
Postsdbo
POMySQL Error - Commands out of sync; you can't run this command now
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POMySQL Error - Commands out of sync; you can't run this command now
    primarykey
    data
    text
    <p>I am using MySQL with PHP, Codeigniter. I had a question which was answered by bluefeet in the post <a href="https://stackoverflow.com/questions/16012098/mysql-show-data-in-pivot-view/16013046#16013046">here</a></p> <p>I created a stored procedure for the second solution by bluefeet. It works perfect, however, while the procedure is called in the production environment, all the other users get the error </p> <blockquote> <p>Commands out of sync; you can't run this command now</p> </blockquote> <p>Not sure how can i overcome with this error. I also tried closing the connection after the procedure is called, however, Queries from other users are executed before the connection is closed. Any work-around for this issue?</p> <p>Below is the stored procedure that i have used</p> <pre><code>DROP PROCEDURE IF EXISTS mailbox.circle_pending_p; CREATE PROCEDURE mailbox.`circle_pending_p`() BEGIN SET @sql = NULL; SELECT GROUP_CONCAT(DISTINCT CONCAT( 'sum(CASE WHEN maildate = ''', date_format(mailtime, '%e-%b'), ''' THEN 1 else 0 END) AS `', date_format(mailtime, '%e-%b'), '`' ) ) INTO @sql FROM circle_pending_temp WHERE mailtime &gt;= (select date_sub(max(mailtime), interval 8 DAY) from circle_pending_temp); SET @sql = CONCAT('SELECT coalesce(email_Circle, ''Grand Total'') Circle, max(`&lt; 9 days`) `&lt; 9 days`, ', @sql, ' , count(*) GrandTotal from ( select c.email_Circle, date_format(c.mailtime, ''%e-%b'') maildate, coalesce(o.`&lt; 9 days`, 0) `&lt; 9 days` from circle_pending_temp c left join ( select email_Circle, count(*) `&lt; 9 days` from circle_pending_temp where mailtime &lt;= (select date_sub(max(mailtime), interval 8 DAY) from circle_pending_temp) ) o on c.email_Circle = o.email_Circle where c.mailtime &gt;= (select date_sub(max(mailtime), interval 8 DAY) from circle_pending_temp) ) d group by email_Circle with rollup '); PREPARE stmt FROM @sql; EXECUTE stmt; DEALLOCATE PREPARE stmt; END; </code></pre> <p>The PHP that i use for calling this procedure is</p> <pre><code> $db = $this-&gt;load-&gt;database('mailbox',TRUE); $res = $db-&gt;query('Call circle_pending_p()'); echo $db-&gt;_error_message(); $db-&gt;close(); $db = $this-&gt;load-&gt;database('mailbox',TRUE); if ($res-&gt;num_rows() &gt; 0) { return $res-&gt;result_array(); } else { return 0; } </code></pre>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USCommunity
    1. USGuns
    plurals
    1. PL
      singulars
      1. LTLinked
    1. PL
      singulars
      1. LTLinked
    2. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POMySQL Error - Commands out of sync; you can't run this command now
      1. USGuns
      1. VTFavorite
    2. VO
      singulars
      1. POMySQL Error - Commands out of sync; you can't run this command now
      1. USahmedsaber111
      1. VTFavorite
    1. This table or related slice is empty.
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload