1

I'm trying to implement a Haversine distance function as desribed in this question.

Whenever I run it though, either on the command line or through PhpMyAdmin, I get the following error:

#1607 - Cannot create stored routine `haversine`. Check warnings

The problem is that when I run SHOW WARNINGS; I get a 0 row result set.

Is this a common problem? How do I view the warnings? (If it's relevant, I'm running MySQL 5.1.37-1ubuntu5.)

Community
  • 1
  • 1
Tom Wright
  • 11,278
  • 15
  • 74
  • 148

1 Answers1

0

Don't know if there is any better way. What I have been doing is to create it very simple and incomplete and test at each added bit of functionality. Why don't you post yours?

Look at this question:

How do you debug MySQL stored procedures?

Community
  • 1
  • 1
Clodoaldo Neto
  • 118,695
  • 26
  • 233
  • 260
  • I didn't see the need to post my stored procedure as it's a verbatim copy of the one on the question I linked to. This is also a reason why I'm reluctant to start taking it to bits; I know it works elsewhere, so it's probably my installation of MySQL that's the problem. – Tom Wright Jul 13 '11 at 11:09