Skip to content

The Dummy Programmer

Stories of daily programming

  • Home
  • The Dummy Programmer Robot
    • Overview
    • Version history & downloads
    • Tutorials
      • TDP Robot – The basics
      • A simple SQL Server backup solution
      • A simple SQL Server backup solution – A next step
  • My other dummy projects
  • Games
    • Space Y: An Asteroids clone
  • Services
    • What’s my user agent
    • What’s my IP address
  • Donate
  • About
  • Toggle search form

phpMyAdmin: #2014 – Commands out of sync

Posted on June 27, 2018May 1, 2019 By

Hello everyone,

another day, another error….

I was migrating a MySql database from one server to a new server.

In the new server, calling one of the stored procedures of the database from the phpMyAdmin interface I obtained the following error:

#2014 – Commands out of sync; you can’t run this command now

#2014 - Commands out of sync; you can't run this command now

Two were the strange things:

  1. Executed in the old server the stored procedure always worked without problems
  2. Called from the Perl application the stored procedure works also in the new server (but as I have said it doesn’t work when called directly from phpMyAdmin)

I can’t publish stored procedure’s code, but after making some debugging sessions, it turned out that the  problem was the last line of the stored procedure, which was something like this:

SELECT 0 AS DUMMY FROM tableX WHERE 1=0;

It was a completely useless statement, and once removed, the stored procedure worked!

Only for your info:

  • Old server  MySql version: 5.1.73
  • New server is MariaDB version 5.5.56
MariaDB, MySql

Post navigation

Previous Post: Hello world!
Next Post: Different ORDER BY behavior between MySql and MariaDB

Related Posts

Different ORDER BY behavior between MySql and MariaDB MariaDB
Configure a PHP development environment in Windows (part 4 of 4) MySql
Hello world! MySql

Search

Subscribe to our newsletter

Categories

  • .NET 6 (1)
  • AJAX (1)
  • Android (2)
  • Apache (4)
  • ASP.NET (9)
  • ASP.NET MVC (3)
  • Avalonia UI (1)
  • BCP (1)
  • Bitlocker (2)
  • C# (14)
  • CentOS (4)
  • ClosedXML (1)
  • CLR (1)
  • DNS (1)
  • Encryption (3)
  • Excel (2)
  • FuelPHP (3)
  • Google Chrome (1)
  • GSuite (1)
  • HTML (1)
  • Imagick (2)
  • Javascript (1)
  • Kindle (1)
  • LAMP (3)
  • Linux (6)
  • MariaDB (2)
  • Mathematics (2)
  • MySql (4)
  • NPOI (1)
  • Office 365 (1)
  • Perl (1)
  • PHP (6)
  • Programming (1)
  • Remote desktop (1)
  • SFTP (2)
  • Sockets (3)
  • Sql Server (18)
  • Sql Server 2016 (14)
  • Sql Server 2019 (1)
  • SSL (2)
  • Task scheduler (1)
  • Telerik ASP.NET AJAX (2)
  • The Dummy Programmer Chat (2)
  • The Dummy Programmer Robot (6)
  • Threading (5)
  • Tools (1)
  • TPL (3)
  • TypeScript (3)
  • Ubuntu (4)
  • Virtualization software (3)
  • Visual Studio (1)
  • Visual Studio Code (2)
  • Web fonts (1)
  • Web programming (6)
  • Windows (12)
  • Windows 10 (15)
  • Windows Forms (1)
  • Windows Server (5)

Copyright © 2022 The Dummy Programmer | Privacy Policy |

Powered by PressBook Masonry Dark