James Black <[EMAIL PROTECTED]> wrote on 06/06/2005 12:33:40 PM: > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1
> I am curious what has changed in 5.0.6 that leds to this error: > ERROR 1418: This routine is declared to be non-deterministic and to > modify data and binary logging is enabled > What should I be looking at changing in my CREATE PROCEDURE call to > enable it to work now. > Thanx. > - -- > "Love is mutual self-giving that ends in self-recovery." Fulton Sheen > James Black [EMAIL PROTECTED] > -----BEGIN PGP SIGNATURE----- > Version: GnuPG v1.4.1 (MingW32) > Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org > iD8DBQFCpHrkikQgpVn8xrARAsU9AJwOp7hjiQNliBEze8699S+9VnPYwACglT0N > IQJ12hARPu9odCU1jRxxdts= > =+DhI > -----END PGP SIGNATURE----- I think it may help everyone if you actually posted your CREATE STORED PROCEDURE statement. Then we can compare that against the changes logged in the manual between your original version (which was what?) and 5.0.6 and see what part of your SPROC would have become conflicted.... At the very least give us your previous MySQL version so that we have somewhere to start from. Shawn Green Database Administrator Unimin Corporation - Spruce Pine