Re: unable to create function in MySQL 5.0

[Jacques Marneweck]

Ted Yu wrote:
> I got an error that I don't understand:
>
> Enter password:
> Welcome to the MySQL monitor.  Commands end with ; or
> \g.
> Your MySQL connection id is 3080 to server version:
> 5.0.18-log
>
> mysql> create function do_system returns integer
> soname 'raptor_udf.so'//
> ERROR 1146 (42S02): Table 'mysql.proc' doesn't exist
>
>   
It's a known MySQL bug - http://bugs.mysql.com/bug.php?id=24750

Use the schema mentioned there to recreate the mysql proc table.

Regards
--jm

-- 
Jacques Marneweck
http://www.powertrip.co.za/
http://www.powertrip.co.za/blog/

#include <std/disclaimer.h>