your database front-end

Server Outage Notice: will be transfering to a new Server on Friday 25th @ 7pm MST

MySQL: Can't load [%procedurename%] parameters

When setting up or running a MySQL stored procedure you may see the following errors:

  • Can't load [%procedurename%] parameters
  • Data is Null.
  • This method or property cannot be called on Null values.


dbFront queries the MySql server for the stored procedure parameters before execution and at the point of configuration.

SHOW CREATE PROCEDURE `mydatabase`.`%procedurename%`;

If the procedure name is not found, or if the user does not have access to the procedure then this process will raise an error.


The solution is to:

  1. Ensure that the connection user has access to execute the specified procedure,
  2. Grant the connection user SELECT permission on the table mysql.proc

Once that access has been granted to the procedure and the table mysql.proc, then dbFront can retrieve the information it needs to correctly run the procedure. 

Content you want the user to see goes here.