I am trying to call a stored procedure on mysql version 5.0.77. When I try to do a simple call of the procedure, I get the following error:
SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘DATA_TYPE’ in ‘field list’ (SQL: SELECT ROUTINE_NAME, DATA_TYPE FROM INFORMATION_SCHEMA.ROUTINES WHERE ROUTINE_TYPE = :type AND ROUTINE_SCHEMA = :schema)",
I believe that this is because my version of MySQL does not have the column ‘DATA_TYPE’ in the ROUTINES table. Is there anyway to get around this? I need to use procedures to fulfill my application’s needs and upgrading the DB is not an easy option right now.