Stored Procedure Error

[Tinnin]

Hi all,

I'm trying to run a stored procedure:

BEGIN

SELECT YFR_Master_Fundraisers.FRName, YFR_Master_Fundraisers.FRActive
FROM YFR_Master
INNER JOIN YFR_Master_Fundraisers
ON YFR_Master.FundRaiser = YFR_Master_Fundraisers.FRNameCode
GROUP BY YFR_Master.FundRaiser
HAVING MAX(YFR_Master.CollectionDate) < DATE_SUB(CURDATE(),INTERVAL 2 MONTH)
AND YFR_Master_Fundraisers.FRActive = 1;

END

But I'm getting the following error:

Procedure execution failed
1312 - PROCEDURE db355379982.Deactivate can't return a result set in the given context

Does anyone know why I might be getting this?

I've never used stored procedures before.

Thanks

[pritaeas]

Do you get this when you run the stored proc in phpMyAdmin (or another client), or when you run it from PHP? Based on this thread on SO.

[Tinnin]

It runs fine from php. I'm using Navicat for MySQL. Could that be the problem?

MySQL Version 5.1.67-log
PHP Version 5.2.17

[pritaeas]

It runs fine from php.

So where do you get the error?

[Tinnin]

In Navicat

[Tinnin]

The SP is called Deactivate

I run

CALL Deactivate

[pritaeas]

Hard to say if it works from PHP. Are you using the same credentials?

[Tinnin]

Sorry, what do you mean by "credentials"?

[pritaeas]

Same user as in PHP. If you are using a different one, with different priviliges, that could cause issues.

[Tinnin]

Oh I see. Yes, Same user.

[pritaeas]

Strange, I'd contact Navicat support.

[Tinnin]

Yeah. It might be time to. Thanks for the help.